Updated 2022-10-22
    with tab1 as (
    SELECT BUYER, min(BLOCK_TIMESTAMP::date) as daily
    from flow.core.ez_nft_sales
    where NFT_COLLECTION ilike '%raceday%'
    and TX_SUCCEEDED ilike '%TRUE%'
    group by 1
    )
    SELECT daily , count(buyer) as new_buyer,
    sum(new_buyer) over(order by daily) as cumulative_new_buyer
    from tab1
    GROUP by 1
    order by 3 DESC


    Run a query to Download Data