PREVIEW / futures_1hour / 2018-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-11.parquet
  size:    55 KB
  rows:    1,672

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
2018-07-11 00:00:00	ES	Futures	3029.01	3030.64	3026.56	3026.83	5189.0
2018-07-11 01:00:00	ES	Futures	3026.83	3028.46	3024.65	3025.19	7997.0
2018-07-11 02:00:00	ES	Futures	3025.19	3027.37	3022.47	3023.01	14507.0
2018-07-11 03:00:00	ES	Futures	3023.29	3025.19	3018.38	3021.92	25902.0
2018-07-11 04:00:00	ES	Futures	3021.65	3025.74	3020.02	3025.47	16086.0
2018-07-11 05:00:00	ES	Futures	3025.19	3025.74	3021.65	3023.56	13339.0
2018-07-11 06:00:00	ES	Futures	3023.56	3029.28	3023.01	3027.92	16305.0
2018-07-11 07:00:00	ES	Futures	3027.92	3029.55	3026.01	3027.1	11348.0
2018-07-11 08:00:00	ES	Futures	3026.83	3033.64	3024.38	3027.1	64039.0
2018-07-11 09:00:00	ES	Futures	3027.37	3034.18	3025.74	3030.37	179290.0
2018-07-11 10:00:00	ES	Futures	3030.1	3038.27	3029.83	3034.73	177919.0
2018-07-11 11:00:00	ES	Futures	3034.73	3037.73	3025.47	3025.74	152097.0
2018-07-11 12:00:00	ES	Futures	3025.74	3031.19	3024.92	3026.83	89173.0
2018-07-11 13:00:00	ES	Futures	3026.83	3032.82	3024.65	3025.19	86902.0
2018-07-11 14:00:00	ES	Futures	3025.19	3030.1	3021.38	3028.19	104320.0
2018-07-11 15:00:00	ES	Futures	3028.19	3030.92	3024.38	3025.74	164111.0
2018-07-11 16:00:00	ES	Futures	3025.74	3026.56	3022.74	3025.19	58083.0
2018-07-11 18:00:00	ES	Futures	3026.28	3027.92	3023.01	3025.19	5369.0
2018-07-11 19:00:00	ES	Futures	3025.19	3028.19	3023.83	3027.37	2564.0
2018-07-11 20:00:00	ES	Futures	3027.37	3029.01	3026.01	3027.37	6105.0
2018-07-11 21:00:00	ES	Futures	3027.37	3034.73	3025.47	3033.09	16582.0
2018-07-11 22:00:00	ES	Futures	3032.82	3034.73	3031.19	3033.09	10280.0
2018-07-11 23:00:00	ES	Futures	3033.09	3034.46	3032.28	3033.64	4280.0
2018-07-11 00:00:00	NQ	Futures	8529.88	8536.07	8523.99	8524.29	2136.0
2018-07-11 01:00:00	NQ	Futures	8523.99	8525.76	8511.33	8513.98	3320.0
2018-07-11 02:00:00	NQ	Futures	8514.28	8519.58	8501.91	8503.97	5211.0
2018-07-11 03:00:00	NQ	Futures	8503.97	8513.98	8495.14	8510.16	6415.0
2018-07-11 04:00:00	NQ	Futures	8509.86	8523.11	8506.62	8521.34	4901.0
2018-07-11 05:00:00	NQ	Futures	8521.64	8523.41	8511.33	8514.57	3279.0
2018-07-11 06:00:00	NQ	Futures	8514.57	8530.18	8511.63	8527.23	4133.0
2018-07-11 07:00:00	NQ	Futures	8527.23	8538.13	8524.58	8526.94	5489.0
2018-07-11 08:00:00	NQ	Futures	8526.64	8552.26	8519.87	8531.94	16372.0
2018-07-11 09:00:00	NQ	Futures	8531.94	8565.21	8523.7	8554.32	59674.0
2018-07-11 10:00:00	NQ	Futures	8554.61	8585.23	8552.55	8572.87	50655.0
2018-07-11 11:00:00	NQ	Futures	8573.16	8580.82	8533.12	8543.43	48334.0
2018-07-11 12:00:00	NQ	Futures	8543.13	8563.74	8530.47	8551.67	31072.0
2018-07-11 13:00:00	NQ	Futures	8551.67	8573.75	8544.31	8550.49	25538.0
2018-07-11 14:00:00	NQ	Futures	8550.2	8565.8	8536.95	8560.5	19927.0
2018-07-11 15:00:00	NQ	Futures	8560.21	8568.45	8550.49	8554.32	28586.0
2018-07-11 16:00:00	NQ	Futures	8554.32	8556.09	8538.42	8544.01	8217.0
2018-07-11 18:00:00	NQ	Futures	8549.61	8553.14	8537.54	8544.31	1428.0
2018-07-11 19:00:00	NQ	Futures	8543.72	8551.08	8539.89	8548.73	1303.0
2018-07-11 20:00:00	NQ	Futures	8548.43	8555.5	8544.6	8550.49	2707.0
2018-07-11 21:00:00	NQ	Futures	8550.79	8576.11	8547.25	8573.75	6352.0
2018-07-11 22:00:00	NQ	Futures	8574.34	8581.41	8570.22	8577.28	3991.0
2018-07-11 23:00:00	NQ	Futures	8577.58	8582.88	8575.52	8581.41	2136.0
2018-07-11 00:00:00	YM	Futures	26910.0	26921.9	26887.1	26888.2	1986.0
2018-07-11 01:00:00	YM	Futures	26887.1	26899.1	26864.3	26868.6	2505.0
2018-07-11 02:00:00	YM	Futures	26869.7	26883.9	26837.1	26844.7	3813.0
2018-07-11 03:00:00	YM	Futures	26844.7	26866.5	26794.7	26837.1	6090.0

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

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