PREVIEW / futures_1hour / 2017-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-29.parquet
  size:    54 KB
  rows:    1,627

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-29 00:00:00	ES	Futures	2657.13	2657.13	2656.31	2656.58	2914.0
2017-08-29 01:00:00	ES	Futures	2656.86	2658.5	2656.58	2657.95	5576.0
2017-08-29 02:00:00	ES	Futures	2657.95	2660.68	2656.58	2656.58	17474.0
2017-08-29 03:00:00	ES	Futures	2656.58	2657.13	2649.75	2650.57	53358.0
2017-08-29 04:00:00	ES	Futures	2650.3	2652.48	2647.29	2648.66	39012.0
2017-08-29 05:00:00	ES	Futures	2648.66	2654.4	2647.02	2652.76	36759.0
2017-08-29 06:00:00	ES	Futures	2653.03	2655.49	2651.39	2655.22	18706.0
2017-08-29 07:00:00	ES	Futures	2655.49	2659.59	2654.94	2658.5	34907.0
2017-08-29 08:00:00	ES	Futures	2658.5	2659.59	2654.67	2656.58	41680.0
2017-08-29 09:00:00	ES	Futures	2656.58	2663.14	2652.76	2662.32	249009.0
2017-08-29 10:00:00	ES	Futures	2662.32	2668.34	2658.5	2666.97	265987.0
2017-08-29 11:00:00	ES	Futures	2666.7	2671.07	2665.88	2669.16	157962.0
2017-08-29 12:00:00	ES	Futures	2668.88	2672.16	2668.06	2671.07	79331.0
2017-08-29 13:00:00	ES	Futures	2671.07	2672.98	2669.16	2671.62	80650.0
2017-08-29 14:00:00	ES	Futures	2671.34	2675.17	2670.8	2674.62	88758.0
2017-08-29 15:00:00	ES	Futures	2674.62	2677.08	2673.26	2673.53	209384.0
2017-08-29 16:00:00	ES	Futures	2673.8	2676.26	2673.26	2675.17	78431.0
2017-08-29 18:00:00	ES	Futures	2674.9	2675.72	2673.53	2674.35	4343.0
2017-08-29 19:00:00	ES	Futures	2674.62	2678.18	2674.35	2677.63	6365.0
2017-08-29 20:00:00	ES	Futures	2677.63	2677.9	2676.26	2676.81	7618.0
2017-08-29 21:00:00	ES	Futures	2676.81	2677.36	2675.72	2677.08	5836.0
2017-08-29 22:00:00	ES	Futures	2677.08	2677.36	2675.44	2677.36	3801.0
2017-08-29 23:00:00	ES	Futures	2677.08	2677.63	2677.08	2677.63	2364.0
2017-08-29 00:00:00	NQ	Futures	6914.38	6916.17	6912.0	6914.97	528.0
2017-08-29 01:00:00	NQ	Futures	6914.97	6923.31	6914.38	6920.93	1389.0
2017-08-29 02:00:00	NQ	Futures	6921.23	6931.35	6918.85	6919.14	3404.0
2017-08-29 03:00:00	NQ	Futures	6918.85	6919.74	6892.35	6893.83	10600.0
2017-08-29 04:00:00	NQ	Futures	6893.83	6900.39	6884.01	6887.28	7079.0
2017-08-29 05:00:00	NQ	Futures	6887.58	6901.87	6880.73	6898.0	5586.0
2017-08-29 06:00:00	NQ	Futures	6898.3	6903.96	6892.94	6903.96	2769.0
2017-08-29 07:00:00	NQ	Futures	6903.96	6913.78	6903.06	6909.02	6178.0
2017-08-29 08:00:00	NQ	Futures	6909.32	6914.68	6898.9	6903.66	8783.0
2017-08-29 09:00:00	NQ	Futures	6903.06	6937.01	6891.45	6933.14	56636.0
2017-08-29 10:00:00	NQ	Futures	6933.73	6963.81	6926.29	6957.26	69356.0
2017-08-29 11:00:00	NQ	Futures	6956.96	6982.56	6954.87	6977.2	41308.0
2017-08-29 12:00:00	NQ	Futures	6977.2	6984.65	6973.33	6977.5	16474.0
2017-08-29 13:00:00	NQ	Futures	6977.8	6981.97	6969.17	6975.42	17051.0
2017-08-29 14:00:00	NQ	Futures	6975.12	6990.9	6974.23	6989.41	18019.0
2017-08-29 15:00:00	NQ	Futures	6989.41	6997.75	6982.27	6985.84	33618.0
2017-08-29 16:00:00	NQ	Futures	6985.84	6994.47	6984.35	6990.9	7254.0
2017-08-29 18:00:00	NQ	Futures	6990.9	6992.39	6985.54	6988.82	882.0
2017-08-29 19:00:00	NQ	Futures	6988.82	7002.81	6988.82	6999.83	2185.0
2017-08-29 20:00:00	NQ	Futures	6999.83	7002.51	6996.26	6999.83	1776.0
2017-08-29 21:00:00	NQ	Futures	7000.13	7002.51	6997.15	7001.03	1320.0
2017-08-29 22:00:00	NQ	Futures	7000.73	7001.92	6994.77	6999.83	1383.0
2017-08-29 23:00:00	NQ	Futures	6999.83	7002.81	6998.05	6999.54	414.0
2017-08-29 00:00:00	YM	Futures	23621.1	23622.2	23615.7	23620.1	690.0
2017-08-29 01:00:00	YM	Futures	23621.1	23637.5	23620.1	23629.9	970.0
2017-08-29 02:00:00	YM	Futures	23629.9	23649.4	23623.3	23623.3	2288.0
2017-08-29 03:00:00	YM	Futures	23623.3	23626.6	23577.6	23580.9	6766.0

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

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