shreexCumulative User Growth Of NFL All Day
    Updated 2023-03-13
    With wallets as (
    select
    distinct buyer as nfl_all_day_wallets,
    min(block_timestamp) as min_date
    from flow.core.ez_nft_sales where nft_collection='A.e4cf4bdc1751c65d.AllDay' and tx_succeeded='TRUE'
    GROUP BY nfl_all_day_wallets
    UNION

    select
    distinct seller as nfl_all_day_wallets,
    min(block_timestamp) as min_date

    from flow.core.ez_nft_sales where nft_collection='A.e4cf4bdc1751c65d.AllDay' and tx_succeeded='TRUE'
    GROUP BY nfl_all_day_wallets
    HAVING count(nfl_all_day_wallets) = 1
    )
    select
    date_trunc('day',min_date) as date,
    count(distinct nfl_all_day_wallets) as user_growth,
    sum(user_growth) over (order by date) AS cumulative_user_growth
    from wallets
    GROUP BY date
    ORDER BY date
    Run a query to Download Data