date_trunc('day', block_hour) as day,

avg(total_liquidity_token) as total_liquidity,

avg(total_stable_debt_token) as total_stable_debt,

avg(total_variable_debt_token) as total_variable_debt

from

ethereum.aave.ez_market_stats

where reserve_name = 'WETH'

and aave_version = 'Aave V2'

and day >= current_date() - 30

group by day