shreexNBA TopShots Daily Sales Volume
    Updated 2022-07-12
    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