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