KaskoazulNew Users on Algorand vs. Ethereum vs. Solana vs. Terra since January 2022
    Updated 2022-05-05
    with ETH_FIRST_TX as (
    select from_address as ETH_users, min (block_timestamp::date) as fecha
    from ethereum.transactions
    group by ETH_users
    ),

    ETH_NEW_USERS as (
    select fecha,
    count (ETH_users) as new_users,
    sum (new_users) over (order by fecha) as cum_new_users
    from ETH_FIRST_TX
    where fecha >= {{Fecha}}
    group by 1
    ),

    TERRA_FIRST_TX as (
    select sender as TERRA_users,
    min (block_timestamp::date) as fecha
    from terra.transfer_events
    group by TERRA_users
    ),

    TERRA_NEW_USERS as (
    select fecha,
    count (TERRA_users) as new_users,
    sum (new_users) over (order by fecha) as cum_new_users
    from TERRA_FIRST_TX
    where fecha >= {{Fecha}}
    group by 1
    ),

    SOL_FIRST_TX as (
    select tx_from as SOL_users,
    min (block_timestamp::date) as fecha
    from solana.fact_transfers
    group by SOL_users
    Run a query to Download Data