with

perp_trades as (

select

*

from blast.blitz.ez_perp_trades

where 1 = 1

,

edge_trades as (

select

* ,

event_index - 1 AS trader_event_before,

event_index + 1 AS trader_event_after

from perp_trades

where trader = '0x0000000000000000000000000000000000000000'

,

FINAL AS (

SELECT

e.block_number,

e.block_timestamp,

e.tx_hash,

e.event_index AS edge_event_index,

e.trader_event_before AS user_event_index,

e.digest AS edge_digest,

p.digest AS user_digest,

p.trader,

p.subaccount,

p.symbol,

e.order_type AS edge_order_type,

p.order_type AS user_order_type,

e.is_taker AS edge_is_taker,

p.is_taker AS user_is_taker,

e.trade_type AS edge_trade_type,

p.trade_type AS user_trade_type,