freemartianFinalists Daily Sales
Updated 2022-07-09
9
1
2
3
4
5
6
7
›
⌄
select sum(price) as volume, team, date_trunc('day', block_timestamp::date) as TIME
from flow.core.fact_nft_sales s
inner join flow.core.dim_topshot_metadata m on s.nft_id = m.nft_id
where block_timestamp between '2022-05-17' and '2022-05-29'
and s.nft_collection = 'A.0b2a3299cc857e29.TopShot'
and team in ('Dallas Mavericks', 'Boston Celtics', 'Miami Heat', 'Golden State Warriors')
group by team, TIME
Run a query to Download Data