i_danoptimistic-fuchsia
    Updated 2024-09-24
    SELECT
    date_trunc('day', block_timestamp) AS day
    , SUM(price_usd) AS volume
    , SUM(volume) OVER (ORDER BY day) AS Cummulative_volume
    FROM base.nft.ez_nft_sales
    WHERE 1=1
    AND nft_address = lower('0x08b757d8c733e9881f225817516c144b9f378c4d')
    GROUP BY 1
    ORDER BY 1 DESC
    QueryRunArchived: QueryRun has been archived