odesenfansGetting Started
    Updated 2024-12-19

    -- 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 SUM(n_txs) from
    (select
    DATE(block_timestamp) AS day,
    COUNT(*) as n_txs,
    SUM(fee)
    FROM eclipse.core.fact_transactions
    GROUP BY 1) sub WHERE sub.day >= '2024-12-12';
    QueryRunArchived: QueryRun has been archived