Overview
- Introduction
- Authentication
- Querying
- Bulk Downloads
- Frequently Asked Questions
Data Tables
- Indicator Descriptions
- Fundamentals
- Stock Prices
- Fund Prices
- Corporate Actions
- Material Corporate Events
- S&P500 Constituents
- Price Based Metrics
- Insiders
- Tickers and Metadata
- Daily Fundamentals
- Institutional Investors
- Institutional Investors Summary by Ticker
- Institutional Investors Summary by Investor
Tickers and Metadata
This table acts as the securities master for Sharadar datasets. It provides a rich variety of reference information for each active and delisted ticker in the fundamentals, stocks and funds tables; each insider in the insiders table; and each investor in holdings table.
Table details
View table
Explore table metadata
The table is queried via the following endpoint:
The queries are authenticated and filtered using query parameters. A query parameter specifies a particular option or filter for the data to be returned. Examples of query parameter include the data format to be returned (format), the table columns to return (fields) or a filter to be applied (table). These are appended to the endpoint above, following a ?. The most important of these is your API key (api_key) which is used to authenticate you. Without a valid API key, results will not be returned.
The tickers table supports the following query parameters:
| Parameter | Description | Default | Examples |
|---|---|---|---|
| format | The format of the results to be returned. | csv | format=json |
| years | Triggers a bulk download of the full table as a compressed CSV. Values: 5, 10, or full. The API redirects to a time-limited download URL. | years=5 | |
| from | Optional lower bound on lastpricedate. There is no default date window for the tickers table (full universe including delisted). | none | from=2023-08-01 |
| to | Optional upper bound on lastpricedate. | none | to=2023-08-31 |
| fields | The fields (table columns) to return. | all | fields=ticker,name,exchange |
| lastupdated | Specifies the last date on which a record was updated. This can be used to retrieve recently updated records. | lastupdated.gte=2023-09-31 | |
| permaticker | Returns data for the specified permaticker, a unique and unchanging identifier for an issuer. Specific to the Sharadar database. | all | |
| table | Returns data for tickers in the specified data table (e.g. stocks, fundamentals). | all | table=fundamentals |
| ticker | Returns results for the specified ticker. Multiple tickers should be separated with a comma(,). | all | ticker=TSLA |
| limit | The number of records to return. | 10000 | limit=10000 |
| skip | The number of results to skip before returning data. Alias: offset. | 0 | skip=10000 |
| sort | The field used to sort the data and the sort method (asc/desc). | lastpricedate.desc | sort=ticker.asc |
Retrieve the PostgreSQL schema:
Retrieve the SQLite schema:
Retrieve the MySQL schema:
Return all metadata for a specified ticker:
Return metadata for tickers in a specified table (including delisted; raise limit to cover the full list, or use bulk download):
Return ticker metadata that have been updated since a specified date:
In Google Sheets, retrieve ticker metadata for a single ticker (AAPL) with IMPORTDATA. You can change the query parameters (ticker, dates, fields, filters, and so on) in the same way as the Examples in the preceding section. Paste this formula into a cell (A1):
=IMPORTDATA("https://api.sharadar.com/v1.0/data/tickers?api_key=test-api-key&format=csv&ticker=AAPL")Download the [tickers] table as a compressed CSV by setting years to 5, 10, or full. The API responds with a redirect to a time-limited download URL:
Example using curl (follow redirects and write the file):
curl -L -o tickers.csv.zip "https://api.sharadar.com/v1.0/data/tickers?api_key=test-api-key&years=full"Check the bulk file status (name, size, last modified) without downloading:
Example response:
{
"table": "tickers",
"name": "tickers.csv.zip",
"size": 3920137,
"sizeLabel": "3.74 MB",
"modified": "2026-07-16T03:59:21.771000+00:00"
}