NavidUntitled Query
    Updated 2022-10-24
    select
    date_trunc('day', block_timestamp) as day,
    sum(price) as daily_volume,
    sum(daily_volume) over (order by day asc) as cumulative_volume,
    avg(daily_volume) over (order by day asc rows between 7 preceding and current row) as moving_average_volume,
    count(distinct tx_id) as number_of_sales,
    sum(number_of_sales) over (order by day asc) as cumulative_number_of_sales,
    avg(number_of_sales) over (order by day asc rows between 7 preceding and current row) as moving_average_number_of_sales,
    count(distinct buyer) as number_of_buyers,
    sum(number_of_buyers) over (order by day asc) as cumulative_number_of_buyers,
    avg(number_of_buyers) over (order by day asc rows between 7 preceding and current row) as moving_average_number_of_buyers,
    count(distinct seller) as number_of_sellers,
    sum(number_of_sellers) over (order by day asc) as cumulative_number_of_sellers,
    avg(number_of_sellers) over (order by day asc rows between 7 preceding and current row) as moving_average_number_of_sellers,
    avg(number_of_sellers+number_of_buyers) over (order by day asc rows between 7 preceding and current row) as moving_average_number_of_traders
    from
    flow.core.ez_nft_sales
    where
    NFT_COLLECTION like '%RaceDay%'
    group by
    day
    order by
    day asc
    Run a query to Download Data