Pine Analyticschemical-jade
    Updated 2025-03-12
    with tab1 as (
    select
    wallet,
    sum(case when type like 'out' then -amount else amount end) as balance
    from (
    select
    tx_hash,
    block_timestamp,
    from_address as wallet,
    'out' as type,
    amount
    from bsc.core.ez_token_transfers
    where contract_address like lower('0x7d814b9eD370Ec0a502EdC3267393bF62d891B62')
    union all
    select
    tx_hash,
    block_timestamp,
    to_address as wallet,
    'in' as type,
    amount
    from bsc.core.ez_token_transfers
    where contract_address like lower('0x7d814b9eD370Ec0a502EdC3267393bF62d891B62')
    )
    group by 1
    )


    select
    case when balance < 0.1 then 'a/ below 0.1'
    when balance < 1 then 'b/ 0.1-1'
    when balance < 10 then 'c/ 1-10'
    Last run: 3 months ago
    HOLDER_BALANCE_GROUP
    CHAIN
    HOLDERS
    TOKEN_BALANCE
    1
    h/ 100K-1MBsc337544672.00977163
    2
    h/ 100K-1MSolana6314245195.0101561
    3
    e/ 100-1KBsc84934067731.48235268
    4
    e/ 100-1KSolana815320064.754180823
    5
    d/ 10-100Bsc6139207595.858169387
    6
    d/ 10-100Solana62026417.866651729
    7
    i/ 1M-10MBsc28589019.43840992
    8
    g/ 10K-100KBsc3287454513.00043068
    9
    g/ 10K-100KSolana34510318938.2391177
    10
    i/ 1M-10MSolana1440452188.9400883
    11
    a/ below 0.1Bsc397984.197451857
    12
    a/ below 0.1Solana7844.627605433
    13
    b/ 0.1-1Bsc89463910.816094412
    14
    b/ 0.1-1Solana13565.831417444
    15
    j/ 10M+Bsc574273011.9797288
    16
    j/ 10M+Solana3825454252.709805
    17
    f/ 1K-10KBsc12883987359.17839635
    18
    f/ 1K-10KSolana13163029033.67303837
    19
    c/ 1-10Bsc1438652123.284668309
    20
    c/ 1-10Solana2641240.718472897
    20
    833B
    166s