PREVIEW / futures_1hour / 2016-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-18.parquet
  size:    52 KB
  rows:    1,611

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-10-18 00:00:00	ES	Futures	2317.02	2317.84	2316.21	2317.02	2762.0
2016-10-18 01:00:00	ES	Futures	2317.02	2320.02	2316.48	2318.93	6803.0
2016-10-18 02:00:00	ES	Futures	2318.93	2319.47	2317.57	2318.66	7165.0
2016-10-18 03:00:00	ES	Futures	2318.93	2322.19	2317.84	2321.92	23119.0
2016-10-18 04:00:00	ES	Futures	2321.65	2324.1	2320.83	2321.92	18336.0
2016-10-18 05:00:00	ES	Futures	2321.92	2322.74	2321.11	2321.65	9942.0
2016-10-18 06:00:00	ES	Futures	2321.38	2322.74	2320.02	2321.38	11741.0
2016-10-18 07:00:00	ES	Futures	2321.38	2325.46	2320.83	2324.1	21694.0
2016-10-18 08:00:00	ES	Futures	2324.37	2328.72	2323.01	2326.0	46529.0
2016-10-18 09:00:00	ES	Futures	2326.0	2328.18	2319.75	2321.38	193110.0
2016-10-18 10:00:00	ES	Futures	2321.38	2322.47	2317.02	2321.38	161201.0
2016-10-18 11:00:00	ES	Futures	2321.11	2327.09	2320.56	2326.82	138600.0
2016-10-18 12:00:00	ES	Futures	2326.82	2327.36	2323.83	2324.64	78118.0
2016-10-18 13:00:00	ES	Futures	2324.92	2326.0	2323.28	2325.19	58916.0
2016-10-18 14:00:00	ES	Futures	2325.19	2326.82	2323.55	2325.73	65782.0
2016-10-18 15:00:00	ES	Futures	2325.73	2326.28	2321.11	2321.38	160270.0
2016-10-18 16:00:00	ES	Futures	2321.38	2321.92	2318.11	2320.29	88948.0
2016-10-18 18:00:00	ES	Futures	2319.75	2321.38	2319.47	2320.56	4910.0
2016-10-18 19:00:00	ES	Futures	2320.56	2321.11	2320.29	2320.56	1471.0
2016-10-18 20:00:00	ES	Futures	2320.83	2321.92	2320.29	2320.56	3476.0
2016-10-18 21:00:00	ES	Futures	2320.83	2322.74	2320.56	2321.92	5687.0
2016-10-18 22:00:00	ES	Futures	2321.92	2324.1	2321.38	2323.01	6589.0
2016-10-18 23:00:00	ES	Futures	2322.74	2323.55	2322.19	2322.74	2310.0
2016-10-18 00:00:00	NQ	Futures	5748.32	5750.41	5747.42	5748.32	457.0
2016-10-18 01:00:00	NQ	Futures	5748.62	5755.48	5747.72	5754.58	1257.0
2016-10-18 02:00:00	NQ	Futures	5754.28	5756.67	5751.0	5753.99	1880.0
2016-10-18 03:00:00	NQ	Futures	5754.28	5762.94	5750.41	5762.64	4259.0
2016-10-18 04:00:00	NQ	Futures	5762.34	5768.6	5759.95	5764.73	3475.0
2016-10-18 05:00:00	NQ	Futures	5764.43	5767.41	5762.34	5763.83	2390.0
2016-10-18 06:00:00	NQ	Futures	5763.83	5766.22	5760.25	5762.04	1849.0
2016-10-18 07:00:00	NQ	Futures	5762.34	5772.48	5760.85	5771.59	4064.0
2016-10-18 08:00:00	NQ	Futures	5771.89	5785.61	5769.2	5781.73	10602.0
2016-10-18 09:00:00	NQ	Futures	5782.03	5788.29	5772.18	5777.55	38730.0
2016-10-18 10:00:00	NQ	Futures	5777.55	5780.84	5765.02	5778.75	27662.0
2016-10-18 11:00:00	NQ	Futures	5778.75	5792.17	5777.85	5791.58	21533.0
2016-10-18 12:00:00	NQ	Futures	5791.87	5795.75	5787.1	5790.08	14781.0
2016-10-18 13:00:00	NQ	Futures	5789.79	5791.58	5784.71	5788.0	10575.0
2016-10-18 14:00:00	NQ	Futures	5787.7	5791.87	5784.42	5787.4	10705.0
2016-10-18 15:00:00	NQ	Futures	5787.7	5788.59	5767.71	5768.01	28305.0
2016-10-18 16:00:00	NQ	Futures	5768.01	5771.29	5754.88	5759.06	13236.0
2016-10-18 18:00:00	NQ	Futures	5756.37	5760.25	5753.39	5759.36	1304.0
2016-10-18 19:00:00	NQ	Futures	5759.36	5759.95	5757.86	5758.76	315.0
2016-10-18 20:00:00	NQ	Futures	5758.46	5762.64	5757.57	5759.06	567.0
2016-10-18 21:00:00	NQ	Futures	5759.06	5765.02	5758.76	5762.64	1014.0
2016-10-18 22:00:00	NQ	Futures	5763.53	5767.71	5761.15	5764.73	831.0
2016-10-18 23:00:00	NQ	Futures	5764.73	5767.11	5763.83	5764.73	344.0
2016-10-18 00:00:00	YM	Futures	19503.4	19506.7	19498.0	19502.4	347.0
2016-10-18 01:00:00	YM	Futures	19501.3	19534.8	19499.1	19519.7	2061.0
2016-10-18 02:00:00	YM	Futures	19519.7	19526.1	19509.9	19517.5	1431.0
2016-10-18 03:00:00	YM	Futures	19518.6	19539.1	19509.9	19531.5	3778.0

> showing 50 of 1,611 rows — these rows as CSV

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