Updated 2022-10-21
    SELECT block_timestamp::date as daily , sum(price) as volume ,
    count(DISTINCT BUYER) as buyers , count(tx_id ) as tx_number , COUNT(DISTINCT NFT_ID) as NFT ,
    sum(volume) over (order by daily) as cumulative_volume ,
    sum(tx_number) over (order by daily) as cumulative_tx_number
    from flow.core.ez_nft_sales
    where NFT_COLLECTION ilike '%raceday%'
    and TX_SUCCEEDED ilike '%TRUE%'
    group by 1
    Run a query to Download Data