flipside

    02_1 Whales Balance on Each Tokens
    bobby_daniel02_1 Whales Balance on Each Tokens
    Updated 2025-04-29
    WITH transfers AS (
    SELECT
    t.block_timestamp,
    t.amount,
    t.mint,
    COALESCE(p.price, 0) as token_price,
    m.symbol,
    m.name,
    m.decimals
    FROM solana.core.fact_transfers t
    LEFT JOIN solana.price.ez_asset_metadata m ON t.mint = m.token_address
    LEFT JOIN solana.price.ez_prices_hourly p
    ON t.mint = p.token_address
    AND DATE_TRUNC('hour', t.block_timestamp) = p.hour
    WHERE (t.tx_from IN (
    '4GQeEya6ZTwvXre4Br6ZfDyfe2WQMkcDz2QbkJZazVqS',
    'JD25qVdtd65FoiXNmR89JjmoJdYk9sjYQeSTZAALFiMy',
    'Hq8MmCBFavX2GooSCk9XFp4Whue3wmC3jaZqk1zDgSXx',
    'HBGdumkxEsZUsWz2sbg4GvHqJW9wA7CTa5sN9pn6pGMB',
    'Fw5RSJEAqoUEY6rr4AAjN8UFCSsZCSqF42ndRjin1TFA',
    '6n9VGHytR4SPBZQSoWVLgH2hLHmfXSSFJsbHAdMr5zzE',
    'GCvHhEUYQwTJ8jyf8Lc4bv8jBXyZU4LMMsZCobwEPzvM',
    'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa',
    '7of9rX4qvtMQFYKi3x64PPzC3EqY1759bJENHzSp4BMU',
    'DEiDqiiBQi54ZdVXKcq2sP5TobTWH258JL3gZgDYE6oD',
    '4Pwm4H7HKJonHSy9drWqdz4ij584jRidQAMVCSGwk2Ms',
    '9rx2sFooy7kJXXFBAS1hJJekEhhtDQPyEpEpogdjnit1',
    '664yPUmgPqFcjTjCsRQRXZ4rAKDkF2vSwhyndeBgsYJy',
    'HmdyD9rq4MZAWkec8i7E7PDWJbB6TrWpEvbHUueqcRc8',
    'zjmgGhx7rUW9Y4FqQCuKLKr4VJsRaarmbvqE5nay3W2'
    )
    OR t.tx_to IN (
    '4GQeEya6ZTwvXre4Br6ZfDyfe2WQMkcDz2QbkJZazVqS',
    'JD25qVdtd65FoiXNmR89JjmoJdYk9sjYQeSTZAALFiMy',
    'Hq8MmCBFavX2GooSCk9XFp4Whue3wmC3jaZqk1zDgSXx',
    'HBGdumkxEsZUsWz2sbg4GvHqJW9wA7CTa5sN9pn6pGMB',
    Last run: about 2 months ago
    TOKEN_SYMBOL
    NAME_OF_TOKEN
    TOTAL_USD_VOLUME
    TOTAL_TOKEN_BALANCE
    1
    		FARTCOINFartcoin1577901861.541712965791407239760000
    2
    		TRUMPOfficial Trump1465287343.84598109586827473763000
    3
    		CBBTCCoinbase Wrapped BTC856833826.021691536387189493.34
    4
    		AI16Zai16z127231080.025853165896114528853000
    5
    		USDSUSDS116247819.3862342654971250764280
    6
    		LAYERSolayer83396216.2352312786619381789450
    7
    		ARCAI Rig Complex78982017.029561484642345814132400
    8
    		PENGUPudgy Penguins75984227.66512542911435714004790000
    9
    		RFCRetard Finder Coin54350543.45567533401186899876700
    10
    		AVAAva AI50560449.449199923319837889485000
    11
    		GRIFFAINGRIFFAIN43940770.063575294788616402465100
    12
    		ZEREBROZerebro39757673.370252453719811804617900
    13
    		FWOGFwog38336970.648554712625590536974800
    14
    		MELANIAMelania Meme37552822.17152562278309394957540
    15
    		PNUTPeanut the Squirrel36076847.036331730046270364958200
    15
    881B
    383s