metrics

Tables

asset_metrics

Daily time-series metrics for crypto assets across blockchains, including mints and redemptions by token address and asset identifier. Enables tracking of supply changes and token activity over time for stablecoins and other digital assets.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Point in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
`asset_id`	`STRING`	Unique identifier for the digital asset being measured, typically a lowercase ticker or slug. Examples include ‘tusd’ for TrueUSD and other stablecoins or tokens tracked across chains.
`chain_id`	`STRING`	Blockchain network identifier where the protocol or asset operates. Lowercase string format such as “ethereum”, “aptos”, or “optimism”.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`metric_id`	`STRING`	Identifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
`value`	`FLOAT64`	Numerical measurement of the metric identified by metric_id at the specified timestamp. Float64 precision for representing counts, percentages, amounts, or other quantitative data depending on the metric type.

Sample Data

asset_id	chain_id	metric_id	timestamp	token_address
tusd	ethereum	asset_redemptions	2018-04-14T00:00:00.000Z	0x8dd5fbce2f6a956c3022ba3663759011dd51e73e
tusd	ethereum	asset_redemptions	2018-04-29T00:00:00.000Z	0x8dd5fbce2f6a956c3022ba3663759011dd51e73e
tusd	ethereum	asset_redemptions	2018-04-16T00:00:00.000Z	0x8dd5fbce2f6a956c3022ba3663759011dd51e73e

Example Query

Query with partition filter

SELECT *
FROM `tt-metrics.metrics.asset_metrics`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

ecosystem_metrics

Time-series metrics for blockchain ecosystems with multi-dimensional breakdowns by chain, protocol, and data product. Supports cross-ecosystem analysis of activity metrics like monthly active addresses at configurable time granularities.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Point in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
`timestamp_grain`	`STRING`	Temporal resolution of the aggregated metric data. Lowercase string format such as “day”, “hour”, or “month”.
`ecosystem_id`	`STRING`	Identifier for the blockchain ecosystem being measured, such as “ethereum” for Ethereum mainnet. This field groups metrics across all chains and protocols within a given ecosystem.
`breakdown_data_id`	`STRING`	Identifier for the specific data entity or protocol being measured within the ecosystem breakdown. Commonly contains protocol names (like “0x”) or other categorical groupings that segment the metric.
`breakdown_chain_id`	`STRING`	Chain identifier for the metric breakdown, indicating which blockchain network the data segment represents. Typically matches ecosystem_id but enables cross-chain metric aggregation within multi-chain ecosystems.
`breakdown_data_product_id`	`STRING`	Identifier for the specific data product or protocol variant within an ecosystem, used to segment metrics by application or service. Null when metrics are not broken down by data product.
`metric_id`	`STRING`	Identifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
`value`	`FLOAT64`	Numerical measurement of the metric identified by metric_id at the specified timestamp. Float64 precision for representing counts, percentages, amounts, or other quantitative data depending on the metric type.

Sample Data

value	metric_id	timestamp	ecosystem_id	timestamp_grain	breakdown_data_id	breakdown_chain_id
7040	ecosystem_active_addresses_monthly	2018-03-24T00:00:00.000Z	ethereum	day	0x	ethereum
7330	ecosystem_active_addresses_monthly	2018-03-27T00:00:00.000Z	ethereum	day	0x	ethereum
7708	ecosystem_active_addresses_monthly	2018-03-06T00:00:00.000Z	ethereum	day	0x	ethereum

Example Query

Query with partition filter

SELECT *
FROM `tt-metrics.metrics.ecosystem_metrics`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

Time-series metrics tracking blockchain project development and ecosystem activity, including code commits, community engagement, and protocol usage statistics. Used for analyzing project health, developer activity trends, and comparative ecosystem growth across different blockchain organizations and protocols.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Point in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
`data_id`	`STRING`	Unique identifier for the protocol or data source being tracked. Lowercase string format.
`metric_id`	`STRING`	Identifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
`value`	`FLOAT64`	Numerical measurement of the metric identified by metric_id at the specified timestamp. Float64 precision for representing counts, percentages, amounts, or other quantitative data depending on the metric type.

Sample Data

data_id	metric_id	timestamp
nethermind	code_commits	2001-08-16T00:00:00.000Z
nethermind	code_commits	2001-08-15T00:00:00.000Z
nethermind	code_commits	2001-08-05T00:00:00.000Z

Example Query

Query with partition filter

SELECT *
FROM `tt-metrics.metrics.metrics`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

metrics_with_breakdowns

Time-series blockchain metrics with market sector classifications across chains, assets, and protocols. Enables comparative analysis of network activity (e.g., daily active addresses) segmented by L1/L2 categories and product types.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Point in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
`data_id`	`STRING`	Unique identifier for the protocol or data source being tracked. Lowercase string format.
`chain_id`	`STRING`	Blockchain network identifier where the protocol or asset operates. Lowercase string format such as “ethereum”, “aptos”, or “optimism”.
`product_id`	`STRING`	Identifier for a specific product or protocol version within the data source. Lowercase string format.
`metric_id`	`STRING`	Identifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
`data_id_market_sector`	`STRING`	Market sector classification for the entity identified by data_id, such as ‘blockchains-l1’ for layer-1 blockchains or ‘defi-lending’ for lending protocols. Used to segment metrics by protocol type or blockchain category for comparative analysis.
`product_id_market_sector`	`STRING`	Market sector classification for the product associated with this metric observation. Null when the metric is not product-specific, as seen in chain-level metrics like daily active addresses.
`chain_id_market_sector`	`STRING`	Market sector classification for the blockchain identified in chain_id. Common values include “blockchains-l1” for layer-1 chains, enabling comparison across similar blockchain types.
`value`	`FLOAT64`	Numerical measurement of the metric identified by metric_id at the specified timestamp. Float64 precision for representing counts, percentages, amounts, or other quantitative data depending on the metric type.

Sample Data

data_id	chain_id	metric_id	timestamp	data_id_market_sector	chain_id_market_sector
bitcoin	bitcoin	active_addresses_daily	2009-07-05T00:00:00.000Z	blockchains-l1	blockchains-l1
bitcoin	bitcoin	active_addresses_daily	2009-07-06T00:00:00.000Z	blockchains-l1	blockchains-l1
bitcoin	bitcoin	active_addresses_daily	2009-07-13T00:00:00.000Z	blockchains-l1	blockchains-l1

Example Query

Query with partition filter

SELECT *
FROM `tt-metrics.metrics.metrics_with_breakdowns`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

metrics

Tables

asset_metrics

ecosystem_metrics

metrics

metrics_with_breakdowns

​Tables

​asset_metrics

​ecosystem_metrics

​metrics

​metrics_with_breakdowns

Tables

asset_metrics

ecosystem_metrics

metrics

metrics_with_breakdowns