with merge as (

---arbitrum

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

WHERE 1=1

AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---base

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

WHERE 1=1

AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---blitz

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

WHERE 1=1

AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---mantle

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

WHERE 1=1

AND block_timestamp::date BETWEEN '{{start_date}}' AND '{{end_date}}'

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'