> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blockworks.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Finding an id
> Which tabular model to query to get the series key a timeseries endpoint needs, and which identifiers each lookup accepts.
Every timeseries endpoint identifies a series by a key in the path or in `series`. For entity-keyed models that key is the primary key of a row in a tabular model, usually a UUID such as `b204e48e-9812-43e6-a00b-5fcfd40e04a2`. Slugs and symbols are accepted by the tabular row endpoint but not by the timeseries path: a request such as `/query/timeseries/blockchains/1d/solana` returns `200` with an empty `points` array and no `entity`, not a `404`. Resolve the identifier first.
```bash theme={null}
curl "https://api.blockworks.com/query/tabular/blockchains/solana?selections=networkID,name" \
-H "X-Blockworks-API-Key: $BLOCKWORKS_API_KEY"
```
```json theme={null}
{"error": null, "data": {"networkID": "b204e48e-9812-43e6-a00b-5fcfd40e04a2", "name": "Solana"}, "metadata": {"matchedField": "slug"}}
```
`/query/timeseries/blockchains/1d/b204e48e-9812-43e6-a00b-5fcfd40e04a2`
## Lookup table
One row per lookup: the timeseries models that share a key, the path parameter that carries it, the request that resolves it, and the identifiers that request accepts. Generated from the catalog, so it is complete for every model in this reference.
| Timeseries models | Series key | Look it up with | Identifiers accepted |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------- |
| [`asset-investor-mentions`](/api-reference/data-api/social-mindshare/timeseries-asset-investor-mentions-by-id), [`asset-marketcap`](/api-reference/data-api/assets/timeseries-asset-marketcap-by-id), [`asset-mindshare`](/api-reference/data-api/social-mindshare/timeseries-asset-mindshare-by-id), [`asset-price`](/api-reference/data-api/assets/timeseries-asset-price-by-id), [`asset-sentiment`](/api-reference/data-api/social-mindshare/timeseries-asset-sentiment-by-id), [`asset-sharpe`](/api-reference/data-api/assets/timeseries-asset-sharpe-by-id), [`asset-supply`](/api-reference/data-api/assets/timeseries-asset-supply-by-id), [`asset-volatility`](/api-reference/data-api/assets/timeseries-asset-volatility-by-id) | `asset-id`, `assetID`, `id` (Asset ID) | [`GET /query/tabular/assets/bitcoin`](/api-reference/data-api/assets/tabular-assets-by-id) then read `assetID` | `slug`, `prioritySymbol` or the `assetID` itself |
| [`blockchains`](/api-reference/data-api/blockchains/timeseries-blockchains-by-id) | `id` (Network ID) | [`GET /query/tabular/blockchains/solana`](/api-reference/data-api/blockchains/tabular-blockchains-by-id) then read `networkID` | `slug` or the `networkID` itself |
| [`dat-companies`](/api-reference/data-api/digital-asset-treasuries/timeseries-dat-companies-by-id) | `id` (DAT Company ID) | [`GET /query/tabular/dat-companies`](/api-reference/data-api/digital-asset-treasuries/tabular-dat-companies) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`dat-companies-by-asset`](/api-reference/data-api/digital-asset-treasuries/timeseries-dat-companies-by-asset-by-id) | `id` (DAT Company Asset ID) | [`GET /query/tabular/dat-company-assets`](/api-reference/data-api/digital-asset-treasuries/tabular-dat-company-assets) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`etf-assets`](/api-reference/data-api/etfs/timeseries-etf-assets-by-id) | `id` (Asset ID) | [`GET /query/tabular/etf-assets`](/api-reference/data-api/etfs/tabular-etf-assets) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`etf-providers`](/api-reference/data-api/etfs/timeseries-etf-providers-by-id) | `id` (Project ID) | [`GET /query/tabular/etf-providers`](/api-reference/data-api/etfs/tabular-etf-providers) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`launchpads-by-chain`](/api-reference/data-api/launchpads/timeseries-launchpads-by-chain-by-id) | `id` (Chain ID) | [`GET /query/tabular/launchpad-chains`](/api-reference/data-api/launchpads/tabular-launchpad-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`launchpads`](/api-reference/data-api/launchpads/timeseries-launchpads-by-id) | `id` (Launchpad ID) | [`GET /query/tabular/launchpads`](/api-reference/data-api/launchpads/tabular-launchpads) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`lending-protocols-by-product-market`](/api-reference/data-api/lending-protocols/timeseries-lending-protocols-by-product-market-by-id) | `id` (Protocol Product Chain Market ID) | [`GET /query/tabular/lending-protocol-product-markets`](/api-reference/data-api/lending-protocols/tabular-lending-protocol-product-markets) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`lending-protocols-by-product`](/api-reference/data-api/lending-protocols/timeseries-lending-protocols-by-product-by-id) | `id` (Protocol Product Chain ID) | [`GET /query/tabular/lending-protocol-products`](/api-reference/data-api/lending-protocols/tabular-lending-protocol-products) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`lending-protocols`](/api-reference/data-api/lending-protocols/timeseries-lending-protocols-by-id) | `id` (Project ID) | [`GET /query/tabular/lending-protocols`](/api-reference/data-api/lending-protocols/tabular-lending-protocols) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`perp-dex-protocols`](/api-reference/data-api/perp-dexes/timeseries-perp-dex-protocols-by-id) | `id` (Project ID) | [`GET /query/tabular/perp-dex-protocols`](/api-reference/data-api/perp-dexes/tabular-perp-dex-protocols) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`perpetual-markets`](/api-reference/data-api/derivatives/timeseries-perpetual-markets-by-id) | `id` (Perpetual Market ID) | [`GET /query/tabular/perpetual-markets/`](/api-reference/data-api/derivatives/tabular-perpetual-markets-by-id) then read `id` | `slug` or the `id` itself |
| [`spot-dex-protocols-by-chain`](/api-reference/data-api/spot-dexes/timeseries-spot-dex-protocols-by-chain-by-id) | `id` (Protocol Version Chain ID) | [`GET /query/tabular/spot-dex-protocol-chains`](/api-reference/data-api/spot-dexes/tabular-spot-dex-protocol-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`spot-dex-protocols`](/api-reference/data-api/spot-dexes/timeseries-spot-dex-protocols-by-id) | `id` (Project ID) | [`GET /query/tabular/spot-dex-protocols`](/api-reference/data-api/spot-dexes/tabular-spot-dex-protocols) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`stablecoins-by-chain`](/api-reference/data-api/stablecoins/timeseries-stablecoins-by-chain-by-id) | `id` (Chain ID) | [`GET /query/tabular/stablecoin-chains`](/api-reference/data-api/stablecoins/tabular-stablecoin-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`stablecoins-by-currency`](/api-reference/data-api/stablecoins/timeseries-stablecoins-by-currency-by-id) | `id` (Currency) | [`GET /query/tabular/stablecoin-currencies`](/api-reference/data-api/stablecoins/tabular-stablecoin-currencies) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`stablecoin-fx`](/api-reference/data-api/stablecoins/timeseries-stablecoin-fx-by-id) | `id` (Currency Pair) | [`GET /query/tabular/stablecoin-fx-pairs`](/api-reference/data-api/stablecoins/tabular-stablecoin-fx-pairs) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`stablecoins-by-issuer`](/api-reference/data-api/stablecoins/timeseries-stablecoins-by-issuer-by-id) | `id` (Issuer ID) | [`GET /query/tabular/stablecoin-issuers`](/api-reference/data-api/stablecoins/tabular-stablecoin-issuers) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`stablecoins-by-product`](/api-reference/data-api/stablecoins/timeseries-stablecoins-by-product-by-id) | `id` (Token ID) | [`GET /query/tabular/stablecoin-products`](/api-reference/data-api/stablecoins/tabular-stablecoin-products) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`stablecoin-reserves`](/api-reference/data-api/stablecoins/timeseries-stablecoin-reserves-by-id) | `id` (Reserve ID) | [`GET /query/tabular/stablecoin-reserve-entities`](/api-reference/data-api/stablecoins/tabular-stablecoin-reserve-entities) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tcg-platforms-by-chain`](/api-reference/data-api/tcg-platforms/timeseries-tcg-platforms-by-chain-by-id) | `id` (Platform Chain ID) | [`GET /query/tabular/tcg-platform-chains`](/api-reference/data-api/tcg-platforms/tabular-tcg-platform-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-commodities-by-commodity`](/api-reference/data-api/tokenized-commodities/timeseries-tokenized-commodities-by-commodity-by-id) | `id` (Commodity ID) | [`GET /query/tabular/tokenized-commodities`](/api-reference/data-api/tokenized-commodities/tabular-tokenized-commodities) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-commodities-by-chain`](/api-reference/data-api/tokenized-commodities/timeseries-tokenized-commodities-by-chain-by-id) | `id` (Chain ID) | [`GET /query/tabular/tokenized-commodity-chains`](/api-reference/data-api/tokenized-commodities/tabular-tokenized-commodity-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-commodities-by-issuer`](/api-reference/data-api/tokenized-commodities/timeseries-tokenized-commodities-by-issuer-by-id) | `id` (Issuer ID) | [`GET /query/tabular/tokenized-commodity-issuers`](/api-reference/data-api/tokenized-commodities/tabular-tokenized-commodity-issuers) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-commodities-by-product`](/api-reference/data-api/tokenized-commodities/timeseries-tokenized-commodities-by-product-by-id) | `id` (Product ID) | [`GET /query/tabular/tokenized-commodity-products`](/api-reference/data-api/tokenized-commodities/tabular-tokenized-commodity-products) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-equities-by-equity`](/api-reference/data-api/tokenized-equities/timeseries-tokenized-equities-by-equity-by-id) | `id` (Equity ID) | [`GET /query/tabular/tokenized-equities`](/api-reference/data-api/tokenized-equities/tabular-tokenized-equities) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-equities-by-chain`](/api-reference/data-api/tokenized-equities/timeseries-tokenized-equities-by-chain-by-id) | `id` (Chain ID) | [`GET /query/tabular/tokenized-equity-chains`](/api-reference/data-api/tokenized-equities/tabular-tokenized-equity-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-equities-by-issuer`](/api-reference/data-api/tokenized-equities/timeseries-tokenized-equities-by-issuer-by-id) | `id` (Issuer ID) | [`GET /query/tabular/tokenized-equity-issuers`](/api-reference/data-api/tokenized-equities/tabular-tokenized-equity-issuers) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`tokenized-equities-by-product`](/api-reference/data-api/tokenized-equities/timeseries-tokenized-equities-by-product-by-id) | `id` (Product ID) | [`GET /query/tabular/tokenized-equity-products`](/api-reference/data-api/tokenized-equities/tabular-tokenized-equity-products) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`vaults-by-chain`](/api-reference/data-api/vaults/timeseries-vaults-by-chain-by-id) | `id` (Chain ID) | [`GET /query/tabular/vault-chains`](/api-reference/data-api/vaults/tabular-vault-chains) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`vault-curators`](/api-reference/data-api/vaults/timeseries-vault-curators-by-id) | `id` (Curator ID) | [`GET /query/tabular/vault-curators`](/api-reference/data-api/vaults/tabular-vault-curators) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`vault-protocols`](/api-reference/data-api/vaults/timeseries-vault-protocols-by-id) | `id` (Project ID) | [`GET /query/tabular/vault-protocols`](/api-reference/data-api/vaults/tabular-vault-protocols) then read `id` of the row | `id` only (list endpoint, no row lookup) |
| [`bqen`](/api-reference/data-api/markets/timeseries-bqen-by-id) | `id` (Market ID) | the `core-metrics-markets` table, not published in this reference | the id only |
| [`exchanges`](/api-reference/data-api/exchanges/timeseries-exchanges-by-id) | `id` (Exchange ID) | the `exchanges` table, not published in this reference | the id only |
| [`project-mindshare`](/api-reference/data-api/social-mindshare/timeseries-project-mindshare-by-id), [`projects`](/api-reference/data-api/projects-entities/timeseries-projects-by-id) | `id`, `project-id` (Project ID) | the `projects` table, not published in this reference | the id only |
| [`protocol-revenue-by-product`](/api-reference/data-api/protocol-revenue/timeseries-protocol-revenue-by-product-by-id) | `id` (Protocol Product Chain ID) | the `protocol-revenue-products` table, not published in this reference; or call the multi-series endpoint without `series` and read `series[].key` | the id only |
| [`protocol-revenue`](/api-reference/data-api/protocol-revenue/timeseries-protocol-revenue-by-id) | `id` (Project ID) | the `protocol-revenues` table, not published in this reference; or call the multi-series endpoint without `series` and read `series[].key` | the id only |
| [`trending-topics`](/api-reference/data-api/news-research/timeseries-trending-topics-by-id) | `trending-topic-id` (Topic ID) | the `topics-current` table, not published in this reference | the id only |
| [`sector-asset-mindshare`](/api-reference/data-api/social-mindshare/timeseries-sector-asset-mindshare-by-id), [`sector-asset-sentiment`](/api-reference/data-api/social-mindshare/timeseries-sector-asset-sentiment-by-id), [`sector-fundraising`](/api-reference/data-api/funding-rounds/timeseries-sector-fundraising-by-id), [`sector-investor-mentions`](/api-reference/data-api/social-mindshare/timeseries-sector-investor-mentions-by-id), [`sector-marketdata`](/api-reference/data-api/market-overview/timeseries-sector-marketdata-by-id) | `sector` (Sectors) | none needed: call the multi-series endpoint without `series` and read `series[].key` | plain names, for example `AI` |
| [`sub-sector-asset-mindshare`](/api-reference/data-api/social-mindshare/timeseries-sub-sector-asset-mindshare-by-id), [`sub-sector-asset-sentiment`](/api-reference/data-api/social-mindshare/timeseries-sub-sector-asset-sentiment-by-id), [`sub-sector-marketdata`](/api-reference/data-api/market-overview/timeseries-sub-sector-marketdata-by-id) | `sub-sector` (Sub-Sectors) | none needed: call the multi-series endpoint without `series` and read `series[].key` | plain names, for example `AI` |
| [`asset-group-sentiment`](/api-reference/data-api/social-mindshare/timeseries-asset-group-sentiment-by-id) | `asset-group-id` (Asset Group ID) | none available: keys must be known in advance | plain names |
| [`exchange-country`](/api-reference/data-api/exchanges/timeseries-exchange-country-by-id) | `country` (Country) | none available: keys must be known in advance | plain names such as `United States`, `Japan` |
| [`exchange-region`](/api-reference/data-api/exchanges/timeseries-exchange-region-by-id) | `region` (Region) | none available: keys must be known in advance | plain names such as `Asia`, `Europe` |
| [`exchange-type`](/api-reference/data-api/exchanges/timeseries-exchange-type-by-id) | `exchange-type` (Exchange Type) | none available: keys must be known in advance | plain names such as `centralized`, `decentralized` |
## Keys that are plain names
Aggregate models (sectors, sub-sectors, exchange types, countries and regions) key their series by a display name rather than an id. Where the model allows it, call the multi-series endpoint without `series` and read `series[].key`; those values are the keys. Where `series` is required, the names must be known in advance; the ones the examples on this site use are listed above.
Which column is the series key of every model (`seriesKey: true`).
Which columns are `primaryKey` and `identifier` on every lookup model.
How the two model kinds compose.
What `entity` and `points` look like once you have the key.