with eth_transactions as (
select
from_address,
min(block_timestamp) as first_tx
from ethereum.core.fact_transactions
group by from_address
),
sol_transactions as (
select
signers[0] as from_address,
min(block_timestamp) as first_tx
from solana.core.fact_transactions
where succeeded = 'TRUE'
group by from_address
),
eth_new as (
select
first_tx::date as date,
count(distinct(from_address)) as new_users
from eth_transactions
where first_tx >= '2022-04-01' -- from April
and first_tx < '2022-09-01' -- to August
group by date
),
sol_new as (
select
first_tx::date as date,
count(distinct(from_address)) as new_users
from sol_transactions
where first_tx >= '2022-04-01' -- from April
and first_tx < '2022-09-01' -- to August
group by date
)