PREVIEW / futures_1hour / 2017-12-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-25.parquet
  size:    13 KB
  rows:    258

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-12-25 18:00:00	ES	Futures	2937.46	2940.46	2937.18	2939.1	4279.0
2017-12-25 19:00:00	ES	Futures	2939.37	2939.64	2937.73	2938.0	1821.0
2017-12-25 20:00:00	ES	Futures	2938.0	2938.0	2934.18	2935.82	4841.0
2017-12-25 21:00:00	ES	Futures	2935.82	2936.09	2935.54	2936.09	1126.0
2017-12-25 22:00:00	ES	Futures	2936.09	2936.36	2935.54	2936.09	669.0
2017-12-25 23:00:00	ES	Futures	2936.09	2936.64	2935.54	2936.36	956.0
2017-12-25 18:00:00	NQ	Futures	7690.69	7701.37	7690.69	7700.48	923.0
2017-12-25 19:00:00	NQ	Futures	7700.48	7701.96	7695.14	7695.73	576.0
2017-12-25 20:00:00	NQ	Futures	7695.43	7696.03	7682.98	7687.13	1548.0
2017-12-25 21:00:00	NQ	Futures	7687.43	7687.43	7684.46	7685.65	495.0
2017-12-25 22:00:00	NQ	Futures	7685.94	7686.83	7684.76	7686.54	220.0
2017-12-25 23:00:00	NQ	Futures	7686.83	7686.83	7682.38	7684.16	374.0
2017-12-25 18:00:00	YM	Futures	26931.8	26950.3	26914.4	26940.5	909.0
2017-12-25 19:00:00	YM	Futures	26940.5	26942.7	26929.6	26934.0	434.0
2017-12-25 20:00:00	YM	Futures	26934.0	26935.1	26884.0	26900.3	1652.0
2017-12-25 21:00:00	YM	Futures	26900.3	26904.6	26891.6	26901.4	465.0
2017-12-25 22:00:00	YM	Futures	26901.4	26902.5	26895.9	26900.3	276.0
2017-12-25 23:00:00	YM	Futures	26901.4	26907.9	26895.9	26902.5	258.0
2017-12-25 18:00:00	CL	Futures	51.81	52.03	51.78	51.97	4036.0
2017-12-25 19:00:00	CL	Futures	51.99	51.99	51.92	51.94	1368.0
2017-12-25 20:00:00	CL	Futures	51.94	51.97	51.88	51.92	2916.0
2017-12-25 21:00:00	CL	Futures	51.91	51.95	51.89	51.9	1775.0
2017-12-25 22:00:00	CL	Futures	51.89	51.9	51.85	51.89	1760.0
2017-12-25 23:00:00	CL	Futures	51.88	51.92	51.88	51.9	1031.0
2017-12-25 18:00:00	GC	Futures	1698.5	1699.9	1696.8	1697.1	3029.0
2017-12-25 19:00:00	GC	Futures	1697.1	1698.7	1696.8	1698.4	2100.0
2017-12-25 20:00:00	GC	Futures	1698.5	1704.4	1698.4	1703.9	9226.0
2017-12-25 21:00:00	GC	Futures	1703.7	1704.0	1702.9	1703.1	3384.0
2017-12-25 22:00:00	GC	Futures	1703.1	1703.3	1702.1	1703.2	2554.0
2017-12-25 23:00:00	GC	Futures	1703.2	1703.6	1702.5	1703.2	940.0
2017-12-25 18:00:00	ZN	Futures	123.223115	123.254299	123.160748	123.191932	7878.0
2017-12-25 19:00:00	ZN	Futures	123.17634	123.191932	123.17634	123.17634	3735.0
2017-12-25 20:00:00	ZN	Futures	123.17634	123.207523	123.17634	123.17634	1851.0
2017-12-25 21:00:00	ZN	Futures	123.17634	123.191932	123.17634	123.17634	2459.0
2017-12-25 22:00:00	ZN	Futures	123.17634	123.191932	123.17634	123.191932	2378.0
2017-12-25 23:00:00	ZN	Futures	123.191932	123.191932	123.17634	123.191932	1421.0

> showing 36 of 258 rows — these rows as CSV

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