SELECT

'Arbitrum' AS chain,

block_timestamp,

symbol,

tx_hash,

trader,

amount_usd,

fee_amount

FROM arbitrum.vertex.ez_perp_trades

WHERE is_taker = 'true'

UNION

SELECT

'Blitz' AS chain,

block_timestamp,

symbol,

tx_hash,

trader,

amount_usd,

fee_amount

FROM blast.blitz.ez_perp_trades

WHERE is_taker = 'true'

UNION

SELECT

'Base' AS chain,

block_timestamp,

symbol,

tx_hash,

trader,

amount_usd,

fee_amount

FROM base.vertex.ez_perp_trades