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