PREVIEW / futures_1hour / 2017-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-04.parquet
  size:    15 KB
  rows:    293

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
2017-06-04 18:00:00	ES	Futures	2660.69	2662.6	2660.69	2661.51	4621.0
2017-06-04 19:00:00	ES	Futures	2661.51	2661.51	2658.77	2659.87	4480.0
2017-06-04 20:00:00	ES	Futures	2659.59	2660.14	2658.23	2659.59	5556.0
2017-06-04 21:00:00	ES	Futures	2659.32	2661.23	2659.05	2659.59	4512.0
2017-06-04 22:00:00	ES	Futures	2659.59	2661.23	2659.59	2660.69	2232.0
2017-06-04 23:00:00	ES	Futures	2660.96	2661.51	2660.14	2660.69	2058.0
2017-06-04 18:00:00	NQ	Futures	7010.17	7017.33	7009.87	7014.05	1309.0
2017-06-04 19:00:00	NQ	Futures	7013.45	7013.45	7006.89	7010.17	892.0
2017-06-04 20:00:00	NQ	Futures	7009.87	7013.45	7006.29	7011.06	1876.0
2017-06-04 21:00:00	NQ	Futures	7010.77	7013.15	7008.98	7010.17	2082.0
2017-06-04 22:00:00	NQ	Futures	7010.17	7013.15	7010.17	7012.26	1177.0
2017-06-04 23:00:00	NQ	Futures	7011.96	7014.94	7011.36	7012.85	726.0
2017-06-04 18:00:00	YM	Futures	23023.7	23048.7	23016.1	23029.1	797.0
2017-06-04 19:00:00	YM	Futures	23030.2	23030.2	23011.7	23020.4	999.0
2017-06-04 20:00:00	YM	Futures	23020.4	23024.8	23007.4	23020.4	957.0
2017-06-04 21:00:00	YM	Futures	23019.3	23033.5	23017.1	23021.5	887.0
2017-06-04 22:00:00	YM	Futures	23022.6	23030.2	23020.4	23029.1	978.0
2017-06-04 23:00:00	YM	Futures	23028.0	23041.1	23028.0	23032.4	943.0
2017-06-04 18:00:00	CL	Futures	43.65	43.77	43.6	43.64	3007.0
2017-06-04 19:00:00	CL	Futures	43.64	43.66	43.61	43.64	953.0
2017-06-04 20:00:00	CL	Futures	43.64	43.71	43.61	43.63	2418.0
2017-06-04 21:00:00	CL	Futures	43.63	43.78	43.63	43.69	4494.0
2017-06-04 22:00:00	CL	Futures	43.68	43.83	43.67	43.78	5215.0
2017-06-04 23:00:00	CL	Futures	43.78	44.3	43.77	44.13	22766.0
2017-06-04 18:00:00	GC	Futures	1717.1	1718.3	1715.2	1717.9	4915.0
2017-06-04 19:00:00	GC	Futures	1717.9	1719.0	1717.0	1717.0	3640.0
2017-06-04 20:00:00	GC	Futures	1717.0	1719.0	1716.7	1717.6	4885.0
2017-06-04 21:00:00	GC	Futures	1717.5	1719.9	1716.7	1717.2	7869.0
2017-06-04 22:00:00	GC	Futures	1717.2	1718.4	1715.5	1718.0	5770.0
2017-06-04 23:00:00	GC	Futures	1718.2	1718.6	1717.0	1717.6	2663.0
2017-06-04 18:00:00	ZN	Futures	125.841294	125.887793	125.794795	125.825794	249.0
2017-06-04 19:00:00	ZN	Futures	125.841294	125.918792	125.841294	125.856794	152.0
2017-06-04 20:00:00	ZN	Futures	125.856794	125.903292	125.841294	125.841294	195.0
2017-06-04 21:00:00	ZN	Futures	125.841294	125.856794	125.794795	125.825794	1442.0
2017-06-04 22:00:00	ZN	Futures	125.810295	125.856794	125.794795	125.825794	495.0
2017-06-04 23:00:00	ZN	Futures	125.825794	125.841294	125.794795	125.794795	22.0

> showing 36 of 293 rows — these rows as CSV

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