WALLET | HOLDING_AMOUNT | |
---|---|---|
1 | HKWEMPBY4zWn8x9ascmKWMGDhcr7WRwNrhAHyvTe1PJT | 11916170505 |
2 | MooNKdkR6tUvY3V8k24YPfGmWNcHhggCousJNfb1MT7 | 9845824881 |
3 | 3fXnpaqT7sPqeAGZzUfHGYsDDfv8dRkXsgFWTzkvkHua | 4094261333 |
4 | D6aUT8Ci33fMirJhET6amys5rqX8uFCPJMCGqyB9ZmZG | 2107889351 |
5 | 2XYZ9YpHsCFiBm4rqLKv7vtjcExH8whFrFDAN5Xqmbdk | 1291250384 |
6 | 4NDhXBxETJqZLiN4UKvuS9b6jr2ycWNVRVXLak5TaSGq | 1014010000 |
7 | FuhDBdrNTbujE6uY8GhAU1yUQVJotGkKYbUCBumwEafQ | 989756000 |
8 | 954Kj3zjeRSbAWh72jd5mvmGu3EErFbdiNPFHdXrAnEv | 969389083 |
9 | FVBRf5sSEKqJ7crWTT6FuPPgSeT8s3yShvqjtBn9Ff7i | 950953000 |
10 | 9M3gAgdbwaSa5z36rDF3W96NGCKhurFndP9YYrtgH6wY | 878199000 |
11 | 2LftXT4Pr8jTEx1VVkPsasP77wam6iz9ifgbRPR7zts7 | 860035000 |
12 | 5G4F8iB78FFiv2Hes4LrPwc4vP3tLuHBnZTNyMce9Pge | 834546000 |
13 | ENM3WJEXzTJ5jaDWRFETrthbRBARbtHtXqY29fNWjCYo | 829696000 |
14 | JD2pdUUT8VRtUV2Z9AyDZ16WupA53n1RbbWdxUxosneP | 819995000 |
15 | 6ka9kdHJAvvFjTndvHtruhxV7qvh6AKWLA9fceLiHS41 | 815230910 |
16 | 2dDX372ujLicSQwnAQcucxoppaFKGNTQTNQxRcDCRnMt | 815145000 |
17 | hezgU57bhCF4ESn1tNutPGNH5SaEdutR6cEVenpZs9B | 776342000 |
18 | AErC2AYerPYq7HufTwXkJxqaDk6u8idgsFm478FjVcod | 766642000 |
19 | 3NvNJ2caXvfTf2ZoeQT4JsakMjxCCd5q7XtjkXAH59KE | 708438000 |
20 | GV6FjeorBGwY41epmEoMrgGZXA4eVK8cYY2XMJdLrc9t | 659935000 |
damidezHolder list
Updated 2025-01-03
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 transfers AS (
-- Inflow and outflow data
SELECT
DATE(BLOCK_TIMESTAMP) AS date,
'inflow' AS Flow,
TX_TO AS wallet,
AMOUNT / pow(10, decimal) AS amount,
FROM eclipse.core.fact_transfers
WHERE MINT = 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
AND succeeded = 'TRUE'
UNION ALL
SELECT
DATE(BLOCK_TIMESTAMP) AS date,
'outflow' AS Flow,
TX_FROM AS wallet,
AMOUNT / pow(10, decimal) AS amount,
FROM eclipse.core.fact_transfers
WHERE MINT = 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
AND succeeded = 'TRUE'
)
-- Calculate the current balance for each holder
SELECT
wallet,
ROUND(SUM(CASE WHEN Flow = 'inflow' THEN amount ELSE -amount END)) AS holding_amount
FROM transfers
GROUP BY wallet
ORDER BY holding_amount DESC
limit 100;
Last run: about 2 months ago
100
6KB
1s