select reserve_name,date_trunc('day',block_hour) as date,avg(supply_rate) supply,avg(borrow_rate_stable) stable,avg(borrow_rate_variable) variable
from flipside_prod_db.aave.market_stats
where aave_version = 'Aave V2' and reserve_name in ('WETH', 'DAI', 'USDT', 'USDC', 'WBTC')
group by DATE,reserve_name