WITH data_tab_lp AS (

SELECT

log.value:POOL_ADDRESS :: string AS lp_contract,

log.value:LP_PAIR :: string AS pair,

log.value:SYMBOL0 :: string AS symbol,

log.value:TOKEN_ADDRESS0 :: string AS Lp_token,

log.value:TOKEN_DECIMAL0 :: string AS Lp_token_decimal

FROM

(

SELECT

livequery.live.udf_api(

'https://flipsidecrypto.xyz/api/v1/queries/df78eb24-21c0-47d9-ae2e-2c8fe625d6cc/data/latest'

) as resp

),

LATERAL FLATTEN (input => resp:data) log

),

capybara_AddLiquidity_tab AS (

SELECT

'Add Liquidity' AS functions,

a.block_timestamp,

a.tx_hash,

a.origin_from_address,

concat('0x', substr(a.data, 24 + 3, 32 + 8)) AS Lp_token_deposits,

b.pair AS pool_name,

b.lp_contract,

b.Lp_token_decimal,

ethereum.public.udf_hex_to_int(substr(a.data,(64 * 2) + 24 + 3, 32 + 8)) AS lp_row_amount,

lp_row_amount / pow(10, b.Lp_token_decimal) AS lp_amount,

b.symbol

FROM

kaia.core.fact_event_logs a

JOIN data_tab_lp b on concat('0x', substr(a.data, 24 + 3, 32 + 8)) :: string = b.Lp_token :: string

WHERE

topics [0] = '0xf5dd9317b9e63ac316ce44acc85f670b54b339cfa3e9076e1dd55065b922314b' -- filter AddLiquidity functions deposit

AND a.tx_succeeded = TRUE