with transactions as (
select
min(block_timestamp) as block_timestamp,
'Ethereum' as block_chain,
from_address as address
from ethereum_core.fact_transactions
group by 2, 3
union all
select
min(block_timestamp) as block_timestamp,
'Ethereum' as block_chain,
to_address as address
from ethereum_core.fact_transactions
group by 2, 3
union all
select
min(block_timestamp) as block_timestamp,
'Solana' as block_chain,
tx_from
from solana.fact_transfers
group by 2, 3
union all
select
min(block_timestamp) as block_timestamp,
'Solana' as block_chain,
tx_to
from solana.fact_transfers
group by 2, 3
union all
select
min(block_timestamp) as block_timestamp,
'Terra' as block_chain,
event_from
from terra.transfers
group by 2, 3
union all