DEPOSITOR,

SUM (AMOUNT_DEPOSITED * PRICE) as volume_deposited

FROM ethereum.maker.ez_deposits 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 DEPOSITOR

HAVING volume_deposited IS NOT NULL

ORDER BY volume_deposited DESC