Post Mortem Event Query of QDS and QH to Study Their Failure Rates

Submitted by mmacieje on
QPS

The following notebook has been prepared to demonstrate the use of the lhcsmapi and pyeDSL in particular to query of PM for QDS and QH events and signals. The goal of the query is to gather information about the failure rates in the QPS hardware for reliability and availability studies.

Table below provides an expected sequence of PM timestamps for QDS boards A and B as well as QH.

Trigger time QPS system Timestamp example
t = 0 QDS Board A 1426251388740000000
t = 0 + 1ms QH 1426251388741000000
t = 0 + 2ms QDS Board B 1426251388742000000

For RB, below we provide a detailed description of the QPS system.

The table below shows the sign of the resistive voltages and inductive voltages (for positive ramp rate) of U1 and U2. U_QS0=-U1-U2.

Circuit Resistive voltage U1 Resistive voltage U2 Inductive voltage U1 Inductive voltage U2
RB.A12 Pos Neg Pos Neg
RB.A23 Neg Pos Neg Pos
RB.A34 Neg Pos Neg Pos
RB.A45 Neg Pos Neg Pos
RB.A56 Pos Neg Pos Neg
RB.A67 Pos Neg Pos Neg
RB.A78 Pos Neg Pos Neg
RB.A81 Neg Pos Neg Pos

The thresholds and evaluation times for the QPS on the RB circuits are given in the following table:

Class System Threshold Evaluation time Signal Comment
DQAMCNMB_PMSTD iQPS, DQQDL 100 mV 10 ms discrimination U_QS0 Old QPS. Detection of quench in one aperture based upon voltage difference between both apertures in same magnet U_QS0 >10 ms above threshold, otherwise discriminator is reset
DQAMCNMB_PMHSU iQPS, nQPS - - - Firing of quench heaters by quench protection. Generation of PM buffers sometimes happens even if there is no heater firing.
DQAMGNSRB (slow sampling rate), DQAMGNSRB_PMREL (fast sampling rate) nQPS, DQQDS 500 mV * >20 ms moving average +1 ms discrimination U_DIODE New QPS. Detection of quench in both apertures based upon comparing voltage across the magnet (bypass diode) from 3 magnets in same half-cell and one reference from adjacent half-cell. 50Hz notch moving average filter (20ms worst case). The signals in the 2 classes are identical, only the sampling rate differs. The data with the slow sampling rate is no longer generated as they can be found in the logging database. The recording of data is usually triggered during a FPA, depending on current in circuit, and always when a symmetric quench occurs. The PM buffers are only sent if the DQAMGNS crate trips (what ever the reason).
DQAMGNSRB nQPS, DQQBS 4 mV >10 s moving average U_RES New QPS. Busbar protection. The signal is not compensated for inductive voltage during ramp.
DQAMGNDRB_EVEN, DQAMGNDRB_ODD iQPS, DQQDC 1 mV, 100 mV 1 s U_HTS, U_RES Old QPS. Leads protection. U_HTS is for the high temperature superconducting leads, and U_RES is for the room temperature leads.
DQAMGNDRB_EVEN, DQAMGNDRB_ODD iQPS, DQQDB +200 V -50 V U_BB1, U_BB2 Old QPS. U_BB1 is the total voltage across the sector. U_BB2 is the voltage across the energy extraction (EE)
DQAMSNRB - - - - Opening of energy extraction (EE) switches during fast power abort (FPA). 2 EE switches per sector. One for "even" points (EE2). One for "odd" points (EE1).

*: It was 800 mV before LS1. After LS1 we changed it to 300 or 400 mV. During the training after LS1 we increased it to 500 mV.

 

0. Useful Imports

In [2]:
    
from datetime import date
import pandas as pd

from lhcsmapi.pyedsl.QueryBuilder import QueryBuilder
from lhcsmapi.metadata.SignalMetadata import SignalMetadata
from lhcsmapi.Time import Time
   
 

1. User Input

In [3]:
    
circuit_type = 'RB'
circuit_name = 'RB.A12' # for QDS and QH, use the first circuit name per circuit type (see Useful Functions below)
year = 2016
verbose = False #True to print out events after each query, False to remove print; printing can block the browser
   
 

2. PM Query Day-By-Day for a Year

In [6]:
    
time_date_start = date(year, 1, 1)
time_date_end = date(year+1, 1, 1)

source_timestamp_qds_dfs = []
source_timestamp_qh_dfs = []

for single_date in Time.daterange(time_date_start, time_date_end):
    
    day_of_query = '{} 00:00:00.00'.format(single_date)
    print('Querying day: {}'.format(day_of_query))
    
    # QDS
    source_timestamp_qds_df = QueryBuilder().with_pm() \
        .with_duration(t_start=day_of_query, duration=[(24*60*60, 's')]) \
        .with_circuit_type('RB') \
        .with_metadata(circuit_name='RB.A45', system='QDS', source='*') \
        .event_query() \
        .df
    
    if not source_timestamp_qds_df.empty:
        source_timestamp_qds_df['day'] = day_of_query
        source_timestamp_qds_df['timestamp_string'] = source_timestamp_qds_df.apply(lambda col: Time.to_string(col['timestamp']), axis=1)
        source_timestamp_qds_dfs.append(source_timestamp_qds_df)
        
        if verbose:
            print(source_timestamp_qds_df.sort_values(by='source').reset_index(drop=True))
            
    # QH
    source_timestamp_qh_df = QueryBuilder().with_pm() \
        .with_duration(t_start=day_of_query, duration=[(24*60*60, 's')]) \
        .with_circuit_type('RB') \
        .with_metadata(circuit_name='RB.A45', system='QH', source='*') \
        .event_query() \
        .df
    
    if not source_timestamp_qh_df.empty:
        source_timestamp_qh_df['day'] = day_of_query
        source_timestamp_qh_df['timestamp_string'] = source_timestamp_qh_df.apply(lambda col: Time.to_string(col['timestamp']), axis=1)
        source_timestamp_qh_dfs.append(source_timestamp_qh_df)
        
        if verbose:
            print(source_timestamp_qh_df.sort_values(by='source').reset_index(drop=True))
        
    print('\tQueried day {} and got {} QDS events, and {} QH events.'.format(day_of_query, len(source_timestamp_qds_df), len(source_timestamp_qh_df)))
   
   
 
Querying day: 2016-01-01 00:00:00.00
    Queried day 2016-01-01 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-02 00:00:00.00
    Queried day 2016-01-02 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-03 00:00:00.00
    Queried day 2016-01-03 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-04 00:00:00.00
    Queried day 2016-01-04 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-05 00:00:00.00
    Queried day 2016-01-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-06 00:00:00.00
    Queried day 2016-01-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-07 00:00:00.00
    Queried day 2016-01-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-08 00:00:00.00
    Queried day 2016-01-08 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-09 00:00:00.00
    Queried day 2016-01-09 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-10 00:00:00.00
    Queried day 2016-01-10 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-11 00:00:00.00
    Queried day 2016-01-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-12 00:00:00.00
    Queried day 2016-01-12 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-13 00:00:00.00
    Queried day 2016-01-13 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-14 00:00:00.00
    Queried day 2016-01-14 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-15 00:00:00.00
    Queried day 2016-01-15 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-16 00:00:00.00
    Queried day 2016-01-16 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-17 00:00:00.00
    Queried day 2016-01-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-18 00:00:00.00
    Queried day 2016-01-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-19 00:00:00.00
    Queried day 2016-01-19 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-20 00:00:00.00
    Queried day 2016-01-20 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-21 00:00:00.00
    Queried day 2016-01-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-22 00:00:00.00
    Queried day 2016-01-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-23 00:00:00.00
    Queried day 2016-01-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-24 00:00:00.00
    Queried day 2016-01-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-25 00:00:00.00
    Queried day 2016-01-25 00:00:00.00 and got 3 QDS events, and 1 QH events.
Querying day: 2016-01-26 00:00:00.00
    Queried day 2016-01-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-27 00:00:00.00
    Queried day 2016-01-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-28 00:00:00.00
    Queried day 2016-01-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-29 00:00:00.00
    Queried day 2016-01-29 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-30 00:00:00.00
    Queried day 2016-01-30 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-01-31 00:00:00.00
    Queried day 2016-01-31 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-01 00:00:00.00
    Queried day 2016-02-01 00:00:00.00 and got 4 QDS events, and 0 QH events.
Querying day: 2016-02-02 00:00:00.00
    Queried day 2016-02-02 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-03 00:00:00.00
    Queried day 2016-02-03 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-04 00:00:00.00
    Queried day 2016-02-04 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-05 00:00:00.00
    Queried day 2016-02-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-06 00:00:00.00
    Queried day 2016-02-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-07 00:00:00.00
    Queried day 2016-02-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-08 00:00:00.00
    Queried day 2016-02-08 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-09 00:00:00.00
    Queried day 2016-02-09 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-10 00:00:00.00
    Queried day 2016-02-10 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-02-11 00:00:00.00
    Queried day 2016-02-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-12 00:00:00.00
    Queried day 2016-02-12 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-13 00:00:00.00
    Queried day 2016-02-13 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-14 00:00:00.00
    Queried day 2016-02-14 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-15 00:00:00.00
    Queried day 2016-02-15 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-16 00:00:00.00
    Queried day 2016-02-16 00:00:00.00 and got 1 QDS events, and 1 QH events.
Querying day: 2016-02-17 00:00:00.00
    Queried day 2016-02-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-18 00:00:00.00
    Queried day 2016-02-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-19 00:00:00.00
    Queried day 2016-02-19 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-20 00:00:00.00
    Queried day 2016-02-20 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-21 00:00:00.00
    Queried day 2016-02-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-22 00:00:00.00
    Queried day 2016-02-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-23 00:00:00.00
    Queried day 2016-02-23 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-02-24 00:00:00.00
    Queried day 2016-02-24 00:00:00.00 and got 14 QDS events, and 7 QH events.
Querying day: 2016-02-25 00:00:00.00
    Queried day 2016-02-25 00:00:00.00 and got 18 QDS events, and 9 QH events.
Querying day: 2016-02-26 00:00:00.00
    Queried day 2016-02-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-27 00:00:00.00
    Queried day 2016-02-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-28 00:00:00.00
    Queried day 2016-02-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-02-29 00:00:00.00
    Queried day 2016-02-29 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-03-01 00:00:00.00
    Queried day 2016-03-01 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-03-02 00:00:00.00
    Queried day 2016-03-02 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-03 00:00:00.00
    Queried day 2016-03-03 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-03-04 00:00:00.00
    Queried day 2016-03-04 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-03-05 00:00:00.00
    Queried day 2016-03-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-06 00:00:00.00
    Queried day 2016-03-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-07 00:00:00.00
    Queried day 2016-03-07 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-03-08 00:00:00.00
    Queried day 2016-03-08 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-03-09 00:00:00.00
    Queried day 2016-03-09 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-10 00:00:00.00
    Queried day 2016-03-10 00:00:00.00 and got 11 QDS events, and 3 QH events.
Querying day: 2016-03-11 00:00:00.00
    Queried day 2016-03-11 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-03-12 00:00:00.00
    Queried day 2016-03-12 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-03-13 00:00:00.00
    Queried day 2016-03-13 00:00:00.00 and got 14 QDS events, and 7 QH events.
Querying day: 2016-03-14 00:00:00.00
    Queried day 2016-03-14 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-15 00:00:00.00
    Queried day 2016-03-15 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-16 00:00:00.00
    Queried day 2016-03-16 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-17 00:00:00.00
    Queried day 2016-03-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-18 00:00:00.00
    Queried day 2016-03-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-19 00:00:00.00
    Queried day 2016-03-19 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-03-20 00:00:00.00
    Queried day 2016-03-20 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-21 00:00:00.00
    Queried day 2016-03-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-22 00:00:00.00
    Queried day 2016-03-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-23 00:00:00.00
    Queried day 2016-03-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-24 00:00:00.00
    Queried day 2016-03-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-25 00:00:00.00
    Queried day 2016-03-25 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-26 00:00:00.00
    Queried day 2016-03-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-27 00:00:00.00
    Queried day 2016-03-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-28 00:00:00.00
    Queried day 2016-03-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-29 00:00:00.00
    Queried day 2016-03-29 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-03-30 00:00:00.00
    Queried day 2016-03-30 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-03-31 00:00:00.00
    Queried day 2016-03-31 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-01 00:00:00.00
    Queried day 2016-04-01 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-02 00:00:00.00
    Queried day 2016-04-02 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-03 00:00:00.00
    Queried day 2016-04-03 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-04 00:00:00.00
    Queried day 2016-04-04 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-05 00:00:00.00
    Queried day 2016-04-05 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-04-06 00:00:00.00
    Queried day 2016-04-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-07 00:00:00.00
    Queried day 2016-04-07 00:00:00.00 and got 9 QDS events, and 3 QH events.
Querying day: 2016-04-08 00:00:00.00
    Queried day 2016-04-08 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-09 00:00:00.00
    Queried day 2016-04-09 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-10 00:00:00.00
    Queried day 2016-04-10 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-11 00:00:00.00
    Queried day 2016-04-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-12 00:00:00.00
    Queried day 2016-04-12 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-13 00:00:00.00
    Queried day 2016-04-13 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-04-14 00:00:00.00
    Queried day 2016-04-14 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-15 00:00:00.00
    Queried day 2016-04-15 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-16 00:00:00.00
    Queried day 2016-04-16 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-04-17 00:00:00.00
    Queried day 2016-04-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-18 00:00:00.00
    Queried day 2016-04-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-19 00:00:00.00
    Queried day 2016-04-19 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-04-20 00:00:00.00
    Queried day 2016-04-20 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-04-21 00:00:00.00
    Queried day 2016-04-21 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-04-22 00:00:00.00
    Queried day 2016-04-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-23 00:00:00.00
    Queried day 2016-04-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-24 00:00:00.00
    Queried day 2016-04-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-25 00:00:00.00
    Queried day 2016-04-25 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-04-26 00:00:00.00
    Queried day 2016-04-26 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-04-27 00:00:00.00
    Queried day 2016-04-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-28 00:00:00.00
    Queried day 2016-04-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-29 00:00:00.00
    Queried day 2016-04-29 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-04-30 00:00:00.00
    Queried day 2016-04-30 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-01 00:00:00.00
    Queried day 2016-05-01 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-02 00:00:00.00
    Queried day 2016-05-02 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-03 00:00:00.00
    Queried day 2016-05-03 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-04 00:00:00.00
    Queried day 2016-05-04 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-05 00:00:00.00
    Queried day 2016-05-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-06 00:00:00.00
    Queried day 2016-05-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-07 00:00:00.00
    Queried day 2016-05-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-08 00:00:00.00
    Queried day 2016-05-08 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-09 00:00:00.00
    Queried day 2016-05-09 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-05-10 00:00:00.00
    Queried day 2016-05-10 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-11 00:00:00.00
    Queried day 2016-05-11 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-12 00:00:00.00
    Queried day 2016-05-12 00:00:00.00 and got 5 QDS events, and 3 QH events.
Querying day: 2016-05-13 00:00:00.00
    Queried day 2016-05-13 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-14 00:00:00.00
    Queried day 2016-05-14 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-05-15 00:00:00.00
    Queried day 2016-05-15 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-05-16 00:00:00.00
    Queried day 2016-05-16 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-17 00:00:00.00
    Queried day 2016-05-17 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-18 00:00:00.00
    Queried day 2016-05-18 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-05-19 00:00:00.00
    Queried day 2016-05-19 00:00:00.00 and got 2 QDS events, and 0 QH events.
Querying day: 2016-05-20 00:00:00.00
    Queried day 2016-05-20 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-21 00:00:00.00
    Queried day 2016-05-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-22 00:00:00.00
    Queried day 2016-05-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-23 00:00:00.00
    Queried day 2016-05-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-24 00:00:00.00
    Queried day 2016-05-24 00:00:00.00 and got 3 QDS events, and 1 QH events.
Querying day: 2016-05-25 00:00:00.00
    Queried day 2016-05-25 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-26 00:00:00.00
    Queried day 2016-05-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-05-27 00:00:00.00
    Queried day 2016-05-27 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-28 00:00:00.00
    Queried day 2016-05-28 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-05-29 00:00:00.00
    Queried day 2016-05-29 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-05-30 00:00:00.00
    Queried day 2016-05-30 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-05-31 00:00:00.00
    Queried day 2016-05-31 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-06-01 00:00:00.00
    Queried day 2016-06-01 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-02 00:00:00.00
    Queried day 2016-06-02 00:00:00.00 and got 15 QDS events, and 6 QH events.
Querying day: 2016-06-03 00:00:00.00
    Queried day 2016-06-03 00:00:00.00 and got 16 QDS events, and 8 QH events.
Querying day: 2016-06-04 00:00:00.00
    Queried day 2016-06-04 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-06-05 00:00:00.00
    Queried day 2016-06-05 00:00:00.00 and got 12 QDS events, and 6 QH events.
Querying day: 2016-06-06 00:00:00.00
    Queried day 2016-06-06 00:00:00.00 and got 34 QDS events, and 17 QH events.
Querying day: 2016-06-07 00:00:00.00
    Queried day 2016-06-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-08 00:00:00.00
    Queried day 2016-06-08 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-06-09 00:00:00.00
    Queried day 2016-06-09 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-06-10 00:00:00.00
    Queried day 2016-06-10 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-11 00:00:00.00
    Queried day 2016-06-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-12 00:00:00.00
    Queried day 2016-06-12 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-13 00:00:00.00
    Queried day 2016-06-13 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-14 00:00:00.00
    Queried day 2016-06-14 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-15 00:00:00.00
    Queried day 2016-06-15 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-16 00:00:00.00
    Queried day 2016-06-16 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-17 00:00:00.00
    Queried day 2016-06-17 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-06-18 00:00:00.00
    Queried day 2016-06-18 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-06-19 00:00:00.00
    Queried day 2016-06-19 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-06-20 00:00:00.00
    Queried day 2016-06-20 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-21 00:00:00.00
    Queried day 2016-06-21 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-22 00:00:00.00
    Queried day 2016-06-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-23 00:00:00.00
    Queried day 2016-06-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-24 00:00:00.00
    Queried day 2016-06-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-25 00:00:00.00
    Queried day 2016-06-25 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-26 00:00:00.00
    Queried day 2016-06-26 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-27 00:00:00.00
    Queried day 2016-06-27 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-06-28 00:00:00.00
    Queried day 2016-06-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-06-29 00:00:00.00
    Queried day 2016-06-29 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-06-30 00:00:00.00
    Queried day 2016-06-30 00:00:00.00 and got 13 QDS events, and 6 QH events.
Querying day: 2016-07-01 00:00:00.00
    Queried day 2016-07-01 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-02 00:00:00.00
    Queried day 2016-07-02 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-07-03 00:00:00.00
    Queried day 2016-07-03 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-07-04 00:00:00.00
    Queried day 2016-07-04 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-07-05 00:00:00.00
    Queried day 2016-07-05 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-07-06 00:00:00.00
    Queried day 2016-07-06 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-07-07 00:00:00.00
    Queried day 2016-07-07 00:00:00.00 and got 7 QDS events, and 2 QH events.
Querying day: 2016-07-08 00:00:00.00
    Queried day 2016-07-08 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-07-09 00:00:00.00
    Queried day 2016-07-09 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-07-10 00:00:00.00
    Queried day 2016-07-10 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-07-11 00:00:00.00
    Queried day 2016-07-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-12 00:00:00.00
    Queried day 2016-07-12 00:00:00.00 and got 22 QDS events, and 11 QH events.
Querying day: 2016-07-13 00:00:00.00
    Queried day 2016-07-13 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-07-14 00:00:00.00
    Queried day 2016-07-14 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-07-15 00:00:00.00
    Queried day 2016-07-15 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-07-16 00:00:00.00
    Queried day 2016-07-16 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-07-17 00:00:00.00
    Queried day 2016-07-17 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-07-18 00:00:00.00
    Queried day 2016-07-18 00:00:00.00 and got 12 QDS events, and 6 QH events.
Querying day: 2016-07-19 00:00:00.00
    Queried day 2016-07-19 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-20 00:00:00.00
    Queried day 2016-07-20 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-07-21 00:00:00.00
    Queried day 2016-07-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-22 00:00:00.00
    Queried day 2016-07-22 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-07-23 00:00:00.00
    Queried day 2016-07-23 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-07-24 00:00:00.00
    Queried day 2016-07-24 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-07-25 00:00:00.00
    Queried day 2016-07-25 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-07-26 00:00:00.00
    Queried day 2016-07-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-27 00:00:00.00
    Queried day 2016-07-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-28 00:00:00.00
    Queried day 2016-07-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-29 00:00:00.00
    Queried day 2016-07-29 00:00:00.00 and got 9 QDS events, and 1 QH events.
Querying day: 2016-07-30 00:00:00.00
    Queried day 2016-07-30 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-07-31 00:00:00.00
    Queried day 2016-07-31 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-01 00:00:00.00
    Queried day 2016-08-01 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-02 00:00:00.00
    Queried day 2016-08-02 00:00:00.00 and got 12 QDS events, and 6 QH events.
Querying day: 2016-08-03 00:00:00.00
    Queried day 2016-08-03 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-08-04 00:00:00.00
    Queried day 2016-08-04 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-08-05 00:00:00.00
    Queried day 2016-08-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-06 00:00:00.00
    Queried day 2016-08-06 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-08-07 00:00:00.00
    Queried day 2016-08-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-08 00:00:00.00
    Queried day 2016-08-08 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-08-09 00:00:00.00
    Queried day 2016-08-09 00:00:00.00 and got 14 QDS events, and 8 QH events.
Querying day: 2016-08-10 00:00:00.00
    Queried day 2016-08-10 00:00:00.00 and got 5 QDS events, and 3 QH events.
Querying day: 2016-08-11 00:00:00.00
    Queried day 2016-08-11 00:00:00.00 and got 1703 QDS events, and 852 QH events.
Querying day: 2016-08-12 00:00:00.00
    Queried day 2016-08-12 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-13 00:00:00.00
    Queried day 2016-08-13 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-08-14 00:00:00.00
    Queried day 2016-08-14 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-08-15 00:00:00.00
    Queried day 2016-08-15 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-16 00:00:00.00
    Queried day 2016-08-16 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-08-17 00:00:00.00
    Queried day 2016-08-17 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-08-18 00:00:00.00
    Queried day 2016-08-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-19 00:00:00.00
    Queried day 2016-08-19 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-20 00:00:00.00
    Queried day 2016-08-20 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-21 00:00:00.00
    Queried day 2016-08-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-22 00:00:00.00
    Queried day 2016-08-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-23 00:00:00.00
    Queried day 2016-08-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-24 00:00:00.00
    Queried day 2016-08-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-25 00:00:00.00
    Queried day 2016-08-25 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-26 00:00:00.00
    Queried day 2016-08-26 00:00:00.00 and got 12 QDS events, and 6 QH events.
Querying day: 2016-08-27 00:00:00.00
    Queried day 2016-08-27 00:00:00.00 and got 16 QDS events, and 8 QH events.
Querying day: 2016-08-28 00:00:00.00
    Queried day 2016-08-28 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-08-29 00:00:00.00
    Queried day 2016-08-29 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-08-30 00:00:00.00
    Queried day 2016-08-30 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-08-31 00:00:00.00
    Queried day 2016-08-31 00:00:00.00 and got 10 QDS events, and 5 QH events.
Querying day: 2016-09-01 00:00:00.00
    Queried day 2016-09-01 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-09-02 00:00:00.00
    Queried day 2016-09-02 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-09-03 00:00:00.00
    Queried day 2016-09-03 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-09-04 00:00:00.00
    Queried day 2016-09-04 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-09-05 00:00:00.00
    Queried day 2016-09-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-06 00:00:00.00
    Queried day 2016-09-06 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-09-07 00:00:00.00
    Queried day 2016-09-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-08 00:00:00.00
    Queried day 2016-09-08 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-09-09 00:00:00.00
    Queried day 2016-09-09 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-09-10 00:00:00.00
    Queried day 2016-09-10 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-11 00:00:00.00
    Queried day 2016-09-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-12 00:00:00.00
    Queried day 2016-09-12 00:00:00.00 and got 12 QDS events, and 6 QH events.
Querying day: 2016-09-13 00:00:00.00
    Queried day 2016-09-13 00:00:00.00 and got 19 QDS events, and 10 QH events.
Querying day: 2016-09-14 00:00:00.00
    Queried day 2016-09-14 00:00:00.00 and got 33 QDS events, and 16 QH events.
Querying day: 2016-09-15 00:00:00.00
    Queried day 2016-09-15 00:00:00.00 and got 40 QDS events, and 21 QH events.
Querying day: 2016-09-16 00:00:00.00
    Queried day 2016-09-16 00:00:00.00 and got 7 QDS events, and 4 QH events.
Querying day: 2016-09-17 00:00:00.00
    Queried day 2016-09-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-18 00:00:00.00
    Queried day 2016-09-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-19 00:00:00.00
    Queried day 2016-09-19 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-20 00:00:00.00
    Queried day 2016-09-20 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-21 00:00:00.00
    Queried day 2016-09-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-22 00:00:00.00
    Queried day 2016-09-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-23 00:00:00.00
    Queried day 2016-09-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-24 00:00:00.00
    Queried day 2016-09-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-25 00:00:00.00
    Queried day 2016-09-25 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-26 00:00:00.00
    Queried day 2016-09-26 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-09-27 00:00:00.00
    Queried day 2016-09-27 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-09-28 00:00:00.00
    Queried day 2016-09-28 00:00:00.00 and got 22 QDS events, and 11 QH events.
Querying day: 2016-09-29 00:00:00.00
    Queried day 2016-09-29 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-09-30 00:00:00.00
    Queried day 2016-09-30 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-01 00:00:00.00
    Queried day 2016-10-01 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-10-02 00:00:00.00
    Queried day 2016-10-02 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-10-03 00:00:00.00
    Queried day 2016-10-03 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-04 00:00:00.00
    Queried day 2016-10-04 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-05 00:00:00.00
    Queried day 2016-10-05 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-06 00:00:00.00
    Queried day 2016-10-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-07 00:00:00.00
    Queried day 2016-10-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-08 00:00:00.00
    Queried day 2016-10-08 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-09 00:00:00.00
    Queried day 2016-10-09 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-10 00:00:00.00
    Queried day 2016-10-10 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-10-11 00:00:00.00
    Queried day 2016-10-11 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-10-12 00:00:00.00
    Queried day 2016-10-12 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-10-13 00:00:00.00
    Queried day 2016-10-13 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-14 00:00:00.00
    Queried day 2016-10-14 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-15 00:00:00.00
    Queried day 2016-10-15 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-10-16 00:00:00.00
    Queried day 2016-10-16 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-10-17 00:00:00.00
    Queried day 2016-10-17 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-18 00:00:00.00
    Queried day 2016-10-18 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-10-19 00:00:00.00
    Queried day 2016-10-19 00:00:00.00 and got 8 QDS events, and 3 QH events.
Querying day: 2016-10-20 00:00:00.00
    Queried day 2016-10-20 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-10-21 00:00:00.00
    Queried day 2016-10-21 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-22 00:00:00.00
    Queried day 2016-10-22 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-23 00:00:00.00
    Queried day 2016-10-23 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-10-24 00:00:00.00
    Queried day 2016-10-24 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-10-25 00:00:00.00
    Queried day 2016-10-25 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-26 00:00:00.00
    Queried day 2016-10-26 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-27 00:00:00.00
    Queried day 2016-10-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-28 00:00:00.00
    Queried day 2016-10-28 00:00:00.00 and got 14 QDS events, and 7 QH events.
Querying day: 2016-10-29 00:00:00.00
    Queried day 2016-10-29 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-10-30 00:00:00.00
    Queried day 2016-10-30 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-10-31 00:00:00.00
    Queried day 2016-10-31 00:00:00.00 and got 32 QDS events, and 16 QH events.
Querying day: 2016-11-01 00:00:00.00
    Queried day 2016-11-01 00:00:00.00 and got 42 QDS events, and 21 QH events.
Querying day: 2016-11-02 00:00:00.00
    Queried day 2016-11-02 00:00:00.00 and got 7 QDS events, and 1 QH events.
Querying day: 2016-11-03 00:00:00.00
    Queried day 2016-11-03 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-04 00:00:00.00
    Queried day 2016-11-04 00:00:00.00 and got 22 QDS events, and 11 QH events.
Querying day: 2016-11-05 00:00:00.00
    Queried day 2016-11-05 00:00:00.00 and got 362 QDS events, and 181 QH events.
Querying day: 2016-11-06 00:00:00.00
    Queried day 2016-11-06 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-07 00:00:00.00
    Queried day 2016-11-07 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-08 00:00:00.00
    Queried day 2016-11-08 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-09 00:00:00.00
    Queried day 2016-11-09 00:00:00.00 and got 616 QDS events, and 308 QH events.
Querying day: 2016-11-10 00:00:00.00
    Queried day 2016-11-10 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-11 00:00:00.00
    Queried day 2016-11-11 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-12 00:00:00.00
    Queried day 2016-11-12 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-11-13 00:00:00.00
    Queried day 2016-11-13 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-11-14 00:00:00.00
    Queried day 2016-11-14 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-11-15 00:00:00.00
    Queried day 2016-11-15 00:00:00.00 and got 2 QDS events, and 1 QH events.
Querying day: 2016-11-16 00:00:00.00
    Queried day 2016-11-16 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-17 00:00:00.00
    Queried day 2016-11-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-18 00:00:00.00
    Queried day 2016-11-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-19 00:00:00.00
    Queried day 2016-11-19 00:00:00.00 and got 16 QDS events, and 8 QH events.
Querying day: 2016-11-20 00:00:00.00
    Queried day 2016-11-20 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-11-21 00:00:00.00
    Queried day 2016-11-21 00:00:00.00 and got 8 QDS events, and 4 QH events.
Querying day: 2016-11-22 00:00:00.00
    Queried day 2016-11-22 00:00:00.00 and got 6 QDS events, and 3 QH events.
Querying day: 2016-11-23 00:00:00.00
    Queried day 2016-11-23 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-11-24 00:00:00.00
    Queried day 2016-11-24 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-11-25 00:00:00.00
    Queried day 2016-11-25 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-11-26 00:00:00.00
    Queried day 2016-11-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-11-27 00:00:00.00
    Queried day 2016-11-27 00:00:00.00 and got 14 QDS events, and 7 QH events.
Querying day: 2016-11-28 00:00:00.00
    Queried day 2016-11-28 00:00:00.00 and got 14 QDS events, and 7 QH events.
Querying day: 2016-11-29 00:00:00.00
    Queried day 2016-11-29 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-11-30 00:00:00.00
    Queried day 2016-11-30 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-12-01 00:00:00.00
    Queried day 2016-12-01 00:00:00.00 and got 4 QDS events, and 2 QH events.
Querying day: 2016-12-02 00:00:00.00
    Queried day 2016-12-02 00:00:00.00 and got 20 QDS events, and 11 QH events.
Querying day: 2016-12-03 00:00:00.00
    Queried day 2016-12-03 00:00:00.00 and got 20 QDS events, and 10 QH events.
Querying day: 2016-12-04 00:00:00.00
    Queried day 2016-12-04 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-05 00:00:00.00
    Queried day 2016-12-05 00:00:00.00 and got 640 QDS events, and 320 QH events.
Querying day: 2016-12-06 00:00:00.00
    Queried day 2016-12-06 00:00:00.00 and got 56 QDS events, and 28 QH events.
Querying day: 2016-12-07 00:00:00.00
    Queried day 2016-12-07 00:00:00.00 and got 60 QDS events, and 30 QH events.
Querying day: 2016-12-08 00:00:00.00
    Queried day 2016-12-08 00:00:00.00 and got 64 QDS events, and 32 QH events.
Querying day: 2016-12-09 00:00:00.00
    Queried day 2016-12-09 00:00:00.00 and got 12 QDS events, and 6 QH events.
Querying day: 2016-12-10 00:00:00.00
    Queried day 2016-12-10 00:00:00.00 and got 28 QDS events, and 14 QH events.
Querying day: 2016-12-11 00:00:00.00
    Queried day 2016-12-11 00:00:00.00 and got 30 QDS events, and 15 QH events.
Querying day: 2016-12-12 00:00:00.00
    Queried day 2016-12-12 00:00:00.00 and got 28 QDS events, and 14 QH events.
Querying day: 2016-12-13 00:00:00.00
    Queried day 2016-12-13 00:00:00.00 and got 48 QDS events, and 24 QH events.
Querying day: 2016-12-14 00:00:00.00
    Queried day 2016-12-14 00:00:00.00 and got 16 QDS events, and 8 QH events.
Querying day: 2016-12-15 00:00:00.00
    Queried day 2016-12-15 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-16 00:00:00.00
    Queried day 2016-12-16 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-17 00:00:00.00
    Queried day 2016-12-17 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-18 00:00:00.00
    Queried day 2016-12-18 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-19 00:00:00.00
    Queried day 2016-12-19 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-20 00:00:00.00
    Queried day 2016-12-20 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-21 00:00:00.00
    Queried day 2016-12-21 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-22 00:00:00.00
    Queried day 2016-12-22 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-23 00:00:00.00
    Queried day 2016-12-23 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-24 00:00:00.00
    Queried day 2016-12-24 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-25 00:00:00.00
    Queried day 2016-12-25 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-26 00:00:00.00
    Queried day 2016-12-26 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-27 00:00:00.00
    Queried day 2016-12-27 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-28 00:00:00.00
    Queried day 2016-12-28 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-29 00:00:00.00
    Queried day 2016-12-29 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-30 00:00:00.00
    Queried day 2016-12-30 00:00:00.00 and got 0 QDS events, and 0 QH events.
Querying day: 2016-12-31 00:00:00.00
    Queried day 2016-12-31 00:00:00.00 and got 0 QDS events, and 0 QH events.
 

3. Write Output to *.csv

In [7]:
    
pd.concat(source_timestamp_qds_dfs).reset_index(drop=True).to_csv('QDS_{}_{}_source_timestamp.csv'.format(year, circuit_type))
   
In [8]:
    
pd.concat(source_timestamp_qh_dfs).reset_index(drop=True).to_csv('QH_{}_{}_source_timestamp.csv'.format(year, circuit_type))
   
 

4. Useful Functions

  • Converting time
In [12]:
    
Time.to_string(1426251388740000000), Time.to_string(1426251388741000000), Time.to_string(1426251388742000000)
   
   
Out[12]:
('2015-03-13 13:56:28.740000+01:00',
 '2015-03-13 13:56:28.741000+01:00',
 '2009-12-04 06:52:57.593000+01:00')
 
  • Get circuit types
In [10]:
    
SignalMetadata.get_circuit_types()
   
   
Out[10]:
['RB',
 'RQ',
 'IT',
 'IPD2_B1B2',
 'IPD2',
 'IPQ2',
 'IPQ4',
 'IPQ8',
 '600A',
 '60A',
 '80-120A']
 
  • Get circuit names for a circuit type
In [11]:
    
SignalMetadata.get_circuit_names('RB')
   
   
Out[11]:
['RB.A12',
 'RB.A23',
 'RB.A34',
 'RB.A45',
 'RB.A56',
 'RB.A67',
 'RB.A78',
 'RB.A81']