kiichiUntitled Query
    Updated 2022-08-02
    with new_poly as (
    select from_address as address , min(block_timestamp)::date as min_date
    from flipside_prod_db.polygon.transactions
    group by address

    )
    select count(address) as new_address, min_date,
    sum(new_address) over (order by min_date asc rows between unbounded preceding and current row) as cumulative_address
    from new_poly group by min_date
    Run a query to Download Data