PREVIEW / futures_1hour / 2017-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-01.parquet
  size:    52 KB
  rows:    1,662

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-06-01 00:00:00	ES	Futures	2636.38	2636.92	2635.28	2636.65	2171.0
2017-06-01 01:00:00	ES	Futures	2636.65	2636.92	2635.56	2635.83	1738.0
2017-06-01 02:00:00	ES	Futures	2635.83	2636.65	2635.28	2635.28	6539.0
2017-06-01 03:00:00	ES	Futures	2635.56	2637.2	2634.74	2636.1	16320.0
2017-06-01 04:00:00	ES	Futures	2635.83	2638.01	2635.56	2637.47	15277.0
2017-06-01 05:00:00	ES	Futures	2637.47	2637.74	2635.28	2635.83	8313.0
2017-06-01 06:00:00	ES	Futures	2635.83	2636.92	2635.28	2636.65	8298.0
2017-06-01 07:00:00	ES	Futures	2636.38	2636.92	2634.46	2635.01	11203.0
2017-06-01 08:00:00	ES	Futures	2635.28	2638.56	2634.74	2638.56	30733.0
2017-06-01 09:00:00	ES	Futures	2638.56	2641.29	2636.1	2639.11	156198.0
2017-06-01 10:00:00	ES	Futures	2639.38	2640.75	2636.65	2638.01	213648.0
2017-06-01 11:00:00	ES	Futures	2638.29	2643.75	2637.47	2643.75	157659.0
2017-06-01 12:00:00	ES	Futures	2643.75	2647.85	2643.2	2647.3	128130.0
2017-06-01 13:00:00	ES	Futures	2647.3	2650.31	2647.03	2649.21	105536.0
2017-06-01 14:00:00	ES	Futures	2648.94	2651.13	2648.39	2648.67	89480.0
2017-06-01 15:00:00	ES	Futures	2648.67	2654.68	2647.85	2654.4	273741.0
2017-06-01 16:00:00	ES	Futures	2654.68	2655.5	2653.04	2654.13	144095.0
2017-06-01 18:00:00	ES	Futures	2654.13	2656.59	2653.86	2654.68	7879.0
2017-06-01 19:00:00	ES	Futures	2654.68	2655.22	2653.58	2654.95	2617.0
2017-06-01 20:00:00	ES	Futures	2654.95	2659.05	2654.68	2658.5	14967.0
2017-06-01 21:00:00	ES	Futures	2658.5	2660.14	2657.68	2659.32	10268.0
2017-06-01 22:00:00	ES	Futures	2659.32	2661.23	2659.05	2659.87	11128.0
2017-06-01 23:00:00	ES	Futures	2660.14	2661.23	2659.59	2659.87	7583.0
2017-06-01 00:00:00	NQ	Futures	6921.92	6924.6	6919.83	6924.31	648.0
2017-06-01 01:00:00	NQ	Futures	6924.01	6924.31	6921.92	6922.52	538.0
2017-06-01 02:00:00	NQ	Futures	6922.22	6924.9	6921.62	6922.52	1654.0
2017-06-01 03:00:00	NQ	Futures	6921.92	6926.99	6920.43	6922.82	3713.0
2017-06-01 04:00:00	NQ	Futures	6922.82	6928.48	6922.52	6926.09	2285.0
2017-06-01 05:00:00	NQ	Futures	6926.09	6926.69	6919.24	6922.22	2082.0
2017-06-01 06:00:00	NQ	Futures	6921.92	6923.71	6920.43	6921.32	1750.0
2017-06-01 07:00:00	NQ	Futures	6921.62	6922.22	6914.17	6915.36	2474.0
2017-06-01 08:00:00	NQ	Futures	6915.66	6923.11	6914.17	6922.22	6741.0
2017-06-01 09:00:00	NQ	Futures	6922.22	6932.36	6912.98	6918.05	40939.0
2017-06-01 10:00:00	NQ	Futures	6918.34	6921.32	6893.6	6901.65	58872.0
2017-06-01 11:00:00	NQ	Futures	6901.95	6919.24	6899.56	6918.64	30733.0
2017-06-01 12:00:00	NQ	Futures	6918.34	6927.88	6915.36	6924.6	21747.0
2017-06-01 13:00:00	NQ	Futures	6924.9	6928.18	6921.03	6922.82	16248.0
2017-06-01 14:00:00	NQ	Futures	6923.11	6928.18	6919.54	6919.83	18338.0
2017-06-01 15:00:00	NQ	Futures	6919.83	6937.42	6919.83	6937.13	32471.0
2017-06-01 16:00:00	NQ	Futures	6937.13	6945.47	6934.44	6944.28	9536.0
2017-06-01 18:00:00	NQ	Futures	6945.18	6949.95	6943.69	6945.77	1336.0
2017-06-01 19:00:00	NQ	Futures	6945.47	6945.77	6943.09	6944.88	607.0
2017-06-01 20:00:00	NQ	Futures	6944.88	6958.59	6944.58	6955.91	3449.0
2017-06-01 21:00:00	NQ	Futures	6955.91	6963.66	6954.42	6960.08	2112.0
2017-06-01 22:00:00	NQ	Futures	6960.08	6966.05	6960.08	6963.66	2587.0
2017-06-01 23:00:00	NQ	Futures	6963.96	6967.83	6961.57	6964.26	1465.0
2017-06-01 00:00:00	YM	Futures	22847.6	22850.9	22840.0	22850.9	411.0
2017-06-01 01:00:00	YM	Futures	22849.8	22850.9	22836.7	22840.0	789.0
2017-06-01 02:00:00	YM	Futures	22838.9	22844.3	22830.2	22832.4	1426.0
2017-06-01 03:00:00	YM	Futures	22831.3	22843.3	22828.0	22829.1	2459.0

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

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