flipside

    01 Whales transfer activity across different tokens
    bobby_daniel 01 Whales transfer activity across different tokens
    Updated 2025-04-29
    WITH transfers AS (
    SELECT
    t.block_timestamp,
    t.amount,
    t.mint,
    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
    WHERE (t.tx_from IN (
    '4GQeEya6ZTwvXre4Br6ZfDyfe2WQMkcDz2QbkJZazVqS',
    'JD25qVdtd65FoiXNmR89JjmoJdYk9sjYQeSTZAALFiMy',
    'Hq8MmCBFavX2GooSCk9XFp4Whue3wmC3jaZqk1zDgSXx',
    'HBGdumkxEsZUsWz2sbg4GvHqJW9wA7CTa5sN9pn6pGMB',
    'Fw5RSJEAqoUEY6rr4AAjN8UFCSsZCSqF42ndRjin1TFA',
    '6n9VGHytR4SPBZQSoWVLgH2hLHmfXSSFJsbHAdMr5zzE',
    'GCvHhEUYQwTJ8jyf8Lc4bv8jBXyZU4LMMsZCobwEPzvM',
    'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa',
    '7of9rX4qvtMQFYKi3x64PPzC3EqY1759bJENHzSp4BMU',
    'DEiDqiiBQi54ZdVXKcq2sP5TobTWH258JL3gZgDYE6oD'
    )
    OR t.tx_to IN (
    '4GQeEya6ZTwvXre4Br6ZfDyfe2WQMkcDz2QbkJZazVqS',
    'JD25qVdtd65FoiXNmR89JjmoJdYk9sjYQeSTZAALFiMy',
    'Hq8MmCBFavX2GooSCk9XFp4Whue3wmC3jaZqk1zDgSXx',
    'HBGdumkxEsZUsWz2sbg4GvHqJW9wA7CTa5sN9pn6pGMB',
    'Fw5RSJEAqoUEY6rr4AAjN8UFCSsZCSqF42ndRjin1TFA',
    '6n9VGHytR4SPBZQSoWVLgH2hLHmfXSSFJsbHAdMr5zzE',
    'GCvHhEUYQwTJ8jyf8Lc4bv8jBXyZU4LMMsZCobwEPzvM',
    'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa',
    '7of9rX4qvtMQFYKi3x64PPzC3EqY1759bJENHzSp4BMU',
    'DEiDqiiBQi54ZdVXKcq2sP5TobTWH258JL3gZgDYE6oD'
    ))
    AND t.block_timestamp >= CURRENT_DATE - {{lookback_days}}
    Last run: about 1 month ago
    TOKEN_SYMBOL
    NAME_OF_TOKEN
    NUMBER_OF_TRANSFERS
    TOTAL_TOKEN_AMOUNT
    TOTAL_USD_VOLUME
    1
    		FARTCOINFartcoin10814132334069455.200841657433121.4123
    2
    		TRUMPOfficial Trump374423142854315.0294461445831056.90873
    3
    		CBBTCCoinbase Wrapped BTC24602010108.49925573851064520.974942
    4
    		AI16Zai16z179581734993369.677667124563587.037486
    5
    		USDSUSDS29001119194096.838929119185603.00412
    6
    		LAYERSolayer10704640924761.552806581520006.1024533
    7
    		ARCAI Rig Complex1095531814564526.9688278722845.800751
    8
    		PENGUPudgy Penguins14190911126985804.994874469701.1854732
    9
    		RFCRetard Finder Coin1118191610148688.1033158708823.5217514
    10
    		AVAAva AI654911507492202.2102450047557.3123173
    11
    		GRIFFAINGRIFFAIN961031052197676.6835843510415.7986472
    12
    		ZEREBROZerebro65200879715793.08241440792829.6361795
    13
    		FWOGFwog760311044814080.1292540032685.0299736
    14
    		MELANIAMelania Meme2535775019612.69814136880419.0340511
    15
    		LUCELuce693392132406372.5642135810860.2997947
    15
    945B
    121s