select

date_trunc('week', block_timestamp) as "date",

sum(FLASHLOAN_AMOUNT_USD) as "Total Flashloan Volume USD",

avg(FLASHLOAN_AMOUNT_USD) as "Average Flashloan Size USD",

sum(PREMIUM_AMOUNT_USD) as "FlashLoan Fee Volume USD",

avg(PREMIUM_AMOUNT_USD) as "Average Flashloan Fee USD"

from ethereum.aave.ez_flashloans

where FLASHLOAN_AMOUNT_USD < 1e9

and PREMIUM_AMOUNT_USD < 1e9

group by 1