with txfee as (

SELECT *

FROM (

SELECT

'arbitrum' as blockchain,

'ETH' as symbol,

block_timestamp,

tx_hash,

tx_fee,

gas_used

FROM arbitrum.core.fact_transactions

UNION

SELECT

'avalanche' as blockchain,

'AVAX' as symbol,

block_timestamp,

tx_hash,

tx_fee,

gas_used

FROM avalanche.core.fact_transactions

UNION

SELECT

'base' as blockchain,

'ETH' as symbol,

block_timestamp,

tx_hash,

tx_fee,

gas_used

FROM base.core.fact_transactions

UNION

SELECT

'bsc' as blockchain,

'BNB' as symbol,

block_timestamp,