flipside

    2.Daily Transfers
    Lordking2.Daily Transfers
    Updated 2025-03-02




    WITH contract_info AS (
    SELECT * FROM (
    VALUES



    ( '0x216a5a1135a9dab49fa9ad865e0f22fe22b5630a','Pump', 'realpumpitcoin','<img src="https://pbs.twimg.com/profile_images/1752775532561764352/8X-GEXw5_400x400.jpg" style="width:30px; border-radius: 100%;"><b> Pump </b>' ),
    ( '0x5FE8534a6F96cb01261Bd96e98c17C2c1Cab3204','BAJA', 'BajaCoinOnBlast','<img src="https://pbs.twimg.com/profile_images/1747329688832221185/yYXzv3ud_400x400.jpg" style="width:30px; border-radius: 100%;"><b> BAJA </b>' ),
    ( 'ARMYZt71GXq4vw4mtDs5LnEp4ZgwWKEE2CdMU3WNnFEC','ARMY ', 'onchainarmy','<img src="https://pbs.twimg.com/profile_images/1839124375670501376/HaMB901j_400x400.jpg" style="width:30px; border-radius: 100%;"><b> ARMY </b>' ),
    ( '0xd43d8adac6a4c7d9aeece7c3151fca8f23752cf8','ANDY', 'AndyBlastL2','<img src="https://blastscan.io/token/images/andyonblast_32.png" style="width:30px; border-radius: 100%;"><b> ANDY </b>' ),
    ('0xa4c7aa67189ec5623121c6c94ec757dfed932d4b','MIA', 'miablastsoff','<img src="https://blastscan.io/token/images/mia_32.png" style="width:30px; border-radius: 100%;"><b> MIA </b>' ),
    ( '0x76D6556758365e63e48A0DFAfd19C8DBa15F97eE','BIG', 'bigonblast','<img src="https://pbs.twimg.com/profile_images/1778558929959522305/RvzsgVQI_400x400.jpg" style="width:30px; border-radius: 100%;"><b> BIG </b>' ),
    ( '0x7217124C626f0b7077bE91dF939195C9a8184ecC','Finger ', 'FingerblastX','<img src="https://blastscan.io/token/images/fingerblast_32.png" style="width:30px; border-radius: 100%;"><b> Finger </b>' ),
    ( '0xb582dc28968c725d2868130752afa0c13ebf9b1a','BEPE', 'bepeblast','<img src="https://pbs.twimg.com/profile_images/1762994417084854272/NUMH_niz_400x400.jpg" style="width:30px; border-radius: 100%;"><b> BEPE </b>'),
    ( '0x0b4d0ee29857c3961b380d4ec138ea5814e346b9','PACM', 'pacman_blastoff' ,'<img src="https://pbs.twimg.com/profile_images/1759511237103374336/6CpLDeF8_400x400.jpg" style="width:30px; border-radius: 100%;"><b> PACM </b>'),
    ( '0xAe8172a7597B3bf4D3816c76DD8D9b2535262955','TOISE ', 'toiseonblast','<img src="https://pbs.twimg.com/profile_images/1746955331966500865/kEpE5Dpz_400x400.jpg" style="width:30px; border-radius: 100%;"><b> TOISE </b>' ),
    ('0x9bd75c164daf830733ac2ea71a0258f95aac7c57','BCAT', 'blastcatcat','<img src="https://pbs.twimg.com/profile_images/1763196217830604800/X1w4-YLa_400x400.jpg" style="width:30px; border-radius: 100%;"><b> BCAT </b>' ),
    ( '0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06','PAC ', 'pacmoon_','<img src="https://blastscan.io/token/images/pacmoon_32.png" style="width:30px; border-radius: 100%;"><b> PAC </b>' ),
    ( '0xd582879453337BD149Ae53EC2092B0af5281d1D7','GLORY ', 'SekaiGlory','<img src="https://blastscan.io/token/images/sekaiglory_32.png" style="width:30px; border-radius: 100%;"><b> GLORY </b>' ),
    ( '0x010392305558d58e1Cb0Eec5529a65bf3545f82e','MACHI ', 'MachidotXYZ','<img src="https://pbs.twimg.com/profile_images/1826581300704079872/A9u_knzc_400x400.jpg" style="width:30px; border-radius: 100%;"><b> MACHI </b>' ),
    ( '0xb73d8850510f2001fd4655c3baf98f3dfb00c0cc','DJENN ', 'djenncoin','<img src="https://pbs.twimg.com/profile_images/1802780641378918400/2DizHsyK_400x400.jpg" style="width:30px; border-radius: 100%;"><b> DJENN </b>' ),
    ( '0xb9dfCd4CF589bB8090569cb52FaC1b88Dbe4981F','bag ', 'bagdotwin' ,'<img src="https://blastscan.io/token/images/bag_32.png" style="width:30px; border-radius: 100%;"><b> bag </b>'),
    ( '0xe919acf861bfb5933126f67a5f9468fe819b6195','pew ', 'pew_on_blast','<img src="https://pbs.twimg.com/profile_images/1790370051935379456/mx00Rpwu_400x400.jpg" style="width:30px; border-radius: 100%;"><b> pew </b>' ),
    ( '0xB6e0d8A730C6e5c85c637b1cf7aD6fD07927b965','bPEPE ', 'blastin_pepes','<img src="https://blastscan.io/token/images/blastinpepes_32.png" style="width:30px; border-radius: 100%;"><b> bPEPE </b>' ),
    ( '0x764933fbad8f5d04ccd088602096655c2ed9879f','AI ', 'anyinucoin','<img src="https://blastscan.io/token/images/anyinu_32.png" style="width:30px; border-radius: 100%;"><b> AI </b>' )


    ) AS t (contract_address, token_name, twitter, image)
    ),

    transfer AS (
    SELECT
    Last run: 11 days ago
    Date
    Name
    Daily Transfer
    Transfer Growth
    1
    		2024-02-26 00:00:00.000AI 11361136
    2
    		2024-02-26 00:00:00.000ANDY30303030
    3
    		2024-02-26 00:00:00.000BAJA3697736977
    4
    		2024-02-26 00:00:00.000BCAT3585335853
    5
    		2024-02-26 00:00:00.000BEPE92589258
    6
    		2024-02-26 00:00:00.000Finger 1568615686
    7
    		2024-02-26 00:00:00.000GLORY 2492724927
    8
    		2024-02-26 00:00:00.000MIA2052720527
    9
    		2024-02-26 00:00:00.000PACM38103810
    10
    		2024-02-26 00:00:00.000Pump3849738497
    11
    		2024-02-26 00:00:00.000bag 16121612
    12
    		2024-03-04 00:00:00.000AI 7821918
    13
    		2024-03-04 00:00:00.000ANDY55748604
    14
    		2024-03-04 00:00:00.000BAJA613943116
    15
    		2024-03-04 00:00:00.000BCAT140637259
    16
    		2024-03-04 00:00:00.000BEPE681716075
    17
    		2024-03-04 00:00:00.000Finger 197017656
    18
    		2024-03-04 00:00:00.000GLORY 784532772
    19
    		2024-03-04 00:00:00.000MIA1539435921
    20
    		2024-03-04 00:00:00.000PACM20035813
    ...
    827
    37KB
    3s