SalehFLOW Usage During the NBA Playoffs-teams
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with lst_Conference_Finals as (
select
block_timestamp::date as day
,m.team
,count(DISTINCT tx_id) as tx_count
,sum(price) as amount
,sum(tx_count) over(order by day) as growth_tx
from flow.core.fact_nft_sales s
join flow.core.dim_topshot_metadata m on m.nft_id = s.nft_id
where s.nft_collection = 'A.0b2a3299cc857e29.TopShot'
and block_timestamp::date>='2022-05-17' and block_timestamp::date<='2022-05-29'
and (m.team ='Miami Heat' or m.team='Dallas Mavericks' or m.team='Boston Celtics' or m.team='Golden State Warriors')
group by 1,2
order by 1
)
, lst_before_Conference_Finals as (
select
block_timestamp::date as day
,m.team
,count(DISTINCT tx_id) as tx_count
,sum(price) as amount
,sum(tx_count) over(order by day) as growth_tx
from flow.core.fact_nft_sales s
join flow.core.dim_topshot_metadata m on m.nft_id = s.nft_id
where s.nft_collection = 'A.0b2a3299cc857e29.TopShot'
and block_timestamp::date<'2022-05-17' and block_timestamp::date>='2022-05-4'
and (m.team ='Miami Heat' or m.team='Dallas Mavericks' or m.team='Boston Celtics' or m.team='Golden State Warriors')
group by 1,2
order by 1
)
, lst_after_Conference_Finals as (
select
block_timestamp::date as day
,m.team
,count(DISTINCT tx_id) as tx_count
Run a query to Download Data