Kruys-Collins$MOD token holders copy copy
    Updated 2025-03-09
    WITH base AS (
    SELECT
    date_trunc('hour',block_timestamp) as hour,
    AMOUNT / 1e8 AS amount
    FROM
    aptos.core.fact_transfers
    WHERE
    token_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
    AND TRANSFER_EVENT = 'DepositEvent'

    UNION ALL

    SELECT
    date_trunc('hour',block_timestamp) as hour,
    -AMOUNT / 1e8 AS amount
    FROM
    aptos.core.fact_transfers
    WHERE
    token_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
    AND TRANSFER_EVENT = 'WithdrawEvent'
    ),

    hourly_balances AS (
    SELECT
    hour,
    SUM(amount) AS balance
    FROM
    base
    GROUP BY
    hour
    ),

    cumulative_supply AS (
    SELECT
    hour,
    SUM(balance) OVER (ORDER BY hour) AS total_supply
    QueryRunArchived: QueryRun has been archived