curl -X POST "https://api.blockdb.io/v1/evm/tvl" \
  -H "Authorization: Bearer $BLOCKDB_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "chain_id": 1,
  "pool_uids": [
    "00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640"
  ],
  "from_timestamp": "2025-12-01T00:00:00Z",
  "to_timestamp": "2025-12-20T00:00:00Z",
  "min_tvl_usd": 1000000,
  "limit": 250
}'

#include <curl/curl.h>
#include <stdio.h>
#include <stdlib.h>

int main(void) {
    CURL *curl = curl_easy_init();
    if (!curl) return 1;

    const char *token = getenv("BLOCKDB_API_KEY");
    char auth_header[256];
    snprintf(auth_header, sizeof(auth_header), "Authorization: Bearer %s", token ? token : "");
    const char *payload = "{\"chain_id\":1,\"pool_uids\":[\"00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640\"],\"from_timestamp\":\"2025-12-01T00:00:00Z\",\"to_timestamp\":\"2025-12-20T00:00:00Z\",\"min_tvl_usd\":1000000,\"limit\":250}";

    struct curl_slist *headers = NULL;
    headers = curl_slist_append(headers, auth_header);
    headers = curl_slist_append(headers, "Content-Type: application/json");

    curl_easy_setopt(curl, CURLOPT_URL, "https://api.blockdb.io/v1/evm/tvl");
    curl_easy_setopt(curl, CURLOPT_HTTPHEADER, headers);
    curl_easy_setopt(curl, CURLOPT_POSTFIELDS, payload);

    CURLcode res = curl_easy_perform(curl);

    curl_slist_free_all(headers);
    curl_easy_cleanup(curl);
    return res == CURLE_OK ? 0 : 1;
}

using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading.Tasks;

class Program
{
    static async Task Main()
    {
        using var client = new HttpClient();
        client.DefaultRequestHeaders.Authorization =
            new AuthenticationHeaderValue("Bearer", Environment.GetEnvironmentVariable("BLOCKDB_API_KEY"));

        var payload = new StringContent(
            "{\"chain_id\":1,\"pool_uids\":[\"00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640\"],\"from_timestamp\":\"2025-12-01T00:00:00Z\",\"to_timestamp\":\"2025-12-20T00:00:00Z\",\"min_tvl_usd\":1000000,\"limit\":250}",
            Encoding.UTF8,
            "application/json"
        );

        var response = await client.PostAsync("https://api.blockdb.io/v1/evm/tvl", payload);
        response.EnsureSuccessStatusCode();

        var body = await response.Content.ReadAsStringAsync();
        Console.WriteLine(body);
    }
}

import os
import requests

response = requests.post(
    "https://api.blockdb.io/v1/evm/tvl",
    headers={
        "Authorization": f"Bearer {os.getenv('BLOCKDB_API_KEY')}",
        "Content-Type": "application/json"
    },
    json={
        'chain_id': 1,
        'pool_uids': ['00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640'],
        'from_timestamp': '2025-12-01T00:00:00Z',
        'to_timestamp': '2025-12-20T00:00:00Z',
        'min_tvl_usd': 1000000,
        'limit': 250
    }
)

data = response.json()
print(data)

const response = await fetch("https://api.blockdb.io/v1/evm/tvl", {
  method: "POST",
  headers: {
    "Authorization": `Bearer ${process.env.BLOCKDB_API_KEY}`,
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
    "chain_id": 1,
    "pool_uids": [
      "00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640"
    ],
    "from_timestamp": "2025-12-01T00:00:00Z",
    "to_timestamp": "2025-12-20T00:00:00Z",
    "min_tvl_usd": 1000000,
    "limit": 250
  })
});

const data = await response.json();
console.log(data);

package main

import (
    "fmt"
    "net/http"
    "os"
    "strings"
)

func main() {
    payload := strings.NewReader(`{
  "chain_id": 1,
  "pool_uids": [
    "00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640"
  ],
  "from_timestamp": "2025-12-01T00:00:00Z",
  "to_timestamp": "2025-12-20T00:00:00Z",
  "min_tvl_usd": 1000000,
  "limit": 250
}`)

    req, _ := http.NewRequest("POST", "https://api.blockdb.io/v1/evm/tvl", payload)
    req.Header.Set("Authorization", fmt.Sprintf("Bearer %s", os.Getenv("BLOCKDB_API_KEY")))
    req.Header.Set("Content-Type", "application/json")

    client := &http.Client{}
    resp, _ := client.Do(req)
    defer resp.Body.Close()
}

{
  "meta": {
    "chain_id": 1,
    "request_window": {
      "from_block": null,
      "to_block": null,
      "from_timestamp": "2025-12-01T00:00:00Z",
      "to_timestamp": "2025-12-20T00:00:00Z"
    },
    "resolved_window": {
      "from_block": 21640000,
      "to_block": 21775000,
      "from_timestamp": "2025-12-01T00:00:00Z",
      "to_timestamp": "2025-12-20T00:00:00Z"
    },
    "filters": {
      "pool_uids": [
        "00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640"
      ],
      "min_tvl_usd": 1000000,
      "limit": 250,
      "cursor": null
    }
  },
  "data": [
    {
      "pool_uid": "00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640",
      "exchange_id": 3,
      "type_id": 302,
      "block_number": 19001234,
      "block_time": "2025-12-20T12:34:56Z",
      "tx_index": 7,
      "log_index": 12,
      "token_amounts": [
        "1250.000000000000000000",
        "3950000.000000000000000000"
      ],
      "tvl_usd": "8750000.00",
      "_tracing_id": "070100000000000000000000000000007401",
      "_parent_tracing_ids": ["030100000000000000000000000000007401"],
      "_created_at": "2025-12-20T12:35:01Z",
      "_updated_at": "2025-12-20T12:35:01Z"
    }
  ],
  "cursor": null,
  "page_count": 1
}

{
  "error": {
    "code": "BAD_REQUEST",
    "http_status": 400,
    "message": "The request contains invalid or missing parameters.",
    "hint": "Validate all required parameters against the endpoint specification before retrying.",
    "severity": "error",
    "retryable": false,
    "details": {
      "invalid_parameters": [
        {
          "name": "chain_id",
          "location": "query",
          "reason": "missing",
          "expected": "positive integer, e.g. 1"
        },
        {
          "name": "from_timestamp",
          "location": "query",
          "reason": "invalid_format",
          "expected": "ISO-8601 UTC timestamp, e.g. 2025-11-11T00:00:00Z"
        }
      ]
    },
    "docs_url": "https://docs.blockdb.io/api-reference/overview/home"
  }
}

{
  "error": {
    "code": "UNAUTHORIZED",
    "http_status": 401,
    "message": "Invalid or missing API key.",
    "hint": "Ensure you send 'Authorization: Bearer <API_KEY>' in every request to this endpoint.",
    "severity": "error",
    "retryable": false,
    "details": {
      "auth_scheme": "bearer",
      "expected_header": "Authorization: Bearer <API_KEY>",
      "provided_header": "Authorization: <REDACTED_OR_MISSING>",
      "token_status": "invalid_or_missing",
      "recommendation": "Regenerate the API key if you suspect it is expired or compromised."
    },
    "docs_url": "https://docs.blockdb.io/api-reference/overview/authorization"
  }
}

{
  "error": {
    "code": "FORBIDDEN",
    "http_status": 403,
    "message": "Your API key does not have permission to access this endpoint.",
    "hint": "Upgrade your subscription tier or request additional access.",
    "severity": "warning",
    "retryable": false,
    "details": {
      "required_plan": "production",
      "your_plan": null,
      "contact": "support@blockdb.io",
      "recommendation": "Contact BlockDB Support Team via email support@blockdb.io."
    },
    "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
  }
}

{
  "error": {
    "code": "NOT_FOUND",
    "http_status": 404,
    "message": "The requested resource does not exist.",
    "hint": "Verify the API endpoint",
    "severity": "warning",
    "retryable": false,
    "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
  }
}

{
  "error": {
    "code": "PAYLOAD_TOO_LARGE",
    "http_status": 413,
    "message": "The requested response exceeds the maximum allowed size of 10 MB.",
    "hint": "Reduce the limit, narrow the block or time window, or apply additional filters before retrying.",
    "details": {
      "max_allowed_bytes": 10485760,
      "estimated_response_bytes": 15360000,
      "recommended_actions": [
        "Decrease the 'limit' parameter value",
        "Shorten the block range or time window",
        "Filter by fewer pools or contract addresses"
      ]
    },
    "docs_url": "https://docs.blockdb.io/api-reference/overview/pagination-and-limits"
  }
}

{
  "error": {
    "code": "CHAIN_NOT_SUPPORTED",
    "http_status": 422,
    "message": "chain_id=137 is not supported.",
    "hint": "Use a supported chain_id. Consult the documentation for the list of available chains.",
    "severity": "error",
    "retryable": false,
    "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
  }
}

{
  "error": {
    "code": "RATE_LIMIT_EXCEEDED",
    "http_status": 429,
    "message": "You have exceeded the allowed request rate.",
    "hint": "Introduce client-side throttling or exponential backoff and respect the retry_after_seconds value.",
    "details": {
      "limit_rps": 1000,
      "current_estimated_rps": 73,
      "retry_after_seconds": 2,
      "limit_scope": "api_key",
      "limit_window_seconds": 1
    },
    "docs_url": "https://docs.blockdb.io/api-reference/overview/rate-limiting"
  }
}

{
  "error": {
    "code": "INTERNAL_SERVER_ERROR",
    "http_status": 500,
    "message": "An unexpected server error occurred.",
    "hint": "This error is not caused by your request. You may retry after a short delay.",
    "severity": "critical",
    "retryable": true,
    "details": {
      "incident_id": "INC-2025-11-11-123456",
      "temporary_issue": true,
      "expected_recovery_seconds": 5
    },
    "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
  }
}

{
  "error": {
    "code": "SERVICE_UNAVAILABLE",
    "http_status": 503,
    "message": "The service is temporarily unable to handle the request.",
    "hint": "The database connection pool is briefly saturated. Retry after a short delay.",
    "severity": "warning",
    "retryable": true,
    "details": null,
    "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
  }
}