OPOF: Only Possible On Flipside

    A walk-through of what analyses are possible with Flipside's data on Solana! If there's anything missing / you'd want us to add, feel free to reach out in the Flipside Discord or on Twitter @runkellen 🫡

    The solana.core.fact_transactions table includes every transaction on the Solana blockchain

    Core Tables
    Loading...

    The solana.core.fact_transfers table includes every token transfer on the Solana blockchain

    Loading...

    Flipside has 5 primary data "schemas"

    • Core
    • Defi
    • Gov
    • Nft
    • Price

    We'll highlight the main tables from each schema below

    The "Core" schema has the most raw data (transfers, transactions, events)

    The other schemas have an interpretation layer that make it easy to access the specific data you are looking for like

    • NFT mints and sales
    • DEX swaps
    • SOL Staking
    • And more!

    The solana.core.fact_events table includes instruction-level detail

    Loading...
    DeFi Tables
    Loading...
    Loading...
    Loading...

    The solana.defi.fact_swaps table includes every DEX swap on Solana

    The fact_stake_pool_actions table includes all $SOL staking and unstaking actions

    The fact_liquidity_pool_actions table includes all token staking and unstaking actions into liquidity pools

    Governance Tables
    Loading...

    The ez_staking_lp_actions table includes all validator staking and unstaking actions

    NFT Tables
    Loading...

    The fact_nft_sales table includes nft sales from all marketplaces

    Loading...

    The fact_nft_mints table inclues all mint transactions for every NFT

    Loading...

    The dim_nft_metadata table includes attributes and traits for NFTs

    Price Tables
    Loading...

    The ez_token_prices_hourly table includes token prices. You can join to other tables using the token_address field.

    The solana.core.fact_decoded_instructions table had decoded solana events

    Loading...

    The fact_rewards_voting table has validator rewards

    Loading...