logo
Sign InSign Up

Fund Prices

Returns data from the [funds] table.

Overview

This table provides adjusted and unadjusted prices for more than 6,000 active and delisted ETFs and CEFs. The data includes:

  • Open, high, low, close, volume
  • Pricing data includes unadjusted prices, prices adjusted for stock splits and prices adjusted for stock splits, stock dividends and spin offs
  • Data covers ETFs (Exchange Traded Funds), CEFs (Closed End Funds), ETNs (Exchange Traded Notes) and ETD (Exchange Traded Debt) securities

For more information on the dataset and the available indicators, please review the funds table on the Data Explorer page.

The table is queried via the following endpoint

https://api.findl.com/v1.0/data/funds?apiKey=test-api-key

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 (tablename). These are appended to the endpoint above, following a ?. The most important of these is your API key (apiKey) which is used to authenticate you. Without a valid API key, results will not be returned.

The funds table supports the following query parameters.

ParameterDescriptionDefaultExamples
formatThe format of the results to be returned.csvformat=json
fromSpecifies the filing date from which to return data.30 days agofrom=2023-08-01
toSpecifies the filing date to return data until.prior dayto=2023-08-31
fieldsThe fields (table columns) to return.allfields=ticker,date,close
lastupdatedSpecifies the last date on which a record was updated. This can be used to retrieve recently updated records.lastupdated.gte=2023-09-31
tickerReturns results for the specified ticker. Multiple tickers should be separated with a comma(,).allticker=TSLA
limitThe number of records to return.10000limit=100000
skipThe number of results to skip before returning data.0skip=10000
sortThe field used to sort the data and the sort method (asc/desc).date.descsort=close.asc

Return all price data for a ticker

https://api.findl.com/v1.0/data/funds?apiKey=test-api-key&format=csv&ticker=AAPL

Return all price data for multiple tickers

https://api.findl.com/v1.0/data/funds?apiKey=test-api-key&format=csv&ticker=AAPL,TSLA

Return price data that has been updated since a specified date

https://api.findl.com/v1.0/data/funds?apiKey=test-api-key&format=csv&lastupdated.gte=2023-08-01

Return all price data for a date range

https://api.findl.com/v1.0/data/funds?apiKey=test-api-key&format=csv&from=2023-08-01&to=2023-08-31

Return specific columns from price data for a ticker in a date range sorted by volume

https://api.findl.com/v1.0/data/funds?apiKey=test-api-key&format=csv&ticker=AAPL&from=2023-08-01&to=2023-08-31&fields=date,open,volume&sort=volume.desc

Set the table to return data from. [Required]

Limits the fields returned. Multiple fields should be separated with a comma (,). Leave blank to return all fields. [Optional]

Sort results by a specified field. Multiple fields should be separated with a comma (,). Indicate direction using [field].desc or [field].asc (e.g. date.desc, ticker.asc). [Optional]

Limit the number of items returned. Defaults to 10,000. Maximum data that can be returned in a single query is 100,000 items. [Optional]

Skip the first x number of results. Defaults to 0. [Optional]

Set the format of the returned data. Options include json and csv. [Default: csv].

logo

Radically accessible financial data

Contact Info

findl.com info@findl.com

Explore findl data

DocumentationSupport

Copyright © findl 2024. All rights reserved.

Terms & Use

Privacy Policy