PREVIEW / futures_1hour / 2017-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-17.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-17 00:00:00	ES	Futures	2695.12	2695.67	2695.12	2695.4	754.0
2017-08-17 01:00:00	ES	Futures	2695.67	2695.94	2694.3	2695.12	2799.0
2017-08-17 02:00:00	ES	Futures	2695.12	2696.22	2694.85	2695.4	4337.0
2017-08-17 03:00:00	ES	Futures	2695.4	2698.95	2694.58	2697.04	18349.0
2017-08-17 04:00:00	ES	Futures	2696.76	2697.04	2693.21	2694.58	15866.0
2017-08-17 05:00:00	ES	Futures	2694.58	2695.67	2693.21	2695.12	13863.0
2017-08-17 06:00:00	ES	Futures	2695.12	2695.4	2693.76	2694.03	10419.0
2017-08-17 07:00:00	ES	Futures	2694.03	2695.12	2689.93	2691.02	33398.0
2017-08-17 08:00:00	ES	Futures	2691.3	2692.39	2688.02	2691.57	44554.0
2017-08-17 09:00:00	ES	Futures	2691.3	2694.03	2688.02	2688.02	168092.0
2017-08-17 10:00:00	ES	Futures	2688.02	2689.38	2678.45	2682.0	472303.0
2017-08-17 11:00:00	ES	Futures	2682.28	2687.47	2678.45	2680.09	201130.0
2017-08-17 12:00:00	ES	Futures	2680.09	2681.73	2670.25	2672.16	193325.0
2017-08-17 13:00:00	ES	Futures	2671.89	2674.08	2668.61	2671.89	171092.0
2017-08-17 14:00:00	ES	Futures	2671.89	2672.71	2666.15	2668.34	181559.0
2017-08-17 15:00:00	ES	Futures	2668.34	2668.61	2655.49	2655.76	470171.0
2017-08-17 16:00:00	ES	Futures	2656.04	2657.95	2650.02	2653.85	175132.0
2017-08-17 18:00:00	ES	Futures	2653.3	2655.49	2652.21	2654.94	14091.0
2017-08-17 19:00:00	ES	Futures	2654.94	2656.04	2652.76	2653.3	8158.0
2017-08-17 20:00:00	ES	Futures	2653.3	2659.59	2651.12	2659.04	20828.0
2017-08-17 21:00:00	ES	Futures	2658.77	2661.23	2658.77	2660.41	15446.0
2017-08-17 22:00:00	ES	Futures	2660.14	2660.41	2657.13	2659.32	6899.0
2017-08-17 23:00:00	ES	Futures	2659.32	2659.86	2657.68	2657.68	4859.0
2017-08-17 00:00:00	NQ	Futures	7043.01	7045.99	7042.71	7045.69	343.0
2017-08-17 01:00:00	NQ	Futures	7045.69	7047.47	7039.73	7042.71	847.0
2017-08-17 02:00:00	NQ	Futures	7043.01	7047.18	7042.71	7043.01	977.0
2017-08-17 03:00:00	NQ	Futures	7043.31	7055.22	7040.03	7048.96	3027.0
2017-08-17 04:00:00	NQ	Futures	7048.67	7049.56	7034.97	7038.84	3329.0
2017-08-17 05:00:00	NQ	Futures	7039.14	7042.71	7033.48	7037.35	2599.0
2017-08-17 06:00:00	NQ	Futures	7037.05	7037.95	7034.37	7035.56	2177.0
2017-08-17 07:00:00	NQ	Futures	7035.86	7041.82	7020.38	7025.74	8118.0
2017-08-17 08:00:00	NQ	Futures	7026.04	7028.42	7015.61	7023.06	10927.0
2017-08-17 09:00:00	NQ	Futures	7023.06	7035.86	7016.21	7016.21	42396.0
2017-08-17 10:00:00	NQ	Futures	7016.21	7016.81	6969.17	6980.18	118423.0
2017-08-17 11:00:00	NQ	Futures	6980.48	6998.35	6974.82	6982.27	42466.0
2017-08-17 12:00:00	NQ	Futures	6982.27	6987.03	6942.96	6948.62	62454.0
2017-08-17 13:00:00	NQ	Futures	6948.62	6962.62	6937.6	6956.66	49732.0
2017-08-17 14:00:00	NQ	Futures	6956.36	6958.45	6932.54	6940.28	42290.0
2017-08-17 15:00:00	NQ	Futures	6940.58	6941.18	6907.83	6908.42	84686.0
2017-08-17 16:00:00	NQ	Futures	6908.42	6913.78	6891.75	6901.28	15783.0
2017-08-17 18:00:00	NQ	Futures	6898.6	6905.45	6895.32	6901.87	2397.0
2017-08-17 19:00:00	NQ	Futures	6901.87	6906.34	6897.41	6900.68	1446.0
2017-08-17 20:00:00	NQ	Futures	6900.98	6921.23	6894.73	6918.85	3641.0
2017-08-17 21:00:00	NQ	Futures	6919.14	6933.44	6918.55	6929.27	4326.0
2017-08-17 22:00:00	NQ	Futures	6929.27	6929.27	6919.44	6928.97	2074.0
2017-08-17 23:00:00	NQ	Futures	6929.27	6931.05	6925.1	6925.99	1277.0
2017-08-17 00:00:00	YM	Futures	23945.5	23949.9	23944.4	23949.9	184.0
2017-08-17 01:00:00	YM	Futures	23948.8	23952.0	23937.9	23942.2	469.0
2017-08-17 02:00:00	YM	Futures	23943.3	23953.1	23942.2	23946.6	739.0
2017-08-17 03:00:00	YM	Futures	23946.6	23967.3	23939.0	23955.3	2374.0

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

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