select
date_trunc('day',block_timestamp) as block_day,
count(tx_id) as Flashloans,
sum(flashloan_amount_usd) as daily_volume
from aave.flashloans
where
block_timestamp >= '2022-01-01'
AND
aave_version = 'Aave V2'
AND
flashloan_amount_usd < 100000000
group by block_day
order by block_day