CoinMarketCap Connector Reference

The CoinMarketCap connector exposes 43 fields (18 metrics, 25 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

CoinMarketCap Fields

CoinMarketCap categories fields

The categories report of the CoinMarketCap connector includes 11 fields.

ID	Type	Name	Description
categories__avg_price_change	NUMERIC	categories.avg_price_change	categories.avg_price_change
categories__description	TEXT	categories.description	categories.description
categories__id	TEXT	categories.id	categories.id
categories__last_updated	TEXT	categories.last_updated	categories.last_updated
categories__market_cap	NUMERIC	categories.market_cap	categories.market_cap
categories__market_cap_change	NUMERIC	categories.market_cap_change	categories.market_cap_change
categories__name	TEXT	categories.name	categories.name
categories__num_tokens	NUMERIC	categories.num_tokens	categories.num_tokens
categories__title	TEXT	categories.title	categories.title
categories__volume	NUMERIC	categories.volume	categories.volume
categories__volume_change	NUMERIC	categories.volume_change	categories.volume_change

CoinMarketCap exchange fields

The exchange report of the CoinMarketCap connector includes 6 fields.

ID	Type	Name	Description
exchange__first_historical_data	TEXT	exchange.first_historical_data	exchange.first_historical_data
exchange__id	NUMERIC	exchange.id	exchange.id
exchange__is_active	NUMERIC	exchange.is_active	exchange.is_active
exchange__last_historical_data	TEXT	exchange.last_historical_data	exchange.last_historical_data
exchange__name	TEXT	exchange.name	exchange.name
exchange__slug	TEXT	exchange.slug	exchange.slug

CoinMarketCap fiat fields

The fiat report of the CoinMarketCap connector includes 4 fields.

ID	Type	Name	Description
fiat__id	NUMERIC	fiat.id	fiat.id
fiat__name	TEXT	fiat.name	fiat.name
fiat__sign	TEXT	fiat.sign	fiat.sign
fiat__symbol	TEXT	fiat.symbol	fiat.symbol

CoinMarketCap listing fields

The listing report of the CoinMarketCap connector includes 17 fields.

ID	Type	Name	Description
listing__circulating_supply	NUMERIC	listing.circulating_supply	listing.circulating_supply
listing__cmc_rank	NUMERIC	listing.cmc_rank	listing.cmc_rank
listing__date_added	TEXT	listing.date_added	listing.date_added
listing__id	NUMERIC	listing.id	listing.id
listing__last_updated	TEXT	listing.last_updated	listing.last_updated
listing__max_supply	NUMERIC	listing.max_supply	listing.max_supply
listing__name	TEXT	listing.name	listing.name
listing__num_market_pairs	NUMERIC	listing.num_market_pairs	listing.num_market_pairs
listing__platform	OBJECT	listing.platform	listing.platform
listing__quote	OBJECT	listing.quote	listing.quote
listing__self_reported_circulating_supply	NUMERIC	listing.self_reported_circulating_supply	listing.self_reported_circulating_supply
listing__self_reported_market_cap	NUMERIC	listing.self_reported_market_cap	listing.self_reported_market_cap
listing__slug	TEXT	listing.slug	listing.slug
listing__symbol	TEXT	listing.symbol	listing.symbol
listing__tags	OBJECT	listing.tags	listing.tags
listing__total_supply	NUMERIC	listing.total_supply	listing.total_supply
listing__tvl_ratio	NUMERIC	listing.tvl_ratio	listing.tvl_ratio

CoinMarketCap other fields

The CoinMarketCap connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date