block_hour,

avg(total_liquidity_token) as supplied,

avg(total_liquidity_usd) as supplied_usd,

avg(total_stable_debt_token+total_variable_debt_token) as borrowed,

avg(total_stable_debt_usd+total_variable_debt_usd) as borrowed_usd

from ethereum.aave.ez_market_stats

where reserve_name = 'WETH'

and block_hour = date(block_hour)

and aave_version = 'Aave V2'

group by 1

order by block_hour desc

limit 180