bobby_daniel4_Whale vs. Retail Participation
    Updated 2025-04-08
    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
    DAY
    WHALE_VOLUME_SOL
    RETAIL_VOLUME_SOL
    WHALE_RATIO
    RETAIL_RATIO
    1
    4104954628419.284142143907.3160790.9986474950.001352504974
    2
    3218124667015.662550179745.8143530.99748402820.002515971791
    3
    21693542625.12764847446483.2330750.66648952550.3335104745
    4
    13713481774.752081079721914.532320.77473898780.2252610122
    4
    260B
    99s