with apy as (
select
avg(BORROW_RATE_STABLE) * 100 as borrow_rate_stable
from flipside_prod_db.aave.market_stats
where AAVE_version = '{{AaveVersion}}'
and block_hour between '{{DateFrom}}' and '{{DateTo}}'
and reserve_name = '{{ReserveName}}'
-- group by date
)
select * from apy
-- select * from flipside_prod_db.aave.market_stats limit 10