banbannardNFL All Day
Updated 2022-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select date_trunc('day', block_timestamp) as day,
'NFL All Day' as nft_collection,
sum(price) as nft_sales_vol,
sum(nft_sales_vol) over (order by day) as cumulative_nft_sales_vol
from flow.core.fact_nft_sales
where nft_collection ilike '%allday%'
and price > 0
and day >= '2022-04-20'
and tx_succeeded = 'TRUE'
group by 1
union
select date_trunc('day', block_timestamp) as day,
'NBA Top Shots',
sum(price) as nft_sales_vol,
sum(nft_sales_vol) over (order by day) as cumulative_nft_sales_vol
from flow.core.fact_nft_sales
where nft_collection ilike '%topshot%'
and price > 0
and day >= '2022-04-20'
and tx_succeeded = 'TRUE'
group by 1
order by 1 desc
Run a query to Download Data