alitaslimiHolders
    Updated 2025-02-07
    WITH daily_transfers AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    from_address,
    to_address,
    amount
    FROM
    arbitrum.core.ez_token_transfers
    WHERE
    contract_address = LOWER('0x912CE59144191C1204e64559FE8253a0e49E6548') -- ARB token address
    -- AND block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
    ),
    daily_address_balances AS (
    SELECT
    date,
    address,
    SUM(balance_change) as daily_balance
    FROM
    (
    -- Outgoing transfers (negative)
    SELECT
    date,
    from_address as address,
    -1 * SUM(amount) as balance_change
    FROM
    daily_transfers
    GROUP BY
    1,
    2
    UNION
    ALL -- Incoming transfers (positive)
    SELECT
    date,
    to_address as address,
    SUM(amount) as balance_change
    FROM
    Last run: about 1 month ago
    DATE
    DAILY_HOLDERS
    PREVIOUS_DAY_HOLDERS
    DAILY_HOLDER_CHANGE
    CUMULATIVE_HOLDERS
    1
    2023-03-16 00:00:00.00088
    2
    2023-03-17 00:00:00.00078-18
    3
    2023-03-18 00:00:00.00007-78
    4
    2023-03-19 00:00:00.0001018
    5
    2023-03-20 00:00:00.000101910
    6
    2023-03-21 00:00:00.000610-410
    7
    2023-03-22 00:00:00.0001661016
    8
    2023-03-23 00:00:00.00028234416282328282344
    9
    2023-03-24 00:00:00.000104483282344-177861282344
    10
    2023-03-25 00:00:00.00047925104483-56558282344
    11
    2023-03-26 00:00:00.0003881047925-9115282344
    12
    2023-03-27 00:00:00.0003965438810844282344
    13
    2023-03-28 00:00:00.0003033039654-9324282344
    14
    2023-03-29 00:00:00.0003125530330925282344
    15
    2023-03-30 00:00:00.00034498312553243282344
    16
    2023-03-31 00:00:00.0002568434498-8814282344
    17
    2023-04-01 00:00:00.0002163025684-4054282344
    18
    2023-04-02 00:00:00.00025429216303799282344
    19
    2023-04-03 00:00:00.0001948725429-5942282344
    20
    2023-04-04 00:00:00.0001908119487-406282344
    ...
    695
    35KB
    17s