barbodsol1
    Updated 2022-05-27
    with tb1 as (select
    block_timestamp::date as day,
    count (distinct FROM_ADDRESS) as active_user_eth,
    sum(active_user_eth) over (order by day) as cum_active_ETH
    from ethereum_core.fact_transactions
    where tx_hash is not null
    and block_timestamp >= '2022-01-01'
    group by 1),

    tb2 as (select
    block_timestamp::date as day,
    count (distinct signers[0]) as active_user_solana,
    sum(active_user_solana) over (order by day asc) as cum_active_solana
    from solana.fact_transactions
    where tx_id is not null
    and block_timestamp >= CURRENT_DATE-90
    group by 1)

    select
    tb1.day as day,
    active_user_solana,
    active_user_eth,
    cum_active_solana,
    cum_active_ETH
    from tb1
    inner join tb2 on tb1.day=tb2.day
    Run a query to Download Data