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

symbol,

avg(token_price)

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