flipside

    Total Holders by category
    freemartianTotal Holders by category
    Updated 2025-03-05
    WITH
    api_call as (
    SELECT
    value:pairAddress AS pairAddress,
    value:liquidity:usd AS liquidity_usd,
    value:marketCap AS marketCap,
    value:priceUsd AS priceUsd,
    value:priceChange:h1 AS priceChange_h1,
    value:priceChange:h6 AS priceChange_h6,
    value:priceChange:h24 AS priceChange_h24,
    value:txns:h1:buys AS h1_buys,
    value:txns:h6:buys AS h6_buys,
    value:txns:h24:buys AS h24_buys,
    value:volume:h1 AS volume_h1,
    value:volume:h6 AS volume_h6,
    value:volume:h24 AS volume_h24
    from (SELECT livequery.live.udf_api(
    'https://api.dexscreener.com/latest/dex/tokens/0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
    ) AS response), lateral FLATTEN (input => response:data:pairs)
    where pairAddress in ('0xe6EC4C661F0B822BA2851b4A1de9Ad64132fbFe3')
    -- where pairAddress in ('0xe6EC4C661F0B822BA2851b4A1de9Ad64132fbFe3','0x1445fA540021e67d2a0291BAc79036c45AF991d3')
    ),

    token_in_out AS(
    SELECT
    to_address AS user,
    SUM(amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
    GROUP BY 1
    UNION ALL
    SELECT
    from_address AS user,
    SUM(-amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x3e64cd8fd4d2fae3d7f4710817885b0941838d0b'
    Last run: 21 days agoAuto-refreshes every 1 hour
    CATEGORY
    USERS
    SUM_BALANCE
    1
    		Between 500k and 1M $3BC11577796045.4059669
    2
    		less than 1k $3BC7764143588.847919335
    3
    		Between 50k and 100k $3BC19513750011.1861158
    4
    		Between 1k and 10k $3BC5071747633.54669611
    5
    		More Than 1M $3BC236928316399.74683
    6
    		Between 100k and 500k $3BC29166789824.3656994
    7
    		Between 10k and 50k $3BC44611456496.9007725
    7
    339B
    610s