date_trunc('day', block_hour) as block_day

, aave_market

, reserve_name

, aave_version

, min(block_number) as block_number

, avg(total_liquidity_token) as total_liquidity_token

, avg(total_liquidity_usd) as total_liquidity_usd

, avg(total_stable_debt_token) as total_stable_debt_token

, avg(total_stable_debt_usd) as total_stable_debt_usd

, avg(total_variable_debt_token) as total_variable_debt_token

, avg(total_variable_debt_usd) as total_variable_debt_usd

, avg(supply_rate) as supply_rate

, avg(borrow_rate_stable) as borrow_rate_stable

, avg(borrow_rate_variable) as borrow_rate_variable

, avg(utilization_rate) as utilization_rate

from ethereum.aave.ez_market_stats

where 1=1

and aave_market in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','0xae7ab96520de3a18e5e111b5eaab095312d7fe84')

and aave_version = 'Aave V2'

and block_hour > current_date - interval '90 days'

group by block_day, aave_market, reserve_name, aave_version