CoinDesk Indices: Single Tokens, Multi-Assets and Rates
Candlestick data for various CoinDesk indices
@coindesk.indices
Candlestick data for various CoinDesk indices
@coindesk.indices
CREATE TABLE coindesk_spot_price (
"unit" VARCHAR,
"timestamp" BIGINT,
"type" BIGINT,
"market" VARCHAR,
"instrument" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"first_message_timestamp" DOUBLE,
"last_message_timestamp" DOUBLE,
"first_message_value" DOUBLE,
"high_message_value" DOUBLE,
"high_message_timestamp" DOUBLE,
"low_message_value" DOUBLE,
"low_message_timestamp" DOUBLE,
"last_message_value" DOUBLE,
"total_index_updates" BIGINT,
"volume" DOUBLE,
"quote_volume" DOUBLE,
"volume_top_tier" DOUBLE,
"quote_volume_top_tier" DOUBLE,
"volume_direct" DOUBLE,
"quote_volume_direct" DOUBLE,
"volume_top_tier_direct" DOUBLE,
"quote_volume_top_tier_direct" DOUBLE,
"datetime" TIMESTAMP,
"first_message_datetime" TIMESTAMP,
"last_message_datetime" TIMESTAMP,
"high_message_datetime" TIMESTAMP,
"low_message_datetime" TIMESTAMP
);
CREATE TABLE multi_assets_indices (
"unit" VARCHAR,
"timestamp" BIGINT,
"type" BIGINT,
"market" VARCHAR,
"instrument" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"first_message_timestamp" DOUBLE,
"last_message_timestamp" DOUBLE,
"first_message_value" DOUBLE,
"high_message_value" DOUBLE,
"high_message_timestamp" DOUBLE,
"low_message_value" DOUBLE,
"low_message_timestamp" DOUBLE,
"last_message_value" DOUBLE,
"total_index_updates" BIGINT,
"datetime" TIMESTAMP,
"first_message_datetime" TIMESTAMP,
"last_message_datetime" TIMESTAMP,
"high_message_datetime" TIMESTAMP,
"low_message_datetime" TIMESTAMP
);
CREATE TABLE rates (
"unit" VARCHAR,
"timestamp" BIGINT,
"date_time_iso_8601" TIMESTAMP,
"type" BIGINT,
"market" VARCHAR,
"instrument" VARCHAR,
"close" DOUBLE,
"datetime" TIMESTAMP
);
Anyone who has the link will be able to view this.