🐳 Whales | TRANSFER_COUNT | UNIQUE_WHALES | TOTAL_TRANSFER_AMOUNT | |
|---|---|---|---|---|
1 | 5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1 | 22545011 | 1 | 10909581957144500000 |
2 | GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL | 2477843 | 1 | 1008599269302850000 |
3 | FpTUZKuviuGaww6ijjXdoeuJtFeEjabEXnzxRYHukhMx | 1416961 | 1 | 269086967023 |
4 | CapuXNQoDviLvU1PxFiizLgPNQCxrsag1uMeyk6zLVps | 1030896 | 1 | 284716772586333000 |
5 | GGztQqQ6pCPaJQnNpXBgELr5cs3WwDakRbh1iEMzjgSJ | 1027951 | 1 | 288077337264102000 |
6 | BQ72nSv9f3PRyRKCBnHLVrerrv37CYTHm5h3s9VSGQDV | 1026409 | 1 | 282026540902529000 |
7 | 9nnLbotNTcUhvbrsA6Mdkx45Sm82G35zo28AqUvjExn8 | 1026232 | 1 | 255817606102160000 |
8 | 6LXutJvKUw8Q5ue2gCgKHQdAN4suWW8awzFVC6XCguFx | 1026198 | 1 | 286990956189465000 |
9 | 6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB | 1026155 | 1 | 308511910641079000 |
10 | 2MFoS3MPtvyQ4Wh4M9pdfPjz6UhVoNbFbGJAskCPCj3h | 1025841 | 1 | 258625880762904000 |
11 | 4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu71 | 1025383 | 1 | 314962509535718000 |
12 | CkUZV387xnoGpF7wC2moMa6mPmAgCvTT4pWgzq4M9fCD | 668753 | 1 | 2347126286112070 |
13 | 7g275uQ9JuvTa7EC3TERyAsQUGwid9eDYK2JgpSLrmjK | 587882 | 1 | 30314664736433600 |
14 | 6iPa5yFqdf7WxJoLJhSHvmxtmvRvVhNvB92Tpp7q3mdP | 478554 | 1 | 6111266185367.01 |
15 | 9EpH5wo4uQ1h39QwJqF3v3mbtHWVfgsEZpmdD4DYF1L | 463461 | 1 | 6307948399392.5 |
16 | 6ny545QXZbGDWXo6F7UEVC7MncAzNNxB62tbVoYWG5gs | 460128 | 1 | 83215708152 |
17 | CsVdJ8WH8Q9eHSTRpwtwN3TYApm24QnLKYUMNxJ3DaED | 444049 | 1 | 28107941876886.2 |
18 | 9MkixYmjT2UbMgnNnPBTYkRjzdmi4zP1jkMdCkR89L67 | 442935 | 1 | 4503497382553.4 |
19 | 7S9KVtU3XBRvkCytbcsybQyMXgL5CKfhW8Ds9PLJaRZQ | 437274 | 1 | 6973744309710.98 |
20 | CtHAnJFXY9cby5qGyfP6sCyGgbgYfszZqaRgisu1uZVJ | 429305 | 1 | 6246540813483.33 |
bobby_daniel1-2 Whales with large transfer count and transfer amount
Updated 2025-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH whale_transfers AS (
SELECT
tx_from as whale_address,
COUNT(*) as transfer_count,
SUM(amount) as total_amount
FROM solana.core.fact_transfers
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())
AND amount > 10000 -- Large transfers filter
GROUP BY tx_from
HAVING COUNT(*) >= 5 -- Address must have made at least 5 large transfers
)
SELECT
wt.whale_address as "🐳 Whales",
COUNT(*) as transfer_count,
COUNT(DISTINCT ft.tx_from) as unique_whales,
SUM(ft.amount) as total_transfer_amount
FROM solana.core.fact_transfers ft
JOIN whale_transfers wt ON ft.tx_from = wt.whale_address
WHERE ft.block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())
AND ft.amount > 10000
GROUP BY 1
ORDER BY transfer_count DESC
LIMIT 20;
Last run: about 1 month ago
20
1KB
110s