aPrioriOccupancy
    Updated 8 hours ago
    -- forked from GROWTH HEADROOM @ https://flipsidecrypto.xyz/studio/queries/43389d73-4fb5-475c-b46e-4085ec106525

    WITH monad_label_dim AS (
    SELECT
    column1 as ADDRESS,
    column2 as NAME,
    column3 as CATEGORY,
    column4 as Entity,
    column5 as twitter
    FROM VALUES
    ('0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e', 'Chapter 1: Genesis','NFT','Monadverse','@monadverse'),
    ('0x3a9acc3be6e9678fa5d23810488c37a3192aaf75', 'Chapter2: Back to the Past', 'NFT', 'Monadverse', '@monadverse'),
    ('0xcab08943346761701ec9757befe79ea88dd67670', 'Chapter3: Whispers in Moyaki''s Pub', 'NFT', 'Monadverse', '@monadverse'),
    -- Curvance
    ('0x5d876d73f4441d5f2438b1a3e2a51771b337f27a', 'USD Coin(USDC)', 'ERC20', 'Curvance', '@Curvance'),
    ('0xcda16e9c25f429f4b01a87ff302ee7943f2d5015', 'Curvance Wrapped Bitcoin(cWBTC)', 'ERC20', 'Curvance', '@Curvance'),
    ('0x7a9c5264bca5a04b7555bee2b85c81bd85b12d51', 'Curvance interest-bearing USD Coin(cUSDC)', 'ERC20', 'Curvance', '@Curvance'),
    ('0xb5481b57ff4e23ea7d2fda70f3137b16d0d99118', 'Curvance Collective(CVE)', 'ERC20', 'Curvance', '@Curvance'),
    ('0x8462c247356d7deb7e26160dbfab16b351eef242', 'Pump4gains', 'Games', 'Curvance', '@Curvance'),
    ('0x2555223a15a931a71951707cb32a541f14e2c730', 'Vote Escrowed CVE', 'Governance', 'Curvance', '@Curvance'),
    ('0x6bb379a2056d1304e73012b99338f8f581ee2e18', 'WBTC(Fake)','WBTC(Fake)','Curvance','@Curvance'),
    -- Meme
    ('0xe0590015a873bf326bd645c3e1266d4db41c4e6b', 'Chog(CHOG)', 'Meme', 'Monad', 'monad_xyz'),
    ('0x0f0bdebf0f83cd1ee3974779bcb7315f9808c714', 'Molandak(DAK)', 'Meme', 'Monad', 'monad_xyz'),
    ('0xfe140e1dce99be9f4f15d657cd9b7bf622270c50', 'Moyaki(YAKI)', 'Meme', 'Monad', 'monad_xyz'),
    -- Public
    ('0x88b8e2161dedc77ef4ab7585569d2415a1c1055d', 'Tether USD(USDT)', 'Stablecoin', 'Tether', ''),
    ('0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb37', 'Wrapped ETH(WETH)', 'ERC20', 'WETH', ''),
    ('0xcf5a6076cfa32686c0df13abada2b40dec133f1d', 'Wrapped BTC(WBTC)', 'ERC20', 'WBTC', ''),
    ('0x760afe86e5de5fa0ee542fc7b7b713e1c5425701', 'Wrapped Monad', 'Token', 'Wrapped Monad', ''),
    -- Dex
    ('0xca810d095e90daae6e867c19df6d9a8c56db2c89', 'Bean DEX', 'DEX', 'Bean Exchange', '@Bean_DEX'),
    ('0x268e4e24e0051ec27b3d27a95977e71ce6875a05', 'Bean Exchange(BEAN)', 'ERC20', 'Bean Exchange', '@Bean_DEX'),
    ('0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfd', 'IZUMI Swap', 'DEX', 'iZUMi Finance', '@izumi_Finance'),
    ('0x3ae6d8a282d67893e17aa70ebffb33ee5aa65893', 'Uniswap Universal Router', 'Dex', 'Uniswap', '@Uniswap'),
    -- Liquid Staking
    Last run: about 8 hours ago
    ENTITIES
    WALLET_COUNT
    APP_ALL_USER
    OCCUPANCY
    GROWTH_HEADROOM
    1
    aPriori170531717053330.99999116
    2
    LFJ.gg50072591680.8462689096
    3
    Monorail2938593817640.7697487905
    4
    Pancake Swap2082492710490.76830862800
    5
    Monadex2311903022880.764871098
    6
    Nad.Fun2243492965750.75646672226
    7
    Magma95835212883910.743836330039
    8
    Kintsu74412310172850.731479273162
    9
    iZUMi Finance4444216131940.724764168773
    10
    La Mouch10402143960.7225623994
    11
    Spiky Nads1186821652890.71802746607
    12
    aijarvis1827182545350.7178571817
    13
    Layer31579132218360.71184663923
    14
    Magic Eden3036604326160.701916128956
    15
    Multipli.fi2189243140620.69707395138
    16
    aiCraft.fu3888055780930.672565189288
    17
    Talentum2577443869670.666062129223
    18
    Tether,WBTC,WETH77900811836190.658158404611
    19
    Nad Name Service92572914106400.656248484911
    20
    Monad5536398502840.651122296645
    42
    2KB
    72s