freeman_7Top 100 Token holders
    Updated 2025-04-26
    with TokenHolders as (
    select
    address as Holder,
    round(sum(amount),4) as amountHold,
    sum(amountHold) over() as totalSupply,
    round((amountHold * 100)/totalSupply,4) as percentage
    from (
    select
    from_address as address,
    -sum(amount) as amount
    from base.core.ez_token_transfers
    where contract_address = lower('{{Token_Contract}}')
    group by from_address
    union all

    select
    to_address as address,
    sum(amount) as amount
    from base.core.ez_token_transfers
    where contract_address = lower('{{Token_Contract}}')
    group by to_address
    )
    group by address
    having amounthold > 0
    )
    select
    holder as Address,
    amountHold as Quantity,
    percentage || '%' as percentage
    --count(distinct Holders) as "Total Holders"
    from TokenHolders
    order by amountHold desc
    limit 100
    Last run: 2 months ago
    ADDRESS
    QUANTITY
    PERCENTAGE
    1
    0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627259562623.786225.9954%
    2
    0xa8e64fb120ce8796594670bae72279c8aa1e5359105957082.267610.6117%
    3
    0x90225a6f282b2dadeaeb2dc4c86beb8344e5fe8a58073090.45955.8161%
    4
    0xbaed383ede0e5d9d72430661f3285daa77e9439f26376092.15562.6416%
    5
    0xd272465be6c5a80e020625ad24692589011489e713492706.33321.3513%
    6
    0x628510e4e22488324bfc1d987d877f59cd37eeea12572971.07081.2592%
    7
    0xc8e0ecdba9562234c0386fc08d009fa671cc6f7112419956.09531.2439%
    8
    0x7d1cba250b768dd5f35e8f9057f5c20d213ea0da123268641.2345%
    9
    0xc77f46ff43d3b73e071fa846277d36c3b127d6e89823589.74480.9838%
    10
    0x0cfe9a38045aebca375e6c564ae814f50c7fa7009493404.41590.9508%
    11
    0x9fe087c8107c858f5fb0596fff31b4b41f5dccca9427779.98550.9442%
    12
    0x0d0707963952f2fba59dd06f2b425ace40b492fe8921452.04690.8935%
    13
    0x53698278aa850df1f71deca59ab502646fba79858431260.04730.8444%
    14
    0x81d064452817a7f783335f70f848274cfb9d236c7995081.87190.8007%
    15
    0x11d2a4b4dd54b4fec53168609ad7dff02cfc7f177752331.58660.7764%
    16
    0xa2a925b78037d4e65fe0d1a6381c31c96e5cc6057664470.3940.7676%
    17
    0x193bc9b3b2fb4468248a654548078caa832e129767000000.671%
    18
    0x806374afb72af0f5af331068c2f9709aa33900dc56040340.5612%
    19
    0xdaf075178fda66986b6ac33c62ff22e69fedb4515584168.89390.5593%
    20
    0x6a7261d6f14f9b41e08afca0bbb1a86f373ad1ef5212601.22570.522%
    100
    7KB
    17s