shrimpboxcumulative sales
    WITH DailySales AS (
    SELECT
    DATE(BLOCK_TIMESTAMP) AS SaleDate,
    SUM(PRICE_USD) AS TotalDailySales
    FROM ethereum.nft.ez_nft_sales
    where nft_address = lower('0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D')
    GROUP BY SaleDate
    ),
    CumulativeSales AS (
    SELECT
    SaleDate,
    SUM(TotalDailySales) OVER (ORDER BY SaleDate) AS CumulativeSalesUSD
    FROM DailySales
    )
    SELECT *
    FROM CumulativeSales;


    Run a query to Download Data