kasadeghAverage Daily Transactions Count Befor/In/After the NBA Conference Finals
Updated 2022-07-10
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 TopShot_Sale_Info_Before_Conference_Finals as (
select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*
from flow.core.fact_nft_sales t1
join flow.core.dim_contract_labels t2
on t1.NFT_COLLECTION=t2.EVENT_CONTRACT
join flow.core.dim_topshot_metadata as t3
on t3.NFT_ID=t1.NFT_ID
where day >='2022-05-4' and day <= '2022-05-16'
),
TopShot_Sale_Info_In_Conference_Finals as (
select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*
from flow.core.fact_nft_sales t1
join flow.core.dim_contract_labels t2
on t1.NFT_COLLECTION=t2.EVENT_CONTRACT
join flow.core.dim_topshot_metadata as t3
on t3.NFT_ID=t1.NFT_ID
where day >= '2022-05-17' and day<='2022-05-29'
)
,
TopShot_Sale_Info_After_Conference_Finals as (
select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*
from flow.core.fact_nft_sales t1
join flow.core.dim_contract_labels t2
on t1.NFT_COLLECTION=t2.EVENT_CONTRACT
join flow.core.dim_topshot_metadata as t3
on t3.NFT_ID=t1.NFT_ID
where day >= '2022-05-30' and day <='2022-06-12'
)
select 'Average Daily Transaction Count' as "Average Daily Transaction Count",
(
select avg(Total_Transaction_Count) as Average_Daily_Transaction_Counte_Befour_Conferance from
Run a query to Download Data