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.

.. code-block:: sql
   :caption: 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``

.. code-block:: sql
   :caption: 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``

.. code-block:: sql
   :caption: 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``

.. code-block:: sql
   :caption: 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``

.. code-block:: sql
   :caption: 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``

.. code-block:: sql
   :caption: 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