flipside

    1 Wallet's transfer activity across different tokens
    bobby_daniel 1 Wallet's transfer activity across different tokens
    Updated 2025-04-28
    WITH transfers AS (
    SELECT
    t.block_timestamp,
    t.amount,
    t.mint,
    t.tx_from,
    t.tx_to,
    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 = '{{Whale_Address}}'
    OR t.tx_to = '{{Whale_Address}}')
    AND t.block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    )

    SELECT
    mint as token_address,
    symbol,
    name,
    COUNT(*) as number_of_transfers,
    SUM(amount / POWER(10, COALESCE(decimals, 0))) as total_token_amount,
    SUM((amount / POWER(10, COALESCE(decimals, 0))) * token_price) as total_usd_volume
    FROM transfers
    GROUP BY 1,2,3
    ORDER BY total_usd_volume DESC;
    Last run: about 2 months ago
    TOKEN_ADDRESS
    SYMBOL
    NAME
    NUMBER_OF_TRANSFERS
    TOTAL_TOKEN_AMOUNT
    TOTAL_USD_VOLUME
    1
    		9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpFARTCOINFartcoin71400218528108.183384154426739.131527
    2
    		6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPNTRUMPOfficial Trump101568578279.25910376271469.9761654
    3
    		CBdCxKo9QavR9hfShgpEBG3zekorAeD7W1jfq2o3pumpLUCELuce577941640526446.1213227347678.9021658
    4
    		DKu9kykSfbN5LBfFXtNNDPaX35o4Fv6vJ9FKk7pZpumpAVAAva AI34352682892586.24066522378565.3246263
    5
    		LAYER4xPpTCb3QL8S9u41EAhAX7mhBn8Q6xMTwY2YzcLAYERSolayer2243610299428.623303318586439.4213398
    6
    		HNg5PYJmtqcmzXrv6S9zP1CDKk5BgDuyFBxbvNApumpALCHAlchemist AI20079198586816.2484517375704.3036006
    7
    		A8C3xuqscfmyLrte3VmTqrAq8kgMASius9AFNANwpumpFWOGFwog40137451819939.95790617085280.8253633
    8
    		Grass7B4RdKfBCjTKgSqnXkqjwiGvQyFbuSCUJr3XXjsGRASSGrass308429809096.9755593416517344.3520622
    9
    		HeLp6NuQkmYB4pYWo2zYs22mESHXPQYzXbB8n4V98jwCAI16Zai16z2311786065694.059764414608128.5442705
    10
    		FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1PMELANIAMelania Meme649129640032.96439114462290.187905
    11
    		61V8vBaqAGMpgDQi4JcAwo1dmBGHsyhzodcPqnEVpumpARCAI Rig Complex31023291855926.2262213900203.4773048
    12
    		8x5VqbHA8D7NkD52uNuS5nnt3PwA8pLD34ymskeSo2WnZEREBROZerebro9576274005069.34649112921717.7963478
    13
    		KENJSUYLASHUMfHyy5o4Hp2FdNqZg1AsUPhfH2kYvEPGRIFFAINGRIFFAIN39193323659357.51861812731471.0114763
    14
    		C3DwDjT17gDvvCYC2nsdGHxDHVmQRdhKfpAdqQ29pumpRFCRetard Finder Coin10560269446815.4598299360211.10588006
    15
    		9DHe3pycTuymFk4H4bbPoAJ4hQrr2kaLDF6J6aAKpumpBUZZHive AI208431075822509.689458697161.37585407
    16
    		GJAFwWjJ3vnTsrQVabjBVK2TYB1YtRCQXRDfDgUnpumpACTAct I The AI Prophecy12260111836705.746868659243.1971654
    17
    		6AJcP7wuLwmRYLBNbi825wgguaPsWzPBEHcHndpRpumpVINEVine17745200441683.556667201966.08941013
    18
    		2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauvPENGUPudgy Penguins65771016293140.475916761658.42949729
    19
    		BZLbGTNCSFfoth2GYDtwr7e4imWzpR5jqcUuGEwr646KIOIO1468610421495.34903936705633.27750111
    20
    		FeR8VBqNRSUD5NtXAj2n3j1dAHkZHfyDktKuLXD4pumpJELLYJELLYJelly-My-Jelly6237366480722.7611056335346.57399076
    ...
    124
    11KB
    72s