ACCOUNT_ADDRESS | TRANSACTION_COUNT | |
---|---|---|
1 | 0xa31dfc92a0c42bbd37a255b35b8b7989caa059ec83d2773b705cac8e39e54107 | 1160 |
2 | 0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af | 398 |
3 | 0x149833cfb9cbb56f665b9d637175b06f65b80213a71998ff60f141f0f809b963 | 90 |
4 | 0x61c2c82337d84545eca0b2cf7c5ea365b217309e04df9bd259e7aba0c78f72f | 81 |
5 | 0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4f | 75 |
6 | 0x67caa4346a2f486b3a5e9a5b4bd2a216b948452bb666ed014c81f28aca82e0d8 | 61 |
7 | 0x75a13f1310edd7d5eec191ffb610866e65b0dffdb2cdadfffce0277188040911 | 60 |
8 | 0xf917612065baf2fe77afbfefea54706bb6de8afcdfda0364c06210b4e485b96b | 55 |
9 | 0x6bfa2b755fae50e7bd9e6ad832ff354cdf28699c51a7865231b4b46f9b35947d | 48 |
10 | 0x6ddefcef244e364222b686913a8ef71343aa1b5b3a8bb54c74c50895c8c63fbe | 36 |
victor-sanzcapdetTop 10 Most Active Wallets by Transaction Count
Updated 2024-12-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
account_address,
COUNT(*) AS transaction_count
FROM
aptos.core.fact_transfers AS et
JOIN
aptos.core.dim_tokens AS dt ON et.token_address = dt.token_address
WHERE
dt.symbol = 'doodoo'
AND et.success = TRUE
AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
GROUP BY
account_address
ORDER BY
transaction_count DESC
LIMIT 10;
Last run: 19 days ago
10
743B
1s