BORROWER,

SUM (AMOUNT_LOANED * PRICE) as volume_loaned

FROM ethereum.maker.ez_flash_loans a

LEFT JOIN ethereum.core.fact_hourly_token_prices b

ON HOUR = BLOCK_TIMESTAMP::date

AND a.symbol = b.symbol

WHERE BLOCK_TIMESTAMP >= '2022-01-01' AND TX_STATUS = 'SUCCESS'

GROUP BY BORROWER

HAVING volume_loaned IS NOT NULL

ORDER BY volume_loaned DESC