News

Expanding the frontier of onchain analytics

Token Terminal

Article hero image

Token Terminal has built its foundation on standardized onchain metrics like TVL, active loans, fees, revenue, active users. These metrics make projects comparable and give investors, analysts, and teams a common language for evaluation.

Behind those outputs sits one of the largest onchain data warehouses in the industry: petabytes of transaction-level data across 100+ chains and thousands of projects. To date, only a small share of this data warehouse has been visible or accessible to users, because our priority has been on standardized reporting.

During Q4, we’re rolling out Queries — a SQL interface designed to complement and extend our existing no-code analytics tools.

Check out the first breakdown charts for Aave, built using Queries, here.


SQL access to the Token Terminal data warehouse

Queries provides direct access to Token Terminal’s underlying data warehouse; enabling analysts to query:

  1. Raw blockchain data (e.g. blocks, transactions, logs).
  2. Decoded smart contract data (e.g. events, functions, state diffs).
  3. Market data (e.g. token metadata, transfers, prices).
  4. Market sector-specific primitives (e.g. DEX trades, lending deposits & borrows).
  5. Standardized metrics (e.g. TVL, GMV, fees, revenue, active users).

With Queries, high-level KPIs can be broken down into detailed drivers:

  • Active loans segmented by borrow size, collateral type, or borrower profile.
  • Trading volume segmented by trader type, pool, or asset category.
  • Total value locked segmented by asset and/or chain.

This is the same analytical flexibility that software companies expect from modern data platforms, now applied to onchain businesses.


Why it matters

  • More granular data: Analysts can move seamlessly from standardized KPIs to the detailed transaction-level factors that shape them.
  • Expanded insights and use cases: SQL queries unlock access to ~1,000x more information, extending utility beyond financial reporting into product analytics, user cohort tracking, and other project-specific analysis.
  • Unique data product: Token Terminal is the only platform in the crypto data market that delivers both standardized and custom metrics, both running on top of a well-documented and easily auditable data pipeline.

Build with us

We are already working with select DeFi protocols to build SQL-powered custom dashboards tailored to their needs.

If your team is interested in exploring how SQL access can unlock new ways to use onchain data, join our early cohort by connecting with us on Telegram here or scheduling a demo call here.

The authors of this content, or members, affiliates, or stakeholders of Token Terminal may be participating or are invested in protocols or tokens mentioned herein. The foregoing statement acts as a disclosure of potential conflicts of interest and is not a recommendation to purchase or invest in any token or participate in any protocol. Token Terminal does not recommend any particular course of action in relation to any token or protocol. The content herein is meant purely for educational and informational purposes only, and should not be relied upon as financial, investment, legal, tax or any other professional or other advice. None of the content and information herein is presented to induce or to attempt to induce any reader or other person to buy, sell or hold any token or participate in any protocol or enter into, or offer to enter into, any agreement for or with a view to buying or selling any token or participating in any protocol. Statements made herein (including statements of opinion, if any) are wholly generic and not tailored to take into account the personal needs and unique circumstances of any reader or any other person. Readers are strongly urged to exercise caution and have regard to their own personal needs and circumstances before making any decision to buy or sell any token or participate in any protocol. Observations and views expressed herein may be changed by Token Terminal at any time without notice. Token Terminal accepts no liability whatsoever for any losses or liabilities arising from the use of or reliance on any of this content.

Stay in the loop

Join our mailing list to get the latest insights!

Continue reading