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.


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