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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

UNION ALL

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

WHERE block_timestamp >= current_date - {{past_n_days}}

-- UNION

-- SELECT *, 'Blast' as src_chain FROM blast.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

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

UNION

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

UNION

SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'BASE' AS chain from base.price.ez_prices_hourly