PREVIEW / futures_1hour / 2016-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-01.parquet
  size:    56 KB
  rows:    1,662

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-11-01 00:00:00	ES	Futures	2316.21	2316.48	2314.58	2315.66	3581.0
2016-11-01 01:00:00	ES	Futures	2315.94	2316.48	2314.85	2315.94	3298.0
2016-11-01 02:00:00	ES	Futures	2315.94	2316.21	2315.12	2315.94	2031.0
2016-11-01 03:00:00	ES	Futures	2315.94	2317.57	2314.3	2315.12	11403.0
2016-11-01 04:00:00	ES	Futures	2314.85	2316.48	2311.86	2312.13	22604.0
2016-11-01 05:00:00	ES	Futures	2312.13	2314.58	2310.77	2314.3	17656.0
2016-11-01 06:00:00	ES	Futures	2314.03	2315.39	2313.76	2314.03	9689.0
2016-11-01 07:00:00	ES	Futures	2313.76	2314.3	2310.77	2310.77	18169.0
2016-11-01 08:00:00	ES	Futures	2310.77	2313.22	2309.95	2312.13	32388.0
2016-11-01 09:00:00	ES	Futures	2311.86	2313.22	2306.14	2306.96	188022.0
2016-11-01 10:00:00	ES	Futures	2306.96	2308.32	2299.61	2303.96	322845.0
2016-11-01 11:00:00	ES	Futures	2303.96	2304.78	2297.16	2298.25	179674.0
2016-11-01 12:00:00	ES	Futures	2298.25	2298.8	2289.27	2291.99	251921.0
2016-11-01 13:00:00	ES	Futures	2291.72	2292.81	2281.65	2283.29	236344.0
2016-11-01 14:00:00	ES	Futures	2283.29	2288.73	2275.67	2283.56	407000.0
2016-11-01 15:00:00	ES	Futures	2283.56	2293.63	2281.38	2291.18	384521.0
2016-11-01 16:00:00	ES	Futures	2291.18	2294.71	2287.64	2287.64	119420.0
2016-11-01 18:00:00	ES	Futures	2287.91	2290.36	2286.01	2287.37	8317.0
2016-11-01 19:00:00	ES	Futures	2287.37	2288.18	2286.82	2287.1	3836.0
2016-11-01 20:00:00	ES	Futures	2287.1	2288.73	2286.01	2288.46	7601.0
2016-11-01 21:00:00	ES	Futures	2288.73	2288.73	2282.74	2284.92	10978.0
2016-11-01 22:00:00	ES	Futures	2284.92	2284.92	2280.29	2280.29	10934.0
2016-11-01 23:00:00	ES	Futures	2280.29	2282.74	2279.48	2280.57	9727.0
2016-11-01 00:00:00	NQ	Futures	5745.93	5747.12	5744.44	5745.93	606.0
2016-11-01 01:00:00	NQ	Futures	5746.23	5748.02	5743.84	5746.83	642.0
2016-11-01 02:00:00	NQ	Futures	5747.12	5747.42	5743.54	5744.14	356.0
2016-11-01 03:00:00	NQ	Futures	5745.04	5747.72	5737.88	5740.26	2180.0
2016-11-01 04:00:00	NQ	Futures	5739.96	5745.33	5731.61	5732.51	3117.0
2016-11-01 05:00:00	NQ	Futures	5732.51	5739.07	5728.93	5738.17	2601.0
2016-11-01 06:00:00	NQ	Futures	5738.17	5741.75	5737.58	5738.17	1456.0
2016-11-01 07:00:00	NQ	Futures	5738.17	5739.07	5730.12	5730.42	3221.0
2016-11-01 08:00:00	NQ	Futures	5730.12	5735.19	5728.93	5734.3	4765.0
2016-11-01 09:00:00	NQ	Futures	5734.3	5737.28	5715.2	5719.98	24594.0
2016-11-01 10:00:00	NQ	Futures	5720.57	5725.05	5697.3	5710.43	45546.0
2016-11-01 11:00:00	NQ	Futures	5710.43	5716.69	5700.29	5702.08	24155.0
2016-11-01 12:00:00	NQ	Futures	5702.37	5703.57	5676.12	5680.6	31912.0
2016-11-01 13:00:00	NQ	Futures	5680.6	5682.39	5648.97	5654.94	37833.0
2016-11-01 14:00:00	NQ	Futures	5654.64	5668.66	5631.07	5655.54	56640.0
2016-11-01 15:00:00	NQ	Futures	5655.54	5683.28	5650.46	5680.6	50960.0
2016-11-01 16:00:00	NQ	Futures	5680.6	5690.44	5674.33	5674.63	10728.0
2016-11-01 18:00:00	NQ	Futures	5673.73	5680.3	5670.75	5674.33	2144.0
2016-11-01 19:00:00	NQ	Futures	5674.33	5676.72	5672.24	5674.63	1182.0
2016-11-01 20:00:00	NQ	Futures	5674.63	5677.31	5671.05	5676.12	1098.0
2016-11-01 21:00:00	NQ	Futures	5675.82	5676.12	5662.4	5667.77	1932.0
2016-11-01 22:00:00	NQ	Futures	5667.47	5667.47	5654.94	5655.83	1833.0
2016-11-01 23:00:00	NQ	Futures	5655.83	5660.61	5653.45	5655.24	1399.0
2016-11-01 00:00:00	YM	Futures	19580.2	19583.4	19569.4	19576.9	688.0
2016-11-01 01:00:00	YM	Futures	19576.9	19581.3	19568.3	19579.1	815.0
2016-11-01 02:00:00	YM	Futures	19579.1	19580.2	19573.7	19574.8	631.0
2016-11-01 03:00:00	YM	Futures	19575.9	19589.9	19570.5	19575.9	2320.0

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

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