flipside

    1-1 Tokens bought by Whales in the last 30 days
    bobby_daniel1-1 Tokens bought by Whales in the last 30 days
    Updated 2025-04-27
    WITH whale_transfers AS (
    SELECT
    t.mint,
    t.amount,
    am.symbol,
    am.name,
    t.tx_from,
    t.tx_to,
    t.block_timestamp,
    l.label_type,
    l.address_name
    FROM solana.core.fact_transfers t
    LEFT JOIN solana.price.ez_asset_metadata am ON t.mint = am.token_address
    LEFT JOIN solana.core.dim_labels l ON t.tx_to = l.address
    WHERE t.block_timestamp >= CURRENT_DATE -{{Lookback }}
    AND t.amount >= 10000 -- Filtering for large transfers
    AND am.symbol IS NOT NULL
    )

    SELECT
    symbol as token,
    name as token_name,
    COUNT(DISTINCT tx_to) as unique_whale_buyers,
    COUNT(*) as number_of_large_transfers,
    SUM(amount) as total_volume,
    AVG(amount) as avg_transfer_size
    FROM whale_transfers
    WHERE label_type NOT IN ('cex') -- Excluding CEX transfers to focus on actual whales
    GROUP BY 1, 2
    HAVING number_of_large_transfers >= 5 -- Focus on tokens with consistent whale activity
    ORDER BY total_volume DESC
    LIMIT 20;
    Last run: 28 days ago
    TOKEN
    TOKEN_NAME
    UNIQUE_WHALE_BUYERS
    NUMBER_OF_LARGE_TRANSFERS
    TOTAL_VOLUME
    AVG_TRANSFER_SIZE
    1
    		JOEYJoey260112617495931228900002099416960271030
    2
    		GHIBLIAIGhibli AI Agent24230951669963999799000224981078959763
    3
    		TOYSTORYToy Story21700268576865892747200040334587632482.8
    4
    		WOJAKMASKWojak Mask13685223156548943200001419336018734570
    5
    		DNADNA41899442851614017806500022560605463728.8
    6
    		$GOLD$GOLD3634784054987452683020006388020184446.61
    7
    		DOGEMOONDOGE TO MOON23261339361805587186000104066791041762
    8
    		PIETRONew Pope2333630872436912723300092543276117276
    9
    		REMUSREMUS22700296881850926914000109956241084042
    10
    		RCCretarded cat coin21577286648812284504000181768428842425
    11
    		FURSIMPSONFur Simpson21498264322902010018000176450535387195
    12
    		DUOLINGO AIDUOLINGO AI22063246864454940312000119662847765541
    13
    		MCDMcDonald's Job Application21889224793370061128000119001254664440
    14
    		GOOFYGoofy2988121122560709424600021376946371242.4
    15
    		FARTIMUSFartimus Prime22014202112538113151000100353792509013
    16
    		MAXIMUSAKekius Maximusa3381019813332589931400052003497611368.4
    17
    		TROPPTroll PEPE11451900939828134360001310992984920250
    18
    		DEALThe Art Of The Deal2288514601884910200400050613119272791.6
    19
    		DIABLODiablo IV Solana2379141512772428301000373384623821375
    20
    		ABSIMPSONabstract simpson2167013737611265019500082261145299517.9
    20
    1KB
    44s