Mityimpact
Updated 2022-11-08
9
1
2
3
4
5
6
7
8
9
›
⌄
select count( TX_ID)as sales_volume,count(distinct BUYER)as unique_buyer,count(distinct SELLER)as unique_seller
, case
when BLOCK_TIMESTAMP>'2022-05-15' and BLOCK_TIMESTAMP<='2022-05-30' then 'during the NBA Conference Finals'
when BLOCK_TIMESTAMP>='2022-05-01' and BLOCK_TIMESTAMP<='2022-05-15' then 'before the NBA Conference Finals' end as nba_impact
from flow.core.fact_nft_sales
where NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'
and nba_impact is not null
group by 4