SalehFLOW Usage During the NBA Playoffs-
Updated 2022-07-09
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
›
⌄
with sales_stats as (
select
block_timestamp,
case
when block_timestamp::date < '2022-05-17' then 'Before the conference'
when block_timestamp::date < '2022-05-30' then 'During the conference'
else 'After the conference' end
as type,
tx_id,
price
from flow.core.fact_nft_sales
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
and block_timestamp::date >= '2022-05-10'
and block_timestamp::date <= '2022-06-06'
)
select
date_trunc('day', block_timestamp) as time,
type,
count(*) as number_of_sales,
sum(price) as volume
from sales_stats
group by 1, 2
-- select distinct team from flow.core.dim_topshot_metadata
-- where team in ('Golden State Warriors', 'Boston Celtics', 'Dallas Mavericks', 'Miami Heat')
Run a query to Download Data