*,

sum(fee_volume_usd) over (ORDER BY week) as total_fees

FROM (

SELECT

date_trunc('week', block_timestamp) as week,

sum(FLASHLOAN_AMOUNT_USD) as flashloan_volume_usd,

sum(PREMIUM_AMOUNT_USD) as fee_volume_usd,

COUNT(DISTINCT tx_hash) as events,

count(DISTINCT INITIATOR_ADDRESS) as users

FROM ethereum.aave.ez_flashloans

WHERE FLASHLOAN_AMOUNT_USD < 100000000000

GROUP BY 1 --,2

ORDER BY 1 DESC