🔥 Google Sheets integration is live! Learn more

Import Historical Crypto Market Data in Airtable

Feb 17, 2022Andy Cloke

In this tutorial, you'll learn how to import historical crypto market data in Airtable. For a particular cryptocurrency, we'll import daily price, market cap and total supply (volume) over time. To do this, we will connect to CoinGecko, which provides crypto market data, using Data Fetcher. You do not need to know how to code to follow this tutorial, but we're assuming you're familiar with Airtable.

Create Market History Table

First, we're going to create a table with a record for each date you want data for.

Create a table in your Airtable base called 'Market History'.

Create a field in this table called 'Date' with the type 'Date'. We want this field to contain sequential dates, one day apart. In the first record, select the earliest date you want market data for. In the next record, select the day after that. Then, highlight both cells, drag down the fill handle, and Airtable will fill the other records with sequential dates.

Take a look at this Airtable support article for more information. You can also automate this using Airtable Automations, e.g. if you want a dynamic date range.

sequential-dates-part-2.gif

Install Data Fetcher

Add Data Fetcher to your base from the Airtable marketplace. This is a free extension that lets us import data from any cryptocurrency API like CoinGecko, Binance or CoinMarketCap.

After you have added Data Fetcher to your base, you will need to create a free Data Fetcher account. Enter a password and click 'Sign up for free' or click 'Continue with Google'. Signing up for an account keeps your details secure. It's separate from your Airtable account.

Group 1Data Fetcher Sign Up .png

Import Historical Crypto Market Data in Airtable

We will create a request to import historical crypto market data from CoinGecko. Requests in Data Fetcher are how you import data to/ from your Airtable base.

On the home screen of the Data Fetcher app, click 'Create your first request'.

click-create-your-first-request.png

On the create request screen in Data Fetcher, for Application, select 'CoinGecko'.

coingecko-application-selected.png

The Endpoint determines what data we want to import from CoinGecko to Airtable. Select 'Get historical data at a given date for a coin'.

Enter a Name for your request, e.g. 'Import Historical Data'.

Click 'Save & Continue'.

coingecko-historical-save-continue.png

For Coin, select the cryptocurrency you want to get historical data for, e.g. 'Bitcoin'.

coingecko-historical-coingecko.png

For Date, we want to insert a reference to our 'Date' field. This means Data Fetcher will use the values from our Airtable 'Date' field and import the market data for each. Click the + button on the right-hand side.

coingecko-historical-date-add-icon.png

On the modal, select 'Market History' for Table, 'Date' for Field and 'Grid view' for Run for every record in view. Then click 'Confirm'.

coingecko-historical-date-reference.png

Date will now contain a reference to the 'Date' field in your table.

coingecko-historical-date-table-reference.png

Select the Output Table & View you want to import CoinGecko data into.

coingecko-historical-output-table.png

Click 'Save & Run'.

coingecko-historical-save-run.png

Next, you need to configure how the available fields from CoinGecko are mapped to the fields in your output table. When you run the request for the first time, the Response field mapping modal will open, where you can do this.

For each CoinGecko field, you can either import or filter it. For an imported field, you can set whether to map them to an existing field or create a new field. For new fields, you can set the field type.

Click 'Filter all' to remove all the fields.

coingecko-historical-filter-all.png

We will now import all the relevant fields. In the 'Find field' input, enter 'USD'.

  • Import all the fields with 'usd' in by clicking on the toggle next to the field name.
  • Change 'Market data current price usd' to 'Current price' and change the type to 'Currency'.
  • Change 'Market data market cap usd' to 'Market cap' and change the type to 'Currency'.
  • Change 'Market data total volume usd' to 'Total volume'.

coingecko-historical-response-field-mapping.png

Click 'Save & Run' in the bottom right.

Data Fetcher will create the new fields in the output table, then run the request again and import the historical crypto data to Airtable.

coingecko-historical-imported-data.png

Import Historical Crypto Market Data in Airtable Automatically

At the moment, we have to manually run the request and import the historical data from CoinGecko. We can use Data Fetcher's scheduled requests feature to do this automatically.

This is a paid feature, so you need to upgrade. In Data Fetcher, scroll to Schedule and click 'Upgrade'.

table-1-schedule-upgrade-button.png

A new tab will open where you can select a plan and enter your payment details to upgrade.

Screenshot 2021-12-29 at 10.25.19.png

Return to the Data Fetcher app and click "I've done this".

table-1-schedule-ive-done-this-button.png

Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

Group 1(10).png

Enable Schedule this request.

Group 1(12).png

Select how often you want the request to run, e.g. 'Every hour'. Click 'Save'.

The request will now run on the schedule and import historical crypto market data from CoinGecko automatically. This will work even if you are not logged into Airtable or Data Fetcher.

Related Posts

How to Create an Airtable Crypto Tracker

How to Create an Airtable Crypto Tracker

Apr 12, 2022

Rosie Threlfall

Cryptocurrency
Import Binance API Data to Airtable

Import Binance API Data to Airtable

Mar 23, 2021

Andy Cloke

CryptocurrencyBinance
Import Coinranking API data to Airtable

Import Coinranking API data to Airtable

Mar 11, 2021

Andy Cloke

Cryptocurrency