headitmanagerTotal number of new users
    Updated 2022-05-03
    with Algorand_new_users as (select address,first_tx_date as first_date from
    (select distinct sender as address, min(block_timestamp::date) as first_tx_date
    from algorand.transactions
    group by address) where first_date >= CURRENT_DATE - interval '60 days'
    )
    ,Ethereum_new_users as
    ( select address,first_tx_date as first_date from
    (select distinct from_address as address, min(block_timestamp::date) as first_tx_date
    from ethereum_core.fact_transactions
    group by address) where first_date >= CURRENT_DATE - interval '60 days'
    )
    ,Solana_new_users as
    ( select address,first_tx_date as first_date from
    (select distinct signers as address, min(block_timestamp::date) as first_tx_date
    from solana.fact_transactions
    group by address) where first_date >= CURRENT_DATE - interval '60 days'
    )
    ,Terra_new_users as
    ( select address ,first_tx_date as first_date from
    (select distinct tx_from[0] as address, min(block_timestamp::date) as first_tx_date
    from terra.transactions
    group by address) where first_date >= CURRENT_DATE - interval '60 days'
    )

    select 'Algorand Total New Users : ' as label , count(distinct address) as cnt from Algorand_new_users
    UNION
    select 'Ethereum Total New Users : ' as label , count(distinct address) as cnt from Ethereum_new_users
    UNION
    select 'Solana Total New Users : ' as label , count(distinct address) as cnt from Solana_new_users
    UNION
    select 'Terra Total New Users : ' as label ,count(distinct address) as cnt from Terra_new_users
    Run a query to Download Data