WITH ARBITRUM AS (

SELECT

'Arbitrum' AS chain,

COUNT(DISTINCT TX_HASH) AS transaction_count

FROM arbitrum.defi.ez_bridge_activity

WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2024-07-01'

),

BASE AS (

SELECT

'Base' AS chain,

COUNT(DISTINCT TX_HASH) AS transaction_count

FROM base.defi.ez_bridge_activity

WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2024-07-01'

),

OPTIMISM AS (

SELECT

'Optimism' AS chain,

COUNT(DISTINCT TX_HASH) AS transaction_count

FROM optimism.defi.ez_bridge_activity

WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2024-07-01'

SELECT chain, transaction_count

FROM ARBITRUM

UNION ALL

SELECT chain, transaction_count

FROM BASE

UNION ALL

SELECT chain, transaction_count

FROM OPTIMISM;