-- forked from 2a7f9bd8-801e-4912-9600-7385be311327
select
--date_trunc('week', block_timestamp),
symbol,
sum(FLASHLOAN_AMOUNT_USD) as "USD Volume in Flashloans"
from ethereum.aave.ez_flashloans
where FLASHLOAN_AMOUNT_USD < 1e9
and PREMIUM_AMOUNT_USD < 1e9
group by 1
order by 2 DESC