flipside

    Ethereum Total users in the last month
    khanhEthereum Total users in the last month
    Updated 2022-09-16
    select count(distinct(user_address)) as users_count from (
    select distinct(from_address) as user_address from ethereum.core.fact_transactions
    where status = 'SUCCESS'
    and block_timestamp::date >= current_date - interval '{{ months}} months'

    union

    select distinct(to_address) as user_address from ethereum.core.fact_transactions
    where status = 'SUCCESS'
    and block_timestamp::date >= current_date - interval '{{ months}} months'
    )
    Run a query to Download Data