flipside

    $MOD token holders
    Kruys-Collins$MOD token holders
    Updated 2025-03-19

    with base as (
    SELECT
    ACCOUNT_ADDRESS as Wallet
    , AMOUNT/1e8 as amount
    FROM aptos.core.fact_transfers
    where
    token_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
    AND TRANSFER_EVENT = 'DepositEvent'

    UNION ALL
    SELECT
    ACCOUNT_ADDRESS as Wallet
    , -AMOUNT/1e8 as amount
    FROM aptos.core.fact_transfers
    where
    token_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
    AND TRANSFER_EVENT = 'WithdrawEvent'
    ),
    refine as (

    SELECT
    wallet
    , SUM (amount) as balance
    from base
    Group by 1
    having balance >= 0.001
    )

    SELECT
    count(distinct wallet) as total_holders from refine

    Last run: about 1 month ago
    TOTAL_HOLDERS
    1
    		23931
    1
    9B
    10s