date_trunc('day',block_timestamp) as dt,

count (distinct tx_from_address) as unq_solana

from Solana.transactions

where tx_id is not NULL

and block_timestamp >= '2022-02-01'

group by 1

order by 1

),

terra as (select

date_trunc('day',block_timestamp) as dt,

count(distinct msg_value:sender) as active_terra

from terra.msgs

where msg_value:sender is not null

and block_timestamp>='2022-02-01'

group by 1

order by 1

),

eth as (SELECT

date_trunc('day',block_timestamp) as dt,

count (distinct from_address) as unq_eth

from ethereum.transactions

where tx_id is not NULL

and block_timestamp >= '2022-02-01'

group by 1

order by 1

),

algo as (

select

date_trunc('day',block_timestamp) as dt,

count (distinct sender) as unqwlt

from algorand.transactions

where dt>='2022-02-01'