PREVIEW / futures_1hour / 2017-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-06.parquet
  size:    52 KB
  rows:    1,640

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-06 00:00:00	ES	Futures	2589.4	2590.21	2589.12	2589.67	3478.0
2017-03-06 01:00:00	ES	Futures	2589.94	2589.94	2588.58	2589.67	5064.0
2017-03-06 02:00:00	ES	Futures	2589.4	2589.94	2588.3	2588.58	6993.0
2017-03-06 03:00:00	ES	Futures	2588.58	2588.85	2584.49	2586.67	29869.0
2017-03-06 04:00:00	ES	Futures	2586.94	2592.12	2586.12	2591.3	23758.0
2017-03-06 05:00:00	ES	Futures	2591.58	2592.12	2589.67	2590.76	16363.0
2017-03-06 06:00:00	ES	Futures	2590.76	2592.67	2590.21	2592.4	14464.0
2017-03-06 07:00:00	ES	Futures	2592.4	2592.4	2590.76	2591.3	12055.0
2017-03-06 08:00:00	ES	Futures	2591.03	2591.85	2588.85	2589.67	23425.0
2017-03-06 09:00:00	ES	Futures	2589.67	2591.03	2584.21	2588.85	205598.0
2017-03-06 10:00:00	ES	Futures	2589.12	2589.67	2582.85	2583.94	219160.0
2017-03-06 11:00:00	ES	Futures	2583.67	2586.4	2582.58	2584.49	112515.0
2017-03-06 12:00:00	ES	Futures	2584.21	2588.85	2583.94	2588.58	98403.0
2017-03-06 13:00:00	ES	Futures	2588.3	2593.21	2588.3	2591.3	120419.0
2017-03-06 14:00:00	ES	Futures	2591.3	2591.85	2590.49	2591.58	62530.0
2017-03-06 15:00:00	ES	Futures	2591.58	2594.85	2590.49	2591.03	228522.0
2017-03-06 16:00:00	ES	Futures	2590.76	2592.12	2586.4	2586.67	83620.0
2017-03-06 18:00:00	ES	Futures	2587.21	2588.3	2586.4	2588.3	6812.0
2017-03-06 19:00:00	ES	Futures	2588.3	2589.67	2588.03	2589.4	5184.0
2017-03-06 20:00:00	ES	Futures	2589.4	2589.67	2588.58	2589.4	2855.0
2017-03-06 21:00:00	ES	Futures	2589.4	2589.94	2588.85	2588.85	2358.0
2017-03-06 22:00:00	ES	Futures	2589.12	2589.4	2588.58	2588.85	2427.0
2017-03-06 23:00:00	ES	Futures	2589.12	2591.3	2588.85	2591.3	4756.0
2017-03-06 00:00:00	NQ	Futures	6392.99	6394.78	6392.1	6392.99	558.0
2017-03-06 01:00:00	NQ	Futures	6392.7	6395.08	6392.1	6394.49	1188.0
2017-03-06 02:00:00	NQ	Futures	6394.19	6394.78	6390.01	6390.61	1684.0
2017-03-06 03:00:00	NQ	Futures	6390.91	6390.91	6379.57	6384.34	4592.0
2017-03-06 04:00:00	NQ	Futures	6384.04	6398.66	6383.45	6398.36	3700.0
2017-03-06 05:00:00	NQ	Futures	6398.36	6400.45	6394.19	6396.87	2665.0
2017-03-06 06:00:00	NQ	Futures	6396.87	6401.05	6395.98	6400.45	1567.0
2017-03-06 07:00:00	NQ	Futures	6400.15	6400.75	6396.28	6396.87	1392.0
2017-03-06 08:00:00	NQ	Futures	6396.87	6398.66	6390.31	6391.5	3013.0
2017-03-06 09:00:00	NQ	Futures	6391.8	6395.08	6378.08	6386.43	26051.0
2017-03-06 10:00:00	NQ	Futures	6386.43	6387.03	6370.92	6375.09	29518.0
2017-03-06 11:00:00	NQ	Futures	6374.8	6382.25	6371.51	6376.88	14147.0
2017-03-06 12:00:00	NQ	Futures	6376.59	6387.33	6375.39	6385.83	10845.0
2017-03-06 13:00:00	NQ	Futures	6385.83	6401.94	6385.24	6397.47	18085.0
2017-03-06 14:00:00	NQ	Futures	6397.47	6401.35	6396.28	6398.66	7222.0
2017-03-06 15:00:00	NQ	Futures	6398.96	6406.72	6394.19	6396.28	21084.0
2017-03-06 16:00:00	NQ	Futures	6396.28	6398.96	6387.33	6387.33	5540.0
2017-03-06 18:00:00	NQ	Futures	6389.71	6393.89	6387.62	6393.89	1042.0
2017-03-06 19:00:00	NQ	Futures	6393.29	6397.77	6392.7	6397.17	994.0
2017-03-06 20:00:00	NQ	Futures	6397.17	6397.47	6395.08	6396.87	823.0
2017-03-06 21:00:00	NQ	Futures	6397.17	6399.26	6395.38	6395.68	510.0
2017-03-06 22:00:00	NQ	Futures	6395.38	6396.87	6394.49	6396.57	429.0
2017-03-06 23:00:00	NQ	Futures	6396.28	6400.45	6395.38	6399.56	718.0
2017-03-06 00:00:00	YM	Futures	22704.2	22715.0	22703.1	22711.7	1144.0
2017-03-06 01:00:00	YM	Futures	22712.8	22716.1	22707.4	22715.0	1309.0
2017-03-06 02:00:00	YM	Futures	22715.0	22717.2	22700.9	22700.9	1224.0
2017-03-06 03:00:00	YM	Futures	22700.9	22702.0	22673.8	22691.1	4218.0

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

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