# SQL API Specifics

For SQL query limits and quotas per tier, see [Pricing](https://koinju.gitbook.io/market-data-api/pricing).

## Tables and schema discovery

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

### List all available tables

```sql
SHOW tables from api
```

*Example Output:*

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

```

### Describe a table

```sql
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                 |
+------------------------+-----------------------+

```