flipside

    Getting Started
    rajeebkmGetting Started
    Updated 2025-06-03

    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.xyz/our-app/getting-started

    -- select
    -- platform_name,
    -- count(*) as sales_count
    -- from ethereum.nft.ez_nft_sales
    -- where block_timestamp > current_date - interval '30 days'
    -- group by platform_name
    -- order by sales_count desc
    -- limit 8

    select * from monad.testnet.fact_event_logs where tx_hash = '0xf41ac5773692ab35243c82520e931f1b3fcc3f0150544c3c6af92e85f00de63b'

    Last run: 18 days ago
    No Data to Display
    0
    2B
    415s