WALLET | TX_COUNT | USD_AMOUNT | |
|---|---|---|---|
1 | 0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 | 4027 | 63570016.5097245 |
2 | 0xd25cde6c21af4047e4647fc89fe081dacee60943 | 4 | 56752465.22 |
3 | 0x027750420d3f4dd56f558871792b1632a21c6205 | 7 | 46338411.8276779 |
4 | 0xf7394d9fa7dc72bc1bf9ca7f7aa1b3e80973242d | 8 | 36755376.06 |
5 | 0x59a661f1c909ca13ba3e9114bfdd81e5a420705d | 5 | 31561600 |
6 | 0xeab23c1e3776fad145e2e3dc56bcf739f6e0a393 | 3 | 30145793.232113 |
7 | 0xc3b30e0c1be66c72dbb6e6deb85d660cb3ef0270 | 3 | 27395804.25 |
8 | 0x020ca66c30bec2c4fe3861a94e4db4a498a35872 | 114 | 23181180.1911965 |
9 | 0x236f233dbf78341d25fb0f1bd14cb2ba4b8a777c | 10 | 22748386.702003 |
10 | 0x7644b015af7f3085f9eb1ef3ed4a7d9da57fc45e | 12 | 18607417.858784 |
11 | 0x304bbec8df6f1a7f3848dc087717c254eb75b913 | 11 | 14203686.3263753 |
12 | 0x924cafec4f967be5df085ad94d8d50574f9a2bb0 | 10 | 13710123.6 |
13 | 0xd746a2a6048c5d3aff5766a8c4a0c8cfd2311745 | 4 | 13554029.22 |
14 | 0xdad36a77358ce31324b9c51687fee6ace5ac60ef | 15 | 12099122.3757108 |
15 | 0x7bda16073b3ffe2ba4cf06784515d6fa21439aa3 | 2 | 11724523.45 |
16 | 0x83768992b44f9afad68889ca59f36507fe00d8f7 | 6 | 11552347.87 |
17 | 0x35e3564c86bc0b5548a3be3a9a1e71eb1455fad2 | 8 | 11297223.1381704 |
18 | 0x4ee79e19c9c398e364d135f01b25dccc0473047c | 5 | 11174120 |
19 | 0x0c883bacaf927076c702fd580505275be44fb63e | 2 | 10955813.6378928 |
20 | 0xa6b1c84133479e41d8d085005476dd007a50be66 | 10 | 10523999.58 |
freemartianTop 20 Depositors
Updated 2024-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with datas AS(
SELECT
eth_from_address AS wallet,
tx_hash,
amount_usd
FROM ethereum.core.ez_eth_transfers
WHERE eth_to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature = '0xf6326fb3'
AND eth_from_address <> '0x0000000000000000000000000000000000000000'
AND amount_usd IS NOT NULL
UNION
SELECT
from_address AS wallet,
tx_hash,
amount_usd
FROM ethereum.core.ez_token_transfers
WHERE to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')
AND origin_function_signature IN ('0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')
AND from_address <> '0x0000000000000000000000000000000000000000'
AND amount_usd IS NOT NULL
)
SELECT
wallet,
COUNT(tx_hash) AS tx_count,
SUM(amount_usd) AS usd_amount
FROM datas
GROUP BY 1
ORDER BY 3 DESC
LIMIT 20
Last run: about 1 year agoAuto-refreshes every 3 hours
20
1KB
54s