2024-04-18 | Release Notes

New tables on Vertex and Solana. Plus updates to Arbitrum and BSC supporting Seaport 1.6.

Highlights

The team just released 5 new tables for Vertex that give you the ability to dig into account stats, market depth stats, market stats, staking actions and edge trades.

We also released a new Solana table core.fact_token_account_owners that provides a comprehensive view of token account ownership, enabling users to track the ownership history of token accounts. As the owner of an account can change over time, and transactions more commonly display the token account over the actual owner, this table makes it easier to analyze the main parties that are executing transactions on-chain, to get insight into user behavior, network connections, and market correlations.

Check out the rest of the release notes below.

Updated Table:

Seaport 1.6 added to ez_nft_sales table

  • nft.ez_nft_sales

Updated Table:

Seaport 1.6 added to ez_nft_sales table

  • nft.ez_nft_sales

New Table:

This new table provides a comprehensive view of address ownership, enabling users to track the ownership history of an account. Because the owner of an account can change over time, and transactions more commonly display the token account over the actual owner — this table enables easier analysis into the main parties that are executing transactions on-chain, and insight into user behavior, network connections, market correlations, etc.

  • core.fact_token_account_owners

Updated Table:

These tables now contain all events related to mints, where previously they only contained the actual minting of the token/nft. This is useful in situations where the first mint and initialization do not occur in the same transactions.

  • nft.fact_nft_mint_actions

  • defi.fact_token_mint_actions

New Tables:

We recently added new tables to integrate Vertex API and on-chain data. You can find this data under the Arbitrum database.

  • arbitrum.vertex.ez_account_stats

  • arbitrum.vertex.ez_market_depth_stats

  • arbitrum.vertex.ez_market_stats

  • arbitrum.vertex.ez_staking_actions

  • arbitrum.vertex.ez_edge_trades

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