SELECT

l.tx_hash AS transaction_hash,

l.event_index,

ROW_NUMBER() OVER (

PARTITION BY l.tx_hash

ORDER BY l.event_index ASC

) AS row_num,

l.contract_address AS pool_address,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64)) AS DECIMAL(38,0)) AS amount0In,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64)) AS DECIMAL(38,0)) AS amount1In,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 131, 64)) AS DECIMAL(38,0)) AS amount0Out,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 195, 64)) AS DECIMAL(38,0)) AS amount1Out,

t.block_timestamp

FROM boba.core.fact_event_logs l

JOIN boba.core.fact_transactions t ON l.tx_hash = t.tx_hash

WHERE l.contract_address IN (

'0xaf3da220bc03bdbf9b0280d6e2813ea0ffe03f69',

'0x78c6db2b6073e762f89a23eb3da71d2feeb18315',

'0x4f059f8d45230cd5b37544e87eebba033a5f1b17',

'0x6398a59ca706c11d02de1ea3d921742771bcd06f',

'0xce4956c398ba118f4eacabca1b32ae97bd31df2a',

'0x247442181b8baa03b3c7dc0d8e971bd4686db27c',

'0x48643395833882729032170078bf7791a0999f8c',

'0x3b444d1dbf68d1cfc64a8158affb6a24a6bdf038',

'0x2e014fe08247a080f2ed6d230b2594911f9f9a69',

'0x0ec9d6d21358221cccfc933530a8026038cedc12'

)

AND l.topics[0] = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'

),

pool_metadata AS (

SELECT

CONTRACT_ADDRESS AS pool_address,

SYMBOL_1,

SYMBOL_2,

SYMBOL_1_DECIMALS,