PREVIEW / futures_1hour / 2017-03-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	2576.85	2577.94	2576.58	2576.58	4535.0
2017-03-08 01:00:00	ES	Futures	2576.85	2578.21	2576.58	2577.94	3507.0
2017-03-08 02:00:00	ES	Futures	2577.67	2578.21	2576.3	2577.67	7703.0
2017-03-08 03:00:00	ES	Futures	2577.67	2580.94	2576.85	2580.94	16897.0
2017-03-08 04:00:00	ES	Futures	2580.67	2582.3	2579.3	2581.21	18257.0
2017-03-08 05:00:00	ES	Futures	2581.21	2583.12	2581.21	2581.76	10591.0
2017-03-08 06:00:00	ES	Futures	2582.03	2582.3	2578.48	2580.12	11165.0
2017-03-08 07:00:00	ES	Futures	2580.39	2583.94	2579.85	2582.58	18835.0
2017-03-08 08:00:00	ES	Futures	2582.3	2584.49	2579.85	2583.94	49335.0
2017-03-08 09:00:00	ES	Futures	2583.94	2589.12	2583.39	2586.67	137676.0
2017-03-08 10:00:00	ES	Futures	2586.67	2588.03	2582.85	2586.94	202274.0
2017-03-08 11:00:00	ES	Futures	2586.94	2588.3	2580.94	2582.85	172113.0
2017-03-08 12:00:00	ES	Futures	2582.85	2585.3	2581.76	2584.49	89564.0
2017-03-08 13:00:00	ES	Futures	2584.49	2587.76	2583.94	2585.85	89280.0
2017-03-08 14:00:00	ES	Futures	2585.85	2586.12	2579.03	2582.85	129112.0
2017-03-08 15:00:00	ES	Futures	2582.58	2583.94	2575.76	2577.67	287224.0
2017-03-08 16:00:00	ES	Futures	2577.67	2579.85	2577.67	2578.48	70992.0
2017-03-08 18:00:00	ES	Futures	2579.03	2580.67	2577.94	2579.85	7248.0
2017-03-08 19:00:00	ES	Futures	2579.85	2581.21	2579.3	2579.85	3274.0
2017-03-08 20:00:00	ES	Futures	2579.85	2581.21	2579.58	2579.85	4710.0
2017-03-08 21:00:00	ES	Futures	2579.85	2580.12	2577.39	2578.48	5178.0
2017-03-08 22:00:00	ES	Futures	2578.21	2579.85	2577.67	2579.03	3534.0
2017-03-08 23:00:00	ES	Futures	2578.76	2579.03	2577.94	2578.48	2003.0
2017-03-08 00:00:00	NQ	Futures	6374.8	6376.59	6372.71	6373.3	847.0
2017-03-08 01:00:00	NQ	Futures	6373.01	6378.08	6373.01	6377.48	1294.0
2017-03-08 02:00:00	NQ	Futures	6376.59	6378.67	6373.9	6375.39	1296.0
2017-03-08 03:00:00	NQ	Futures	6375.39	6382.55	6373.6	6382.25	2897.0
2017-03-08 04:00:00	NQ	Futures	6381.96	6387.33	6378.97	6385.54	3289.0
2017-03-08 05:00:00	NQ	Futures	6385.54	6388.52	6385.24	6386.73	2062.0
2017-03-08 06:00:00	NQ	Futures	6386.73	6387.33	6377.48	6381.06	2165.0
2017-03-08 07:00:00	NQ	Futures	6381.36	6388.52	6380.17	6385.83	2964.0
2017-03-08 08:00:00	NQ	Futures	6385.83	6387.33	6375.99	6385.24	7068.0
2017-03-08 09:00:00	NQ	Futures	6385.24	6406.72	6381.66	6405.82	31568.0
2017-03-08 10:00:00	NQ	Futures	6405.82	6412.68	6396.87	6410.0	32888.0
2017-03-08 11:00:00	NQ	Futures	6410.0	6416.56	6389.71	6396.28	28961.0
2017-03-08 12:00:00	NQ	Futures	6396.57	6404.33	6392.99	6403.44	15075.0
2017-03-08 13:00:00	NQ	Futures	6403.44	6412.38	6401.94	6408.21	15771.0
2017-03-08 14:00:00	NQ	Futures	6408.51	6411.19	6391.2	6399.86	20497.0
2017-03-08 15:00:00	NQ	Futures	6399.86	6403.73	6387.03	6395.38	33654.0
2017-03-08 16:00:00	NQ	Futures	6395.68	6401.65	6395.38	6399.86	4376.0
2017-03-08 18:00:00	NQ	Futures	6398.66	6401.65	6395.68	6400.75	1154.0
2017-03-08 19:00:00	NQ	Futures	6400.75	6403.44	6398.66	6399.56	618.0
2017-03-08 20:00:00	NQ	Futures	6399.56	6402.54	6397.47	6398.96	1221.0
2017-03-08 21:00:00	NQ	Futures	6398.66	6399.26	6393.29	6395.68	1257.0
2017-03-08 22:00:00	NQ	Futures	6395.38	6399.56	6394.19	6397.17	887.0
2017-03-08 23:00:00	NQ	Futures	6396.87	6397.77	6395.08	6396.87	499.0
2017-03-08 00:00:00	YM	Futures	22652.1	22664.0	22646.7	22654.3	2418.0
2017-03-08 01:00:00	YM	Futures	22653.2	22666.2	22648.8	22660.8	1606.0
2017-03-08 02:00:00	YM	Futures	22659.7	22664.0	22651.0	22660.8	1443.0
2017-03-08 03:00:00	YM	Futures	22659.7	22683.5	22654.3	22682.5	3057.0

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

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