select

date_trunc('day', block_hour) as date,

avg(supply_rate) as supply_rate,

avg(borrow_rate_variable) as borrow_rate_variable,

avg(borrow_rate_stable) as borrow_rate_stable

from

flipside_prod_db.aave.market_stats

where

reserve_name = 'USDC'

and

aave_version = 'Aave V2'

and date_trunc('day', block_hour) >= CURRENT_DATE - 30

group by 1