USER_ADDRESS | TOTAL_TRANSACTIONS | |
---|---|---|
1 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 2855994 |
2 | 0x339d413ccefd986b1b3647a9cfa9cbbe70a30749 | 116610 |
3 | 0xe93685f3bba03016f02bd1828badd6195988d950 | 11648 |
4 | 0x38a81967a2337a4a505e0e693f7593586fe0065a | 9743 |
5 | 0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb | 8230 |
6 | 0x4c968f6beecf1906710b08e8b472b8ba6e75f957 | 5562 |
7 | 0xf7ba9ef12995defc5ff47ec0e13252f0e690486a | 4725 |
8 | 0x5a023a673998d39035a0781d54293d1c4862ec49 | 4063 |
9 | 0xd49eeafa6bdbcc551f462c5a582959a9b7a2efdb | 2952 |
10 | 0x435e00984f45918e1bdd56788ad9a4f21be1e80d | 2835 |
11 | 0x74cae0ecc47b02ed9b9d32e000fd70b9417970c5 | 2609 |
12 | 0x09b96417602ed6ac76651f7a8c4860e60e3aa6d0 | 2547 |
13 | 0x1684b956859b75a4d107d45c4c32b2eda90430ca | 2219 |
14 | 0xcb4febb79873ab77fc72550dc5821580812bab79 | 1998 |
15 | 0x91604f590d66ace8975eed6bd16cf55647d1c499 | 1995 |
16 | 0x5f2e4398fbc8fc5a58a785d6e289c52bff580516 | 1346 |
17 | 0x5c8a5efd5a524fb11b3871b4c12d551869d1eaa9 | 1164 |
18 | 0xa7eccdb9be08178f896c26b7bbd8c3d4e844d9ba | 917 |
19 | 0x10447f93ce6990d5c0192fa79ad6cb4187b8bf22 | 705 |
20 | 0x3fa332824ea18f6400b4713722e9bff815e89ccc | 695 |
par_rnSwell 03
Updated 2025-02-01
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
FROM_ADDRESS AS user_address,
COUNT(DISTINCT TX_HASH) AS total_transactions,
FROM swell.core.fact_transactions
WHERE TX_SUCCEEDED = TRUE
GROUP BY FROM_ADDRESS
ORDER BY total_transactions DESC
LIMIT 100
Last run: 24 days ago
100
5KB
1s