avg(flashloan_volume_usd),

median(flashloan_volume_usd),

AVG(events),

MEDIAN(events)

FROM (

SELECT

INITIATOR_ADDRESS,

sum(FLASHLOAN_AMOUNT_USD) as flashloan_volume_usd,

sum(PREMIUM_AMOUNT_USD) as fee_volume_usd,

COUNT(DISTINCT tx_hash) as events

FROM ethereum.aave.ez_flashloans

WHERE FLASHLOAN_AMOUNT_USD < 100000000000

GROUP BY 1

ORDER BY 2 DESC