DAY | WHALE_VOLUME_SOL | RETAIL_VOLUME_SOL | WHALE_RATIO | RETAIL_RATIO | |
---|---|---|---|---|---|
1 | 4 | 104954628419.284 | 142143907.316079 | 0.998647495 | 0.001352504974 |
2 | 3 | 218124667015.662 | 550179745.814353 | 0.9974840282 | 0.002515971791 |
3 | 2 | 1693542625.12764 | 847446483.233075 | 0.6664895255 | 0.3335104745 |
4 | 1 | 3713481774.75208 | 1079721914.53232 | 0.7747389878 | 0.2252610122 |
bobby_daniel4_Whale vs. Retail Participation
Updated 2025-04-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
Month(block_timestamp) AS day,
SUM(CASE WHEN amount > 100 THEN amount ELSE 0 END) AS whale_volume_sol,
SUM(CASE WHEN amount <= 100 THEN amount ELSE 0 END) AS retail_volume_sol,
whale_volume_sol / NULLIF((whale_volume_sol + retail_volume_sol), 0) AS whale_ratio,
retail_volume_sol / NULLIF((whale_volume_sol + retail_volume_sol), 0) AS retail_ratio
FROM solana.core.fact_transfers
WHERE mint = 'So11111111111111111111111111111111111111112' -- Native SOL mint address
AND block_timestamp >= DATEADD(day, -90, CURRENT_DATE())
GROUP BY day
ORDER BY day DESC;
Last run: about 2 months ago
4
260B
99s