Historical OHLCV

Overview
The "price_history" formula returns a table of the daily Open, High, Low, Close & Volume (OHLCV) values for a given market. Both quote and base volumes are included.
​See supported exchanges.​
Specific exchange
=CRYPTOFINANCE("exchange_name:BTC/USD", "price_history")
Example:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history")
Note: Default exchange is Kraken when no exchange is specified.
Example below will display results for the KRAKEN:BTC/USD market:
=CRYPTOFINANCE("BTC/USD", "price_history")
Specific exchange & period
You can specify a time period to narrow or broaden your results. Compatible time periods are listed below with examples.
"Kraken":BTC/USD" is used as a placeholder for the exchange and market in the examples below.
Year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2021")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "ytd")
Returns market price history for 2021.
Quarter (1/4) of a year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2020Q3")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "2022Q1")
Returns market price history for Q3, 2020.
Month and year:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2021-01")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "2022-01")
Returns market price history for January, 2021.
Last month:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "1m")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "1m")
Returns market price history for the previous 30 days from current date.
Last 3 months:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "3m")
Returns market price history for the previous 90 days from current date.
Last year: 
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "1y")
=CRYPTOFINANCE("OPENSEA:MUTANT-APE-YACHT-CLUB", "price_history", "1y")
Returns market price history over the last 365 days from current date.
Last 2 years:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "price_history", "2y")
Returns market price history over the last 730 days from current date).

Markets Data - Previous

Historical Data

Next - Markets Data

All-Time-Highs

Last modified 2mo ago

Copy link

Outline

Overview

Specific exchange

Specific exchange & period