PREVIEW / futures_1hour / 2016-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-21.parquet
  size:    15 KB
  rows:    294

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
2016-08-21 18:00:00	ES	Futures	2366.64	2367.46	2365.83	2366.37	4860.0
2016-08-21 19:00:00	ES	Futures	2366.37	2367.19	2366.1	2366.37	2311.0
2016-08-21 20:00:00	ES	Futures	2366.37	2366.37	2364.2	2364.47	6437.0
2016-08-21 21:00:00	ES	Futures	2364.2	2365.56	2362.85	2363.93	6496.0
2016-08-21 22:00:00	ES	Futures	2363.93	2364.47	2361.49	2362.3	4521.0
2016-08-21 23:00:00	ES	Futures	2362.03	2362.85	2362.03	2362.58	2285.0
2016-08-21 18:00:00	NQ	Futures	5733.62	5733.92	5727.66	5732.13	401.0
2016-08-21 19:00:00	NQ	Futures	5732.13	5733.62	5730.64	5731.23	332.0
2016-08-21 20:00:00	NQ	Futures	5730.94	5731.23	5724.38	5724.38	1021.0
2016-08-21 21:00:00	NQ	Futures	5725.27	5729.45	5721.4	5724.97	1255.0
2016-08-21 22:00:00	NQ	Futures	5724.38	5726.76	5718.72	5721.4	1101.0
2016-08-21 23:00:00	NQ	Futures	5721.1	5722.29	5719.31	5721.4	299.0
2016-08-21 18:00:00	YM	Futures	19957.1	19960.4	19949.6	19955.0	570.0
2016-08-21 19:00:00	YM	Futures	19956.1	19958.2	19951.8	19951.8	258.0
2016-08-21 20:00:00	YM	Futures	19951.8	19953.9	19932.4	19935.6	672.0
2016-08-21 21:00:00	YM	Futures	19935.6	19946.4	19922.7	19933.5	1166.0
2016-08-21 22:00:00	YM	Futures	19932.4	19937.8	19913.0	19918.4	825.0
2016-08-21 23:00:00	YM	Futures	19917.3	19921.6	19913.0	19918.4	470.0
2016-08-21 18:00:00	CL	Futures	49.79	49.86	49.38	49.45	4607.0
2016-08-21 19:00:00	CL	Futures	49.46	49.71	49.44	49.58	5537.0
2016-08-21 20:00:00	CL	Futures	49.58	49.64	49.5	49.52	2934.0
2016-08-21 21:00:00	CL	Futures	49.52	49.55	49.33	49.35	5887.0
2016-08-21 22:00:00	CL	Futures	49.36	49.42	49.25	49.27	4112.0
2016-08-21 23:00:00	CL	Futures	49.26	49.44	49.25	49.41	3734.0
2016-08-21 18:00:00	GC	Futures	1819.7	1820.7	1811.9	1815.0	5496.0
2016-08-21 19:00:00	GC	Futures	1815.0	1818.5	1814.2	1815.0	4281.0
2016-08-21 20:00:00	GC	Futures	1815.0	1816.1	1809.4	1813.1	9362.0
2016-08-21 21:00:00	GC	Futures	1813.2	1815.4	1809.2	1810.4	9605.0
2016-08-21 22:00:00	GC	Futures	1810.4	1811.2	1806.7	1808.5	7231.0
2016-08-21 23:00:00	GC	Futures	1808.5	1812.4	1807.7	1809.7	7169.0
2016-08-21 18:00:00	ZN	Futures	128.431774	128.446989	128.279621	128.310052	14254.0
2016-08-21 19:00:00	ZN	Futures	128.310052	128.355697	128.294837	128.310052	8046.0
2016-08-21 20:00:00	ZN	Futures	128.325267	128.401343	128.310052	128.370913	9703.0
2016-08-21 21:00:00	ZN	Futures	128.370913	128.401343	128.294837	128.325267	12286.0
2016-08-21 22:00:00	ZN	Futures	128.310052	128.310052	128.249191	128.294837	17782.0
2016-08-21 23:00:00	ZN	Futures	128.294837	128.294837	128.233976	128.249191	7283.0

> showing 36 of 294 rows — these rows as CSV

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