DISTINCT TO_ADDRESS,

SUM(ETH_VALUE) AS TOTAL_VALUE_RECEIVED

FROM ETHEREUM.CORE.FACT_TRANSACTIONS

WHERE BLOCK_TIMESTAMP >= getdate() - interval '1 days'

GROUP BY TO_ADDRESS

ORDER BY TOTAL_VALUE_RECEIVED DESC

LIMIT 10