SELECT DATE_TRUNC('day',Hour) AS DATE ,AVG(PRICE) AS ETH_PRICE

FROM ethereum.core.fact_hourly_token_prices

WHERE TOKEN_ADDRESS = LOWER('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')

AND Date >= CURRENT_DATE - 90

AND Date < CURRENT_DATE

Group By 1 ),

t1 AS (

SELECT DATE_TRUNC('day',BLOCK_TIMESTAMP) AS DATE1 , SUM(AMOUNT_OUT_USD) AS Swap_Volume

FROM ethereum.sushi.ez_swaps

WHERE Date1 >= CURRENT_DATE - 90

AND Date1 < CURRENT_DATE

GROUP BY 1 )

SELECT Date, ETH_PRICE, Swap_Volume

FROM t0

JOIN t1 ON t0.date=t1.date1