-- 'add_liquidity' 'remove_liquidity'

with swap_addliquidity as (

SELECT

DISTINCT tx_id as tx,

block_timestamp,

b.address_name

FROM sei.core.fact_msg_attributes a

LEFT JOIN sei.core.dim_labels b ON a.ATTRIBUTE_VALUE = b.address

WHERE ATTRIBUTE_KEY = '_contract_address'

AND ATTRIBUTE_VALUE IN (SELECT address FROM sei.core.dim_labels WHERE label ilike 'fuzio')

AND b.address_name NOT ilike '%bonding%'

,

add_liquidity as (

SELECT b.*

FROM sei.core.fact_msg_attributes a

INNER JOIN swap_addliquidity b ON a.tx_id = b.tx

WHERE ATTRIBUTE_KEY = 'action' AND ATTRIBUTE_VALUE = 'add_liquidity'

,

remove_liqudity as (

SELECT b.*

FROM sei.core.fact_msg_attributes a

INNER JOIN swap_addliquidity b ON a.tx_id = b.tx

WHERE ATTRIBUTE_KEY = 'action' AND ATTRIBUTE_VALUE = 'remove_liquidity'

,

token_amount_add as (

SELECT

tx_id,

2*ATTRIBUTE_VALUE as token_amount_sei

FROM sei.core.fact_msg_attributes

WHERE tx_id IN (SELECT tx FROM add_liquidity)