Import this formula to enter in multiple types of inputs (e.g. multiple symbols, intervals, etc…) and this workflow will combine all results together. You also probably want to set the limit to 10000 if scraping historical data.
Import this formula to enter in multiple types of inputs (e.g. multiple symbols, intervals, etc…) and this workflow will combine all results together. You also probably want to set the limit to 10000 if scraping historical data.
Endpoint
Your CoinMarketCap API Key: https://pro.coinmarketcap.com/account/
One or more comma-separated CoinMarketCap cryptocurrency IDs.
How many quotes to return per API call. Max is 10000.
Interval of time to return data points for. See details in endpoint description.
Set this to true to ignore cases where there’s no data for your specified query. When requesting records on multiple cryptocurrencies an error is returned if no match is found for 1 or more requested cryptocurrencies. If set to true, invalid lookups will be skipped allowing valid cryptocurrencies to still be returned.
Timestamp (Unix or ISO 8601) to stop returning quotes for (inclusive). Optional, if not passed, we’ll default to the current time. If no “time_start” is passed, we return quotes in reverse order starting from this time.
Whether to use the latest version of the endpoint: https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyQuotesLatest or the historical version: https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyQuotesHistorical to get back time-series quotes of prices.
IMPORTANT The historical version requires you setting the time_start & time_end inputs and requires the CoinMarketCap Standard or higher pricing plan. To use this, enter historical here and make sure to set time_start & time_end entries!
Symbols to look up prices for.
Only used for the historical version of this endpoint. Timestamp (Unix or ISO 8601) to start returning quotes for. Optional, if not passed, we’ll return quotes calculated in reverse from “time_end”.
Auxiliary Fields to return in the response. To get ALL the available fields, use:
price,volume,market_cap,quote_timestamp,is_active,is_fiat,search_interval
Extractors
.data
.data.quotes