NavidUntitled Query
Updated 2022-10-24Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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