WITH eth_transactions AS (

SELECT

DATE_TRUNC('month', block_timestamp) AS month,

COUNT(DISTINCT tx_hash) AS transactions,

'Ethereum' AS blockchain

FROM ethereum.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY month

),

btc_transactions AS (

SELECT

DATE_TRUNC('month', block_timestamp) AS month,

COUNT(DISTINCT tx_hash) AS transactions,

'Bitcoin' AS blockchain

FROM bitcoin.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY month

SELECT month, transactions, blockchain

FROM eth_transactions

UNION ALL

SELECT month, transactions, blockchain

FROM btc_transactions

ORDER BY month;