PREVIEW / futures_1hour / 2017-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-07.parquet
  size:    47 KB
  rows:    1,359

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-04-07 00:00:00	ES	Futures	2564.54	2566.45	2563.45	2564.81	8817.0
2017-04-07 01:00:00	ES	Futures	2565.09	2566.72	2562.08	2563.99	13565.0
2017-04-07 02:00:00	ES	Futures	2563.99	2566.72	2563.72	2565.36	13471.0
2017-04-07 03:00:00	ES	Futures	2565.36	2570.55	2563.72	2569.46	24830.0
2017-04-07 04:00:00	ES	Futures	2569.46	2569.73	2567.0	2568.36	15201.0
2017-04-07 05:00:00	ES	Futures	2568.09	2569.18	2564.81	2567.0	17963.0
2017-04-07 06:00:00	ES	Futures	2567.0	2572.19	2566.45	2570.28	17490.0
2017-04-07 07:00:00	ES	Futures	2570.55	2573.83	2570.28	2570.82	18204.0
2017-04-07 08:00:00	ES	Futures	2570.82	2571.37	2562.63	2567.54	82420.0
2017-04-07 09:00:00	ES	Futures	2567.27	2576.01	2564.54	2565.09	229925.0
2017-04-07 10:00:00	ES	Futures	2565.09	2574.37	2564.27	2570.28	166326.0
2017-04-07 11:00:00	ES	Futures	2570.55	2572.19	2567.27	2571.37	120325.0
2017-04-07 12:00:00	ES	Futures	2571.09	2574.65	2571.09	2574.1	69415.0
2017-04-07 13:00:00	ES	Futures	2573.83	2579.29	2571.91	2575.74	130301.0
2017-04-07 14:00:00	ES	Futures	2576.01	2578.2	2573.01	2573.01	99411.0
2017-04-07 15:00:00	ES	Futures	2573.01	2575.19	2569.18	2570.28	216777.0
2017-04-07 16:00:00	ES	Futures	2570.28	2571.37	2569.46	2570.82	59382.0
2017-04-07 00:00:00	NQ	Futures	6451.46	6457.12	6449.37	6452.35	1809.0
2017-04-07 01:00:00	NQ	Futures	6452.35	6456.52	6446.39	6448.18	2686.0
2017-04-07 02:00:00	NQ	Futures	6447.88	6455.93	6447.88	6450.86	2319.0
2017-04-07 03:00:00	NQ	Futures	6450.86	6465.17	6447.28	6461.59	4132.0
2017-04-07 04:00:00	NQ	Futures	6461.59	6462.49	6455.03	6458.31	2429.0
2017-04-07 05:00:00	NQ	Futures	6458.31	6461.0	6452.05	6456.52	2902.0
2017-04-07 06:00:00	NQ	Futures	6456.23	6468.45	6455.33	6464.57	2861.0
2017-04-07 07:00:00	NQ	Futures	6464.57	6472.92	6464.57	6465.77	2993.0
2017-04-07 08:00:00	NQ	Futures	6465.77	6466.36	6446.39	6459.21	15362.0
2017-04-07 09:00:00	NQ	Futures	6459.21	6477.39	6441.32	6444.3	44460.0
2017-04-07 10:00:00	NQ	Futures	6444.0	6470.54	6439.83	6459.8	35320.0
2017-04-07 11:00:00	NQ	Futures	6459.8	6465.77	6451.75	6462.49	23606.0
2017-04-07 12:00:00	NQ	Futures	6462.19	6475.01	6461.89	6473.82	11564.0
2017-04-07 13:00:00	NQ	Futures	6473.82	6482.76	6468.75	6474.41	18275.0
2017-04-07 14:00:00	NQ	Futures	6474.11	6480.67	6470.83	6471.43	14510.0
2017-04-07 15:00:00	NQ	Futures	6471.13	6475.9	6462.49	6462.79	21287.0
2017-04-07 16:00:00	NQ	Futures	6462.79	6466.96	6462.19	6464.57	3744.0
2017-04-07 00:00:00	YM	Futures	22334.6	22353.1	22328.1	22339.0	1778.0
2017-04-07 01:00:00	YM	Futures	22339.0	22356.4	22318.3	22330.3	3951.0
2017-04-07 02:00:00	YM	Futures	22332.5	22358.6	22329.2	22347.7	1927.0
2017-04-07 03:00:00	YM	Futures	22346.6	22391.2	22333.6	22382.5	3906.0
2017-04-07 04:00:00	YM	Futures	22382.5	22383.6	22362.9	22369.4	2154.0
2017-04-07 05:00:00	YM	Futures	22369.4	22377.0	22343.3	22360.7	2662.0
2017-04-07 06:00:00	YM	Futures	22359.6	22402.0	22355.3	22386.8	2798.0
2017-04-07 07:00:00	YM	Futures	22387.9	22414.0	22385.7	22393.3	2671.0
2017-04-07 08:00:00	YM	Futures	22393.3	22395.5	22314.0	22350.9	13286.0
2017-04-07 09:00:00	YM	Futures	22350.9	22425.9	22336.8	22343.3	27384.0
2017-04-07 10:00:00	YM	Futures	22342.3	22411.8	22332.5	22380.3	18274.0
2017-04-07 11:00:00	YM	Futures	22381.4	22402.0	22358.6	22394.4	11773.0
2017-04-07 12:00:00	YM	Futures	22393.3	22417.2	22392.2	22414.0	8217.0
2017-04-07 13:00:00	YM	Futures	22412.9	22462.9	22399.9	22441.2	12121.0
2017-04-07 14:00:00	YM	Futures	22440.1	22461.8	22405.3	22407.5	10127.0
2017-04-07 15:00:00	YM	Futures	22407.5	22425.9	22381.4	22389.0	12129.0

> showing 50 of 1,359 rows — these rows as CSV

> unlock the full archive -- $79 one-time