BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS AS Trader,

CONTRACT_ADDRESS AS Token_address,

ethereum.public.udf_hex_to_int(data)::int/1e18 AS Amount,

Amount*price AS Amount_USD

blast.core.fact_event_logs A

inner join base.price.ez_hourly_token_prices B on B.TOKEN_ADDRESS='0x4200000000000000000000000000000000000006'

and date_trunc('hour',BLOCK_TIMESTAMP)=B.HOUR

ORIGIN_TO_ADDRESS in ('0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e','0x98994a9a7a2570367554589189dc9772241650f6')

and topics [0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and CONTRACT_ADDRESS='0x4300000000000000000000000000000000000004'

and ORIGIN_FUNCTION_SIGNATURE in (

'0x7ff36ab5',

'0x18cbafe5',

'0xfb3bdb41',

'0x791ac947',

'0xb6f9de95',

'0x38ed1739'

)

order by 1 desc limit 1000