LittlerDatala liga new buyers
    Updated 2022-12-07
    with allday_buyers as (
    select
    min(block_timestamp) as arrival
    ,buyer
    from flow.core.ez_nft_sales
    where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    group by 2
    ),

    allday as (
    select
    'All Day' as nft_collection
    ,date_trunc('day',arrival) as date_arrival
    ,count(buyer) as buyers
    ,sum(buyers) over (order by date_arrival) as cum_buyers
    ,row_number () over (order by date_arrival) as rn
    from allday_buyers
    group by 1, 2
    order by 2 asc
    limit 9
    ),
    topshot_buyers as (
    select
    min(block_timestamp) as arrival
    ,buyer
    from flow.core.ez_nft_sales
    where nft_collection = 'A.0b2a3299cc857e29.TopShot'
    group by 2
    ),

    topshot as (
    select
    'TopShot' as nft_collection
    ,date_trunc('day',arrival) as date_arrival
    ,count(buyer) as buyers