PREVIEW / futures_1hour / 2019-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-06.parquet
  size:    17 KB
  rows:    352

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
2019-10-06 18:00:00	ES	Futures	3183.24	3195.47	3181.34	3195.2	19079.0
2019-10-06 19:00:00	ES	Futures	3195.2	3197.37	3193.84	3193.84	6604.0
2019-10-06 20:00:00	ES	Futures	3193.84	3196.82	3190.03	3190.58	12024.0
2019-10-06 21:00:00	ES	Futures	3190.85	3193.02	3188.95	3192.48	9281.0
2019-10-06 22:00:00	ES	Futures	3192.75	3192.75	3189.76	3190.85	3989.0
2019-10-06 23:00:00	ES	Futures	3191.12	3192.48	3190.31	3191.66	2927.0
2019-10-06 18:00:00	NQ	Futures	8961.69	8994.8	8926.83	8994.51	5701.0
2019-10-06 19:00:00	NQ	Futures	8994.51	9002.07	8988.99	8991.03	2299.0
2019-10-06 20:00:00	NQ	Futures	8991.03	9001.78	8976.5	8978.54	5015.0
2019-10-06 21:00:00	NQ	Futures	8978.83	8986.09	8971.56	8983.77	3623.0
2019-10-06 22:00:00	NQ	Futures	8984.06	8984.64	8973.31	8978.83	2448.0
2019-10-06 23:00:00	NQ	Futures	8979.41	8983.47	8976.21	8980.86	1309.0
2019-10-06 18:00:00	YM	Futures	28702.0	28783.7	28666.1	28781.5	2479.0
2019-10-06 19:00:00	YM	Futures	28777.1	28802.2	28760.8	28764.1	1002.0
2019-10-06 20:00:00	YM	Futures	28765.2	28786.9	28733.6	28740.1	2161.0
2019-10-06 21:00:00	YM	Futures	28740.1	28760.8	28723.8	28756.4	1854.0
2019-10-06 22:00:00	YM	Futures	28757.5	28757.5	28729.2	28743.4	1227.0
2019-10-06 23:00:00	YM	Futures	28745.6	28757.5	28736.9	28752.1	716.0
2019-10-06 18:00:00	CL	Futures	46.81	46.92	46.74	46.86	4338.0
2019-10-06 19:00:00	CL	Futures	46.85	46.86	46.76	46.77	1657.0
2019-10-06 20:00:00	CL	Futures	46.77	46.87	46.75	46.83	3929.0
2019-10-06 21:00:00	CL	Futures	46.83	46.84	46.76	46.81	2742.0
2019-10-06 22:00:00	CL	Futures	46.81	46.85	46.72	46.78	3842.0
2019-10-06 23:00:00	CL	Futures	46.77	46.81	46.76	46.8	1750.0
2019-10-06 18:00:00	GC	Futures	1923.9	1924.1	1915.0	1915.1	4926.0
2019-10-06 19:00:00	GC	Futures	1915.0	1918.0	1914.2	1917.8	2886.0
2019-10-06 20:00:00	GC	Futures	1917.8	1918.3	1915.7	1918.2	5174.0
2019-10-06 21:00:00	GC	Futures	1918.2	1919.2	1917.1	1917.3	3302.0
2019-10-06 22:00:00	GC	Futures	1917.3	1917.5	1915.6	1917.3	2896.0
2019-10-06 23:00:00	GC	Futures	1917.3	1917.4	1915.5	1915.9	1698.0
2019-10-06 18:00:00	ZN	Futures	131.983782	132.061953	131.874343	131.874343	10803.0
2019-10-06 19:00:00	ZN	Futures	131.889977	131.952514	131.858709	131.952514	6412.0
2019-10-06 20:00:00	ZN	Futures	131.952514	131.999417	131.874343	131.999417	10906.0
2019-10-06 21:00:00	ZN	Futures	131.999417	132.061953	131.968148	131.968148	10272.0
2019-10-06 22:00:00	ZN	Futures	131.968148	131.983782	131.905612	131.921246	7546.0
2019-10-06 23:00:00	ZN	Futures	131.921246	131.93688	131.905612	131.905612	2060.0

> showing 36 of 352 rows — these rows as CSV

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