zakkisyed$ECO Holders
    Updated 2023-06-30
    WITH holder_balances AS (
    SELECT user_address AS holder,
    SUM(current_bal) AS tokens_held,
    SUM(current_bal) * 100.0 / (SELECT SUM(current_bal) FROM ethereum.core.ez_current_balances WHERE contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727') AS percentage_holdings
    FROM ethereum.core.ez_current_balances
    WHERE contract_address = '0x8dbf9a4c99580fc7fd4024ee08f3994420035727'
    GROUP BY user_address
    )

    SELECT holder,
    tokens_held,
    percentage_holdings,
    CASE
    WHEN holder = '0x8c02d4cc62f79aceb652321a9f8988c0f6e71e68' THEN 'Community Treasury'
    WHEN holder = '0x99f98ea4a883db4692fa317070f4ad2dc94b05ce' THEN 'Association'
    WHEN holder = '0xa201d3c815ac9d4d8830fb3de2b490b5b0069aca' THEN 'Eco Inc.'
    WHEN holder = '0x6d432fdf80d57724cb7b5f3dfbe12a8e6f46e174' THEN 'Future Liquidity'
    WHEN holder = '0x09bc52b9eb7387ede639fc10ce5fa01cbcbf2b17' THEN 'Unknown'
    WHEN holder = '0xa28f219bf1e15f5217b8eb5f406bcbe8f13d16dc' THEN 'Claim Contract'
    WHEN holder = '0x26bf0495fe1c40256fe9f72278724fac538b9828' THEN 'Future Liquidity'
    ELSE 'Unknown'
    END AS holder_label
    FROM holder_balances
    ORDER BY tokens_held DESC
    limit 10;

    Run a query to Download Data