select DISTINCT

AVG(supply_usd+ reserves_usd) over (partition by date_trunc('Day', block_hour), underlying_symbol order by date_trunc('Day', block_hour), underlying_symbol) AS Deposits,

AVG(borrows_usd) over (partition by date_trunc('Day', block_hour), underlying_symbol order by date_trunc('Day', block_hour), underlying_symbol) AS Borrows,

underlying_symbol as Token,

date_trunc('Day', block_hour) DAY

from compound.market_stats

where block_hour >= CURRENT_DATE - 180

order by DAY desc