# 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.

```sql
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`

```sql
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`

```sql
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`

```sql
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`

```sql
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`

```sql
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
```