PREVIEW / futures_1hour / 2016-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-12.parquet
  size:    44 KB
  rows:    1,295

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
2016-08-12 00:00:00	ES	Futures	2365.56	2366.64	2365.29	2366.1	1893.0
2016-08-12 01:00:00	ES	Futures	2366.1	2366.64	2365.29	2365.83	2444.0
2016-08-12 02:00:00	ES	Futures	2366.1	2366.64	2365.29	2366.64	7904.0
2016-08-12 03:00:00	ES	Futures	2366.64	2368.81	2366.37	2367.19	20765.0
2016-08-12 04:00:00	ES	Futures	2367.19	2369.08	2366.64	2368.0	14095.0
2016-08-12 05:00:00	ES	Futures	2368.0	2368.81	2368.0	2368.0	6593.0
2016-08-12 06:00:00	ES	Futures	2368.27	2369.08	2367.73	2368.0	8861.0
2016-08-12 07:00:00	ES	Futures	2368.0	2368.0	2366.92	2367.46	11180.0
2016-08-12 08:00:00	ES	Futures	2367.46	2368.0	2363.39	2364.47	51480.0
2016-08-12 09:00:00	ES	Futures	2364.47	2365.29	2361.22	2363.93	232483.0
2016-08-12 10:00:00	ES	Futures	2364.2	2367.46	2362.85	2366.64	190000.0
2016-08-12 11:00:00	ES	Futures	2366.64	2368.0	2364.2	2365.29	104470.0
2016-08-12 12:00:00	ES	Futures	2365.56	2365.83	2362.58	2363.12	129983.0
2016-08-12 13:00:00	ES	Futures	2363.12	2363.39	2359.86	2361.49	119307.0
2016-08-12 14:00:00	ES	Futures	2361.49	2364.47	2360.95	2363.39	109163.0
2016-08-12 15:00:00	ES	Futures	2363.66	2366.37	2363.12	2364.75	173401.0
2016-08-12 16:00:00	ES	Futures	2364.75	2366.1	2364.75	2366.1	58558.0
2016-08-12 00:00:00	NQ	Futures	5719.61	5724.08	5719.61	5722.89	289.0
2016-08-12 01:00:00	NQ	Futures	5722.59	5723.48	5721.1	5722.59	272.0
2016-08-12 02:00:00	NQ	Futures	5723.19	5724.08	5720.5	5722.59	630.0
2016-08-12 03:00:00	NQ	Futures	5722.89	5728.85	5721.4	5724.38	1798.0
2016-08-12 04:00:00	NQ	Futures	5724.38	5728.85	5722.59	5725.57	1117.0
2016-08-12 05:00:00	NQ	Futures	5725.57	5727.66	5724.38	5724.68	799.0
2016-08-12 06:00:00	NQ	Futures	5725.27	5727.36	5724.08	5724.68	636.0
2016-08-12 07:00:00	NQ	Futures	5724.68	5725.57	5722.29	5724.97	831.0
2016-08-12 08:00:00	NQ	Futures	5724.68	5726.17	5717.82	5720.21	4028.0
2016-08-12 09:00:00	NQ	Futures	5720.21	5721.7	5707.09	5714.84	29577.0
2016-08-12 10:00:00	NQ	Futures	5714.84	5719.91	5709.18	5719.01	21759.0
2016-08-12 11:00:00	NQ	Futures	5719.61	5724.68	5715.14	5718.42	12002.0
2016-08-12 12:00:00	NQ	Futures	5718.42	5720.21	5713.35	5716.93	12405.0
2016-08-12 13:00:00	NQ	Futures	5716.63	5716.93	5708.58	5713.65	10294.0
2016-08-12 14:00:00	NQ	Futures	5713.65	5722.29	5711.86	5721.1	9277.0
2016-08-12 15:00:00	NQ	Futures	5721.1	5727.66	5720.5	5727.06	13703.0
2016-08-12 16:00:00	NQ	Futures	5727.06	5730.64	5725.87	5729.74	4441.0
2016-08-12 00:00:00	YM	Futures	19976.5	19987.3	19976.5	19985.1	366.0
2016-08-12 01:00:00	YM	Futures	19984.1	19985.1	19977.6	19983.0	297.0
2016-08-12 02:00:00	YM	Futures	19983.0	19988.4	19977.6	19985.1	820.0
2016-08-12 03:00:00	YM	Futures	19985.1	20001.3	19981.9	19989.4	2102.0
2016-08-12 04:00:00	YM	Futures	19988.4	20001.3	19981.9	19992.7	1653.0
2016-08-12 05:00:00	YM	Futures	19992.7	19999.1	19991.6	19991.6	658.0
2016-08-12 06:00:00	YM	Futures	19993.7	20000.2	19988.4	19990.5	959.0
2016-08-12 07:00:00	YM	Futures	19990.5	19990.5	19981.9	19988.4	1291.0
2016-08-12 08:00:00	YM	Futures	19987.3	19990.5	19953.9	19959.3	4552.0
2016-08-12 09:00:00	YM	Futures	19959.3	19964.7	19934.5	19956.1	19990.0
2016-08-12 10:00:00	YM	Futures	19957.1	19975.4	19945.3	19967.9	11171.0
2016-08-12 11:00:00	YM	Futures	19969.0	19973.3	19935.6	19941.0	7946.0
2016-08-12 12:00:00	YM	Futures	19941.0	19943.2	19914.1	19923.8	10236.0
2016-08-12 13:00:00	YM	Futures	19923.8	19923.8	19894.7	19908.7	8670.0
2016-08-12 14:00:00	YM	Futures	19907.6	19934.5	19905.5	19929.2	6099.0
2016-08-12 15:00:00	YM	Futures	19929.2	19948.5	19921.6	19936.7	8245.0

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

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