binhachonNew Users on Algorand vs. Ethereum vs. Solana vs. Terra - All time
    Updated 2022-05-02
    with transactions as (
    select
    min(block_timestamp) as block_timestamp,
    'Ethereum' as block_chain,
    from_address as address
    from ethereum_core.fact_transactions
    group by 2, 3
    union all
    select
    min(block_timestamp) as block_timestamp,
    'Ethereum' as block_chain,
    to_address as address
    from ethereum_core.fact_transactions
    group by 2, 3
    union all
    select
    min(block_timestamp) as block_timestamp,
    'Solana' as block_chain,
    tx_from
    from solana.fact_transfers
    group by 2, 3
    union all
    select
    min(block_timestamp) as block_timestamp,
    'Solana' as block_chain,
    tx_to
    from solana.fact_transfers
    group by 2, 3
    union all
    select
    min(block_timestamp) as block_timestamp,
    'Terra' as block_chain,
    event_from
    from terra.transfers
    group by 2, 3
    union all
    Run a query to Download Data