flipside

    1-0 Top whale addresses for SOL transfers in the last 30 days
    bobby_daniel1-0 Top whale addresses for SOL transfers in the last 30 days
    Updated 2025-04-27
    WITH transfers AS (
    SELECT
    tx_from as address,
    -amount as amount
    FROM solana.core.fact_transfers
    WHERE block_timestamp >= CURRENT_DATE -{{Lookback }}
    AND mint = 'So11111111111111111111111111111111111111112' -- SOL mint address
    UNION ALL
    SELECT
    tx_to as address,
    amount
    FROM solana.core.fact_transfers
    WHERE block_timestamp >= CURRENT_DATE -{{Lookback }}
    AND mint = 'So11111111111111111111111111111111111111112' -- SOL mint address
    ),

    whale_stats AS (
    SELECT
    address,
    SUM(ABS(amount)) as total_volume,
    SUM(CASE WHEN amount > 0 THEN amount ELSE 0 END) as total_received,
    SUM(CASE WHEN amount < 0 THEN ABS(amount) ELSE 0 END) as total_sent,
    COUNT(*) as number_of_transfers
    FROM transfers
    GROUP BY 1
    HAVING total_volume > 1000000 -- Filter for significant volume
    )

    SELECT
    w.address,
    w.total_volume,
    w.total_received,
    w.total_sent,
    w.number_of_transfers
    Last run: about 1 month ago
    ADDRESS
    TOTAL_VOLUME
    TOTAL_RECEIVED
    TOTAL_SENT
    NUMBER_OF_TRANSFERS
    1
    		Dx8iy2o46sK1DzWbEcznqSKeLbLVeu7otkibA3WohGAj514824519896.878257412189575.761257412330321.11751459425
    2
    		4VztozdDL8yFPLdpUpMNT3Hf7xMZ2qPGAMretExTvZ78274260001969.77137130001122.996137130000846.77527531825
    3
    		ANhqQ5PFNzKNnhuKW5zf6yZ62yFxGB82NsT6xBgZ9QFD25520407002.870112760203519.846112760203483.0242577406
    4
    		EZvyYN1Q98yPJXh8FCTx94ZYFeo6wtJ544hKdAF72QyU25514571872.970512757285969.988312757285902.98222591175
    5
    		9DrvZvyWh1HuAoZxvYWMvkf2XCzryCpGgHqrMjyDWpmo20656149485.584210328030171.371910328119314.21232488247
    6
    		7JFphvzpvcQjJV7Kv7FJnQX8h6GDKNrpUFMpKg7Zc9Tu19917825547.63279958912793.045049958912754.587662017139
    7
    		91Nk1HwpfQk5qno1LSB5GKw9hJ9yBXkpWqkTtmGMrphe19639441565.75539819720777.050319819720788.704971985284
    8
    		H6FTjrbVduVKWiMDDiyvyXYacK17apFajQwymchXfyDT19137364310.86569568682166.88169568682143.9841931378
    9
    		Fsa5uw2K8sYJmZhWvKG9YiRPoa454xxHwMg4SLPp8AQq18549618127.90569274809122.450669274809005.454941926531
    10
    		EuLceVgXMaJNPT7C88pnL7DRWcf1poy9BCeWY1GL8Agd18475687351.52129237843700.303099237843651.218061906854
    11
    		4QbWA5MChbahM5GqstbfHfbE3HuYX1grg4VB5MhmUcXr17285285425.74548642642729.200688642642696.544721765333
    12
    		6suJ1bjP8uN1Kz5JBa9yHG7fHPpT8usZQWndegbhaEkF15797007444.43077898503751.586887898503692.843841602801
    13
    		75ULw1FyG5ZY7aJ9eWGpkydbrP7KQhF6ULZA4Ho9axVi15681525585.1017840762810.967097840762774.133941588980
    14
    		6zhK4gpohxPyk7fd4nTqWMgqLJVZshivxe7r7G9EdTgf15073107943.26637536553999.23217536553944.034161536994
    15
    		Cdx4Yt2TED94J9fPbDqmJCwvmguzekkFhq35AauCpT4R14699347600.97137349673886.109887349673714.861451569187
    16
    		Drsy4FmB1LeJpQrLWanRHE7i8go1RJSe8ESycgfMih319632341723.402864816170868.29424816170855.10867970033
    17
    		JBiqjt4eVh1jCqc4c9h8WfrfpqxyEzWo6Wkquth9hAFs3115240186.404761557620093.35311557620093.05166166649
    18
    		HkVw1hFhZqrJt58dQvGv7B29CagUDcxakYmFt3CN2n7r3098702211.410021549351115.775341549351095.63468312987
    19
    		Hsf1oqYpQ98iSJQdaNonVXXQX14gm2b55njexzjos5nh3096503280.080031548251650.981781548251629.09824313939
    20
    		4TbinUKMjVMXozQyrA6WWJC9RHYg8yjtEA2NW7WqfCiM1805643886.96123902821958.841188902821928.120044185299
    20
    2KB
    77s