Total Unique Addresses Count of Ethereum Classic

Question

I need to find an API giving the total number of unique addresses used on the Ethereum Classic blockchain.

For example, the following API provides it for Ethereum: https://etherscan.io/chart/address

Is there a similar API for ETC?

Answer 1

It is hard to tell what exactly Etherscan.io counts on that chart. I tried to reproduce it via Google BigQuery but didn't manage to get the same result. Here is what I tried:

1. All addresses Google has recorded balance for:

SELECT COUNT(*)
FROM `bigquery-public-data.crypto_ethereum.balances`;

Gives me 104,951,247 for Ethereum and 73,653,935 for Ethereum Classic.

2. All addresses a transaction, or some kind of internal transaction was ever send to or from:

SELECT count(*)
FROM (
  SELECT `from_address`
  FROM `bigquery-public-data.crypto_ethereum.transactions`
  UNION DISTINCT 
  SELECT  `to_address`
  FROM `bigquery-public-data.crypto_ethereum.transactions`
  UNION DISTINCT 
  SELECT  `from_address`
  FROM `bigquery-public-data.crypto_ethereum.traces`
  UNION DISTINCT 
  SELECT  `to_address`
  FROM `bigquery-public-data.crypto_ethereum.traces`
)

Gives me 105,040,917 for Ethereum and 73,693,901 for Ethereum Classic.

You may play with the queries above and probably you will find out how Etherscan.io counts addresses.