Skip to content
Book a demoStart free
Connectors

CoinGecko connector

Set up the CoinGecko connector in Kaivo: authentication, configuration, the 2 BigQuery tables it syncs, and answers to common questions.

CoinGecko connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your CoinGecko data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

Sync your CoinGecko coin prices and market history into BigQuery with Kaivo to track crypto prices, market cap, and volume over time.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the CoinGecko connector

Section titled “Getting started with the CoinGecko connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your CoinGecko account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
CoinGecko Pro API key. Leave empty to use the free public API.

|

When you set up the connector, you provide:

Field Description
Coin ID
CoinGecko coin ID (e.g. bitcoin).

| | Target Currency |

Target currency for market data (e.g. usd, eur, jpy).

| | Days |

Number of days of market chart data to fetch.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 2 tables from CoinGecko into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

history (242 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
symbol STRING
name STRING
localization__en STRING
localization__de STRING
localization__es STRING
localization__fr STRING
localization__it STRING
localization__pl STRING
localization__ro STRING
localization__hu STRING
localization__nl STRING
localization__pt STRING
localization__sv STRING
localization__vi STRING
localization__tr STRING
localization__ru STRING
localization__ja STRING
localization__zh STRING
localization__zh_tw STRING
localization__ko STRING
localization__ar STRING
localization__th STRING
localization__id STRING
localization__cs STRING
localization__da STRING
localization__el STRING
localization__hi STRING
localization__no STRING
localization__sk STRING
localization__uk STRING
localization__he STRING
localization__fi STRING
localization__bg STRING
localization__hr STRING
localization__lt STRING
localization__sl STRING
image__thumb STRING
image__small STRING
market_data__current_price__aed FLOAT64
market_data__current_price__ars FLOAT64
market_data__current_price__aud FLOAT64
market_data__current_price__bch FLOAT64
market_data__current_price__bdt FLOAT64
market_data__current_price__bhd FLOAT64
market_data__current_price__bmd FLOAT64
market_data__current_price__bnb FLOAT64
market_data__current_price__brl FLOAT64
market_data__current_price__btc FLOAT64
market_data__current_price__cad FLOAT64
market_data__current_price__chf FLOAT64
market_data__current_price__clp FLOAT64
market_data__current_price__cny FLOAT64
market_data__current_price__czk FLOAT64
market_data__current_price__dkk FLOAT64
market_data__current_price__dot FLOAT64
market_data__current_price__eos FLOAT64
market_data__current_price__eth FLOAT64
market_data__current_price__eur FLOAT64
market_data__current_price__gbp FLOAT64
market_data__current_price__hkd FLOAT64
market_data__current_price__huf FLOAT64
market_data__current_price__idr FLOAT64
market_data__current_price__ils FLOAT64
market_data__current_price__inr FLOAT64
market_data__current_price__jpy FLOAT64
market_data__current_price__krw FLOAT64
market_data__current_price__kwd FLOAT64
market_data__current_price__lkr FLOAT64
market_data__current_price__ltc FLOAT64
market_data__current_price__mmk FLOAT64
market_data__current_price__mxn FLOAT64
market_data__current_price__myr FLOAT64
market_data__current_price__ngn FLOAT64
market_data__current_price__nok FLOAT64
market_data__current_price__nzd FLOAT64
market_data__current_price__php FLOAT64
market_data__current_price__pkr FLOAT64
market_data__current_price__pln FLOAT64
market_data__current_price__rub FLOAT64
market_data__current_price__sar FLOAT64
market_data__current_price__sek FLOAT64
market_data__current_price__sgd FLOAT64
market_data__current_price__thb FLOAT64
market_data__current_price__try FLOAT64
market_data__current_price__twd FLOAT64
market_data__current_price__uah FLOAT64
market_data__current_price__usd FLOAT64
market_data__current_price__vef FLOAT64
market_data__current_price__vnd FLOAT64
market_data__current_price__xag FLOAT64
market_data__current_price__xau FLOAT64
market_data__current_price__xdr FLOAT64
market_data__current_price__xlm FLOAT64
market_data__current_price__xrp FLOAT64
market_data__current_price__yfi FLOAT64
market_data__current_price__zar FLOAT64
market_data__current_price__bits FLOAT64
market_data__current_price__link FLOAT64
market_data__current_price__sats FLOAT64
market_data__market_cap__aed FLOAT64
market_data__market_cap__ars FLOAT64
market_data__market_cap__aud FLOAT64
market_data__market_cap__bch FLOAT64
market_data__market_cap__bdt FLOAT64
market_data__market_cap__bhd FLOAT64
market_data__market_cap__bmd FLOAT64
market_data__market_cap__bnb FLOAT64
market_data__market_cap__brl FLOAT64
market_data__market_cap__btc FLOAT64
market_data__market_cap__cad FLOAT64
market_data__market_cap__chf FLOAT64
market_data__market_cap__clp FLOAT64
market_data__market_cap__cny FLOAT64
market_data__market_cap__czk FLOAT64
market_data__market_cap__dkk FLOAT64
market_data__market_cap__dot FLOAT64
market_data__market_cap__eos FLOAT64
market_data__market_cap__eth FLOAT64
market_data__market_cap__eur FLOAT64
market_data__market_cap__gbp FLOAT64
market_data__market_cap__hkd FLOAT64
market_data__market_cap__huf FLOAT64
market_data__market_cap__idr FLOAT64
market_data__market_cap__ils FLOAT64
market_data__market_cap__inr FLOAT64
market_data__market_cap__jpy FLOAT64
market_data__market_cap__krw FLOAT64
market_data__market_cap__kwd FLOAT64
market_data__market_cap__lkr FLOAT64
market_data__market_cap__ltc FLOAT64
market_data__market_cap__mmk FLOAT64
market_data__market_cap__mxn FLOAT64
market_data__market_cap__myr FLOAT64
market_data__market_cap__ngn FLOAT64
market_data__market_cap__nok FLOAT64
market_data__market_cap__nzd FLOAT64
market_data__market_cap__php FLOAT64
market_data__market_cap__pkr FLOAT64
market_data__market_cap__pln FLOAT64
market_data__market_cap__rub FLOAT64
market_data__market_cap__sar FLOAT64
market_data__market_cap__sek FLOAT64
market_data__market_cap__sgd FLOAT64
market_data__market_cap__thb FLOAT64
market_data__market_cap__try FLOAT64
market_data__market_cap__twd FLOAT64
market_data__market_cap__uah FLOAT64
market_data__market_cap__usd FLOAT64
market_data__market_cap__vef FLOAT64
market_data__market_cap__vnd FLOAT64
market_data__market_cap__xag FLOAT64
market_data__market_cap__xau FLOAT64
market_data__market_cap__xdr FLOAT64
market_data__market_cap__xlm FLOAT64
market_data__market_cap__xrp FLOAT64
market_data__market_cap__yfi FLOAT64
market_data__market_cap__zar FLOAT64
market_data__market_cap__bits FLOAT64
market_data__market_cap__link FLOAT64
market_data__market_cap__sats FLOAT64
market_data__total_volume__aed FLOAT64
market_data__total_volume__ars FLOAT64
market_data__total_volume__aud FLOAT64
market_data__total_volume__bch FLOAT64
market_data__total_volume__bdt FLOAT64
market_data__total_volume__bhd FLOAT64
market_data__total_volume__bmd FLOAT64
market_data__total_volume__bnb FLOAT64
market_data__total_volume__brl FLOAT64
market_data__total_volume__btc FLOAT64
market_data__total_volume__cad FLOAT64
market_data__total_volume__chf FLOAT64
market_data__total_volume__clp FLOAT64
market_data__total_volume__cny FLOAT64
market_data__total_volume__czk FLOAT64
market_data__total_volume__dkk FLOAT64
market_data__total_volume__dot FLOAT64
market_data__total_volume__eos FLOAT64
market_data__total_volume__eth FLOAT64
market_data__total_volume__eur FLOAT64
market_data__total_volume__gbp FLOAT64
market_data__total_volume__hkd FLOAT64
market_data__total_volume__huf FLOAT64
market_data__total_volume__idr FLOAT64
market_data__total_volume__ils FLOAT64
market_data__total_volume__inr FLOAT64
market_data__total_volume__jpy FLOAT64
market_data__total_volume__krw FLOAT64
market_data__total_volume__kwd FLOAT64
market_data__total_volume__lkr FLOAT64
market_data__total_volume__ltc FLOAT64
market_data__total_volume__mmk FLOAT64
market_data__total_volume__mxn FLOAT64
market_data__total_volume__myr FLOAT64
market_data__total_volume__ngn FLOAT64
market_data__total_volume__nok FLOAT64
market_data__total_volume__nzd FLOAT64
market_data__total_volume__php FLOAT64
market_data__total_volume__pkr FLOAT64
market_data__total_volume__pln FLOAT64
market_data__total_volume__rub FLOAT64
market_data__total_volume__sar FLOAT64
market_data__total_volume__sek FLOAT64
market_data__total_volume__sgd FLOAT64
market_data__total_volume__thb FLOAT64
market_data__total_volume__try FLOAT64
market_data__total_volume__twd FLOAT64
market_data__total_volume__uah FLOAT64
market_data__total_volume__usd FLOAT64
market_data__total_volume__vef FLOAT64
market_data__total_volume__vnd FLOAT64
market_data__total_volume__xag FLOAT64
market_data__total_volume__xau FLOAT64
market_data__total_volume__xdr FLOAT64
market_data__total_volume__xlm FLOAT64
market_data__total_volume__xrp FLOAT64
market_data__total_volume__yfi FLOAT64
market_data__total_volume__zar FLOAT64
market_data__total_volume__bits FLOAT64
market_data__total_volume__link FLOAT64
market_data__total_volume__sats FLOAT64
community_data__facebook_likes JSON
community_data__twitter_followers JSON
community_data__reddit_average_posts_48h FLOAT64
community_data__reddit_average_comments_48h FLOAT64
community_data__reddit_subscribers FLOAT64
community_data__reddit_accounts_active_48h STRING
developer_data__forks FLOAT64
developer_data__stars FLOAT64
developer_data__subscribers FLOAT64
developer_data__total_issues FLOAT64
developer_data__closed_issues FLOAT64
developer_data__pull_requests_merged FLOAT64
developer_data__pull_request_contributors FLOAT64
developer_data__code_additions_deletions_4_weeks__additions FLOAT64
developer_data__code_additions_deletions_4_weeks__deletions FLOAT64
developer_data__commit_count_4_weeks FLOAT64
public_interest_stats__alexa_rank JSON
public_interest_stats__bing_matches JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
market_chart (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: market_chart__total_volumes__list

Section titled “Subtable: market_chart__total_volumes__list”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where CoinGecko supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for CoinGecko?

Section titled “How long does the initial sync take for CoinGecko?”

It depends on how much history is in your CoinGecko account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when CoinGecko’s schema changes?

Section titled “What happens when CoinGecko’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in CoinGecko, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in CoinGecko instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the CoinGecko connector in Kaivo and all of its synced data is deleted with it.

Use market_chart prices to chart coin prices over your chosen window.

Analyse market_caps and total_volumes to see how coins move in size and liquidity.

Use history to compare market_data for a coin across dates.

Join price history to your holdings to value a portfolio over time.

Use CoinGecko data in your AI and BI tools

Section titled “Use CoinGecko data in your AI and BI tools”

Once CoinGecko data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with CoinGecko data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for CoinGecko connector pricing and plan details.