Windsor brings all your CoinMarketCap data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
CoinMarketCap Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| categories__avg_price_change | NUMERIC | categories.avg_price_change | categories.avg_price_change | categories |
| categories__description | TEXT | categories.description | categories.description | categories |
| categories__id | TEXT | categories.id | categories.id | categories |
| categories__last_updated | TEXT | categories.last_updated | categories.last_updated | categories |
| categories__market_cap | NUMERIC | categories.market_cap | categories.market_cap | categories |
| categories__market_cap_change | NUMERIC | categories.market_cap_change | categories.market_cap_change | categories |
| categories__name | TEXT | categories.name | categories.name | categories |
| categories__num_tokens | NUMERIC | categories.num_tokens | categories.num_tokens | categories |
| categories__title | TEXT | categories.title | categories.title | categories |
| categories__volume | NUMERIC | categories.volume | categories.volume | categories |
| categories__volume_change | NUMERIC | categories.volume_change | categories.volume_change | categories |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| exchange__first_historical_data | TEXT | exchange.first_historical_data | exchange.first_historical_data | exchange |
| exchange__id | NUMERIC | exchange.id | exchange.id | exchange |
| exchange__is_active | NUMERIC | exchange.is_active | exchange.is_active | exchange |
| exchange__last_historical_data | TEXT | exchange.last_historical_data | exchange.last_historical_data | exchange |
| exchange__name | TEXT | exchange.name | exchange.name | exchange |
| exchange__slug | TEXT | exchange.slug | exchange.slug | exchange |
| fiat__id | NUMERIC | fiat.id | fiat.id | fiat |
| fiat__name | TEXT | fiat.name | fiat.name | fiat |
| fiat__sign | TEXT | fiat.sign | fiat.sign | fiat |
| fiat__symbol | TEXT | fiat.symbol | fiat.symbol | fiat |
| listing__circulating_supply | NUMERIC | listing.circulating_supply | listing.circulating_supply | listing |
| listing__cmc_rank | NUMERIC | listing.cmc_rank | listing.cmc_rank | listing |
| listing__date_added | TEXT | listing.date_added | listing.date_added | listing |
| listing__id | NUMERIC | listing.id | listing.id | listing |
| listing__last_updated | TEXT | listing.last_updated | listing.last_updated | listing |
| listing__max_supply | NUMERIC | listing.max_supply | listing.max_supply | listing |
| listing__name | TEXT | listing.name | listing.name | listing |
| listing__num_market_pairs | NUMERIC | listing.num_market_pairs | listing.num_market_pairs | listing |
| listing__platform | OBJECT | listing.platform | listing.platform | listing |
| listing__quote | OBJECT | listing.quote | listing.quote | listing |
| listing__self_reported_circulating_supply | NUMERIC | listing.self_reported_circulating_supply | listing.self_reported_circulating_supply | listing |
| listing__self_reported_market_cap | NUMERIC | listing.self_reported_market_cap | listing.self_reported_market_cap | listing |
| listing__slug | TEXT | listing.slug | listing.slug | listing |
| listing__symbol | TEXT | listing.symbol | listing.symbol | listing |
| listing__tags | OBJECT | listing.tags | listing.tags | listing |
| listing__total_supply | NUMERIC | listing.total_supply | listing.total_supply | listing |
| listing__tvl_ratio | NUMERIC | listing.tvl_ratio | listing.tvl_ratio | listing |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |