sinahosseinzadehUntitled Query
    Updated 2022-08-01

    WITH
    active_users as (
    SELECT
    distinct from_address as active_user--,
    from flipside_prod_db.polygon.transactions
    where block_timestamp>=CURRENT_DATE-INTERVAL '3 MONTHS'
    group by 1
    ),
    active_users_n as (
    select count (distinct active_user) as active_users_doing_transactions from active_users
    ),
    active_users_2 as (
    SELECT
    distinct to_address as active_receiver--,
    from flipside_prod_db.polygon.transactions
    where block_timestamp>=CURRENT_DATE-INTERVAL '3 MONTHS'
    group by 1
    ),
    active_users_21 as (
    SELECT
    count(distinct active_receiver) as active_users_receiving_tokens--,

    from active_users_2
    where active_receiver not in (select active_user from active_users)
    )
    select
    active_users_doing_transactions,
    active_users_receiving_tokens,
    active_users_doing_transactions+active_users_receiving_tokens as current_total_active_users
    from active_users_n, active_users_21



    Run a query to Download Data