PromotedPawnCopy of Query 1 - New Users
    Updated 2022-05-07
    --Create a Dashboard for new users on : Algorand, Ethereum, Solana and Terra What trends do you see?

    with raw_terra as (
    select
    event_from as address,
    date_trunc('day',min(block_timestamp)) as first_transfer
    from terra.transfers
    group by event_from
    ),

    new_terra as (
    select
    first_transfer as daysterra,
    count(DISTINCT address) as new_terra_users,
    sum(new_terra_users) over (order by daysterra) as cum_new_terra
    from raw_terra
    group by 1
    order by 1
    ),
    raw_solana as (
    select
    tx_from as address,
    date_trunc('day',min(block_timestamp)) as first_transfer
    from solana.fact_transfers
    group by tx_from
    ),

    new_solana as (
    select
    first_transfer as dayssolana,
    count(DISTINCT address) as new_sol_users,
    sum(new_sol_users) over (order by dayssolana) as cum_new_sol
    Run a query to Download Data