nickpayiatis_Users per day
    Updated 2023-03-04

    with users_year as (

    select
    count(distinct tx_signer) as "Active Wallets"
    from near.core.fact_transactions
    where block_timestamp::date >= current_date()-366
    )
    ,users_month as (
    select
    count(distinct tx_signer) as "Active Wallets"
    from near.core.fact_transactions
    where block_timestamp::date >= current_date()-31

    )
    select * from users_year
    union all
    select * from users_month