SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Arbitrum' as src_chain FROM arbitrum.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'OP' as src_chain FROM optimism.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'BSC' as src_chain FROM bsc.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'BASE' as src_chain FROM base.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Ethereum' as src_chain FROM ethereum.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Polygon' as src_chain FROM polygon.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Gnosis' as src_chain FROM gnosis.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Avalanche' as src_chain FROM avalanche.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Blast' as src_chain FROM blast.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

SELECT contract_address, event_name, block_timestamp, tx_hash, decoded_log, 'Ink' as src_chain FROM ink.core.ez_decoded_event_logs

WHERE block_timestamp >= current_date - {{past_n_days}}

),

prices as (

SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'Arbitrum' AS chain FROM arbitrum.price.ez_prices_hourly

UNION ALL

SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'OP' AS chain FROM optimism.price.ez_prices_hourly

UNION ALL