flipside-101
Deep Dive into the foundations of crypto via flipside schemas: Core, DeFi, Governance, NFT, Price. Including reviews of Dims, Labels, Tags, Contracts (ABIs/IDLs), Facts of Transactions, Event Logs, Traces, Swaps, NFTs, and common blockers when analyzing crypto data.
Schema
Although blockchains can vary in structure (Bitcoin UTXO, Ethereum/EVM Account based, Cosmos/IBC, Solana, Aptos, Sei) flipside works to align each blockchain to a categorical based schema.
NOTE: Blockchains have different cultures and may not have defined standards for certain actions, making it unfeasible to have the same table(s) across them. We are always working to improve, don't hesitate to reach out if something useful is missing!
Throughout this dashboard, columns will be downselected and renamed to prioritize understanding, always reference the (provided) SQL code next to tables to see the original column names. column_names
will also be identified using code style font.
Core
Foundations of a blockchain: contract addresses and ABIs, facts about blocks, facts about transactions, facts about logs, facts about transfers. See: Core
tab for a deeper dive. For some chains, you may see protocol specific tables under Core.
DeFi
Typically liquidity pools and swaps on DEXes. Depending on the chain you may also see bridging, bonding, liquidity events. But expect dim_dex_liquidity_pools
and ez_dex_swaps
for most chains.
Gov
Not available on all chains, but details foundational governance actions, e.g., delegations. For Solana, rewards for stakers/validators in its delegated proof of stake model. See Governance
for that deep dive in Solana as it is the most advanced governance table in Flipside currently.
NFT
Will include at a minimum NFT transfers and sales on common marketplaces. Where possible (i.e. the culture for NFTs on that blockchain supports standards for it) we will also include mints of NFTs. Not all chains have NFTs.
Price
We source hourly prices from a variety of providers (e.g. Coingecko, Coinmarketcap). These prices feed into amount...usd
columns across chains, e.g., ez_dex_swaps
will use hourly (close) prices for amount_out_usd
and amount_in_usd
. See data engineering note
below.
Data Engineering Note
You will see insert/modified timestamps and unique row ids in tables. This is because some data comes later than others. We can't put a price on a 12:18pm swap until the 12-1pm hour is done. So expect infills and metadata around modification to support engineering built on our data!
