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']
- Log in to post comments