primo_datatotal_circulation
Updated 2022-07-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date(MOMENT_DATE) dt
, case when d.team in ('Golden State Warriors', 'Boston Celtics', 'Dallas Mavericks', 'Miami Heat') then d.team else 'Other' end playoff_teams
, sum(TOTAL_CIRCULATION) sales_ct
from flow.core.dim_topshot_metadata d
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
--and date(s.block_timestamp) >= date('2022-05-17')
--and date(s.block_timestamp) <= date('2022-05-29')
and date(MOMENT_DATE) > date('2022-04-01')
group by 1,2
Run a query to Download Data