PREVIEW / futures_1hour / 2017-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-29.parquet
  size:    53 KB
  rows:    1,633

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-03-29 00:00:00	ES	Futures	2571.64	2572.19	2571.09	2572.19	3081.0
2017-03-29 01:00:00	ES	Futures	2571.91	2572.19	2571.37	2572.19	3737.0
2017-03-29 02:00:00	ES	Futures	2571.91	2573.83	2571.91	2573.01	9541.0
2017-03-29 03:00:00	ES	Futures	2572.73	2574.92	2571.64	2574.1	20130.0
2017-03-29 04:00:00	ES	Futures	2574.1	2574.37	2570.28	2570.82	11412.0
2017-03-29 05:00:00	ES	Futures	2570.55	2570.82	2568.36	2569.73	10421.0
2017-03-29 06:00:00	ES	Futures	2569.73	2569.73	2567.54	2568.91	9761.0
2017-03-29 07:00:00	ES	Futures	2568.91	2570.0	2567.82	2569.18	13722.0
2017-03-29 08:00:00	ES	Futures	2568.91	2571.09	2568.09	2569.46	18607.0
2017-03-29 09:00:00	ES	Futures	2569.46	2572.19	2566.18	2572.19	156856.0
2017-03-29 10:00:00	ES	Futures	2571.91	2577.1	2570.0	2575.74	208099.0
2017-03-29 11:00:00	ES	Futures	2575.47	2576.28	2569.46	2572.73	147704.0
2017-03-29 12:00:00	ES	Futures	2573.01	2574.92	2571.09	2571.64	88530.0
2017-03-29 13:00:00	ES	Futures	2571.64	2576.01	2571.64	2575.74	88035.0
2017-03-29 14:00:00	ES	Futures	2575.47	2577.65	2574.1	2576.56	67823.0
2017-03-29 15:00:00	ES	Futures	2576.83	2578.2	2574.1	2575.74	199866.0
2017-03-29 16:00:00	ES	Futures	2575.74	2576.56	2574.65	2574.92	61360.0
2017-03-29 18:00:00	ES	Futures	2575.19	2576.01	2574.37	2575.74	2905.0
2017-03-29 19:00:00	ES	Futures	2575.74	2576.56	2575.47	2576.28	2308.0
2017-03-29 20:00:00	ES	Futures	2576.01	2581.2	2575.74	2579.29	13199.0
2017-03-29 21:00:00	ES	Futures	2579.29	2580.11	2576.83	2577.65	6074.0
2017-03-29 22:00:00	ES	Futures	2577.65	2577.92	2576.28	2576.56	3934.0
2017-03-29 23:00:00	ES	Futures	2576.56	2577.38	2576.28	2577.1	2390.0
2017-03-29 00:00:00	NQ	Futures	6455.03	6457.42	6454.74	6457.12	774.0
2017-03-29 01:00:00	NQ	Futures	6457.42	6457.42	6455.03	6456.52	442.0
2017-03-29 02:00:00	NQ	Futures	6456.52	6461.29	6455.33	6458.61	1261.0
2017-03-29 03:00:00	NQ	Futures	6458.61	6462.19	6455.63	6460.7	2456.0
2017-03-29 04:00:00	NQ	Futures	6460.7	6461.0	6451.75	6452.95	2581.0
2017-03-29 05:00:00	NQ	Futures	6452.65	6454.14	6446.09	6450.56	1580.0
2017-03-29 06:00:00	NQ	Futures	6449.97	6450.26	6445.79	6449.67	1255.0
2017-03-29 07:00:00	NQ	Futures	6449.97	6451.46	6445.49	6448.47	1971.0
2017-03-29 08:00:00	NQ	Futures	6448.77	6455.93	6446.69	6453.54	3183.0
2017-03-29 09:00:00	NQ	Futures	6453.24	6465.47	6447.58	6465.47	28318.0
2017-03-29 10:00:00	NQ	Futures	6465.47	6473.22	6460.1	6468.45	30020.0
2017-03-29 11:00:00	NQ	Futures	6468.15	6470.24	6454.44	6461.0	22806.0
2017-03-29 12:00:00	NQ	Futures	6460.7	6468.75	6458.31	6461.29	13810.0
2017-03-29 13:00:00	NQ	Futures	6461.29	6473.22	6460.7	6472.62	11342.0
2017-03-29 14:00:00	NQ	Futures	6472.33	6477.39	6467.85	6475.31	9865.0
2017-03-29 15:00:00	NQ	Futures	6475.9	6482.16	6474.41	6480.08	28897.0
2017-03-29 16:00:00	NQ	Futures	6480.08	6484.55	6478.29	6482.76	6223.0
2017-03-29 18:00:00	NQ	Futures	6482.76	6484.55	6480.38	6484.25	899.0
2017-03-29 19:00:00	NQ	Futures	6483.95	6485.44	6482.46	6484.25	676.0
2017-03-29 20:00:00	NQ	Futures	6484.25	6500.65	6483.95	6495.28	3719.0
2017-03-29 21:00:00	NQ	Futures	6495.28	6497.07	6488.72	6490.21	1799.0
2017-03-29 22:00:00	NQ	Futures	6490.51	6492.3	6486.04	6486.93	1093.0
2017-03-29 23:00:00	NQ	Futures	6486.64	6490.21	6486.04	6489.92	707.0
2017-03-29 00:00:00	YM	Futures	22435.7	22439.0	22434.6	22436.8	368.0
2017-03-29 01:00:00	YM	Futures	22436.8	22439.0	22430.3	22435.7	479.0
2017-03-29 02:00:00	YM	Futures	22435.7	22452.0	22434.6	22445.5	1737.0
2017-03-29 03:00:00	YM	Futures	22443.3	22456.4	22434.6	22449.8	2487.0

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

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