NakedCollectorETHEREUM WHALES
Updated 2024-08-06
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
›
⌄
WITH whales AS (
SELECT
USER_ADDRESS,
SUM(USD_VALUE_NOW) AS "Wallet Wealth (USD)"
FROM
ethereum.core.ez_current_balances
GROUP BY
USER_ADDRESS
ORDER BY
"Wallet Wealth (USD)" DESC
LIMIT
10
)
SELECT
*
FROM
whales w
JOIN
ethereum.core.fact_token_transfers t ON w.USER_ADDRESS = t.ORIGIN_FROM_ADDRESS
WHERE
t.BLOCK_TIMESTAMP >= current_timestamp - interval '7 days'
GROUP BY
t.CONTRACT_ADDRESS
ORDER BY
"Interaction Count" DESC
LIMIT
10;
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived