LordkingMC- Supply- Price
    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)
    ),
    price AS (
    SELECT
    Last run: about 2 months ago
    Meme Coin
    Total Holder
    Fully diluted MarketCap
    Fully diluted market cap
    MarketCap
    Market cap
    Burnned Supply
    Total Burnned
    Burnned MarketCap
    Burnned market cap
    Circulating Supply (%)
    Price
    ATL
    ATH
    percentage from ATH
    percentage from ATL
    Total Supply.
    Avg Holding (USD)
    Contract
    Price (24h)
    Price (7d)
    Price (30d)
    Twitter
    Image
    1
    MACHI 3382.79 M27912372.79 M279123700001000.0835320.0740140.165474-501333.42 M82580x010392305558d58e1Cb0Eec5529a65bf3545f82e-0.53-0.82-2.1MachidotXYZ
    <img src="https://pbs.twimg.com/profile_images/1826581300704079872/A9u_k...
    2
    bPEPE 2.7 K1.55 M15488201.55 M15488207.13948772e-060.00000713948772001000.1548820.1425650.362687-57910 M5750xB6e0d8A730C6e5c85c637b1cf7aD6fD07927b9650.38-20-32.4blastin_pepes
    <img src="https://blastscan.io/token/images/blastinpepes_32.png" styl...
    3
    Pump8.8 K1.14 M11448151.14 M114481500001000.0545150.045151741.416420305-962121 M1300x216a5a1135a9dab49fa9ad865e0f22fe22b5630a-0.2-34.21-67.92realpumpitcoin
    <img src="https://pbs.twimg.com/profile_images/1752775532561764352/8X-GE...
    4
    ANDY21.1 K888.3 K888270866.1 K866063.22.5 M250000022.2 K22206.8980.00888270.008688010.503928-982100 M410xd43d8adac6a4c7d9aeece7c3151fca8f23752cf8-1.09-35.76-60.62AndyBlastL2
    <img src="https://blastscan.io/token/images/andyonblast_32.png" style...
    5
    DJENN 34512 K1198811.2 K11159.8690.9 K690906828.2828.2930.001198760.001198760.07956-98010 M320xb73d8850510f2001fd4655c3baf98f3dfb00c0ccdjenncoin
    <img src="https://pbs.twimg.com/profile_images/1802780641378918400/2DizH...
    6
    AI 1.3 K21.7 K2173721.7 K2173700001000.000003110.000001550.000119089-971016.99 B170x764933fbad8f5d04ccd088602096655c2ed9879f-0.79-13.64-27.94anyinucoin
    <img src="https://blastscan.io/token/images/anyinu_32.png" style="wid...
    7
    bag 29.7 K448.4 K448437448.4 K448436.61.4 K1420.690.40.41000.000248570.000185170.006200163-96341.8 B150xb9dfCd4CF589bB8090569cb52FaC1b88Dbe4981F-3.98-46.08-63.57bagdotwin
    <img src="https://blastscan.io/token/images/bag_32.png" style="width:...
    8
    GLORY 14.1 K194.1 K194067192.9 K192901.85.39 M53906051.2 K1165.2990.000216150.000202580.017123854-997897.84 M140xd582879453337BD149Ae53EC2092B0af5281d1D7-0.25-25.22-57.84SekaiGlory
    <img src="https://blastscan.io/token/images/sekaiglory_32.png" style=...
    9
    BEPE5.7 K58.4 K5843658.4 K584361010001005.844e-75.68e-70.000080603-993100 B100xb582dc28968c725d2868130752afa0c13ebf9b1a0.26-20.71-29.76bepeblast
    <img src="https://pbs.twimg.com/profile_images/1762994417084854272/NUMH_...
    10
    BCAT3.7 K31.5 K3151224.9 K24901.496.0074 T96007369030191.26.6 K6610.6791e-1008e-9-9956457.6561 T70x9bd75c164daf830733ac2ea71a0258f95aac7c57-0.1-20.41-35.24blastcatcat
    <img src="https://pbs.twimg.com/profile_images/1763196217830604800/X1w4-...
    11
    MIA15.2 K95.5 K9547095.5 K95469.73 K3021.3321444610.30.31000.000095470.000045450.019946071-1001101 B60xa4c7aa67189ec5623121c6c94ec757dfed932d4b5.19-16.8280.26miablastsoff
    <img src="https://blastscan.io/token/images/mia_32.png" style="width:...
    12
    Finger 4.5 K22.5 K2250522.5 K2250544001003.24e-83.2e-80.000005012-991694.2 B50x7217124C626f0b7077bE91dF939195C9a8184ecCFingerblastX
    <img src="https://blastscan.io/token/images/fingerblast_32.png" style...
    13
    PACM5.8 K7.2 K71607.1 K7137.96.17 B617482008122.122.11003.6e-93e-94.55e-7-9961.9994 T10x0b4d0ee29857c3961b380d4ec138ea5814e346b9pacman_blastoff
    <img src="https://pbs.twimg.com/profile_images/1759511237103374336/6CpLD...
    14
    PAC 100 K547.9 K54791041.8 K41837.3923.64 M923642106.647716506.1 K506072.780.000547910.000398340.225728-100381000 M00x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06-0.01-17.31-27.94pacmoon_
    <img src="https://blastscan.io/token/images/pacmoon_32.png" style="wi...
    14
    5KB
    7s