The analytics and validators tab on explorer uses some external datasets stored as JSON.

This folder will hold the logic for generating these JSON from google public dataset

• daily_max_tps_15_blocks
• max_tps_15_blocks_in_past_30_days

• daily_user_transactions

• daily_average_gas_unit_price
• daily_gas_from_user_transactions

• daily_deployed_contracts
• daily_contract_deployers

A subset of address on chain are accounts (have 0x1::account::Account resource). Accounts can be created in many different ways (direct call to create account, first APT receipt, first signature, etc).

We define new accounts as addresses that received APT for the first time.

If an address signs a transactions, they are considered an active user.

• daily_new_accounts_created
• daily_active_users
• mau_signers

Approx logic in validator_stats. True current state is obtained by calling view function.

Since bigquery data only has changes, would need to build current state for historical.

location_stats uses IP of validators to map to geo and is excluded (not recorded on chain)