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

    select *,'Algorand' from Algorand_new_users
    UNION
    select *,'Ethereum' from Ethereum_new_users
    UNION
    select *,'Solana' from Solana_new_users
    UNION
    select * ,'Terra' from Terra_new_users
    Run a query to Download Data