event signature hash (like Transfer, Approval, Swap, etc.) | no. of emissions across all contracts and transactions | no. of unique transactions | no. of unique contracts | |
|---|---|---|---|---|
1 | 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef | 2248144 | 1436654 | 6263 |
2 | 0x804c9b842b2748a22bb64b345453a3de7ca54a6ca45ce00d415894979e22897a | 443344 | 443344 | 3 |
3 | 0x458f5fa412d0f69b08dd84872b0215675cc67bc1d5b6fd93300a1c3878b86196 | 434129 | 434129 | 20 |
4 | 0x9c9231087215d0ccca20a3c98640429f2ea8bdd6498c53843c06d1138b8c94fa | 382281 | 128170 | 9 |
5 | 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925 | 359414 | 359413 | 71 |
defi__joshMost Common Events on Mezo Testnet
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
---Popular smart contract interactions
SELECT
topic_0 as "event signature hash (like Transfer, Approval, Swap, etc.)",
COUNT(*) as "no. of emissions across all contracts and transactions",
COUNT(DISTINCT tx_hash) as "no. of unique transactions",
COUNT(DISTINCT contract_address) as "no. of unique contracts"
FROM mezo.testnet.fact_event_logs
WHERE block_timestamp >= (
SELECT MIN(block_timestamp)
FROM mezo.testnet.fact_transactions
)
GROUP BY 1
ORDER BY 2 DESC
LIMIT 5;
Last run: 6 days ago
5
443B
443s