2024-06-14 | Release Notes
New data from Kaia, 9 new Farcaster tables, tons of new core tables for SEI, and new dex swap tables for Solana.
Highlights
This week we added data for a new partner – check out the new Kaia tables in the studio. You can also now query many new Sei core tables that provide the new Sei V2 (EVM) data. Social data from Farcaster is now available, plus upgrades to Solana tables.
On July 15th, 2024 we’re making an update to the solana.core.fact_transfers table to include both native and wrapped solana addresses in the mint column. If you’re querying this data you will need to update your query to include both addresses. You can learn more about this change on our docs here.
Check out these updates and the rest of the release notes below.
External (Data Studio Only)
New Tables:
Social data from Farcaster is now available in our external database. Analyze casts activity, users and other activity on the social platform.
external.farcaster.dim_fids
external.farcaster.dim_fnames
external.farcaster.fact_casts
external.farcaster.fact_links
external.farcaster.fact_reactions
external.farcaster.fact_signers
external.farcaster.fact_storage
external.farcaster.fact_user_data
external.farcaster.fact_verifications
external.farcaster.dim_profile_with_addresses
New Data:
This week we added the EVM chain, Kaia, to our list of ever growing blockchains. We’re launching with 5 core tables which will include 90 days of data.
kaia.core.fact_transactions
kaia.core.fact_blocks
kaia.core.dim_labels
kaia.core.fact_event_logs
kaia.core.fact_traces
New Tables:
Tons of new core tables for sei launched this week to help analysts query the EVM specific data that is not available on the cosmos/ibc side of the chain.
sei.core_evm.fact_blocks
sei.core_evm.fact_event_logs
sei.core_evm.fact_traces
sei.core_evm.fact_transactions
sei.core_evm.dim_contracts
sei.core_evm.fact_token_transfers
sei.core_evm.ez_token_transfers
sei.core_evm.ez_native_transfers
New Tables:
These tables now contain a more complete record of every individual swap performed on the Raydium dex and now users do not have to do additional joins to get info such as USD amounts or token symbols.
solana.defi.fact_swaps
solana.defi.ez_swaps
Updated Column Data:
The address of native SOL will now be reflected in the 'mint' column. Native SOL is the native token of the Solana blockchain and is used for paying tx fees, staking and participating in governance. Learn more about this change here.
solana.core.fact_transfers
Useful Resources
Request a smart contract ABI to be decoded: https://science.flipsidecrypto.xyz/abi-requestor/
Request a Solana IDL to be decoded: https://science.flipsidecrypto.xyz/idl-requestor
Add labels: https://science.flipsidecrypto.xyz/add-a-label
Last updated