Coinmarketcap

Tables in the Coinmarketcap connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	fiat	4		Full Refresh		API Reference
2	exchange	6		Full Refresh		API Reference
3	categories	11		Full Refresh		API Reference
4	listing	17		Full Refresh		API Reference
5	quotes	0		Full Refresh		API Reference

Table: fiat

No	Column Name	Type	Notes
1	symbol	VARCHAR
2	name	VARCHAR
3	sign	VARCHAR
4	id	INTEGER

Table: exchange

No	Column Name	Type	Notes
1	is_active	INTEGER
2	last_historical_data	VARCHAR
3	name	VARCHAR
4	id	INTEGER
5	slug	VARCHAR
6	first_historical_data	VARCHAR

Table: categories

No	Column Name	Type	Notes
1	volume	DOUBLE
2	last_updated	VARCHAR
3	market_cap	DOUBLE
4	avg_price_change	DOUBLE
5	num_tokens	INTEGER
6	name	VARCHAR
7	description	VARCHAR
8	id	VARCHAR
9	title	VARCHAR
10	volume_change	DOUBLE
11	market_cap_change	DOUBLE

Table: listing

No	Column Name	Type	Notes
1	symbol	VARCHAR
2	circulating_supply	DOUBLE
3	last_updated	VARCHAR
4	total_supply	DOUBLE
5	tvl_ratio	DOUBLE
6	cmc_rank	INTEGER
7	self_reported_circulating_supply	DOUBLE
8	platform	VARCHAR
9	tags	VARCHAR
10	date_added	VARCHAR
11	quote	VARCHAR
12	num_market_pairs	INTEGER
13	name	VARCHAR
14	max_supply	DOUBLE
15	id	INTEGER
16	self_reported_market_cap	DOUBLE
17	slug	VARCHAR

Table: quotes

| No | Column Name | Type | Notes || --- | ----------- | ---- | ----- |

External Resources

• Coinmarketcap Api
• Here
• Api Token

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.