SELECT date_trunc('day', _INSERTED_TIMESTAMP) AS flashloan_per_day,

COUNT(TX_HASH) AS transaction_hash,

SYMBOL

FROM ethereum.aave.ez_flashloans

WHERE AAVE_VERSION = 'Aave V2'

AND flashloan_per_day > CURRENT_DATE - 365

AND TX_HASH IS NOT NULL

GROUP BY 1,3

ORDER BY 1, 2 DESC

LIMIT 30