SQL API Specifics

Usage Limit per Minute

Type	Tier 1	Remarks
result_rows	100_000

Usage Limit per Month

Type	Tier 1	Remarks
queries	100_000	The maximum queries per month
result_rows	1_000_000_000
execution_time	60	Total max time that a query will be allowed to run before termination
data_transfer	100	The maximum outbound data volume in Gb included per month

Those limits should be sufficient for most use cases but if your's requires more, contact us !

Tables and schema discovery

While this documentation provides the tables' description it can always be generated by querying the table.

List all available tables

SHOW tables from api

Example Output:

┌─name──────────────────────┐
│ market_future             │
│ market_option             │
│ market_spot               │
│ ohlcv                     │
│ trade                     │
└───────────────────────────┘

Describe a table

DESCRIBE api.market_future

Example Output:

+------------------------+-----------------------+
|name                    |type                   |
+------------------------+-----------------------+
|exchange                |LowCardinality(String) |
|market_symbol           |Nullable(String)       |
|underlying_asset        |String                 |
|quote_asset             |String                 |
|settling_asset          |String                 |
|denomination_asset      |String                 |
|expiration              |Nullable(DateTime64(9))|
|contract_size           |Decimal(38, 18)        |
|contract_type           |String                 |
|future_type             |String                 |
|exchange_specific_symbol|String                 |
+------------------------+-----------------------+