select

date_trunc('day', block_timestamp) as dt,

'Solana' as tag,

count(distinct signers[0]) as n_users

from solana.core.fact_transactions

where

block_timestamp >= current_date() - interval '30 days'

and block_timestamp < current_date()

group by 1

,ethereum_daily_users as(

select

date_trunc('day', block_timestamp) as dt,

'Ethereum' as tag,

count(distinct from_address) as n_users

from ethereum.core.fact_transactions

where

block_timestamp >= current_date() - interval '30 days'

and block_timestamp < current_date()

group by 1,2

,avalanche_daily_users as(

select

date_trunc('day', block_timestamp) as dt,

'Avalanche' as tag,

count(distinct from_address) as n_users