avg(reserve_price),

sum(borrow_rate_stable) as stable,

sum(borrow_rate_variable) as variable,

stable + variable as rate

from ethereum.aave.ez_market_stats

where block_hour >= CURRENT_DATE - {{Date}}

and reserve_name not in ('UNI-V2')

group by 1

order by 5 DESC

limit 50