Transpose · Example Payload

Sql Query Request

Example SQL Analytics API request querying top NFT collections by sales volume

BlockchainNFTCryptocurrencyWeb3EthereumToken TransfersSmart ContractsHistorical DataDeFiDEX

Sql Query Request is an example object payload from Transpose, with 5 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

descriptionmethodurlheadersbody

Example Payload

Raw ↑ 
{
  "description": "Example SQL Analytics API request querying top NFT collections by sales volume",
  "method": "POST",
  "url": "https://api.transpose.io/sql",
  "headers": {
    "X-API-KEY": "YOUR_API_KEY",
    "Content-Type": "application/json"
  },
  "body": {
    "sql": "SELECT contract_address, COUNT(*) AS sale_count, SUM(CAST(price AS FLOAT)) AS total_volume FROM ethereum.nft_sales WHERE timestamp >= '2023-01-01' AND timestamp < '2024-01-01' GROUP BY contract_address ORDER BY total_volume DESC LIMIT 10;"
  }
}