SELECT * FROM base.core.ez_decoded_event_logs

WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'

AND block_timestamp::date >= '2025-01-09'

),

uniswap_lp AS(

SELECT

block_timestamp, tx_hash,event_name,

(CASE WHEN event_name = 'DecreaseLiquidity' THEN -(decoded_log:amount0/pow(10,18)) ELSE (decoded_log:amount0/pow(10,18)) END) AS amount,

origin_from_address AS user

FROM base.core.ez_decoded_event_logs

WHERE tx_hash in (SELECT tx_hash FROM uniswap_datas)

AND event_name IN ('DecreaseLiquidity','IncreaseLiquidity','SwapAndIncreaseLiquidity')

AND block_timestamp::date >= '2025-01-09'

Count(DISTINCT user) AS user, SUM(amount) AS amounts

FROM uniswap_lp