Moe1 FLOW Usage During the NBA Playoffs
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
--Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume.
--Did the Warriors, Celtics, Mavericks, or Heat see higher sales volume?
select
date_trunc(day,BLOCK_TIMESTAMP)::date as days,
case when BLOCK_TIMESTAMP between '2022-05-17' and '2022-05-29' then 'Conference Finals' else 'others' end as day_type,
count(distinct buyer) as unique_buyers,
sum(price) as total_volume
from flow.core.fact_nft_sales
where NFT_COLLECTION ilike 'A.0b2a3299cc857e29.TopShot'
and CURRENCY = 'A.ead892083b3e2c6c.DapperUtilityCoin'
and TX_SUCCEEDED = 'TRUE'
and days ilike '2022-05%'
group by 1 , 2
order by 1
Run a query to Download Data