select

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

symbol,

sum(FLASHLOAN_AMOUNT_USD) as "Total Flashloan Volume USD"

from ethereum.aave.ez_flashloans

where FLASHLOAN_AMOUNT_USD < 1e9

and PREMIUM_AMOUNT_USD < 1e9

and symbol in ('USDC', 'WETH', 'DAI', 'WBTC', 'USDT' )

group by 1, 2