mlhTopShot
    Updated 2022-12-06
    select day,
    collection_name,
    case when purchases = 1 then 'purchase 1 time'
    when purchases > 1 and purchases <= 5 then 'purchase 2 to 5 times'
    when purchases > 5 and purchases <= 10 then 'purchased 6 to 10 times'
    else 'purhase more than 10 times'
    end as purchase_count,
    count(distinct(wallet)) as wallet_count,
    sum(price) as USD_volume
    from (select date_trunc('day', block_timestamp) as day,
    case when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA TopShot'
    end as collection_name,
    buyer as wallet,
    price,
    count(distinct(tx_id)) as purchases
    from flow.core.ez_nft_sales
    where tx_succeeded = 'TRUE'
    and nft_collection in ('A.0b2a3299cc857e29.TopShot')
    group by 1,2, 3, 4
    )
    where day <= '2020-10-20'
    group by 1,2, 3
    Run a query to Download Data