WITH swaptxns as (

SELECT tx_hash

FROM avalanche.core.ez_decoded_event_logs

WHERE contract_address='0xeed3c159f3a96ab8d41c8b9ca49ee1e5071a7cdd'

AND event_name='SwapExecuted'

),

native_transfers as (

SELECT

ORIGIN_FROM_ADDRESS trader,

TRACE_INDEX EVENT_INDEX,

'AVAX' symbol,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

from_address,

TO_ADDRESS

FROM avalanche.core.ez_native_transfers

WHERE tx_hash IN (SELECT * FROM swaptxns)

),

token_transfers as (

SELECT

ORIGIN_FROM_ADDRESS trader,

EVENT_INDEX,

SYMBOL,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

from_address,

TO_ADDRESS

FROM avalanche.core.ez_token_transfers

WHERE tx_hash IN (SELECT * FROM swaptxns)

),

swaps as (

SELECT * FROM native_transfers