Skip to main content

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;