select

block_timestamp,

tx_hash,

origin_from_address,

concat('0x', substr(data, 24 + 3, 32 + 8)) as pool_address,

case

when topics[0] = '0xf565fdd70b3936f0ae8efc41c2e0822f9de5ecb4dc162b153b129ec4bb9cd93c' then 'AddLiquidity'

else 'DecLiquidity'

end as event,

case

when topics[0] = '0xf565fdd70b3936f0ae8efc41c2e0822f9de5ecb4dc162b153b129ec4bb9cd93c' then ethereum.public.udf_hex_to_int(substr(data, 131, 64))

else -ethereum.public.udf_hex_to_int(substr(data, 131, 64))

end as amount_0,

case

when topics[0] = '0xf565fdd70b3936f0ae8efc41c2e0822f9de5ecb4dc162b153b129ec4bb9cd93c' then ethereum.public.udf_hex_to_int(substr(data, 195, 64))

else -ethereum.public.udf_hex_to_int(substr(data, 195, 64))

end as amount_1

from

kaia.core.fact_event_logs

where

contract_address = '0x19b683a2f45012318d9b2ae1280d68d3ec54d663' -- kaiaswap LP NFT

and topics[0] in (

'0xf565fdd70b3936f0ae8efc41c2e0822f9de5ecb4dc162b153b129ec4bb9cd93c', -- add liquidity

'0x24f4b91fa7871755148bc2a9e01f85d6fd73ec2a0e6bd9a5717c0d7f5be8c2c3' -- remove liquidity

)

and concat('0x', substr(data, 24 + 3, 32 + 8)) in (

'0x4037ce3f802336b0682a821378b7b1e0ff52737b', -- USDC-USDT

'0x050bb0533a273b509ec502d5bf47dbb07d44c5bc', -- WKLAY-USDC

'0xe833e5e3a52839ff2a167eb5f3077f254d9d63e9', -- USDC-USDCe

'0xb9a1b7a04b6bbf4c319b46583c41f84edc6c9932' -- WKLAY-USDT

)

and block_timestamp > '2024-09-25'