❄ Snowflake
Assets Dataset
Access CoinAPI assets data through Snowflake data warehouse
Assets Dataset
Overview
The "ASSETS" dataset provides a comprehensive listing of various assets in the crypto markets. It includes metadata such as asset identifiers, names, date ranges for quotes, trades, orderbook activity, and additional metrics related to trading volume, price, and coverage dates.
This dataset helps users:
- Quickly discover new assets
- Understand available historical date ranges for quotes, trades, and orderbook data
- Evaluate the scope of coverage and key activity metrics
Table Details
Name: LISTINGS.PUBLIC.ASSETS
Schema
CREATE OR REPLACE TABLE LISTINGS.PUBLIC.ASSETS (
ASSET_ID VARCHAR(16777216),
NAME VARCHAR(16777216),
DATA_QUOTE_START TIMESTAMP_NTZ(9),
DATA_QUOTE_END TIMESTAMP_NTZ(9),
DATA_ORDERBOOK_START TIMESTAMP_NTZ(9),
DATA_ORDERBOOK_END TIMESTAMP_NTZ(9),
DATA_TRADE_START TIMESTAMP_NTZ(9),
DATA_TRADE_END TIMESTAMP_NTZ(9),
DATA_SYMBOLS_COUNT NUMBER(38,0),
VOLUME_1HRS_USD NUMBER(38,2),
VOLUME_1DAY_USD VARCHAR(16777216),
VOLUME_1MTH_USD VARCHAR(16777216),
PRICE_USD VARCHAR(16777216),
ID_ICON VARCHAR(16777216),
DATA_START DATE,
DATA_END DATE
);Example Query
SELECT
asset_id,
name,
data_start,
data_end
FROM ASSETS
WHERE data_start IS NOT NULL
AND data_end IS NOT NULL
ORDER BY data_end - data_start DESC
LIMIT 50;