With pools as (SELECT

tx_hash,

WHEN event_name = 'Mint' THEN 'IncreaseLiquidity'

WHEN event_name = 'Burn' THEN 'DecreaseLiquidity'

ELSE 'null'

END as mint_or_burn,

contract_address as pool_address

FROM base.core.ez_decoded_event_logs

WHERE (event_name = 'Mint' or event_name = 'Burn')

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

AND block_timestamp::date < '2024-05-01'

AND decoded_log:owner is not NULL

),

add_or_remove_liq as (SELECT

block_timestamp as block_timestamp2,

block_timestamp::date as block_date,

a.tx_hash as tx_hash2,

origin_from_address as wallet_address,

event_name,

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)-- AND mint_or_burn = a.event_name)

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' OR event_name ilike 'Decreaseliquidity')