barbodCompare newcomers on Terra with Solana and Ethereum blockchains
    Updated 2022-04-25
    with t1 as(
    WITH join_date_per_terra_user as (
    SELECT
    msg_value:sender::string sender_address,
    MIN(DATE(block_timestamp)) join_date,
    DATEDIFF(day, MIN(DATE(block_timestamp)), CURRENT_DATE) user_age_days
    FROM terra.msgs
    WHERE tx_id is not null
    GROUP BY 1
    ORDER BY 2
    )

    SELECT
    date_trunc('day',join_date) as dt,
    COUNT(sender_address) new_terra_users,
    sum(new_terra_users) over(order by dt asc) as cumulative_terra
    FROM
    join_date_per_terra_user
    WHERE join_date >= '2022-01-01'
    GROUP BY 1
    ORDER BY 1),

    t2 as(WITH join_date_per_terra_user as (
    SELECT
    signers[0] sender_address,
    MIN(DATE(block_timestamp)) join_date,
    DATEDIFF(day, MIN(DATE(block_timestamp)), CURRENT_DATE) user_age_days
    FROM solana.fact_transactions
    WHERE tx_id is not null
    GROUP BY 1
    ORDER BY 2
    )

    SELECT
    date_trunc('day',join_date) as dt1,
    COUNT(sender_address) new_solana_users,
    Run a query to Download Data