LittlerDataCopy of AVG thanksgiving flow users
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
⌄
/* Sales volume (daily)
Total Sales Volume
Daily Average Sales Price and 7-day moving average
Total Unique Buyers
Average Buyers/Day */
with buyers as (
select
date_trunc('day',block_timestamp) as day
,count(distinct tx_id) as sales
,count(distinct buyer) as buyers
from flow.core.ez_nft_sales sales
where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by 1
)
select
case
when day >= '2022-11-24' then 'After_Thanksgiving'
when day < '2022-11-24' then 'Before_Thanksgiving'
end as Period
,avg(sales) as avg_sales
,avg(buyers) as avg_buyers
,median(sales) as median_Sales
,median(buyers) as median_buyers
from buyers
group by 1
Run a query to Download Data