SELECT

tx_hash,

origin_to_address AS pool_address,

block_timestamp

FROM

ink.core.ez_decoded_event_logs

WHERE

event_name = 'Swap'

AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'

AND block_timestamp IS NOT NULL

AND tx_succeeded = TRUE

),

token_transfers AS (

SELECT

tx_hash,

contract_address,

symbol,

amount_usd,

event_index

FROM

ink.core.ez_token_transfers

),

ranked_transfers AS (

SELECT

tx_hash,

symbol,

amount_usd,

event_index,

ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY event_index) AS rank

FROM

token_transfers

),