flipside

    Number of $AXL Holders Across Different Chains Over Time
    Eman-RazNumber of $AXL Holders Across Different Chains Over Time
    Updated 2025-03-11
    -----------------------------------------------------------------------
    --------------------------------arbitrum-------------------------------
    -----------------------------------------------------------------------
    with arbitrum as (with transactions as (
    select
    block_timestamp :: date as date,
    from_address as address,
    - amount as amount
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address = lower('0x23ee2343B892b1BB63503a4FAbc840E0e2C6810f')
    union
    all
    select
    block_timestamp :: date as date,
    to_address as address,
    amount as amount
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address = lower('0x23ee2343B892b1BB63503a4FAbc840E0e2C6810f')
    ),
    date_list as (
    select
    block_timestamp :: date as date
    from
    arbitrum.core.ez_token_transfers
    where
    block_timestamp :: date >= '2022-12-01'
    ),
    all_dates AS (
    SELECT
    DISTINCT date
    FROM
    date_list
    Last run: about 1 month ago
    Date
    Number of Holders
    Chain
    1
    		2023-02-17 00:00:00.0004Arbitrum
    2
    		2023-02-18 00:00:00.0004Arbitrum
    3
    		2023-02-19 00:00:00.0004Arbitrum
    4
    		2023-02-20 00:00:00.0004Arbitrum
    5
    		2023-02-21 00:00:00.0004Arbitrum
    6
    		2023-02-22 00:00:00.0006Arbitrum
    7
    		2023-02-23 00:00:00.0006Arbitrum
    8
    		2023-02-24 00:00:00.0006Arbitrum
    9
    		2023-02-25 00:00:00.0006Arbitrum
    10
    		2023-02-26 00:00:00.0006Arbitrum
    11
    		2023-02-27 00:00:00.0006Arbitrum
    12
    		2023-02-28 00:00:00.0006Arbitrum
    13
    		2023-03-01 00:00:00.0006Arbitrum
    14
    		2022-10-29 00:00:00.00014Avalanche
    15
    		2022-10-30 00:00:00.00014Avalanche
    16
    		2022-10-31 00:00:00.00018Avalanche
    17
    		2022-11-01 00:00:00.00016Avalanche
    18
    		2022-11-02 00:00:00.00016Avalanche
    19
    		2022-11-03 00:00:00.00016Avalanche
    20
    		2022-11-04 00:00:00.00016Avalanche
    ...
    6191
    254KB
    212s