'Solana' as network

, extract('month',block_timestamp_hour) as month

, avg(transaction_count) as avg_transactions_count

, avg(unique_signers_count) as avg_users_signing

, avg(block_count) as avg_blocks

FROM solana.stats.ez_core_metrics_hourly

WHERE 1=1

and datediff( day, block_timestamp_hour, date_trunc('day',current_timestamp) ) <= 180

group by 2

UNION ALL

SELEct 'Bitcoin' as network

, extract('month',block_timestamp_hour) as month

, avg(transaction_count) as avg_transactions_count

, avg(UNIQUE_ADDRESS_COUNT) as avg_users_signing

, avg(block_count) as avg_blocks

FROM bitcoin.stats.ez_core_metrics_hourly

WHERE 1=1

and datediff( day, block_timestamp_hour, date_trunc('day',current_timestamp) ) <= 180

group by 2