Trading Hours & Holidays
========================

Both Trading Hours and historic holidays are recorded in the database ``OQD_MKTCAL``.  
Data is divided between Equity Markets and Futures products given that different futures products on the same venue may have different trading hours.

Equity Market Holiday History
#############################

Equity Market Holidays are retrieved by setting the ``SYMBOL_NAME`` to the required database prefixed with ``CLOUD_DB_``.  The Time range should cover the required history of holiday events,
while the ``ACTIVITY_NAME`` should include ``HOLIDAY``.  The results will include the fields ``TIME_ZONE``, ``START_TIME``, ``END_TIME``, ``START_DATE`` and ``END_DATE``.

.. code-block:: sql
   :caption: Holiday History for LSE

   SELECT * FROM OQD_MKTCAL.MKTCAL
   WHERE SYMBOL_NAME = 'CLOUD_DB_LSE'
   and TIMESTAMP >= '2023-01-03 00:00:00 UTC'
   and TIMESTAMP < '2024-01-04 00:00:00 UTC'
   and ACTIVITY_NAME like '%HOLIDAY%'
   LIMIT 10


.. csv-table:: Holiday History for LSE Results
   :header: Symbol,Timestamp,SYMBOL_NAME,TICK_TYPE,OMDSEQ,START_TIME,END_TIME,DELETED_TIME,TICK_STATUS,CALENDAR_NAME,ACTIVITY_NAME,TIME_ZONE,START_DATE,END_DATE,WEEKDAYS

   OQD_MKTCAL::CLOUD_DB_LSE,2023-04-07 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,621,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-04-07 00:00:00,2023-04-07 00:00:00,32
   OQD_MKTCAL::CLOUD_DB_LSE,2023-04-10 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,249,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-04-10 00:00:00,2023-04-10 00:00:00,2
   OQD_MKTCAL::CLOUD_DB_LSE,2023-05-01 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,388,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-05-01 00:00:00,2023-05-01 00:00:00,2
   OQD_MKTCAL::CLOUD_DB_LSE,2023-05-08 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,34,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-05-08 00:00:00,2023-05-08 00:00:00,2
   OQD_MKTCAL::CLOUD_DB_LSE,2023-05-29 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,243,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-05-29 00:00:00,2023-05-29 00:00:00,2
   OQD_MKTCAL::CLOUD_DB_LSE,2023-08-28 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,24,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-08-28 00:00:00,2023-08-28 00:00:00,2
   OQD_MKTCAL::CLOUD_DB_LSE,2023-12-22 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,37,08:00,12:30,,0,CLOUD_DB_LSE,DAY_HOLIDAY,Europe/London,2023-12-22 00:00:00,2023-12-22 00:00:00,32
   OQD_MKTCAL::CLOUD_DB_LSE,2023-12-25 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,563,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-12-25 00:00:00,2023-12-25 00:00:00,2
   OQD_MKTCAL::CLOUD_DB_LSE,2023-12-26 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,325,00:00,24:00,,0,CLOUD_DB_LSE,ALL_HOLIDAY,Europe/London,2023-12-26 00:00:00,2023-12-26 00:00:00,4
   OQD_MKTCAL::CLOUD_DB_LSE,2023-12-29 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,98,08:00,12:30,,0,CLOUD_DB_LSE,DAY_HOLIDAY,Europe/London,2023-12-29 00:00:00,2023-12-29 00:00:00,32
 


Equity Trading Hour History
###########################

Equity Trading Hours are retrieved by setting the ``SYMBOL_NAME`` to the required database prefixed with ``CLOUD_DB_``.  The Time range should cover the required history of trading hours,
while the ``ACTIVITY_NAME`` should not include ``HOLIDAY``.  The results will include the fields ``TIME_ZONE``, ``START_TIME``, ``END_TIME``, ``START_DATE`` , ``END_DATE`` and ``ACTIVITIY_NAME``.

.. code-block:: sql
   :caption: Trading Hours History for LSE

   SELECT * FROM OQD_MKTCAL.MKTCAL t
   WHERE SYMBOL_NAME = 'CLOUD_DB_LSE'
   and TIMESTAMP >= '1990-01-03 00:00:00 UTC'
   and TIMESTAMP < '2024-01-04 00:00:00 UTC'
   and ACTIVITY_NAME not like '%HOLIDAY%'
   LIMIT 100


.. csv-table:: Trading Hours History for LSE Results
   :header: Symbol,Timestamp,SYMBOL_NAME,TICK_TYPE,OMDSEQ,START_TIME,END_TIME,DELETED_TIME,TICK_STATUS,CALENDAR_NAME,ACTIVITY_NAME,TIME_ZONE,START_DATE,END_DATE,WEEKDAYS

   OQD_MKTCAL::CLOUD_DB_LSE,1993-01-01 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,582,08:00,16:30,,0,CLOUD_DB_LSE,MARKET,Europe/London,1993-01-01 00:00:00,2068-07-19 00:00:00,62
   OQD_MKTCAL::CLOUD_DB_LSE,1993-01-01 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,583,16:30,18:30,,0,CLOUD_DB_LSE,POST_MARKET,Europe/London,1993-01-01 00:00:00,2068-07-19 00:00:00,62
   OQD_MKTCAL::CLOUD_DB_LSE,1993-01-01 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,584,07:00,08:00,,0,CLOUD_DB_LSE,PRE_MARKET,Europe/London,1993-01-01 00:00:00,2068-07-19 00:00:00,62
   OQD_MKTCAL::CLOUD_DB_LSE,1993-01-01 00:00:00,OQD_MKTCAL::CLOUD_DB_LSE,MKTCAL,585,08:00,16:30,,0,CLOUD_DB_LSE,X_MARKET_MTF,Europe/London,1993-01-01 00:00:00,2068-07-19 00:00:00,62



Futures Product Holiday History
###############################

Futures products may have different market holidays within the same exchange.  
Consequently Futures product Holidays are retrieved by setting the ``SYMBOL_NAME`` to the required Futures product prefixed with ``TDI_F_``.  The Time range should cover the required history of holiday events,
while the ``ACTIVITY_NAME`` should include ``HOLIDAY``.  The results will include the fields ``TIME_ZONE``, ``START_TIME``, ``END_TIME``, ``START_DATE`` and ``END_DATE``.

.. code-block:: sql
   :caption: Trading Hours History for CL

   SELECT * FROM OQD_MKTCAL.MKTCAL
   WHERE SYMBOL_NAME = 'TDI_F_CL'
   and TIMESTAMP >= '2023-01-03 00:00:00 UTC'
   and TIMESTAMP < '2024-01-04 00:00:00 UTC'
   and ACTIVITY_NAME like '%HOLIDAY%'
   LIMIT 10


.. csv-table:: Trading Hours History for CL Results
   :header: Symbol,Timestamp,SYMBOL_NAME,TICK_TYPE,OMDSEQ,START_TIME,END_TIME,DELETED_TIME,TICK_STATUS,CALENDAR_NAME,ACTIVITY_NAME,TIME_ZONE,START_DATE,END_DATE,WEEKDAYS

   OQD_MKTCAL::TDI_F_CL,2023-01-16 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,502,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-01-16 00:00:00,2023-01-16 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2023-02-20 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,689,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-02-20 00:00:00,2023-02-20 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2023-04-07 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,"1,896",00:00,24:00,,0,TDI_F_CL,ALL_HOLIDAY,America/New_York,2023-04-07 00:00:00,2023-04-07 00:00:00,32
   OQD_MKTCAL::TDI_F_CL,2023-05-29 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,708,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-05-29 00:00:00,2023-05-29 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2023-06-19 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,494,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-06-19 00:00:00,2023-06-19 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2023-07-04 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,480,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-07-04 00:00:00,2023-07-04 00:00:00,4
   OQD_MKTCAL::TDI_F_CL,2023-09-04 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,649,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-09-04 00:00:00,2023-09-04 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2023-11-23 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,608,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-11-23 00:00:00,2023-11-23 00:00:00,16
   OQD_MKTCAL::TDI_F_CL,2023-11-24 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,540,09:00,13:45,,0,TDI_F_CL,DAY_HOLIDAY,America/New_York,2023-11-24 00:00:00,2023-11-24 00:00:00,32
   OQD_MKTCAL::TDI_F_CL,2023-11-24 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,541,00:00,24:00,,0,TDI_F_CL,NIGHT2_HOLIDAY,America/New_York,2023-11-24 00:00:00,2023-11-24 00:00:00,32

 


Futures Product Trading Hour History
####################################

Futures products may have different trading hours within the same exchange.  
Futures Prodict Trading Hours are retrieved by setting the ``SYMBOL_NAME`` to the required database prefixed with ``TDI_F_CL_``.  The Time range should cover the required history of trading hours,
while the ``ACTIVITY_NAME`` should not include ``HOLIDAY``.  The results will include the fields ``TIME_ZONE``, ``START_TIME``, ``END_TIME``, ``START_DATE`` , ``END_DATE`` and ``ACTIVITIY_NAME``.

.. code-block:: sql
   :caption: Trading Hour History for CL

   SELECT * FROM OQD_MKTCAL.MKTCAL t
   WHERE SYMBOL_NAME = 'TDI_F_CL'
   and TIMESTAMP >= '1990-01-03 00:00:00 UTC'
   and TIMESTAMP < '2024-01-04 00:00:00 UTC'
   and ACTIVITY_NAME not like '%HOLIDAY%'
   LIMIT 100


.. csv-table:: Trading Hours History for CL Results
   :header: Symbol,Timestamp,SYMBOL_NAME,TICK_TYPE,OMDSEQ,START_TIME,END_TIME,DELETED_TIME,TICK_STATUS,CALENDAR_NAME,ACTIVITY_NAME,TIME_ZONE,START_DATE,END_DATE,WEEKDAYS
   
   OQD_MKTCAL::TDI_F_CL,1993-01-06 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,2,09:45,15:40,,0,TDI_F_CL,DAY,America/New_York,1993-01-06 00:00:00,1993-03-12 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,1993-03-13 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,2,09:45,15:15,,0,TDI_F_CL,DAY,America/New_York,1993-03-13 00:00:00,2001-09-10 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2001-09-17 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,20,11:45,14:40,,0,TDI_F_CL,DAY,America/New_York,2001-09-17 00:00:00,2001-09-17 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2001-09-18 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,8,09:45,13:45,,0,TDI_F_CL,DAY,America/New_York,2001-09-18 00:00:00,2001-09-19 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2001-09-20 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,43,10:45,13:50,,0,TDI_F_CL,DAY,America/New_York,2001-09-20 00:00:00,2001-09-28 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2001-10-01 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,10,10:00,14:00,,0,TDI_F_CL,DAY,America/New_York,2001-10-01 00:00:00,2001-10-05 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2001-10-06 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,33,10:00,14:30,,0,TDI_F_CL,DAY,America/New_York,2001-10-06 00:00:00,2006-06-10 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2001-10-06 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,34,15:15,09:30,,0,TDI_F_CL,NIGHT1,America/New_York,2001-10-06 00:00:00,2006-06-10 00:00:00,60
   OQD_MKTCAL::TDI_F_CL,2001-10-06 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,35,19:00,09:30,,0,TDI_F_CL,NIGHT1,America/New_York,2001-10-06 00:00:00,2006-06-10 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2006-06-11 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,45,10:00,14:30,,0,TDI_F_CL,DAY,America/New_York,2006-06-11 00:00:00,2007-01-31 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2006-06-11 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,46,18:00,10:00,,0,TDI_F_CL,NIGHT1,America/New_York,2006-06-11 00:00:00,2007-01-31 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2006-06-11 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,47,14:30,17:15,,0,TDI_F_CL,NIGHT2,America/New_York,2006-06-11 00:00:00,2007-01-31 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2007-02-01 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,33,09:00,14:30,,0,TDI_F_CL,DAY,America/New_York,2007-02-01 00:00:00,2050-12-31 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2007-02-01 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,34,18:00,09:00,,0,TDI_F_CL,NIGHT1,America/New_York,2007-02-01 00:00:00,2008-09-14 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2007-02-01 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,35,14:30,17:15,,0,TDI_F_CL,NIGHT2,America/New_York,2007-02-01 00:00:00,2015-09-18 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2008-09-15 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,196,10:00,09:00,,0,TDI_F_CL,NIGHT1,America/New_York,2008-09-15 00:00:00,2008-09-15 00:00:00,2
   OQD_MKTCAL::TDI_F_CL,2008-09-16 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,27,18:00,09:00,,0,TDI_F_CL,NIGHT1,America/New_York,2008-09-16 00:00:00,2068-07-19 00:00:00,62
   OQD_MKTCAL::TDI_F_CL,2015-09-21 00:00:00,OQD_MKTCAL::TDI_F_CL,MKTCAL,196,14:30,17:00,,0,TDI_F_CL,NIGHT2,America/New_York,2015-09-21 00:00:00,2068-07-19 00:00:00,62