AS (SELECT symbol AS mah,

Avg (price) AS op

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol IN ( 'WETH', 'UNI', 'AAVE', 'CRV',

'MKR', 'LINK', 'COMP','ALGO','MATIC','SOL','ATOM' )

AND hour BETWEEN CURRENT_DATE - 32 AND CURRENT_DATE - 29

GROUP BY 1)

SELECT

Date_trunc('day', hour) as timespan,

symbol,

( Avg(price - op) / Avg(op) ) * 100 AS price_changes

FROM ethereum.core.fact_hourly_token_prices

JOIN g

ON mah = symbol

WHERE symbol IN ( 'WETH', 'UNI', 'AAVE', 'CRV',

'MKR', 'LINK', 'COMP','ALGO','MATIC','SOL','ATOM' )

AND hour > CURRENT_DATE - 30

GROUP BY 1,

2