PREVIEW / futures_1hour / 2019-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-08.parquet
  size:    16 KB
  rows:    348

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-09-08 18:00:00	ES	Futures	3227.08	3232.76	3226.8	3230.32	6024.0
2019-09-08 19:00:00	ES	Futures	3230.32	3230.86	3228.43	3228.7	3832.0
2019-09-08 20:00:00	ES	Futures	3228.7	3235.47	3227.62	3234.38	13414.0
2019-09-08 21:00:00	ES	Futures	3234.11	3236.55	3229.78	3230.59	18139.0
2019-09-08 22:00:00	ES	Futures	3230.59	3235.2	3230.05	3233.57	8647.0
2019-09-08 23:00:00	ES	Futures	3233.57	3234.11	3232.49	3233.3	2751.0
2019-09-08 18:00:00	NQ	Futures	9118.6	9139.2	9114.53	9131.07	3084.0
2019-09-08 19:00:00	NQ	Futures	9130.49	9132.52	9124.69	9126.72	2115.0
2019-09-08 20:00:00	NQ	Futures	9126.72	9147.32	9122.95	9143.84	6407.0
2019-09-08 21:00:00	NQ	Futures	9144.13	9153.41	9126.14	9128.46	7173.0
2019-09-08 22:00:00	NQ	Futures	9128.17	9143.26	9126.43	9136.88	4966.0
2019-09-08 23:00:00	NQ	Futures	9136.88	9139.2	9131.07	9135.13	2053.0
2019-09-08 18:00:00	YM	Futures	29152.6	29203.7	29148.3	29175.5	1452.0
2019-09-08 19:00:00	YM	Futures	29175.5	29182.0	29160.2	29160.2	728.0
2019-09-08 20:00:00	YM	Futures	29160.2	29217.9	29150.4	29205.9	3237.0
2019-09-08 21:00:00	YM	Futures	29205.9	29232.0	29165.7	29175.5	3711.0
2019-09-08 22:00:00	YM	Futures	29174.4	29214.6	29170.0	29200.5	2058.0
2019-09-08 23:00:00	YM	Futures	29201.6	29208.1	29191.8	29200.5	616.0
2019-09-08 18:00:00	CL	Futures	50.43	50.7	50.32	50.51	5357.0
2019-09-08 19:00:00	CL	Futures	50.5	50.56	50.43	50.47	1596.0
2019-09-08 20:00:00	CL	Futures	50.47	50.62	50.45	50.48	3695.0
2019-09-08 21:00:00	CL	Futures	50.48	50.57	50.33	50.46	10015.0
2019-09-08 22:00:00	CL	Futures	50.46	50.77	50.45	50.72	8315.0
2019-09-08 23:00:00	CL	Futures	50.72	50.85	50.68	50.75	4930.0
2019-09-08 18:00:00	GC	Futures	1921.1	1921.1	1914.9	1919.3	4715.0
2019-09-08 19:00:00	GC	Futures	1919.3	1920.2	1916.3	1917.9	3353.0
2019-09-08 20:00:00	GC	Futures	1917.9	1921.1	1917.4	1919.8	4816.0
2019-09-08 21:00:00	GC	Futures	1919.9	1926.5	1918.9	1924.0	21831.0
2019-09-08 22:00:00	GC	Futures	1924.0	1924.6	1919.3	1922.7	9446.0
2019-09-08 23:00:00	GC	Futures	1922.8	1923.9	1922.1	1922.7	3877.0
2019-09-08 18:00:00	ZN	Futures	131.389683	131.405318	131.342781	131.374049	5025.0
2019-09-08 19:00:00	ZN	Futures	131.358415	131.405318	131.342781	131.374049	2769.0
2019-09-08 20:00:00	ZN	Futures	131.374049	131.436586	131.280244	131.311513	14102.0
2019-09-08 21:00:00	ZN	Futures	131.327147	131.374049	131.280244	131.358415	18784.0
2019-09-08 22:00:00	ZN	Futures	131.342781	131.358415	131.295878	131.327147	6256.0
2019-09-08 23:00:00	ZN	Futures	131.327147	131.358415	131.327147	131.342781	3947.0

> showing 36 of 348 rows — these rows as CSV

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