WITH prices AS(

SELECT

DATE_TRUNC('day', hour) AS p_date,

token_address,

AVG(price) AS price

FROM base.price.ez_prices_hourly

GROUP BY 1, 2

),

lp_mints AS(

SELECT

DATE_TRUNC('day', a.block_timestamp) AS date,

CASE WHEN platform ILIKE '%uniswap%' THEN 'uniswap'

WHEN platform ILIKE '%aerodrome%' THEN 'aerodrome'

ELSE platform END AS dex,

b.pool_name,

b.tokens:token0 AS token0,

b.tokens:token1 AS token1,

b.symbols:token0 AS symbol0,

b.symbols:token1 AS symbol1,

decoded_log:amount0 AS amount0_added,

decoded_log:amount1 AS amount1_added,

decoded_log:amount0 / POW(10, COALESCE(b.decimals:token0, 18 )) AS amount0_added_new,

decoded_log:amount1 / POW(10, COALESCE(b.decimals:token1, 18)) AS amount1_added_new

FROM base.core.ez_decoded_event_logs AS a

INNER JOIN base.defi.dim_dex_liquidity_pools AS b ON a.contract_address = b.pool_address

AND (b.tokens:token0 = '0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf' OR b.tokens:token1 = '0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf')

--WHERE event_name = 'Mint'

WHERE event_name ilike '%Mint%'

),

lp_mints_new AS(

SELECT

date,

dex,

symbol0 || ' - ' || symbol1 AS pool,