Skip to main content

​
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.
ColumnTypeDescription
timestampTIMESTAMPPoint in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
asset_idSTRINGUnique 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_idSTRINGBlockchain network identifier where the protocol or asset operates. Lowercase string format such as “ethereum”, “aptos”, or “optimism”.
token_addressSTRINGContract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
metric_idSTRINGIdentifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
valueFLOAT64Numerical 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.
valueasset_idchain_idmetric_idtimestamptoken_address
0tusdethereumasset_redemptions2018-04-14T00:00:00.000Z0x8dd5fbce2f6a956c3022ba3663759011dd51e73e
0tusdethereumasset_redemptions2018-04-29T00:00:00.000Z0x8dd5fbce2f6a956c3022ba3663759011dd51e73e
0tusdethereumasset_redemptions2018-04-16T00:00:00.000Z0x8dd5fbce2f6a956c3022ba3663759011dd51e73e
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.
ColumnTypeDescription
timestampTIMESTAMPPoint in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
timestamp_grainSTRINGTemporal resolution of the aggregated metric data. Lowercase string format such as “day”, “hour”, or “month”.
ecosystem_idSTRINGIdentifier 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_idSTRINGIdentifier 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_idSTRINGChain 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_idSTRINGIdentifier 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_idSTRINGIdentifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
valueFLOAT64Numerical 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.
valuemetric_idtimestampecosystem_idtimestamp_grainbreakdown_data_idbreakdown_chain_idbreakdown_data_product_id
7040ecosystem_active_addresses_monthly2018-03-24T00:00:00.000Zethereumday0xethereum
7330ecosystem_active_addresses_monthly2018-03-27T00:00:00.000Zethereumday0xethereum
7708ecosystem_active_addresses_monthly2018-03-06T00:00:00.000Zethereumday0xethereum
Query with partition filter
SELECT *
FROM `tt-metrics.metrics.ecosystem_metrics`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

​
metrics

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.
ColumnTypeDescription
timestampTIMESTAMPPoint in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
data_idSTRINGUnique identifier for the protocol or data source being tracked. Lowercase string format.
metric_idSTRINGIdentifier for the specific type of metric being measured. Lowercase string with underscores, such as “asset_redemptions”, “ecosystem_active_addresses_monthly”, or “code_commits”.
valueFLOAT64Numerical 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.
valuedata_idmetric_idtimestamp
0nethermindcode_commits2001-08-16T00:00:00.000Z
0nethermindcode_commits2001-08-15T00:00:00.000Z
0nethermindcode_commits2001-08-05T00:00:00.000Z
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.
ColumnTypeDescription
timestampTIMESTAMPPoint in time when the metric value was recorded. ISO 8601 format with UTC timezone and millisecond precision.
data_idSTRINGUnique identifier for the protocol or data source being tracked. Lowercase string format.
chain_idSTRINGBlockchain network identifier where the protocol or asset operates. Lowercase string format such as “ethereum”, “aptos”, or “optimism”.
product_idSTRINGIdentifier for a specific product or protocol version within the data source. Lowercase string format.
metric_idSTRINGIdentifier 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_sectorSTRINGMarket 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_sectorSTRINGMarket 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_sectorSTRINGMarket sector classification for the blockchain identified in chain_id. Common values include “blockchains-l1” for layer-1 chains, enabling comparison across similar blockchain types.
valueFLOAT64Numerical 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.
valuedata_idchain_idmetric_idtimestampproduct_iddata_id_market_sectorchain_id_market_sectorproduct_id_market_sector
0bitcoinbitcoinactive_addresses_daily2009-07-05T00:00:00.000Zblockchains-l1blockchains-l1
0bitcoinbitcoinactive_addresses_daily2009-07-06T00:00:00.000Zblockchains-l1blockchains-l1
0bitcoinbitcoinactive_addresses_daily2009-07-13T00:00:00.000Zblockchains-l1blockchains-l1
Query with partition filter
SELECT *
FROM `tt-metrics.metrics.metrics_with_breakdowns`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100