'Blitz' as platform,

tx_hash,

trader,

symbol,

case when is_taker = 'true' then amount_usd else 0 end as amount

from blast.blitz.ez_perp_trades)

,

vertex as (select block_timestamp,

'Vertex' as platform,

tx_hash,

trader,

symbol,

case when is_taker = 'true' then amount_usd else 0 end as amount

from arbitrum.vertex.ez_perp_trades

UNION all

select block_timestamp,

'Vertex' as platform,

tx_hash,

trader,

symbol,

case when is_taker = 'true' then amount_usd else 0 end as amount

from arbitrum.vertex.ez_spot_trades

,

tblitz as ( select platform,

count(DISTINCT trader) as blitz_trader,

count(DISTINCT tx_hash) as blitz_tx,

sum(amount) as blitz_volume,

avg(amount) as avg_b_volume

from blitz

where block_timestamp::date >= current_date - 30

group by 1)

,

tvertex as ( select platform,

count(DISTINCT trader) as vertex_trader,