PREVIEW / futures_1hour / 2018-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-13.parquet
  size:    53 KB
  rows:    1,638

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-06-13 00:00:00	ES	Futures	3044.56	3045.38	3044.56	3045.38	596.0
2018-06-13 01:00:00	ES	Futures	3045.11	3045.93	3045.11	3045.38	703.0
2018-06-13 02:00:00	ES	Futures	3045.38	3045.65	3042.11	3042.65	3075.0
2018-06-13 03:00:00	ES	Futures	3042.92	3043.74	3040.74	3041.83	4153.0
2018-06-13 04:00:00	ES	Futures	3041.83	3042.38	3040.2	3041.83	1861.0
2018-06-13 05:00:00	ES	Futures	3042.11	3044.29	3040.74	3043.2	3461.0
2018-06-13 06:00:00	ES	Futures	3043.2	3044.84	3042.92	3044.29	1767.0
2018-06-13 07:00:00	ES	Futures	3044.56	3045.38	3043.47	3044.29	2345.0
2018-06-13 08:00:00	ES	Futures	3044.29	3044.29	3041.83	3042.92	3969.0
2018-06-13 09:00:00	ES	Futures	3043.2	3044.84	3041.56	3042.38	22677.0
2018-06-13 10:00:00	ES	Futures	3042.38	3046.47	3042.38	3043.74	21223.0
2018-06-13 11:00:00	ES	Futures	3044.02	3047.02	3044.02	3045.65	8981.0
2018-06-13 12:00:00	ES	Futures	3045.65	3045.93	3041.83	3041.83	6702.0
2018-06-13 13:00:00	ES	Futures	3041.83	3043.47	3040.47	3042.65	6308.0
2018-06-13 14:00:00	ES	Futures	3042.92	3043.47	3030.64	3038.83	43232.0
2018-06-13 15:00:00	ES	Futures	3038.56	3044.29	3028.19	3029.83	40060.0
2018-06-13 16:00:00	ES	Futures	3029.83	3032.55	3027.91	3029.55	12898.0
2018-06-13 18:00:00	ES	Futures	3027.37	3031.19	3027.37	3030.92	319.0
2018-06-13 19:00:00	ES	Futures	3031.19	3031.46	3029.01	3030.1	610.0
2018-06-13 20:00:00	ES	Futures	3030.37	3032.55	3029.01	3032.55	1465.0
2018-06-13 21:00:00	ES	Futures	3032.55	3033.65	3032.28	3033.1	1641.0
2018-06-13 22:00:00	ES	Futures	3033.1	3033.37	3028.19	3028.19	982.0
2018-06-13 23:00:00	ES	Futures	3028.19	3030.1	3027.37	3029.83	791.0
2018-06-13 00:00:00	NQ	Futures	8536.74	8538.51	8534.38	8538.22	146.0
2018-06-13 01:00:00	NQ	Futures	8538.22	8539.4	8535.56	8537.04	232.0
2018-06-13 02:00:00	NQ	Futures	8536.74	8537.04	8523.74	8526.4	756.0
2018-06-13 03:00:00	NQ	Futures	8526.4	8530.54	8516.05	8519.9	725.0
2018-06-13 04:00:00	NQ	Futures	8520.49	8525.51	8514.58	8524.33	591.0
2018-06-13 05:00:00	NQ	Futures	8524.03	8533.49	8520.49	8530.24	540.0
2018-06-13 06:00:00	NQ	Futures	8530.54	8538.51	8528.47	8537.04	698.0
2018-06-13 07:00:00	NQ	Futures	8537.33	8538.81	8530.54	8533.49	396.0
2018-06-13 08:00:00	NQ	Futures	8532.6	8533.2	8524.92	8528.17	955.0
2018-06-13 09:00:00	NQ	Futures	8527.88	8544.43	8526.99	8540.88	6715.0
2018-06-13 10:00:00	NQ	Futures	8541.17	8565.41	8541.17	8554.47	7583.0
2018-06-13 11:00:00	NQ	Futures	8555.36	8585.5	8555.36	8578.12	4990.0
2018-06-13 12:00:00	NQ	Futures	8577.82	8578.71	8557.72	8563.34	3173.0
2018-06-13 13:00:00	NQ	Futures	8563.04	8572.5	8555.06	8567.77	2428.0
2018-06-13 14:00:00	NQ	Futures	8568.07	8569.25	8501.87	8549.15	10392.0
2018-06-13 15:00:00	NQ	Futures	8548.56	8566.59	8513.1	8517.83	7972.0
2018-06-13 16:00:00	NQ	Futures	8517.83	8527.28	8514.58	8521.67	2621.0
2018-06-13 18:00:00	NQ	Futures	8515.17	8526.1	8513.99	8523.15	141.0
2018-06-13 19:00:00	NQ	Futures	8524.33	8526.1	8516.05	8520.19	246.0
2018-06-13 20:00:00	NQ	Futures	8520.49	8526.4	8516.94	8525.51	216.0
2018-06-13 21:00:00	NQ	Futures	8525.81	8529.35	8523.15	8523.74	105.0
2018-06-13 22:00:00	NQ	Futures	8524.62	8524.62	8507.48	8507.78	266.0
2018-06-13 23:00:00	NQ	Futures	8507.78	8514.58	8506.01	8513.69	202.0
2018-06-13 00:00:00	YM	Futures	27566.6	27569.9	27557.9	27566.6	558.0
2018-06-13 01:00:00	YM	Futures	27566.6	27569.9	27561.2	27563.3	541.0
2018-06-13 02:00:00	YM	Futures	27563.3	27565.5	27523.1	27531.8	2005.0
2018-06-13 03:00:00	YM	Futures	27531.8	27542.7	27510.1	27529.6	2780.0

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

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