PREVIEW / futures_1hour / 2019-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-18.parquet
  size:    17 KB
  rows:    361

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-08-18 18:00:00	ES	Futures	3132.6	3148.57	3132.06	3144.24	17514.0
2019-08-18 19:00:00	ES	Futures	3143.97	3147.76	3142.34	3146.68	8323.0
2019-08-18 20:00:00	ES	Futures	3146.41	3148.03	3140.72	3143.97	15658.0
2019-08-18 21:00:00	ES	Futures	3143.97	3147.76	3143.43	3145.32	9650.0
2019-08-18 22:00:00	ES	Futures	3145.59	3147.76	3144.24	3147.49	7814.0
2019-08-18 23:00:00	ES	Futures	3147.49	3147.76	3146.13	3146.41	3574.0
2019-08-18 18:00:00	NQ	Futures	8840.35	8885.9	8838.9	8870.81	7476.0
2019-08-18 19:00:00	NQ	Futures	8869.94	8883.0	8867.04	8880.39	2958.0
2019-08-18 20:00:00	NQ	Futures	8880.1	8884.45	8862.4	8872.56	7234.0
2019-08-18 21:00:00	NQ	Futures	8872.27	8886.48	8869.94	8882.42	7070.0
2019-08-18 22:00:00	NQ	Futures	8882.71	8888.51	8876.91	8886.77	4193.0
2019-08-18 23:00:00	NQ	Futures	8887.35	8888.8	8884.16	8885.03	2164.0
2019-08-18 18:00:00	YM	Futures	28179.3	28335.9	28179.3	28315.2	3482.0
2019-08-18 19:00:00	YM	Futures	28314.2	28342.4	28294.6	28327.2	1520.0
2019-08-18 20:00:00	YM	Futures	28326.1	28338.1	28277.2	28298.9	2572.0
2019-08-18 21:00:00	YM	Futures	28297.8	28332.6	28297.8	28309.8	1714.0
2019-08-18 22:00:00	YM	Futures	28309.8	28338.1	28296.8	28329.4	1587.0
2019-08-18 23:00:00	YM	Futures	28330.5	28331.6	28313.1	28318.5	770.0
2019-08-18 18:00:00	CL	Futures	48.78	48.93	48.64	48.83	5321.0
2019-08-18 19:00:00	CL	Futures	48.84	49.04	48.82	48.99	3291.0
2019-08-18 20:00:00	CL	Futures	48.99	49.08	48.94	48.97	4606.0
2019-08-18 21:00:00	CL	Futures	48.97	49.17	48.97	49.08	6324.0
2019-08-18 22:00:00	CL	Futures	49.09	49.18	49.04	49.15	4507.0
2019-08-18 23:00:00	CL	Futures	49.14	49.16	49.06	49.07	2862.0
2019-08-18 18:00:00	GC	Futures	1929.4	1930.2	1923.5	1925.5	6523.0
2019-08-18 19:00:00	GC	Futures	1925.5	1927.5	1925.0	1925.1	2322.0
2019-08-18 20:00:00	GC	Futures	1925.3	1926.3	1924.1	1925.9	4602.0
2019-08-18 21:00:00	GC	Futures	1926.0	1926.1	1919.5	1924.6	17842.0
2019-08-18 22:00:00	GC	Futures	1924.6	1929.4	1924.1	1924.6	13427.0
2019-08-18 23:00:00	GC	Futures	1924.6	1925.4	1923.7	1924.5	3406.0
2019-08-18 18:00:00	ZN	Futures	131.609765	131.609765	131.389682	131.468283	22826.0
2019-08-18 19:00:00	ZN	Futures	131.452563	131.515444	131.452563	131.515444	9641.0
2019-08-18 20:00:00	ZN	Futures	131.515444	131.531164	131.405402	131.484004	23125.0
2019-08-18 21:00:00	ZN	Futures	131.468283	131.468283	131.342522	131.468283	22849.0
2019-08-18 22:00:00	ZN	Futures	131.468283	131.515444	131.405402	131.421123	14688.0
2019-08-18 23:00:00	ZN	Futures	131.421123	131.436843	131.405402	131.436843	4578.0

> showing 36 of 361 rows — these rows as CSV

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