select

ORIGIN_FROM_ADDRESS trader,

TRACE_INDEX EVENT_INDEX ,

'ETH' symbol ,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH ,

from_address,

from blast.core.ez_native_transfers

where ORIGIN_TO_ADDRESS = '0x337827814155ecbf24d20231fca4444f530c0555'

and origin_from_address not in (

select distinct address from blast.core.dim_labels

union all

select distinct address from blast.core.dim_contracts)

),

token_transfers as (

select ORIGIN_FROM_ADDRESS trader,

EVENT_INDEX ,

SYMBOL,

AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

from_address,

from blast.core.ez_token_transfers

where ORIGIN_TO_ADDRESS = '0x337827814155ecbf24d20231fca4444f530c0555'

and origin_from_address not in (

select distinct address from blast.core.dim_labels

union all

select distinct address from blast.core.dim_contracts)

),

swaps as (

select * from eth_transfers