Dotlake API Publicly available

Introducing the Dotlake API: Polkadot Ecosystem Data at Your Fingertips

Overview

The Parity Data Team is excited to announce the Dotlake API — a RESTful API providing programmatic access to comprehensive blockchain metrics across the Polkadot, Kusama, Westend, Paseo, ans Solo (Substrate) ecosystems.

Production URL: https://api.data.parity.io
Interactive Documentation: Dotlake API - Swagger UI

Whether you’re building dashboards, conducting research, or developing analytics tools, Dotlake provides the data infrastructure you need without the complexity of running your own indexers.

The Problem

Accessing reliable, aggregated blockchain data in the Polkadot ecosystem has traditionally required:

  • Running and maintaining your own indexer infrastructure
  • Writing complex queries against raw blockchain data
  • Aggregating data across multiple parachains manually
  • Significant DevOps overhead for data pipelines

While tools like Subscan and SubQuery serve specific use cases well, there’s been a gap for developers who need pre-aggregated, time-series metrics via a simple REST API.

What Dotlake Provides

Daily Metrics

Endpoint Description
/api/daily-uptime Chain uptime percentages (1-day, 7-day, 30-day windows)
/api/daily-tps Transactions per second
/api/daily-fees Transaction fees in native tokens and USD
/api/daily-summary 25+ comprehensive daily indicators
/api/daily-staking-participation Validators, nominators, pools, and staked amounts
/api/daily-staking-rewards Per-account staking rewards in native tokens and USD
/api/daily-opengov-referenda-results Referendum outcomes, support levels, and voting data
/api/daily-usdc / /api/daily-usdt Stablecoin holdings across chains

Monthly Metrics

Endpoint Description
/api/monthly-active-validators Validator and nominator counts
/api/monthly-percent-staked DOT issuance and staking ratios
/api/monthly-opengov-participation Voter counts by type
/api/monthly-opengov-tokens DOT voting volumes
/api/monthly-treasury-assets Treasury holdings in native tokens and USD
/api/monthly-treasury-balances Treasury as percentage of total issuance
/api/monthly-unique-accounts Active account metrics

Coverage

  • Relay Chains: Polkadot, Kusama, Westend, Paseo
  • Parachains: Parachains and Solo-chains with data dating back to genesis
  • Data Freshness: Daily updates

Authentication

Dotlake uses a wallet-based registration system powered by SIWS (Sign-In With Substrate):

  1. Visit the registration page and connect your Polkadot wallet
  2. Click on Request API Key to get your wallet on the allowlist
  3. Once done, you can immediately Sign in with Wallet and cretae your API key
  4. Use the key as a Bearer token: Authorization: Bearer <your-api-key>

No email verification delays. Pure Web3 authentication (h/t to @shawn.coe:parity.io for SIWS).
We will monitor API usage and revoke acccess to anyone abusing the server. We can add verification if we need to, but for now it is totally open.

Example Usage

# Query daily staking participation for Polkadot
curl -X GET "https://api.data.parity.io/api/daily-staking-participation" \
  -G \
  --data-urlencode "relay_chain=polkadot" \
  --data-urlencode "start_date=2025-01-01" \
  --data-urlencode "end_date=2025-01-15" \
  -H "Authorization: Bearer $API_KEY"
{
  "data": [
    {
      "date": "2025-01-15",
      "relay_chain": "polkadot",
      "chain": "polkadot",
      "number_of_validators": 500,
      "number_of_nominators": 28450,
      "number_of_pools": 215,
      "staked_DOT": 725000000.5,
      "percentage_staked": 58.2
    }
  ]
}

Use Cases

  • Dashboard Builders: Power real-time ecosystem health dashboards
  • Researchers: Analyze governance participation trends over time
  • Treasury Analysts: Track treasury balances and spending patterns
  • Staking Services: Monitor validator performance and reward distributions
  • DeFi Protocols: Access stablecoin supply data across chains

Technical Details

  • Backend: FastAPI (Python) with ClickHouse for high-performance analytics
  • Frontend: Vite + vanilla JavaScript with Polkadot wallet integration
  • Authentication: SIWS (Sign-In With Substrate) for wallet-based auth
  • Rate Limiting: Fair usage policies apply

Getting Started

  1. Get an API Key: Visit https://api.data.parity.io and connect your wallet
  2. Explore the Docs: Interactive Swagger documentation at /docs
  3. Start Querying: Use any HTTP client to access the endpoints

Feedback Welcome

We’re actively developing Dotlake and would love your input:

  • What additional metrics would be valuable?

Drop your feedback in this thread or reach out to the Parity Data Team.

6 Likes

This is quite underwhelming. Why don’t you expose these for public use without api keys with rate limits? Requiring API keys means any app that uses it has to store the key server-side and do the calls server-side as well, creating their own wrapper API just to protect their key.

A client can’t query any info on an account/extrinsic or anything, just high level numbers? Who are the people that will even use these endpoints? What’s the point of this data lake if it’s isolated and no one can really use it except for Parity?

This is something claude could whip up in a few hours. You guys should have dune-level dashboards for every aspect of the chains with public APIs by now.