binhachonNew Addresses
    Updated 2022-05-28
    with transactions as (
    select
    block_timestamp,
    from_address
    from flipside_prod_db.polygon.transactions
    where nonce = 0
    )
    select
    date_trunc('{{timefram}}', block_timestamp) as time,
    count(*) as number_of_new_users,
    sum(number_of_new_users) over (order by time) as total_users
    from transactions
    group by 1
    Run a query to Download Data