SELECT

min(block_timestamp::date) AS first_transaction_date

FROM

flow.core.fact_transactions

), ethereum_date as (

SELECT

min(block_timestamp::date) AS first_transaction_date

FROM

ethereum.core.fact_transactions

), solana_date as (

SELECT

min(block_timestamp::date) AS first_transaction_date

FROM

solana.core.fact_transactions

select 'Flow' as network, first_transaction_date

from flow_date

union all

select 'Ethereum' as network, first_transaction_date

from ethereum_date

union all

select 'Solana' as network, first_transaction_date

from solana_date

order by first_transaction_date