SELECT

TX_HASH,

BLOCK_TIMESTAMP,

CONTRACT_ADDRESS,

AMOUNT,

-- HAS_PRICE,

AMOUNT_USD,

ROW_NUMBER() OVER (

PARTITION BY TX_HASH

ORDER BY

EVENT_INDEX ASC

) AS ROW_NUM

FROM

avalanche.core.ez_token_transfers

WHERE

(

ORIGIN_TO_ADDRESS = LOWER('0x18556DA13313f3532c54711497A8FedAC273220E')

or ORIGIN_TO_ADDRESS = LOWER('0xb4315e873dBcf96Ffd0acd8EA43f689D8c20fB30')

or ORIGIN_TO_ADDRESS = LOWER('0xE3Ffc583dC176575eEA7FD9dF2A7c65F7E23f4C3') --v2.0

)

AND ORIGIN_FUNCTION_SIGNATURE IN (

--v21,v22

'0xb066ea7c',

'0xe038e6dc',

'0x9ab6156b',

'0x1a24f9a9',

'0x2a443fae',

'0x4b801870',

'0x2075ad22',

'0x3dc8f8ec',

--v20

'0x92fe8e70',

'0x42f564a0',

'0x264bb94e',

'0x440830bd',