DATE_TRUNC('HOUR',BLOCK_HOUR) AS DATE,

SUPPLY_RATE AS "SUPPLY RATE",

BORROW_RATE_STABLE AS "BORROW RATE STABLE",

BORROW_RATE_VARIABLE AS "BORROW RATE VARIABLE",

UTILIZATION_RATE AS "UTILIZATION RATE"

FROM flipside_prod_db.aave.market_stats

WHERE AAVE_VERSION = 'Aave V2'

and reserve_name = 'SNX'

AND DATE >= '2021-01-01'

order by 1 desc