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!

    db_img