all_bridge_txns as (

SELECT *, 'Arbitrum' as src_chain FROM arbitrum.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'OP' as src_chain FROM optimism.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'BSC' as src_chain FROM bsc.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'BASE' as src_chain FROM base.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'Ethereum' as src_chain FROM ethereum.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'Polygon' as src_chain FROM polygon.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'Gnosis' as src_chain FROM gnosis.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT *, 'Avalanche' as src_chain FROM avalanche.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - interval '{{past_period}}'

),

all_traces as (

SELECT tx_hash, tx_status, 'Arbitrum' as src_chain FROM arbitrum.core.fact_traces

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT tx_hash, tx_status, 'OP' as src_chain FROM optimism.core.fact_traces

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL

SELECT tx_hash, tx_status, 'BSC' as src_chain FROM bsc.core.fact_traces

WHERE block_timestamp >= current_date - interval '{{past_period}}'

UNION ALL