PREVIEW / futures_1hour / 2016-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-14.parquet
  size:    51 KB
  rows:    1,578

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-09-14 00:00:00	ES	Futures	2314.58	2314.85	2313.22	2314.3	2946.0
2016-09-14 01:00:00	ES	Futures	2314.3	2315.39	2314.03	2314.85	3599.0
2016-09-14 02:00:00	ES	Futures	2314.58	2316.75	2313.22	2316.21	11021.0
2016-09-14 03:00:00	ES	Futures	2316.48	2316.75	2308.59	2311.04	39268.0
2016-09-14 04:00:00	ES	Futures	2310.77	2317.57	2310.49	2315.39	26250.0
2016-09-14 05:00:00	ES	Futures	2315.66	2315.66	2309.68	2312.67	29462.0
2016-09-14 06:00:00	ES	Futures	2312.67	2313.22	2310.77	2311.31	14856.0
2016-09-14 07:00:00	ES	Futures	2311.04	2316.48	2311.04	2313.76	21766.0
2016-09-14 08:00:00	ES	Futures	2313.76	2315.39	2312.13	2314.03	32653.0
2016-09-14 09:00:00	ES	Futures	2314.03	2314.03	2304.51	2310.49	314823.0
2016-09-14 10:00:00	ES	Futures	2310.49	2323.01	2309.41	2312.94	382929.0
2016-09-14 11:00:00	ES	Futures	2312.94	2317.57	2309.68	2315.66	257544.0
2016-09-14 12:00:00	ES	Futures	2315.66	2318.11	2311.31	2312.94	140513.0
2016-09-14 13:00:00	ES	Futures	2313.22	2315.39	2307.23	2308.59	152362.0
2016-09-14 14:00:00	ES	Futures	2308.59	2310.22	2301.79	2308.05	226635.0
2016-09-14 15:00:00	ES	Futures	2308.05	2308.86	2298.52	2305.6	364689.0
2016-09-14 16:00:00	ES	Futures	2305.6	2306.69	2299.07	2302.6	89997.0
2016-09-14 18:00:00	ES	Futures	2301.79	2303.15	2301.52	2303.15	4760.0
2016-09-14 19:00:00	ES	Futures	2303.15	2305.05	2302.88	2304.51	2638.0
2016-09-14 20:00:00	ES	Futures	2304.51	2304.78	2302.33	2302.6	3813.0
2016-09-14 21:00:00	ES	Futures	2302.6	2303.42	2295.26	2295.53	11603.0
2016-09-14 22:00:00	ES	Futures	2295.53	2298.52	2293.9	2296.07	12608.0
2016-09-14 23:00:00	ES	Futures	2296.07	2299.07	2295.53	2298.8	4383.0
2016-09-14 00:00:00	NQ	Futures	5648.38	5648.67	5643.01	5646.88	484.0
2016-09-14 01:00:00	NQ	Futures	5646.88	5648.67	5646.29	5646.88	437.0
2016-09-14 02:00:00	NQ	Futures	5646.59	5653.75	5645.39	5651.66	1576.0
2016-09-14 03:00:00	NQ	Futures	5651.66	5652.85	5634.65	5641.51	5410.0
2016-09-14 04:00:00	NQ	Futures	5641.81	5659.41	5641.22	5654.04	4453.0
2016-09-14 05:00:00	NQ	Futures	5654.34	5654.34	5640.92	5649.27	2852.0
2016-09-14 06:00:00	NQ	Futures	5648.97	5650.46	5644.2	5645.99	1337.0
2016-09-14 07:00:00	NQ	Futures	5645.99	5659.12	5645.99	5653.45	2286.0
2016-09-14 08:00:00	NQ	Futures	5653.75	5657.92	5649.87	5654.34	4470.0
2016-09-14 09:00:00	NQ	Futures	5654.64	5661.5	5633.46	5658.82	47388.0
2016-09-14 10:00:00	NQ	Futures	5658.82	5689.25	5654.34	5671.94	53922.0
2016-09-14 11:00:00	NQ	Futures	5671.94	5687.76	5662.99	5682.09	45247.0
2016-09-14 12:00:00	NQ	Futures	5682.39	5689.55	5672.54	5675.23	29937.0
2016-09-14 13:00:00	NQ	Futures	5675.52	5682.98	5657.33	5663.59	32483.0
2016-09-14 14:00:00	NQ	Futures	5663.29	5669.86	5647.18	5665.98	31733.0
2016-09-14 15:00:00	NQ	Futures	5665.98	5668.07	5639.43	5658.82	42865.0
2016-09-14 16:00:00	NQ	Futures	5658.82	5660.31	5640.32	5647.48	9423.0
2016-09-14 18:00:00	NQ	Futures	5643.3	5649.87	5643.3	5648.97	567.0
2016-09-14 19:00:00	NQ	Futures	5649.27	5654.04	5648.97	5653.15	630.0
2016-09-14 20:00:00	NQ	Futures	5652.85	5652.85	5647.48	5648.08	426.0
2016-09-14 21:00:00	NQ	Futures	5648.08	5650.46	5630.18	5630.47	1703.0
2016-09-14 22:00:00	NQ	Futures	5630.77	5637.93	5628.09	5632.56	2088.0
2016-09-14 23:00:00	NQ	Futures	5632.56	5639.13	5631.67	5638.53	709.0
2016-09-14 00:00:00	YM	Futures	19504.5	19505.6	19492.6	19499.1	342.0
2016-09-14 01:00:00	YM	Futures	19499.1	19507.8	19499.1	19502.4	561.0
2016-09-14 02:00:00	YM	Futures	19502.4	19516.4	19491.6	19512.1	1246.0
2016-09-14 03:00:00	YM	Futures	19512.1	19515.3	19451.6	19471.0	4847.0

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

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