with

perp_trades as (

select

a.* , b.product_id

from blast.blitz.ez_perp_trades a

left join (

select tx_hash ,

block_timestamp,

event_index,

livequery.utils.udf_hex_to_int(topics[1]) as product_id

from blast.core.fact_event_logs

where tx_hash IN (select tx_hash from blast.blitz.ez_perp_trades)

) b using(block_timestamp, tx_hash, event_index)

,

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,