0xaimanUntitled Query
    Updated 2022-09-13
    select date as month, vol_sales, vol_sales_usd,
    sum(vol_sales) OVER(ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol_sales,
    sum(vol_sales_usd) OVER(ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_vol_sales_usd
    from (select date_trunc('month', block_timestamp) as date, currency_symbol, sum(price) as vol_sales, sum(price_usd) as vol_sales_usd
    from ethereum.core.ez_nft_sales
    where event_type = 'sale'
    group by 1,2) where currency_symbol='ETH' or currency_symbol='WETH'
    order by 1 desc
    Run a query to Download Data