DATE_TRUNC('{{granularity}}', block_timestamp) AS dt,

SUM(AMOUNT_USD) AS borrow_volume,

platform

FROM ethereum.defi.ez_lending_borrows

WHERE platform ILIKE 'Aave%'

AND block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'

GROUP BY 1, 3;