Retrieval with Symbology#

A series of simple examples are provided showing how to retrieve data with a specified symbology.

Standard Retrieval#

Data is generally retrieved by specifying

  • Database & Table (separated by a period. e.g. LSE_SAMPLE.TRD).

  • Symbol or Symbols using the field SYMBOL_NAME

  • Time Range using field TIMESTAMP

  • Limiting the volume of returned records with LIMIT

Where the Symbol typically represents the exchange ticker symbol for the instrument. e.g. AAPL for Apple Inc.

Retrieve with Exchange Symbol#
SELECT * FROM US_COMP_SAMPLE.TRD
WHERE SYMBOL_NAME='AAPL'
and TIMESTAMP >= '2024-01-03 00:00:00 UTC'
and TIMESTAMP < '2024-01-04 00:00:00 UTC'
LIMIT 10

Bloomberg Symbol Retrieval#

Symbols can be retrieved by Bloomberg Symbol with:

  • Prefixing the Database name with BSYM::

  • Specifying the SYMBOL_NAME as the full Bloomberg Symbol

  • Specifying the Date when the symbol is active (as symbols can change across time), using SYMBOL_DATE

Retrieve with Bloomberg Symbol#
SELECT * FROM BSYM::US_COMP_SAMPLE.TRD
WHERE SYMBOL_NAME='AAPL US Equity'
and TIMESTAMP >= '2024-01-03 00:00:00 UTC'
and TIMESTAMP < '2024-01-04 00:00:00 UTC'
and SYMBOL_DATE = 20240104
LIMIT 10

FIGI Composite Symbol Retrieval#

Symbols can be retrieved by FGI Composite with:

  • Prefixing the Database name with FGC::

  • Specifying the SYMBOL_NAME as the FIGI Symbol

  • Specifying the Date when the symbol is active (as symbols can change across time), using SYMBOL_DATE

Retrieve with FIGI Composite Symbol#
SELECT * FROM FGC::US_COMP_SAMPLE.TRD
WHERE SYMBOL_NAME='BBG000B9XRY4'
and TIMESTAMP >= '2024-01-03 00:00:00 UTC'
and TIMESTAMP < '2024-01-04 00:00:00 UTC'
and SYMBOL_DATE = 20240104
LIMIT 10

CUSIP Symbol Retrieval#

Symbols can be retrieved by CUSIP with:

  • Prefixing the Database name with CUS::

  • Specifying the SYMBOL_NAME as the CUSIP

  • Specifying the Date when the symbol is active (as symbols can change across time), using SYMBOL_DATE

Retrieve with CUSIP#
SELECT * FROM CUS::US_COMP_SAMPLE.TRD
WHERE SYMBOL_NAME='037833100'
and TIMESTAMP >= '2024-01-03 00:00:00 UTC'
and TIMESTAMP < '2024-01-04 00:00:00 UTC'
and SYMBOL_DATE = 20240104
LIMIT 10

ISIN Symbol Retrieval#

Symbols can be retrieved by ISIN with:

  • Prefixing the Database name with ISN::

  • Specifying the SYMBOL_NAME as the ISIN

  • Specifying the Date when the symbol is active (as symbols can change across time), using SYMBOL_DATE

Retrieve with ISIN#
SELECT * FROM ISN::LSE_SAMPLE.TRD
WHERE SYMBOL_NAME='GB00BH4HKS39'
and TIMESTAMP >= '2024-01-03 00:00:00 UTC'
and TIMESTAMP < '2024-01-04 00:00:00 UTC'
and SYMBOL_DATE = 20240104
LIMIT 10

SEDOL Symbol Retrieval#

Symbols can be retrieved by SEDOL with:

  • Prefixing the Database name with SED::

  • Specifying the SYMBOL_NAME as the SEDOL

  • Specifying the Date when the symbol is active (as symbols can change across time), using SYMBOL_DATE

Retrieve with SEDOL#
SELECT * FROM SED::LSE_SAMPLE.TRD
WHERE SYMBOL_NAME='BH4HKS3'
and TIMESTAMP >= '2024-01-03 00:00:00 UTC'
and TIMESTAMP < '2024-01-04 00:00:00 UTC'
and SYMBOL_DATE = 20240104
LIMIT 10