beta_breakdowns

Tables

active_loans_by_lending_market

Daily time series of outstanding loan counts across DeFi lending protocols, broken down by individual lending markets and token pairs. Used for tracking borrowing activity and utilization trends across protocols like Aave v3 on multiple chains.

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”.
`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.
`lending_market_name`	`STRING`	Human-readable name identifying a specific lending market within a protocol. Format includes the chain name followed by the asset symbol, separated by a colon.
`lending_market_id`	`STRING`	Unique identifier for a specific lending market within a lending protocol. 66-character hex string including 0x prefix.
`active_loans`	`FLOAT64`	Number of outstanding loan positions in the lending market at the specified timestamp. Can be zero when no loans are active in the market.

Sample Data

data_id	chain_id	timestamp	product_id	active_loans	timestamp_grain	lending_market_id	lending_market_name
aave	aptos	2025-09-02T00:00:00.000Z	aavev3	2574.8813	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
aave	aptos	2025-10-29T00:00:00.000Z	aavev3	446569.5129	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
aave	aptos	2025-09-29T00:00:00.000Z	aavev3	4593.5068	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.active_loans_by_lending_market`
LIMIT 100

active_loans_by_lending_pool

Daily snapshot of outstanding loan balances across DeFi lending protocol pools, broken down by chain and protocol version (e.g., Aave v3). Enables tracking of total debt exposure and borrowing trends across lending markets.

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”.
`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.
`lending_pool_name`	`STRING`	Human-readable name identifier for the lending pool or market within the protocol.
`lending_pool_address`	`STRING`	Contract address of the lending pool. Hex-encoded string with 0x prefix.
`active_loans`	`FLOAT64`	Total value of outstanding loans in USD denominated across all positions within the lending pool at the given timestamp. Can be zero when no active borrowing positions exist in the pool.

Sample Data

data_id	chain_id	timestamp	product_id	active_loans	timestamp_grain	lending_pool_name	lending_pool_address
aave	aptos	2025-10-22T00:00:00.000Z	aavev3	1241533.6113	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
aave	aptos	2025-12-31T00:00:00.000Z	aavev3	13017076.2921	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
aave	aptos	2025-10-17T00:00:00.000Z	aavev3	1168723.9046	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.active_loans_by_lending_pool`
LIMIT 100

active_loans_by_token

Daily snapshot of outstanding loan balances by token across DeFi lending protocols. Enables tracking of borrowing activity, token-specific demand, and protocol utilization trends over time.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`active_loans`	`FLOAT64`	Outstanding principal amount denominated in the specified token at the snapshot timestamp. Values represent the total borrowed balance across all active positions for this token on the protocol.

Sample Data

data_id	chain_id	timestamp	active_loans	token_symbol	token_address	timestamp_grain
venus	ethereum	2024-09-18T00:00:00.000Z	218412.8879	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
venus	ethereum	2025-01-17T00:00:00.000Z	369795.1437	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
venus	ethereum	2024-09-04T00:00:00.000Z	184159.1149	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.active_loans_by_token`
LIMIT 100

capital_deployed_by_token

Daily capital deployment amounts for tokens across DeFi protocols and liquidity products, broken down by token address and chain. Used for analyzing total value locked (TVL) trends and capital allocation across protocol products.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`capital_deployed`	`FLOAT64`	Total value of capital allocated to this token within the specified product and protocol at the given timestamp. Measured in USD equivalent, aggregated at daily granularity as indicated by timestamp_grain.

Sample Data

data_id	chain_id	timestamp	product_id	token_symbol	token_address	timestamp_grain	capital_deployed
spark	ethereum	2025-09-20T00:00:00.000Z	sparkliquidity	sUSDSUSDT	0x00836fe54625be242bcfa286207795405ca4fd10	day	51073935.1133
spark	ethereum	2025-10-27T00:00:00.000Z	sparkliquidity	sUSDSUSDT	0x00836fe54625be242bcfa286207795405ca4fd10	day	49999135.0436
spark	ethereum	2025-09-13T00:00:00.000Z	sparkliquidity	sUSDSUSDT	0x00836fe54625be242bcfa286207795405ca4fd10	day	51048749.1095

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.capital_deployed_by_token`
LIMIT 100

fees_by_collateral

Daily fee revenue breakdown by collateral type and product across DeFi protocols, with MakerDAO USDS stablecoin stability fees as primary example. Enables analysis of fee generation patterns by underlying collateral asset and protocol product offerings.

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”.
`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.
`collateral_id`	`STRING`	Identifier for the specific collateral asset backing the protocol product (e.g., ETH, WBTC). May be null when fees aggregate across all collateral types for the product.
`collateral_name`	`STRING`	Human-readable name of the collateral asset used to secure loans or positions in the protocol. Null when fees are not specific to a particular collateral type or aggregated across all collateral.
`fees`	`FLOAT64`	Fee revenue generated by the protocol, denominated in USD.

Sample Data

fees	data_id	chain_id	timestamp	product_id	timestamp_grain
1368.69	makerdao	ethereum	2020-06-02T00:00:00.000Z	usds	day
166.1422	makerdao	ethereum	2020-04-09T00:00:00.000Z	usds	day
22.953	makerdao	ethereum	2020-07-04T00:00:00.000Z	usds	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.fees_by_collateral`
LIMIT 100

fees_by_collateral_extended

Daily fee and interest income records broken down by collateral type across DeFi protocols, primarily tracking MakerDAO vault positions and D3M (Direct Deposit Dai Module) integrations. Enables revenue analysis by collateral asset and income classification across 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.
`timestamp_grain`	`STRING`	Temporal resolution of the aggregated metric data. Lowercase string format such as “day”, “hour”, or “month”.
`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.
`source_table`	`STRING`	Name of the underlying fact table or data source from which this fee record was extracted. Used to trace data lineage and identify the originating system or computation for each fee entry.
`collateral_name`	`STRING`	Human-readable name of the collateral type used in the protocol. Examples include specific vault types like DIRECT-AAVEV2-DAI for MakerDAO’s direct deposit modules.
`collateral_id`	`STRING`	Unique identifier for the collateral type backing a DeFi position or loan, typically hex-encoded for protocol-specific vault or collateral pool identifiers. Used to group fee and income metrics by the specific asset type used as collateral in lending protocols like MakerDAO.
`income_type`	`STRING`	Category of protocol revenue representing how fees were generated, such as interest accrued on deposits or trading activity. Common values include ‘interest’ for lending protocols and other revenue classifications specific to each DeFi protocol.
`fees`	`FLOAT64`	Fee revenue generated by the protocol, denominated in USD.

Sample Data

data_id	chain_id	timestamp	product_id	income_type	source_table	collateral_id	collateral_name	timestamp_grain
makerdao	ethereum	2022-06-23T00:00:00.000Z	usds	interest	fct_makerdao_d3m_interests	0x4449524543542d4141564556322d444149000000000000000000000000000000	DIRECT-AAVEV2-DAI	day
makerdao	ethereum	2023-03-24T00:00:00.000Z	usds	interest	fct_makerdao_d3m_interests	0x4449524543542d4141564556322d444149000000000000000000000000000000	DIRECT-AAVEV2-DAI	day
makerdao	ethereum	2023-02-19T00:00:00.000Z	usds	interest	fct_makerdao_d3m_interests	0x4449524543542d4141564556322d444149000000000000000000000000000000	DIRECT-AAVEV2-DAI	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.fees_by_collateral_extended`
LIMIT 100

fees_by_income_type

Daily fee revenue breakdown by income source (interest, liquidation, flash_loan) across DeFi protocols and chains. Enables revenue composition analysis and protocol income stream comparison across products like Aave V3.

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”.
`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.
`income_type`	`STRING`	Category of protocol revenue source such as interest, flash_loan, or liquidation fees. Used to segment fee generation by the type of DeFi activity generating the revenue.
`fees`	`FLOAT64`	Fee revenue generated by the protocol, denominated in USD.

Sample Data

data_id	chain_id	timestamp	product_id	income_type	timestamp_grain
aave	aptos	2025-10-14T00:00:00.000Z	aavev3	liquidation	day
aave	aptos	2026-01-02T00:00:00.000Z	aavev3	liquidation	day
aave	aptos	2025-10-05T00:00:00.000Z	aavev3	flash_loan	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.fees_by_income_type`
LIMIT 100

fees_by_lending_market

Daily fee revenue aggregated by individual lending markets across DeFi protocols like Aave, with protocol, chain, and asset-specific market identifiers. Enables comparative analysis of lending protocol economics and individual market performance across chains.

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”.
`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.
`lending_market_name`	`STRING`	Human-readable name identifying a specific lending market within a protocol. Format includes the chain name followed by the asset symbol, separated by a colon.
`lending_market_id`	`STRING`	Unique identifier for a specific lending market within a lending protocol. 66-character hex string including 0x prefix.
`fees`	`FLOAT64`	Fee revenue generated by the protocol, denominated in USD.

Sample Data

fees	data_id	chain_id	timestamp	product_id	timestamp_grain	lending_market_id	lending_market_name
182.9707	aave	aptos	2025-10-22T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
0	aave	aptos	2025-07-04T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
27.2613	aave	aptos	2025-11-18T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.fees_by_lending_market`
LIMIT 100

fees_by_lending_pool

Daily fee revenue aggregated by individual lending pool across DeFi protocols like Aave v3. Enables analysis of protocol economics and comparative performance across chains and market deployments.

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”.
`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.
`lending_pool_name`	`STRING`	Human-readable name identifier for the lending pool or market within the protocol.
`lending_pool_address`	`STRING`	Contract address of the lending pool. Hex-encoded string with 0x prefix.
`fees`	`FLOAT64`	Fee revenue generated by the protocol, denominated in USD.

Sample Data

fees	data_id	chain_id	timestamp	product_id	timestamp_grain	lending_pool_name	lending_pool_address
0	aave	aptos	2025-08-01T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
0	aave	aptos	2025-08-07T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
1384.6521	aave	aptos	2025-11-03T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.fees_by_lending_pool`
LIMIT 100

fees_by_token

Daily fee revenue aggregated by token for DeFi protocols across multiple chains. Enables token-level fee analysis and comparison across protocols and blockchain networks.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`fees`	`FLOAT64`	Fee revenue generated by the protocol, denominated in USD.

Sample Data

data_id	chain_id	timestamp	token_symbol	token_address	timestamp_grain
venus	ethereum	2025-12-19T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
venus	ethereum	2024-10-17T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
venus	ethereum	2024-10-13T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.fees_by_token`
LIMIT 100

revenue_by_collateral

Daily revenue breakdown by collateral type for DeFi protocols, tracking fee generation across different asset types used as backing or security. Enables analysis of revenue concentration and collateral performance across protocols like MakerDAO.

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”.
`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.
`collateral_id`	`STRING`	Unique identifier for the specific collateral asset backing a lending or stablecoin product. May be null when revenue is aggregated across all collateral types or not collateral-specific.
`collateral_name`	`STRING`	Human-readable name of the collateral asset type used to back the product (e.g., ETH, WBTC, USDC). May be null for aggregate product-level revenue or non-collateralized products.
`revenue`	`FLOAT64`	Revenue generated by the protocol or product during the specified time period, denominated in USD.

Sample Data

data_id	revenue	chain_id	timestamp	product_id	timestamp_grain
makerdao	46.4145	ethereum	2020-01-24T00:00:00.000Z	usds	day
makerdao	46705.4987	ethereum	2019-11-21T00:00:00.000Z	usds	day
makerdao	1661.4349	ethereum	2020-02-17T00:00:00.000Z	usds	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.revenue_by_collateral`
LIMIT 100

revenue_by_income_type

Daily revenue breakdown by income type (interest, flash loans) across DeFi protocols, chains, and product versions. Used for analyzing protocol revenue composition and comparing income sources across deployments.

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”.
`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.
`income_type`	`STRING`	Classification of revenue source for DeFi protocols such as interest, flash_loan, or liquidation fees. Values describe the mechanism through which the protocol generates revenue rather than the asset type.
`revenue`	`FLOAT64`	Revenue generated by the protocol or product during the specified time period, denominated in USD.

Sample Data

data_id	chain_id	timestamp	product_id	income_type	timestamp_grain
aave	aptos	2025-11-02T00:00:00.000Z	aavev3	flash_loan	day
aave	aptos	2025-11-15T00:00:00.000Z	aavev3	flash_loan	day
aave	aptos	2025-10-21T00:00:00.000Z	aavev3	flash_loan	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.revenue_by_income_type`
LIMIT 100

revenue_by_lending_market

Daily protocol revenue generated by individual lending markets across DeFi protocols like Aave V3, broken down by chain and asset. Enables tracking of revenue performance by specific collateral types and comparing market profitability across deployments.

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”.
`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.
`lending_market_name`	`STRING`	Human-readable name identifying a specific lending market within a protocol. Format includes the chain name followed by the asset symbol, separated by a colon.
`lending_market_id`	`STRING`	Unique identifier for a specific lending market within a lending protocol. 66-character hex string including 0x prefix.
`revenue`	`FLOAT64`	Revenue generated by the protocol or product during the specified time period, denominated in USD.

Sample Data

data_id	revenue	chain_id	timestamp	product_id	timestamp_grain	lending_market_id	lending_market_name
aave	0	aptos	2025-07-28T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
aave	0.0036	aptos	2025-09-19T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
aave	0	aptos	2025-07-19T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.revenue_by_lending_market`
LIMIT 100

revenue_by_lending_pool

Daily revenue metrics for individual lending pools across DeFi protocols like Aave V3, broken down by chain and pool address. Used for analyzing protocol revenue performance and comparing lending market profitability across chains.

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”.
`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.
`lending_pool_name`	`STRING`	Human-readable name identifier for the lending pool or market within the protocol.
`lending_pool_address`	`STRING`	Contract address of the lending pool. Hex-encoded string with 0x prefix.
`revenue`	`FLOAT64`	Revenue generated by the protocol or product during the specified time period, denominated in USD.

Sample Data

data_id	revenue	chain_id	timestamp	product_id	timestamp_grain	lending_pool_name	lending_pool_address
aave	1.8291	aptos	2025-09-03T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
aave	15.3717	aptos	2025-09-23T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
aave	0	aptos	2025-08-02T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.revenue_by_lending_pool`
LIMIT 100

revenue_by_token

Daily revenue breakdowns by token for DeFi protocols, with token addresses and chain identifiers. Enables time-series analysis of protocol income streams across different assets and blockchain networks.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`revenue`	`FLOAT64`	Revenue generated by the protocol or product during the specified time period, denominated in USD.

Sample Data

data_id	chain_id	timestamp	token_symbol	token_address	timestamp_grain
venus	ethereum	2025-01-18T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
venus	ethereum	2025-11-07T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
venus	ethereum	2025-05-25T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.revenue_by_token`
LIMIT 100

spark_liquidity_layer_aum_by_token

Daily assets under management (AUM) for Spark Protocol’s liquidity layer, broken down by individual token addresses and symbols. Enables tracking of capital allocation and growth trends across Spark’s lending markets on Ethereum.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`spark_liquidity_layer_aum`	`FLOAT64`	Total assets under management (AUM) for the Spark Liquidity Layer product denominated in the specified token at the given timestamp. Values are in token units and typically range in the tens of millions for stablecoin liquidity pools.

Sample Data

data_id	chain_id	timestamp	product_id	token_symbol	token_address	timestamp_grain	spark_liquidity_layer_aum
spark	ethereum	2025-12-17T00:00:00.000Z	sparkliquidity	sUSDSUSDT	0x00836fe54625be242bcfa286207795405ca4fd10	day	49977636.9882
spark	ethereum	2025-10-31T00:00:00.000Z	sparkliquidity	sUSDSUSDT	0x00836fe54625be242bcfa286207795405ca4fd10	day	49980863.7766
spark	ethereum	2025-06-28T00:00:00.000Z	sparkliquidity	sUSDSUSDT	0x00836fe54625be242bcfa286207795405ca4fd10	day	50660417.2469

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.spark_liquidity_layer_aum_by_token`
LIMIT 100

trading_volume_by_token

Daily trading volume metrics aggregated by token across decentralized exchanges and chains, identified by token address and symbol. Enables cross-protocol volume analysis and token liquidity trends over time.

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”.
`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.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`trading_volume`	`FLOAT64`	Total trading volume for the specified token on the given product and timestamp. Values represent the aggregate volume traded during the period defined by timestamp_grain, typically measured in the token’s native units.

Sample Data

data_id	chain_id	timestamp	product_id	token_symbol	token_address	trading_volume	timestamp_grain
orca	solana	2023-04-29T00:00:00.000Z	orcatokenswapv2	SAO	2HeykdKjzHKGm2LKHw8pDYwjKPiFEoXAz74dirhUgQvq	35.3934	day
orca	solana	2023-01-04T00:00:00.000Z	orcatokenswapv2	SAO	2HeykdKjzHKGm2LKHw8pDYwjKPiFEoXAz74dirhUgQvq	421.5727	day
orca	solana	2022-05-27T00:00:00.000Z	orcatokenswapv2	SAO	2HeykdKjzHKGm2LKHw8pDYwjKPiFEoXAz74dirhUgQvq	948.5527	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.trading_volume_by_token`
LIMIT 100

trading_volume_by_trading_pair

Daily trading volume aggregated by trading pair across decentralized exchanges and protocols. Enables analysis of liquidity concentration, pair-level market activity trends, and protocol-specific trading patterns across chains.

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”.
`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.
`trading_pair_id`	`STRING`	Unique identifier for the specific token pair being traded, combining pool and market addresses. Format varies by chain; Solana uses base58-encoded identifiers concatenated with hyphens.
`trading_pair_name`	`STRING`	Human-readable label for the trading pair showing the two tokens being swapped, formatted as base-quote (e.g., SAO-USDC). Provides a user-friendly identifier corresponding to the technical trading_pair_id.
`trading_volume`	`FLOAT64`	Total trading volume denominated in USD for the specified trading pair during the time period. Aggregated at daily granularity as indicated by the timestamp_grain field.

Sample Data

data_id	chain_id	timestamp	product_id	trading_volume	timestamp_grain	trading_pair_id	trading_pair_name
orca	solana	2023-08-09T00:00:00.000Z	orcatokenswapv2	1094.4669	day	2HeykdKjzHKGm2LKHw8pDYwjKPiFEoXAz74dirhUgQvq-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	SAO-USDC
orca	solana	2023-06-17T00:00:00.000Z	orcatokenswapv2	647.4885	day	2HeykdKjzHKGm2LKHw8pDYwjKPiFEoXAz74dirhUgQvq-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	SAO-USDC
orca	solana	2022-05-11T00:00:00.000Z	orcatokenswapv2	21381.2179	day	2HeykdKjzHKGm2LKHw8pDYwjKPiFEoXAz74dirhUgQvq-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	SAO-USDC

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.trading_volume_by_trading_pair`
LIMIT 100

trading_volume_by_trading_pool

Daily trading volume metrics for decentralized exchange liquidity pools, primarily from Orca’s Whirlpools product on Solana. Enables tracking of pool-level trading activity across different token pairs and fee tiers for liquidity analysis.

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”.
`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.
`trading_pool_id`	`STRING`	Unique identifier for the liquidity pool where trading occurred, typically the pool’s on-chain program address. For Solana pools, this is a base58-encoded public key string.
`trading_pool_name`	`STRING`	Human-readable identifier for the liquidity pool, typically showing token pair and fee tier. Format follows pattern “TOKEN1-TOKEN2, FEE%” as seen in examples like “$BULL-REX, 2%”.
`trading_volume`	`FLOAT64`	Total USD-denominated trading volume for the specified pool during the time period. Aggregated at daily granularity as indicated by timestamp_grain.

Sample Data

data_id	chain_id	timestamp	product_id	trading_volume	timestamp_grain	trading_pool_id	trading_pool_name
orca	solana	2024-06-03T00:00:00.000Z	whirlpools	26.9885	day	4ugXDopQ8unFeBKvjcahoE91J6sEmEEY1XwZPNbYgu8K	$1-retail, 2%
orca	solana	2024-06-04T00:00:00.000Z	whirlpools	18.7504	day	4ugXDopQ8unFeBKvjcahoE91J6sEmEEY1XwZPNbYgu8K	$1-retail, 2%
orca	solana	2024-06-06T00:00:00.000Z	whirlpools	13.9844	day	4ugXDopQ8unFeBKvjcahoE91J6sEmEEY1XwZPNbYgu8K	$1-retail, 2%

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.trading_volume_by_trading_pool`
LIMIT 100

tvl_by_lending_market

Daily total value locked (TVL) for individual lending markets across DeFi protocols like Aave, broken down by asset, chain, and product version. Enables tracking of capital deployment and market share analysis at the granular market level.

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”.
`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.
`lending_market_name`	`STRING`	Human-readable name identifying a specific lending market within a protocol. Format includes the chain name followed by the asset symbol, separated by a colon.
`lending_market_id`	`STRING`	Unique identifier for a specific lending market within a lending protocol. 66-character hex string including 0x prefix.
`tvl`	`FLOAT64`	Total value locked in USD. Represents the aggregate dollar value of assets deposited or held within the specified scope.

Sample Data

tvl	data_id	chain_id	timestamp	product_id	timestamp_grain	lending_market_id	lending_market_name
25299.0036	aave	aptos	2025-06-23T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
28607.6866	aave	aptos	2025-07-11T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT
31181.5616	aave	aptos	2025-07-19T00:00:00.000Z	aavev3	day	0xb68e2ba5211193d45cbeacb6c8a4408a270cb183722bdc4de8d666f405dbe586	Aptos: APT

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.tvl_by_lending_market`
LIMIT 100

tvl_by_lending_pool

Daily total value locked (TVL) snapshots for individual lending pools across DeFi protocols and chains. Enables tracking of capital flows and protocol growth by specific pool address and product version.

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”.
`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.
`lending_pool_name`	`STRING`	Human-readable name identifier for the lending pool or market within the protocol.
`lending_pool_address`	`STRING`	Contract address of the lending pool. Hex-encoded string with 0x prefix.
`tvl`	`FLOAT64`	Total value locked in USD. Represents the aggregate dollar value of assets deposited or held within the specified scope.

Sample Data

tvl	data_id	chain_id	timestamp	product_id	timestamp_grain	lending_pool_name	lending_pool_address
3804081.3186	aave	aptos	2025-10-02T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
100553.1276	aave	aptos	2025-07-29T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb
103479.2005	aave	aptos	2025-07-15T00:00:00.000Z	aavev3	day	Aptos	0x39ddcd9e1a39fa14f25e3f9ec8a86074d05cc0881cbf667df8a6ee70942016fb

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.tvl_by_lending_pool`
LIMIT 100

tvl_by_token

Daily total value locked (TVL) broken down by individual token across protocols and chains. Used for tracking token-level liquidity distribution and protocol composition analysis over time.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`tvl`	`FLOAT64`	Total value locked in USD. Represents the aggregate dollar value of assets deposited or held within the specified scope.

Sample Data

tvl	data_id	chain_id	timestamp	token_symbol	token_address	timestamp_grain
966382.678	venus	ethereum	2024-11-09T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
1016726.6746	venus	ethereum	2025-11-24T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day
1012475.7215	venus	ethereum	2025-08-08T00:00:00.000Z	TUSD	0x0000000000085d4780b73119b644ae5ecd22b376	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.tvl_by_token`
LIMIT 100

tvl_by_trading_pair

Daily Total Value Locked (TVL) metrics broken down by trading pair across decentralized exchange protocols and blockchain networks. Used to track liquidity depth and concentration across specific token pairs like HQ-SOL on Orca’s Whirlpools product.

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”.
`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.
`trading_pair_id`	`STRING`	Unique identifier for the trading pair, constructed from the token contract addresses on Solana. Hyphen-separated base58-encoded addresses identifying the two assets in the pool.
`trading_pair_name`	`STRING`	Human-readable name of the trading pair, displaying base and quote tokens separated by a hyphen (e.g., HQ-SOL). Derived from the token symbols in the liquidity pool.
`tvl`	`FLOAT64`	Total value locked in USD. Represents the aggregate dollar value of assets deposited or held within the specified scope.

Sample Data

tvl	data_id	chain_id	timestamp	product_id	timestamp_grain	trading_pair_id	trading_pair_name
0.3992	orca	solana	2025-03-08T00:00:00.000Z	whirlpools	day	122V8QAaysrNWpGmjv4dhk2RwkNmjQso48sFXJHjDJc4-So11111111111111111111111111111111111111112	HQ-SOL
0.5163	orca	solana	2025-03-23T00:00:00.000Z	whirlpools	day	122V8QAaysrNWpGmjv4dhk2RwkNmjQso48sFXJHjDJc4-So11111111111111111111111111111111111111112	HQ-SOL
4.6904	orca	solana	2025-02-08T00:00:00.000Z	whirlpools	day	122V8QAaysrNWpGmjv4dhk2RwkNmjQso48sFXJHjDJc4-So11111111111111111111111111111111111111112	HQ-SOL

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.tvl_by_trading_pair`
LIMIT 100

tvl_by_trading_pool

Daily total value locked (TVL) snapshots for individual trading pools across decentralized exchanges and automated market makers (AMMs). Enables tracking liquidity depth trends and comparing pool performance across protocols, chains, and token pairs.

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”.
`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.
`trading_pool_id`	`STRING`	Unique identifier for the liquidity pool or trading pair on the decentralized exchange. Typically represented as a base58-encoded Solana program address for pools on Solana-based DEXs like Orca.
`trading_pool_name`	`STRING`	Human-readable label for the trading pool, typically showing token pair and fee tier (e.g., “SOL-USDC, 0.3%”). May show “N/A” for one token when pool information is incomplete or unavailable.
`tvl`	`FLOAT64`	Total value locked in USD. Represents the aggregate dollar value of assets deposited or held within the specified scope.

Sample Data

tvl	data_id	chain_id	timestamp	product_id	timestamp_grain	trading_pool_id	trading_pool_name
0.1218	orca	solana	2026-01-09T00:00:00.000Z	whirlpools	day	12313EMkWTAuokuptmkwXKJJJiQZa5v3LzmGSgvqbjGt	AI-USDC, 0.01%
0.1218	orca	solana	2026-01-10T00:00:00.000Z	whirlpools	day	12313EMkWTAuokuptmkwXKJJJiQZa5v3LzmGSgvqbjGt	AI-USDC, 0.01%
0.1218	orca	solana	2026-01-11T00:00:00.000Z	whirlpools	day	12313EMkWTAuokuptmkwXKJJJiQZa5v3LzmGSgvqbjGt	AI-USDC, 0.01%

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.tvl_by_trading_pool`
LIMIT 100

tvl_with_staking_by_token

Daily total value locked (TVL) including staked assets, broken down by individual token across protocols and chains. Enables tracking of capital allocation trends and token-specific liquidity analysis over time.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`tvl`	`FLOAT64`	Total value locked in USD. Represents the aggregate dollar value of assets deposited or held within the specified scope.

Sample Data

tvl	data_id	chain_id	timestamp	token_symbol	token_address	timestamp_grain
31.3957	mamo	base	2025-12-18T00:00:00.000Z	WETH	0x4200000000000000000000000000000000000006	day
34.2377	mamo	base	2025-12-17T00:00:00.000Z	WETH	0x4200000000000000000000000000000000000006	day
1047300.04	mamo	base	2025-12-29T00:00:00.000Z	WETH	0x4200000000000000000000000000000000000006	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.tvl_with_staking_by_token`
LIMIT 100

user_dau_by_token

Daily active users (DAU) broken down by token address and chain for specific data sources. Enables tracking of per-token user engagement trends across blockchain networks over time.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`user_dau`	`BIGNUMERIC`	Number of unique active users (daily active users) interacting with the specified token on a given day. Values represent distinct wallet addresses that performed transactions involving this token.

Sample Data

data_id	chain_id	user_dau	timestamp	token_symbol	token_address	timestamp_grain
mamo	base	9	2025-12-16T00:00:00.000Z	WETH	0x4200000000000000000000000000000000000006	day
mamo	base	15	2025-12-20T00:00:00.000Z	WETH	0x4200000000000000000000000000000000000006	day
mamo	base	1350	2025-12-07T00:00:00.000Z	MAMO	0x7300b37dfdfab110d83290a29dfb31b1740219fe	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.user_dau_by_token`
LIMIT 100

vault_deposits_by_curator_address

Daily vault deposit totals aggregated by curator address for Morpho Blue lending vaults across chains. Used for analyzing curator performance and vault growth trends over time.

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”.
`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.
`curator_address`	`STRING`	Ethereum address of the curator managing or overseeing the vault’s strategy and asset allocation. Hex-encoded, 0x-prefixed 40-character string representing the curator’s on-chain identity.
`vault_deposits`	`FLOAT64`	Total value of assets deposited in vaults for the specified time period and breakdown dimensions. Floating-point value representing the aggregate deposit amount.

Sample Data

data_id	chain_id	timestamp	product_id	vault_deposits	curator_address	timestamp_grain
morpho	arbitrum	2025-11-27T00:00:00.000Z	morphoblue	1624.8913	0x00000000cb0020fdd92ce1a5f2638abfa637f966	day
morpho	arbitrum	2025-12-06T00:00:00.000Z	morphoblue	1968.4754	0x00000000cb0020fdd92ce1a5f2638abfa637f966	day
morpho	arbitrum	2025-12-15T00:00:00.000Z	morphoblue	2371.8226	0x00000000cb0020fdd92ce1a5f2638abfa637f966	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.vault_deposits_by_curator_address`
LIMIT 100

vault_deposits_by_curator_name

Daily vault deposit balances for Morpho Blue lending vaults segmented by curator name across multiple chains. Enables analysis of curator performance and vault capital allocation trends across Ethereum, Base, Arbitrum, and Unichain.

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”.
`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.
`curator_name`	`STRING`	Name of the entity or organization that curates or manages the Morpho vault strategy. Common values include “Steakhouse Financial” for known curators or “Other” for aggregated smaller curators.
`vault_deposits`	`FLOAT64`	Total value of assets deposited in vaults for the specified time period and breakdown dimensions. Floating-point value representing the aggregate deposit amount.

Sample Data

data_id	chain_id	timestamp	product_id	curator_name	vault_deposits	timestamp_grain
morpho	unichain	2025-12-20T00:00:00.000Z	morphoblue	Other	935969.6631	day
morpho	arbitrum	2025-11-23T00:00:00.000Z	morphoblue	Other	996180.4257	day
morpho	base	2025-12-23T00:00:00.000Z	morphoblue	Steakhouse Financial	545151483.9711	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.vault_deposits_by_curator_name`
LIMIT 100

vault_deposits_by_token

Daily total value deposited in DeFi savings vaults broken down by token, chain, and product. Used for tracking vault TVL (total value locked) trends and comparing deposit volumes across different yield products.

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”.
`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.
`token_symbol`	`STRING`	Ticker symbol identifying the cryptocurrency or token. Uppercase string format.
`token_address`	`STRING`	Contract address of the token on the blockchain. Hex-encoded string with 0x prefix, 42 characters total.
`vault_deposits`	`FLOAT64`	Total value of assets deposited in vaults for the specified time period and breakdown dimensions. Floating-point value representing the aggregate deposit amount.

Sample Data

data_id	chain_id	timestamp	product_id	token_symbol	token_address	vault_deposits	timestamp_grain
spark	avalanche	2025-10-12T00:00:00.000Z	sparksavings	USDC	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0	day
spark	avalanche	2025-12-19T00:00:00.000Z	sparksavings	USDC	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	225055765.4086	day
spark	avalanche	2025-12-21T00:00:00.000Z	sparksavings	USDC	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	216190733.3134	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.vault_deposits_by_token`
LIMIT 100

vault_deposits_by_vault

Daily vault deposit balances aggregated by vault address, curator, and chain across DeFi lending protocols like Spark. Enables analysis of deposit concentration, curator performance, and cross-chain vault growth trends.

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”.
`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.
`curator_name`	`STRING`	Human-readable name of the vault curator or strategy manager. Defaults to “Other” when curator is unidentified or not categorized.
`curator_address`	`STRING`	Contract address of the vault curator or manager on the specified chain. Null when the curator is categorized as “Other” or when curator information is not available.
`vault_name`	`STRING`	Human-readable name of the vault product (e.g., “Spark Savings V2: USDC”), typically including the protocol and underlying asset. Provides a friendly identifier for the vault contract at vault_address.
`vault_address`	`STRING`	Contract address of the vault holding deposited assets on the specified chain. Hex-encoded, 0x-prefixed 40-character Ethereum address format.
`vault_deposits`	`FLOAT64`	Total value of assets deposited in vaults for the specified time period and breakdown dimensions. Floating-point value representing the aggregate deposit amount.

Sample Data

data_id	chain_id	timestamp	product_id	vault_name	curator_name	vault_address	vault_deposits	timestamp_grain
spark	ethereum	2025-11-10T00:00:00.000Z	sparksavings	Spark Savings V2: USDC	Other	0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	83144839.775	day
spark	ethereum	2025-10-23T00:00:00.000Z	sparksavings	Spark Savings V2: USDC	Other	0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	49995034.4372	day
spark	avalanche	2025-12-14T00:00:00.000Z	sparksavings	Spark Savings V2: USDC	Other	0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	200929274.1693	day

Example Query

Get sample data

SELECT *
FROM `tt-metrics.beta_breakdowns.vault_deposits_by_vault`
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

active_loans_by_lending_market

active_loans_by_lending_pool

active_loans_by_token

capital_deployed_by_token

fees_by_collateral

fees_by_collateral_extended

fees_by_income_type

fees_by_lending_market

fees_by_lending_pool

fees_by_token

revenue_by_collateral

revenue_by_income_type

revenue_by_lending_market

revenue_by_lending_pool

revenue_by_token

spark_liquidity_layer_aum_by_token

trading_volume_by_token

trading_volume_by_trading_pair

trading_volume_by_trading_pool

tvl_by_lending_market

tvl_by_lending_pool

tvl_by_token

tvl_by_trading_pair

tvl_by_trading_pool

tvl_with_staking_by_token

user_dau_by_token

vault_deposits_by_curator_address

vault_deposits_by_curator_name

vault_deposits_by_token

vault_deposits_by_vault

​Tables

​active_loans_by_lending_market

​active_loans_by_lending_pool

​active_loans_by_token

​capital_deployed_by_token

​fees_by_collateral

​fees_by_collateral_extended

​fees_by_income_type

​fees_by_lending_market

​fees_by_lending_pool

​fees_by_token

​revenue_by_collateral

​revenue_by_income_type

​revenue_by_lending_market

​revenue_by_lending_pool

​revenue_by_token

​spark_liquidity_layer_aum_by_token

​trading_volume_by_token

​trading_volume_by_trading_pair

​trading_volume_by_trading_pool

​tvl_by_lending_market

​tvl_by_lending_pool

​tvl_by_token

​tvl_by_trading_pair

​tvl_by_trading_pool

​tvl_with_staking_by_token

​user_dau_by_token

​vault_deposits_by_curator_address

​vault_deposits_by_curator_name

​vault_deposits_by_token

​vault_deposits_by_vault

Tables

active_loans_by_lending_market

active_loans_by_lending_pool

active_loans_by_token

capital_deployed_by_token

fees_by_collateral

fees_by_collateral_extended

fees_by_income_type

fees_by_lending_market

fees_by_lending_pool

fees_by_token

revenue_by_collateral

revenue_by_income_type

revenue_by_lending_market

revenue_by_lending_pool

revenue_by_token

spark_liquidity_layer_aum_by_token

trading_volume_by_token

trading_volume_by_trading_pair

trading_volume_by_trading_pool

tvl_by_lending_market

tvl_by_lending_pool

tvl_by_token

tvl_by_trading_pair

tvl_by_trading_pool

tvl_with_staking_by_token

user_dau_by_token

vault_deposits_by_curator_address

vault_deposits_by_curator_name

vault_deposits_by_token

vault_deposits_by_vault