with add_liquidity AS (

SELECT

block_timestamp,

tx_id,

msg:sender AS sender,

(CASE

WHEN msg:tokens_provided[0]:denom = 'factory/osmo1mlng7pz4pnyxtpq0akfwall37czyk9lukaucsrn30ameplhhshtqdvfm5c/ulvn' THEN 'LVN'

WHEN msg:tokens_provided[0]:denom = 'ibc/498A0751C798A0D9A389AA3691123DADA57DAA4FE165D5C75894505B876BA6E4' THEN 'USDC'

WHEN msg:tokens_provided[0]:denom = 'uosmo' THEN 'OSMO'

END) AS first_token_symbol,

msg:tokens_provided[0]:amount AS first_token_raw_amount,

msg:tokens_provided[0]:amount/pow(10,6) AS first_token_amount,

(CASE

WHEN msg:tokens_provided[1]:denom = 'factory/osmo1mlng7pz4pnyxtpq0akfwall37czyk9lukaucsrn30ameplhhshtqdvfm5c/ulvn' THEN 'LVN'

WHEN msg:tokens_provided[1]:denom = 'ibc/498A0751C798A0D9A389AA3691123DADA57DAA4FE165D5C75894505B876BA6E4' THEN 'USDC'

WHEN msg:tokens_provided[1]:denom = 'uosmo' THEN 'OSMO'

END) AS second_token_symbol,

msg:tokens_provided[1]:amount AS second_token_raw_amount,

msg:tokens_provided[1]:amount/pow(10,6) AS second_token_amount,

msg:pool_id AS pool_id,

(CASE

WHEN msg:pool_id = '1325' THEN 'LVN/OSMO'

WHEN msg:pool_id = '1337' THEN 'LVN/USDC'

END

) AS pool_name

FROM osmosis.core.fact_tx_body_msgs

WHERE tx_succeeded

AND msg_type = '/osmosis.concentratedliquidity.v1beta1.MsgCreatePosition'

AND msg:pool_id IN ('1325','1337')

AND block_timestamp::date >= '2023-12-16'

AND sender = '{{wallet_address}}'

),