SELECT 'aleo' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM aleo.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'aptos' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM aptos.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'arbitrum' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM arbitrum.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'avalanche' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM avalanche.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'axelar' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM axelar.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'base' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM base.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'bitcoin' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM bitcoin.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'blast' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM blast.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'bsc' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM bsc.stats.ez_core_metrics_hourly -- Binance Smart Chain (BSC)

UNION ALL

SELECT 'cosmos' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM cosmos.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'eclipse' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM eclipse.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'ethereum' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM ethereum.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'flow' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM flow.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'gnosis' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM gnosis.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'near' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM near.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'optimism' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM optimism.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'osmosis' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM osmosis.stats.ez_core_metrics_hourly

UNION ALL

SELECT 'polygon' AS blockchain, BLOCK_TIMESTAMP_HOUR, transaction_count FROM polygon.stats.ez_core_metrics_hourly