shreexNBA TopShots Daily Sales Volume
Updated 2022-07-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('d',block_timestamp) as date,
case
when date <= '2022-06-16' then 'Before Conference Finals'
when date between '2022-06-17' and '2022-06-29' then 'During Conference Finals'
when date > '2022-06-29' then 'After Conference Finals' else 'block_timestamp' end as before_or_after,
sum(price) as daily_volume_usd,
count(*) as daily_sales_count
from flow.core.fact_nft_sales
where nft_collection='A.0b2a3299cc857e29.TopShot' and currency='A.ead892083b3e2c6c.DapperUtilityCoin' and tx_succeeded='TRUE'
GROUP BY date,before_or_after
ORDER BY date
Run a query to Download Data