PREVIEW / futures_1hour / 2016-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-17.parquet
  size:    15 KB
  rows:    287

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-07-17 18:00:00	ES	Futures	2337.08	2343.86	2336.0	2341.97	21562.0
2016-07-17 19:00:00	ES	Futures	2341.69	2342.24	2337.9	2338.71	8078.0
2016-07-17 20:00:00	ES	Futures	2338.71	2339.8	2338.17	2338.44	3748.0
2016-07-17 21:00:00	ES	Futures	2338.71	2341.42	2338.44	2338.71	5952.0
2016-07-17 22:00:00	ES	Futures	2338.98	2340.88	2338.17	2338.71	4563.0
2016-07-17 23:00:00	ES	Futures	2338.71	2339.8	2337.9	2338.71	4403.0
2016-07-17 18:00:00	NQ	Futures	5460.3	5478.49	5456.73	5471.33	2567.0
2016-07-17 19:00:00	NQ	Futures	5471.33	5472.52	5464.78	5467.46	1422.0
2016-07-17 20:00:00	NQ	Futures	5467.46	5470.44	5465.97	5466.86	755.0
2016-07-17 21:00:00	NQ	Futures	5466.86	5475.21	5466.27	5468.35	1262.0
2016-07-17 22:00:00	NQ	Futures	5468.05	5472.52	5465.37	5466.56	1509.0
2016-07-17 23:00:00	NQ	Futures	5466.27	5468.35	5463.29	5466.27	1261.0
2016-07-17 18:00:00	YM	Futures	19829.1	19881.8	19824.8	19864.6	2369.0
2016-07-17 19:00:00	YM	Futures	19864.6	19866.7	19839.8	19847.4	1047.0
2016-07-17 20:00:00	YM	Futures	19847.4	19854.9	19842.0	19847.4	519.0
2016-07-17 21:00:00	YM	Futures	19845.2	19870.0	19844.1	19847.4	1213.0
2016-07-17 22:00:00	YM	Futures	19848.4	19863.5	19847.4	19849.5	602.0
2016-07-17 23:00:00	YM	Futures	19849.5	19864.6	19835.5	19844.1	3595.0
2016-07-17 18:00:00	CL	Futures	48.29	48.3	47.82	48.06	3079.0
2016-07-17 19:00:00	CL	Futures	48.04	48.13	47.98	48.08	1403.0
2016-07-17 20:00:00	CL	Futures	48.07	48.09	47.91	48.03	1713.0
2016-07-17 21:00:00	CL	Futures	48.02	48.11	47.92	48.06	2042.0
2016-07-17 22:00:00	CL	Futures	48.06	48.2	48.02	48.18	2611.0
2016-07-17 23:00:00	CL	Futures	48.17	48.24	48.15	48.21	2233.0
2016-07-17 18:00:00	GC	Futures	1814.6	1816.6	1810.2	1811.6	3479.0
2016-07-17 19:00:00	GC	Futures	1811.7	1815.7	1810.9	1814.3	2260.0
2016-07-17 20:00:00	GC	Futures	1814.5	1816.8	1812.5	1813.9	4600.0
2016-07-17 21:00:00	GC	Futures	1813.9	1813.9	1801.9	1806.4	12852.0
2016-07-17 22:00:00	GC	Futures	1806.3	1811.7	1804.7	1809.0	5534.0
2016-07-17 23:00:00	GC	Futures	1809.0	1811.5	1808.2	1808.3	2004.0
2016-07-17 18:00:00	ZN	Futures	128.477419	128.53828	128.279621	128.431774	24255.0
2016-07-17 19:00:00	ZN	Futures	128.431774	128.492635	128.416558	128.492635	6408.0
2016-07-17 20:00:00	ZN	Futures	128.492635	128.523065	128.462204	128.50785	4691.0
2016-07-17 21:00:00	ZN	Futures	128.492635	128.583926	128.462204	128.553495	9366.0
2016-07-17 22:00:00	ZN	Futures	128.553495	128.568711	128.477419	128.50785	3468.0
2016-07-17 23:00:00	ZN	Futures	128.523065	128.53828	128.492635	128.523065	1222.0

> showing 36 of 287 rows — these rows as CSV

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