PREVIEW / futures_1hour / 2017-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-17.parquet
  size:    56 KB
  rows:    1,679

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-05-17 00:00:00	ES	Futures	2603.6	2606.33	2603.33	2604.96	8207.0
2017-05-17 01:00:00	ES	Futures	2605.24	2606.33	2602.51	2604.69	9204.0
2017-05-17 02:00:00	ES	Futures	2604.42	2604.96	2602.78	2603.6	14103.0
2017-05-17 03:00:00	ES	Futures	2603.6	2606.33	2601.96	2604.96	28950.0
2017-05-17 04:00:00	ES	Futures	2605.24	2608.24	2604.42	2605.51	18602.0
2017-05-17 05:00:00	ES	Futures	2605.51	2606.33	2603.6	2605.24	16656.0
2017-05-17 06:00:00	ES	Futures	2604.96	2608.79	2604.96	2608.52	18825.0
2017-05-17 07:00:00	ES	Futures	2608.52	2609.88	2607.7	2608.24	22148.0
2017-05-17 08:00:00	ES	Futures	2607.97	2608.24	2600.59	2600.59	73965.0
2017-05-17 09:00:00	ES	Futures	2600.59	2604.42	2593.49	2594.59	397850.0
2017-05-17 10:00:00	ES	Futures	2594.86	2597.04	2585.84	2586.94	393473.0
2017-05-17 11:00:00	ES	Futures	2586.94	2594.59	2585.3	2594.59	251681.0
2017-05-17 12:00:00	ES	Futures	2594.59	2594.59	2588.58	2593.49	130279.0
2017-05-17 13:00:00	ES	Futures	2593.49	2593.49	2584.48	2585.84	162681.0
2017-05-17 14:00:00	ES	Futures	2585.84	2588.85	2576.01	2580.93	311872.0
2017-05-17 15:00:00	ES	Futures	2581.2	2585.57	2572.73	2574.1	590871.0
2017-05-17 16:00:00	ES	Futures	2573.83	2579.56	2573.28	2574.37	204050.0
2017-05-17 18:00:00	ES	Futures	2573.01	2579.56	2572.73	2579.02	15170.0
2017-05-17 19:00:00	ES	Futures	2579.02	2580.38	2577.65	2579.29	7986.0
2017-05-17 20:00:00	ES	Futures	2579.29	2582.29	2577.1	2577.92	17626.0
2017-05-17 21:00:00	ES	Futures	2578.2	2581.75	2576.56	2581.47	14685.0
2017-05-17 22:00:00	ES	Futures	2581.47	2583.39	2581.47	2582.02	10935.0
2017-05-17 23:00:00	ES	Futures	2582.02	2582.02	2579.84	2581.47	6784.0
2017-05-17 00:00:00	NQ	Futures	6791.04	6798.19	6790.74	6795.51	2022.0
2017-05-17 01:00:00	NQ	Futures	6795.81	6800.88	6791.63	6795.81	2949.0
2017-05-17 02:00:00	NQ	Futures	6795.51	6796.7	6789.84	6793.42	3154.0
2017-05-17 03:00:00	NQ	Futures	6793.42	6802.07	6789.55	6800.88	4939.0
2017-05-17 04:00:00	NQ	Futures	6800.88	6806.54	6799.09	6801.17	3208.0
2017-05-17 05:00:00	NQ	Futures	6801.17	6802.37	6796.11	6799.09	2940.0
2017-05-17 06:00:00	NQ	Futures	6798.79	6806.24	6798.19	6805.35	3412.0
2017-05-17 07:00:00	NQ	Futures	6805.05	6808.03	6801.17	6801.47	2987.0
2017-05-17 08:00:00	NQ	Futures	6801.47	6802.07	6780.9	6781.5	15236.0
2017-05-17 09:00:00	NQ	Futures	6781.5	6788.65	6754.66	6756.45	81476.0
2017-05-17 10:00:00	NQ	Futures	6756.45	6760.03	6709.94	6713.82	81112.0
2017-05-17 11:00:00	NQ	Futures	6714.12	6733.79	6703.09	6733.2	52031.0
2017-05-17 12:00:00	NQ	Futures	6733.2	6733.5	6717.1	6732.01	25754.0
2017-05-17 13:00:00	NQ	Futures	6731.71	6733.5	6705.17	6708.45	29397.0
2017-05-17 14:00:00	NQ	Futures	6708.15	6716.8	6672.97	6686.69	61966.0
2017-05-17 15:00:00	NQ	Futures	6686.99	6696.83	6655.09	6656.87	81522.0
2017-05-17 16:00:00	NQ	Futures	6656.87	6667.91	6648.23	6650.32	18542.0
2017-05-17 18:00:00	NQ	Futures	6649.12	6665.22	6647.04	6664.03	4172.0
2017-05-17 19:00:00	NQ	Futures	6664.33	6668.8	6662.24	6666.12	1989.0
2017-05-17 20:00:00	NQ	Futures	6666.41	6675.36	6661.64	6663.43	4474.0
2017-05-17 21:00:00	NQ	Futures	6663.43	6674.76	6659.86	6674.46	5148.0
2017-05-17 22:00:00	NQ	Futures	6674.46	6680.13	6674.17	6677.15	3772.0
2017-05-17 23:00:00	NQ	Futures	6677.45	6678.04	6673.57	6677.45	1582.0
2017-05-17 00:00:00	YM	Futures	22627.0	22655.2	22625.9	22646.6	1543.0
2017-05-17 01:00:00	YM	Futures	22647.6	22653.1	22630.3	22646.6	1564.0
2017-05-17 02:00:00	YM	Futures	22645.5	22646.6	22630.3	22633.5	2458.0
2017-05-17 03:00:00	YM	Futures	22632.4	22652.0	22620.5	22641.1	4849.0

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

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