PREVIEW / futures_1hour / 2016-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-10.parquet
  size:    51 KB
  rows:    1,574

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-08-10 00:00:00	ES	Futures	2360.68	2361.49	2360.68	2360.95	1940.0
2016-08-10 01:00:00	ES	Futures	2360.68	2360.95	2360.14	2360.41	3681.0
2016-08-10 02:00:00	ES	Futures	2360.41	2361.22	2360.14	2360.41	6194.0
2016-08-10 03:00:00	ES	Futures	2360.41	2364.75	2359.59	2362.3	23339.0
2016-08-10 04:00:00	ES	Futures	2362.58	2365.02	2362.3	2364.2	14441.0
2016-08-10 05:00:00	ES	Futures	2364.2	2366.37	2362.85	2363.39	16629.0
2016-08-10 06:00:00	ES	Futures	2363.66	2364.2	2362.85	2362.85	10065.0
2016-08-10 07:00:00	ES	Futures	2362.85	2366.1	2362.85	2364.2	15384.0
2016-08-10 08:00:00	ES	Futures	2364.47	2365.83	2364.2	2365.29	22302.0
2016-08-10 09:00:00	ES	Futures	2365.29	2365.83	2359.32	2359.32	171420.0
2016-08-10 10:00:00	ES	Futures	2359.59	2363.12	2359.05	2360.41	205383.0
2016-08-10 11:00:00	ES	Futures	2360.68	2362.3	2353.9	2354.71	217225.0
2016-08-10 12:00:00	ES	Futures	2354.71	2358.24	2354.17	2358.24	99015.0
2016-08-10 13:00:00	ES	Futures	2357.97	2358.24	2354.98	2355.53	90362.0
2016-08-10 14:00:00	ES	Futures	2355.53	2357.42	2351.46	2353.08	159803.0
2016-08-10 15:00:00	ES	Futures	2352.81	2357.15	2352.0	2356.07	217862.0
2016-08-10 16:00:00	ES	Futures	2356.07	2357.97	2355.8	2356.88	65004.0
2016-08-10 18:00:00	ES	Futures	2356.61	2356.61	2353.9	2355.25	4174.0
2016-08-10 19:00:00	ES	Futures	2355.25	2355.8	2354.98	2354.98	1079.0
2016-08-10 20:00:00	ES	Futures	2355.25	2355.8	2354.71	2355.25	2458.0
2016-08-10 21:00:00	ES	Futures	2354.98	2357.69	2354.98	2357.42	3585.0
2016-08-10 22:00:00	ES	Futures	2357.42	2357.69	2356.61	2356.88	2980.0
2016-08-10 23:00:00	ES	Futures	2356.88	2357.42	2356.88	2357.42	1879.0
2016-08-10 00:00:00	NQ	Futures	5709.18	5711.86	5709.18	5709.48	364.0
2016-08-10 01:00:00	NQ	Futures	5709.77	5710.37	5706.5	5707.39	550.0
2016-08-10 02:00:00	NQ	Futures	5706.79	5709.77	5706.2	5706.2	887.0
2016-08-10 03:00:00	NQ	Futures	5706.2	5719.31	5705.0	5713.05	2147.0
2016-08-10 04:00:00	NQ	Futures	5713.65	5719.61	5713.35	5718.12	1093.0
2016-08-10 05:00:00	NQ	Futures	5718.12	5722.89	5713.95	5715.14	1404.0
2016-08-10 06:00:00	NQ	Futures	5714.84	5717.23	5713.65	5714.24	678.0
2016-08-10 07:00:00	NQ	Futures	5714.24	5721.99	5713.95	5718.42	1466.0
2016-08-10 08:00:00	NQ	Futures	5718.12	5721.7	5717.82	5720.5	1993.0
2016-08-10 09:00:00	NQ	Futures	5720.5	5721.7	5704.41	5704.71	22117.0
2016-08-10 10:00:00	NQ	Futures	5704.41	5717.23	5703.22	5706.2	24676.0
2016-08-10 11:00:00	NQ	Futures	5705.9	5709.77	5683.55	5690.1	25594.0
2016-08-10 12:00:00	NQ	Futures	5690.1	5703.51	5688.91	5702.62	12047.0
2016-08-10 13:00:00	NQ	Futures	5702.92	5703.51	5695.77	5697.26	9029.0
2016-08-10 14:00:00	NQ	Futures	5696.96	5701.43	5688.31	5692.49	13085.0
2016-08-10 15:00:00	NQ	Futures	5692.49	5703.22	5690.4	5699.04	17123.0
2016-08-10 16:00:00	NQ	Futures	5698.75	5702.32	5697.55	5700.53	3803.0
2016-08-10 18:00:00	NQ	Futures	5701.43	5701.43	5693.68	5696.96	695.0
2016-08-10 19:00:00	NQ	Futures	5696.96	5697.85	5695.17	5696.06	255.0
2016-08-10 20:00:00	NQ	Futures	5696.36	5697.26	5694.87	5695.77	249.0
2016-08-10 21:00:00	NQ	Futures	5695.47	5702.32	5695.47	5701.73	615.0
2016-08-10 22:00:00	NQ	Futures	5701.43	5702.32	5698.15	5699.64	559.0
2016-08-10 23:00:00	NQ	Futures	5698.45	5701.13	5698.45	5701.13	163.0
2016-08-10 00:00:00	YM	Futures	19862.4	19866.7	19861.4	19862.4	438.0
2016-08-10 01:00:00	YM	Futures	19863.5	19864.6	19853.8	19857.1	742.0
2016-08-10 02:00:00	YM	Futures	19857.1	19863.5	19853.8	19854.9	831.0
2016-08-10 03:00:00	YM	Futures	19856.0	19891.5	19851.7	19875.4	2369.0

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

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