NEW: Transpose SQL Playground

Transpose SQL API

A powerful and flexible API that lets you write your own queries against the entirety of our indexed data. Perform aggregations, join data across tables and minimize the need for local data post-processing.

Top use cases:

Retrieve data for leaderboards

Compute floor prices

Wallet balances at any point in history

Advanced user segmentation

Explore, share, build.

Transpose SQL Playground

A graphical environment designed for crafting queries and exploring what’s possible with Transpose SQL. This includes the Atlas, a streamlined component for sharing and exploring queries published by the Transpose team and community. Once the query is ready, it can be exported into your production coding environment.

Browse the Atlas

OHLC token prices

Aggregate data across time at any level of granularity to get OHLC token price data in a single query.
A Transpose Atlas Query
by Patrick Croke

Token transfers with token data

Easily add additional data to minimize repeated requests when pulling transfer data.
A Transpose Atlas Query
by Jon Becker

Mint price in ETH for a collection

Aggregate and clean low-level data to retrieve non-standard, targeted metrics like mint price for any collection with token-level granularity.
A Transpose Atlas Query
by Lucas Fulks

All-time NFT trade PnL for a wallet

Perform complex math and aggregations across time to return trade profitability data in one query.
A Transpose Atlas Query
by Jon Becker

Start building today

Access the industry's most complete view of blockchain data with Transpose.

Start for free