flipside

    Near protocol: New users
    zakkisyedNear protocol: New users
    Updated 2022-07-02
    select count (users), date_trunc(day, earliest_date)

    from (

    select distinct tx_signer as users, min(block_timestamp) as earliest_date

    from flipside_prod_db.mdao_near.transactions
    group by 1

    )
    group by 2
    order by 2 desc
    Run a query to Download Data