khanhSolana Total users in the last month
    Updated 2022-09-16
    select count(distinct(user_address)) as users_count from (
    select distinct(signers[0]) as user_address from solana.core.fact_transactions
    where succeeded = true
    and block_timestamp::date >= current_date - interval '{{ months}} months'

    union

    select distinct(signers[1]) as user_address from solana.core.fact_transactions
    where succeeded = true
    and block_timestamp::date >= current_date - interval '{{ months}} months'
    )
    Run a query to Download Data