tx_hash,

contract_address as pool_address

FROM base.core.ez_decoded_event_logs

WHERE event_name = 'Mint'

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

AND decoded_log:owner is not NULL

),

add_liq as (SELECT

a.*,

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,

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 >= '2024-03-20' AND a.block_timestamp::date <= '2024-04-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 a