LTirrellnear_citizens_users-near
    Updated 2022-10-03
    with active_users_30d as (
    select
    distinct t.tx_signer as users
    from
    flipside_prod_db.mdao_near.transactions t
    where
    t.block_timestamp :: date >= current_date - 30
    ),
    active_user_activity as (
    select
    t.block_timestamp :: date as datetime,
    count(t.tx_hash) as active_users_tx,
    count(distinct t.tx_signer) as active_users,
    active_users_tx / active_users as tx_per_active_users
    from
    flipside_prod_db.mdao_near.transactions t
    where
    datetime >= current_date -90
    and t.tx_signer in (
    select
    users
    from
    active_users_30d
    )
    group by
    datetime
    ),
    all_user_activity as (
    select
    t.block_timestamp :: date as datetime,
    count(t.tx_hash) as all_users_tx,
    count(distinct t.tx_signer) as all_users,
    all_users_tx / all_users as tx_per_all_users
    from
    flipside_prod_db.mdao_near.transactions t
    where
    Run a query to Download Data