binhachonCitizens of NEAR
    Updated 2022-07-06
    with user_list_1 as (
    select
    date_trunc('day', block_timestamp) as time_1,
    tx_signer as address_1
    from flipside_prod_db.mdao_near.transactions
    group by 1, 2
    union
    select
    date_trunc('day', block_timestamp) as time,
    tx_receiver as address_1
    from flipside_prod_db.mdao_near.transactions
    group by 1, 2
    ),
    active_addresses as (
    select
    time_1,
    sum(1) as active_address
    from user_list_1
    where time_1 >= getdate() - interval'90 days'
    group by 1
    ),
    first_day as (
    select
    active_address as first_day
    from active_addresses
    order by time_1
    limit 1
    )
    select
    active_addresses.*,
    first_day,
    active_address * 100 / first_day as perc_growth
    from active_addresses
    left join first_day


    Run a query to Download Data