CASE

WHEN Pool_Name = '-WETH SLP' THEN 'AAVE/ETH LP'

ELSE Pool_Name

END AS FIXED_POOL_NAME

FROM ethereum.core.dim_dex_liquidity_pools WHERE PLATFORM = 'sushiswap'),

ADD_LIQUIDITY_RAW AS (

SELECT BLOCK_TIMESTAMP::DATE AS DAYS,TX_HASH ,ORIGIN_FROM_ADDRESS AS Provider,

POOL_NAME, FIXED_POOL_NAME , POOL_ADDRESS,EVENT_INPUTS:amount0 AS TOLKEN0_RAW_AMOUNT, TOKEN0 AS TOKEN0_CONTRACT ,EVENT_INPUTS:amount1 AS TOLKEN1_RAW_AMOUNT,TOKEN1 AS TOKEN1_CONTRACT,

CASE

WHEN Days BETWEEN '2022-09-01' AND '2022-09-14' THEN 'Before Merge'

WHEN Days BETWEEN '2022-09-15' AND '2022-09-28' THEN 'After Merge'

END AS Time_Period

FROM ethereum.core.fact_event_logs JOIN SUSHISWAP_POOLS ON CONTRACT_ADDRESS = POOL_ADDRESS

WHERE Days BETWEEN '2022-09-01' AND '2022-09-28' AND EVENT_NAME = 'Mint'

),

ADDED_TOKENS AS (

SELECT TOKEN0_CONTRACT AS CONTRACT FROM ADD_LIQUIDITY_RAW

UNION

SELECT TOKEN1_CONTRACT AS CONTRACT FROM ADD_LIQUIDITY_RAW

),

TOKEN_PRICES AS (

SELECT HOUR::DATE AS DAYS, AVG(PRICE) AS Price, Symbol,TOKEN_ADDRESS, IFF(DECIMALS IS NULL, 18, DECIMALS) AS DECIMALS

FROM ADDED_TOKENS JOIN ethereum.core.fact_hourly_token_prices ON (CONTRACT = TOKEN_ADDRESS)

WHERE DAYS BETWEEN '2022-09-01' AND '2022-09-28'

GROUP BY DAYS, SYMBOL, TOKEN_ADDRESS, DECIMALS ),

ADD_AMOUNT_TOKEN0 AS(

SELECT ADD_LIQUIDITY_RAW.DAYS, Time_Period ,TX_HASH, PROVIDER, POOL_NAME,FIXED_POOL_NAME ,POOL_ADDRESS,TOKEN0_CONTRACT,TOKEN_PRICES.SYMBOL AS TOKEN0_SYMBOL, TOKEN_PRICES.PRICE AS TOKEN0_PRICE ,

TOLKEN0_RAW_AMOUNT, DECIMALS AS TOKEN0_DECIMALS, TOLKEN0_RAW_AMOUNT/(POW(10, TOKEN0_DECIMALS)) * TOKEN0_PRICE AS TOKEN0_AMOUNT_USD,