saeedmznNFL All Day Tournament [Round 1] -
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with NFLallDay as (
select EVENT_CONTRACT, CONTRACT_NAME
from flow.core.dim_contract_labels
where contract_name ='AllDay'
group by 1,2
)
select
play_type,
count (distinct buyer) num_buyers ,
count (DISTINCT seller) num_sellers,
count (DISTINCT TX_ID ) num_sales,
sum (price) as sales_volume
-- sum (sales_volume) over (partition by play_type order by weekly) as cum_sales_volume
from flow.core.ez_nft_sales join flow.core.dim_allday_metadata using (nft_id)
where NFT_COLLECTION in (select EVENT_CONTRACT from NFLallDay )
and tx_succeeded = 'TRUE'
group by 1
Run a query to Download Data