PREVIEW / futures_1hour / 2016-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-29.parquet
  size:    49 KB
  rows:    1,529

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-29 00:00:00	ES	Futures	2350.37	2350.92	2349.83	2350.37	1135.0
2016-08-29 01:00:00	ES	Futures	2350.37	2351.19	2350.1	2350.92	2331.0
2016-08-29 02:00:00	ES	Futures	2351.19	2351.46	2350.1	2350.64	4644.0
2016-08-29 03:00:00	ES	Futures	2350.64	2352.27	2348.2	2348.47	27542.0
2016-08-29 04:00:00	ES	Futures	2348.47	2352.0	2348.2	2350.64	15268.0
2016-08-29 05:00:00	ES	Futures	2350.92	2351.46	2348.75	2351.46	12954.0
2016-08-29 06:00:00	ES	Futures	2351.46	2353.36	2351.19	2353.08	9312.0
2016-08-29 07:00:00	ES	Futures	2352.81	2353.08	2352.0	2352.54	9315.0
2016-08-29 08:00:00	ES	Futures	2352.54	2355.8	2352.27	2354.44	20918.0
2016-08-29 09:00:00	ES	Futures	2354.44	2361.76	2353.08	2360.68	215478.0
2016-08-29 10:00:00	ES	Futures	2360.41	2363.12	2359.59	2361.49	207317.0
2016-08-29 11:00:00	ES	Futures	2361.49	2366.1	2360.95	2365.29	154087.0
2016-08-29 12:00:00	ES	Futures	2365.29	2366.37	2363.93	2365.83	85020.0
2016-08-29 13:00:00	ES	Futures	2366.1	2367.19	2365.02	2366.64	72915.0
2016-08-29 14:00:00	ES	Futures	2366.64	2366.92	2363.66	2365.02	107821.0
2016-08-29 15:00:00	ES	Futures	2365.02	2365.83	2362.85	2363.93	167817.0
2016-08-29 16:00:00	ES	Futures	2363.66	2365.02	2362.85	2364.75	78895.0
2016-08-29 18:00:00	ES	Futures	2364.75	2365.29	2363.93	2365.02	2833.0
2016-08-29 19:00:00	ES	Futures	2365.02	2365.56	2364.47	2364.75	2297.0
2016-08-29 20:00:00	ES	Futures	2365.02	2365.56	2364.47	2365.02	2944.0
2016-08-29 21:00:00	ES	Futures	2365.02	2365.56	2364.47	2364.47	2838.0
2016-08-29 22:00:00	ES	Futures	2364.47	2364.75	2363.66	2363.93	2783.0
2016-08-29 23:00:00	ES	Futures	2363.93	2364.2	2363.39	2363.39	3370.0
2016-08-29 00:00:00	NQ	Futures	5699.04	5700.24	5697.26	5698.45	193.0
2016-08-29 01:00:00	NQ	Futures	5698.15	5701.43	5697.85	5700.24	382.0
2016-08-29 02:00:00	NQ	Futures	5700.83	5702.32	5698.15	5699.04	820.0
2016-08-29 03:00:00	NQ	Futures	5699.04	5704.11	5693.38	5695.77	4030.0
2016-08-29 04:00:00	NQ	Futures	5695.77	5706.2	5694.28	5702.32	2446.0
2016-08-29 05:00:00	NQ	Futures	5702.02	5703.51	5696.66	5702.62	1184.0
2016-08-29 06:00:00	NQ	Futures	5703.22	5706.5	5701.73	5705.9	1253.0
2016-08-29 07:00:00	NQ	Futures	5705.9	5706.5	5703.51	5704.71	1361.0
2016-08-29 08:00:00	NQ	Futures	5704.71	5711.56	5704.11	5709.77	2677.0
2016-08-29 09:00:00	NQ	Futures	5709.77	5721.99	5706.2	5717.23	27824.0
2016-08-29 10:00:00	NQ	Futures	5717.23	5720.21	5708.28	5711.86	20648.0
2016-08-29 11:00:00	NQ	Futures	5711.86	5726.76	5709.77	5723.78	17558.0
2016-08-29 12:00:00	NQ	Futures	5724.08	5728.85	5721.7	5728.55	10395.0
2016-08-29 13:00:00	NQ	Futures	5728.85	5729.45	5724.38	5726.46	7581.0
2016-08-29 14:00:00	NQ	Futures	5726.46	5727.95	5718.42	5721.99	9928.0
2016-08-29 15:00:00	NQ	Futures	5721.99	5722.89	5712.16	5712.75	25574.0
2016-08-29 16:00:00	NQ	Futures	5712.75	5717.82	5711.56	5716.33	5326.0
2016-08-29 18:00:00	NQ	Futures	5716.63	5717.82	5714.84	5717.52	254.0
2016-08-29 19:00:00	NQ	Futures	5717.82	5718.42	5716.63	5718.12	293.0
2016-08-29 20:00:00	NQ	Futures	5717.82	5720.21	5717.23	5719.31	453.0
2016-08-29 21:00:00	NQ	Futures	5719.31	5720.8	5717.23	5718.42	807.0
2016-08-29 22:00:00	NQ	Futures	5718.42	5718.42	5715.73	5716.03	398.0
2016-08-29 23:00:00	NQ	Futures	5715.73	5715.73	5713.35	5714.54	505.0
2016-08-29 00:00:00	YM	Futures	19776.3	19777.4	19768.8	19773.1	276.0
2016-08-29 01:00:00	YM	Futures	19773.1	19779.6	19772.0	19775.3	391.0
2016-08-29 02:00:00	YM	Futures	19777.4	19780.6	19769.9	19769.9	675.0
2016-08-29 03:00:00	YM	Futures	19771.0	19785.0	19750.5	19754.8	3286.0

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

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