10BlockchainCamembert
    Updated 2025-02-27
    WITH address_categories AS (
    /*
    =================================================
    1) mETH Protocol Community (60%)
    Sub-campagnes :
    - Season 1:
    Stash, Puff, Bybit, etc.
    - Growth
    - Future
    =================================================
    On place ci-dessous des placeholders "0xAAA..."
    que tu remplaceras par les adresses réelles
    quand tu les auras.
    */
    SELECT LOWER('0xAAA11111111111111111111111111111111111111') AS addr,
    'Community - S1 Stash' AS category,
    'ANY' AS chain_label
    UNION ALL
    SELECT LOWER('0xAAA22222222222222222222222222222222222222'),
    'Community - S1 Puff',
    'ANY'
    UNION ALL
    SELECT LOWER('0xAAA33333333333333333333333333333333333333'),
    'Community - S1 Bybit',
    'ANY'
    UNION ALL
    SELECT LOWER('0xAAA44444444444444444444444444444444444444'),
    'Community - Growth',
    'ANY'
    UNION ALL
    SELECT LOWER('0xAAA55555555555555555555555555555555555555'),
    'Community - Future',
    'ANY'

    /*
    =================================================
    Last run: about 2 months ago
    INFO
    CATEGORY
    TOTAL_L1
    TOTAL_L2
    TOTAL_L1_L2
    PCT_OF_TOTAL
    1
    Overall Supply991958987.0614374008111364.331415000070351.39285100
    2
    Distribution by CategoryUNCLASSIFIED86222039.0614372140175911.93857222639795144.527332508
    3
    Distribution by CategoryMPTreasury L2 Core01700000000170000000033.999521617
    4
    Distribution by CategoryMPTreasury L1 Core905736948090573694818.114484084
    5
    Distribution by CategoryMPTreasury L2 Eco01678650991678650993.357254742
    6
    Distribution by CategoryCOOK L2 main contract070353.39284771770353.3928477170.001407048059
    7
    Distribution by CategoryMPTreasury L1 Eco0000
    7
    593B
    10s