PREVIEW / futures_1hour / 2017-08-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-22.parquet
  size:    51 KB
  rows:    1,597

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-08-22 00:00:00	ES	Futures	2660.68	2660.68	2659.59	2660.14	2157.0
2017-08-22 01:00:00	ES	Futures	2660.41	2661.23	2659.32	2660.41	5266.0
2017-08-22 02:00:00	ES	Futures	2660.14	2663.69	2659.04	2663.69	14809.0
2017-08-22 03:00:00	ES	Futures	2663.42	2664.78	2659.04	2660.96	29707.0
2017-08-22 04:00:00	ES	Futures	2660.96	2661.23	2658.5	2660.14	12945.0
2017-08-22 05:00:00	ES	Futures	2660.14	2660.41	2656.04	2658.22	18569.0
2017-08-22 06:00:00	ES	Futures	2657.95	2659.32	2656.31	2656.86	13598.0
2017-08-22 07:00:00	ES	Futures	2656.86	2660.68	2656.86	2659.59	27578.0
2017-08-22 08:00:00	ES	Futures	2659.59	2663.69	2659.32	2661.5	38649.0
2017-08-22 09:00:00	ES	Futures	2661.23	2670.25	2659.86	2668.06	187396.0
2017-08-22 10:00:00	ES	Futures	2667.79	2672.16	2667.79	2671.89	154380.0
2017-08-22 11:00:00	ES	Futures	2671.89	2675.44	2669.7	2674.35	144385.0
2017-08-22 12:00:00	ES	Futures	2674.62	2677.08	2674.08	2675.44	105670.0
2017-08-22 13:00:00	ES	Futures	2675.72	2677.08	2674.9	2675.44	62830.0
2017-08-22 14:00:00	ES	Futures	2675.72	2680.36	2674.9	2679.54	139948.0
2017-08-22 15:00:00	ES	Futures	2679.27	2683.1	2678.72	2680.09	241886.0
2017-08-22 16:00:00	ES	Futures	2680.09	2683.37	2678.72	2682.82	100038.0
2017-08-22 18:00:00	ES	Futures	2682.0	2683.37	2681.18	2682.55	6879.0
2017-08-22 19:00:00	ES	Futures	2682.28	2683.92	2680.91	2682.0	5827.0
2017-08-22 20:00:00	ES	Futures	2682.0	2682.28	2679.27	2679.82	8067.0
2017-08-22 21:00:00	ES	Futures	2679.82	2680.64	2679.0	2679.27	6279.0
2017-08-22 22:00:00	ES	Futures	2679.27	2679.82	2677.63	2677.9	8331.0
2017-08-22 23:00:00	ES	Futures	2677.9	2678.18	2674.9	2675.72	13959.0
2017-08-22 00:00:00	NQ	Futures	6928.67	6929.56	6925.69	6929.27	635.0
2017-08-22 01:00:00	NQ	Futures	6928.97	6932.24	6926.59	6928.67	1255.0
2017-08-22 02:00:00	NQ	Futures	6929.56	6937.01	6925.69	6936.71	2640.0
2017-08-22 03:00:00	NQ	Futures	6936.41	6941.47	6923.91	6931.05	4946.0
2017-08-22 04:00:00	NQ	Futures	6931.05	6932.54	6921.82	6930.46	2390.0
2017-08-22 05:00:00	NQ	Futures	6929.56	6929.56	6913.78	6922.72	4084.0
2017-08-22 06:00:00	NQ	Futures	6922.72	6926.29	6918.85	6920.93	4192.0
2017-08-22 07:00:00	NQ	Futures	6921.23	6934.03	6921.23	6928.08	7199.0
2017-08-22 08:00:00	NQ	Futures	6928.37	6940.88	6928.08	6934.92	8162.0
2017-08-22 09:00:00	NQ	Futures	6935.22	6964.1	6927.78	6954.58	56465.0
2017-08-22 10:00:00	NQ	Futures	6954.28	6977.8	6953.98	6976.61	47037.0
2017-08-22 11:00:00	NQ	Futures	6976.61	6989.41	6974.82	6986.44	42156.0
2017-08-22 12:00:00	NQ	Futures	6986.44	6997.75	6985.84	6990.9	28280.0
2017-08-22 13:00:00	NQ	Futures	6990.6	6993.58	6983.46	6985.24	16214.0
2017-08-22 14:00:00	NQ	Futures	6984.95	7002.81	6984.65	6996.86	25838.0
2017-08-22 15:00:00	NQ	Futures	6996.56	7005.49	6994.18	6998.05	34564.0
2017-08-22 16:00:00	NQ	Futures	6998.05	7005.79	6995.37	7003.41	7649.0
2017-08-22 18:00:00	NQ	Futures	7001.03	7005.79	6997.45	7003.7	1241.0
2017-08-22 19:00:00	NQ	Futures	7004.0	7007.87	6998.35	7003.11	1480.0
2017-08-22 20:00:00	NQ	Futures	7003.11	7004.3	6994.47	6997.15	1884.0
2017-08-22 21:00:00	NQ	Futures	6997.15	6998.94	6994.77	6995.67	832.0
2017-08-22 22:00:00	NQ	Futures	6995.67	6996.56	6992.39	6993.28	1287.0
2017-08-22 23:00:00	NQ	Futures	6993.28	6993.58	6984.65	6988.22	1885.0
2017-08-22 00:00:00	YM	Futures	23671.2	23671.2	23663.6	23666.9	361.0
2017-08-22 01:00:00	YM	Futures	23666.9	23670.1	23659.2	23664.7	821.0
2017-08-22 02:00:00	YM	Futures	23665.8	23690.8	23653.8	23690.8	1954.0
2017-08-22 03:00:00	YM	Futures	23689.7	23701.7	23659.2	23673.4	3829.0

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

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