shreexSales
    Updated 2023-03-13
    select
    date_trunc('day',block_timestamp) as date,
    sum(price) as daily_volume,
    sum(daily_volume) over (order by date) as sales_volume_cumulative,
    count(distinct buyer) as distinct_buyers,
    sum(distinct_buyers) over (order by date) as cumulative_buyers,
    count(distinct seller) as distinct_sellers,
    sum(distinct_sellers) over (order by date) as cumulative_buyers
    from flow.core.ez_nft_sales where nft_collection='A.e4cf4bdc1751c65d.AllDay' and tx_succeeded='TRUE'
    GROUP BY date
    ORDER BY date
    Run a query to Download Data