SELECT

tx_hash,

contract_address AS pool_address

FROM base.core.ez_decoded_event_logs

WHERE event_name = 'Mint'

AND block_timestamp::date >= '2024-03-01'

AND decoded_log:owner IS NOT NULL

),

add_liq AS (

SELECT

a.block_timestamp::date AS date,

a.tx_hash,

decoded_log:"amount0" AS amount0,

decoded_log:"amount1" AS amount1,

symbols:"token0" AS token0,

symbols:"token1" AS token1,

decimals:"token0" AS decimals0,

decimals:"token1" AS decimals1,

b.pool_address,

c.pool_name

FROM base.core.ez_decoded_event_logs a

LEFT JOIN pools b ON a.tx_hash = b.tx_hash

LEFT JOIN base.defi.dim_dex_liquidity_pools c ON b.pool_address = c.pool_address

WHERE contract_name ILIKE '%uniswap%'

AND event_name ILIKE 'Increaseliquidity'

AND a.block_timestamp::date BETWEEN '2024-03-01' AND '2024-05-01'

),

user_add_liq AS (

SELECT

block_timestamp::date AS date,

origin_from_address AS users,

COUNT(DISTINCT tx_hash) AS lp_action

FROM base.core.ez_decoded_event_logs