Skip to main content

New Accounts

New Accounts tracks the number of Hedera accounts created within a specific time period.

Hedera Data Access

To access this Hedera network statistic (and others) via Hgraph's GraphQL & REST APIs, get started here.

Hedera Stat Name: new_accounts

Methodology​

Defining a "New Account"​

  • Account Type Identification:

    • Only entities with type = 'ACCOUNT' are considered for this metric.
    • Other entity types are ignored.

  • Creation Timestamp:

    • Each qualifying account must have a created_timestamp—the point in time when the account was first registered on the Hedera network.

Filtering by Time Window​

  • User-Specified Time Range:
    • The metric is calculated over a time window defined by the function parameters:
      • start_timestamp: The lower bound of the window (inclusive).
      • end_timestamp: The upper bound (inclusive; defaults to the current time if not specified).
    • Only accounts created between these timestamps are included in the calculation.

GraphQL API Examples​

Test out these queries using our developer playground.

Fetch current new accounts (hourly)​

query NewAccountsHour {
  ecosystem_metric(
    order_by: {end_date: desc_nulls_last}
    limit: 1
    where: {name: {_eq: "new_accounts"}, period: {_eq: "hour"}}
  ) {
    total
    end_date
  }
}

Fetch daily new accounts for 1 month (timeseries)​

query DailyNewAccounts {
  ecosystem_metric(
    order_by: {end_date: desc_nulls_last}
    limit: 30
    where: {name: {_eq: "new_accounts"}, period: {_eq: "day"}}
  ) {
    total
    end_date
  }
}

Available Time Periods​

The period field supports the following values:

  • hour
  • day

SQL Implementation​

Below is a link to the Hedera Stats GitHub repository. The repo contains the SQL function that calculates the New Accounts statistic outlined in this methodology.

SQL Function: ecosystem.dashboard_new_accounts

View GitHub Repository →

Dependencies​

  • Hedera mirror node