---arbitrum

SELECT * EXCLUDE version, 'arbitrum' as label from arbitrum.vertex.ez_perp_trades

WHERE 1=1

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---base

SELECT *, 'base' as label from base.vertex.ez_perp_trades

WHERE 1=1

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---blitz

SELECT * , 'blitz' as label from blast.blitz.ez_perp_trades

WHERE 1=1

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---mantle

SELECT *, 'mantle' as label from mantle.vertex.ez_perp_trades

WHERE 1=1

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---sei

SELECT * , 'sei' as label from sei.vertex.ez_perp_trades

WHERE 1=1

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'