with trades_data as (

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

WHERE 1=1

AND (DATEDIFF('month', '{{start_date}}', block_timestamp::date) BETWEEN -9 and 2)

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---base

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

WHERE 1=1

AND (DATEDIFF('month', '{{start_date}}', block_timestamp::date) BETWEEN -9 and 2)

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---blitz

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

WHERE 1=1

AND (DATEDIFF('month', '{{start_date}}', block_timestamp::date) BETWEEN -9 and 2)

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---mantle

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

WHERE 1=1

AND (DATEDIFF('month', '{{start_date}}', block_timestamp::date) BETWEEN -9 and 2)

AND trader != '0x0000000000000000000000000000000000000000'

AND subaccount!='0x0000000000000000000000000000000000000000000000000000000000000001'

UNION ALL

---sei