with

chain_tx as (

SELECT

gas_price_paid as gas_price,

gas_limit,

gas_used,

tx_fee,

tx_hash, block_timestamp,

'arbitrum' as chain

FROM

arbitrum.core.fact_transactions

UNION

ALL

SELECT

gas_price,

gas_limit,

gas_used,

tx_fee,

tx_hash, block_timestamp,

'optimism' as chain

FROM

optimism.core.fact_transactions

UNION

ALL

SELECT

gas_price,

gas_limit,

gas_used,

tx_fee,

tx_hash, block_timestamp,

'bnb' as chain

FROM

bsc.core.fact_transactions