voiceless-coffee

cryptodatadivevoiceless-coffee

Updated 2025-04-10

SELECT

TO_ADDRESS AS CONTRACT_ADDRESS,

LEFT(TO_ADDRESS, 6) || '...' || RIGHT(TO_ADDRESS, 4) AS SHORT_CONTRACT,

COUNT(*) AS INTERACTIONS,

COUNT(DISTINCT FROM_ADDRESS) AS UNIQUE_USERS,

SUM(GAS_USED) AS TOTAL_GAS_USED

FROM mezo.testnet.fact_transactions

WHERE TO_ADDRESS IS NOT NULL

GROUP BY TO_ADDRESS

ORDER BY INTERACTIONS DESC

LIMIT 10;

Last run: 17 days ago

457B

flipside