PREVIEW / futures_1hour / 2016-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-26.parquet
  size:    45 KB
  rows:    1,312

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-26 00:00:00	ES	Futures	2358.78	2359.32	2358.24	2359.32	1107.0
2016-08-26 01:00:00	ES	Futures	2359.05	2359.32	2357.69	2357.97	3443.0
2016-08-26 02:00:00	ES	Futures	2357.97	2359.32	2357.69	2359.32	5806.0
2016-08-26 03:00:00	ES	Futures	2359.05	2360.68	2356.88	2359.05	34098.0
2016-08-26 04:00:00	ES	Futures	2359.05	2359.05	2357.42	2358.51	12762.0
2016-08-26 05:00:00	ES	Futures	2358.51	2359.59	2357.42	2359.05	10781.0
2016-08-26 06:00:00	ES	Futures	2359.32	2359.32	2356.88	2357.15	8269.0
2016-08-26 07:00:00	ES	Futures	2357.15	2357.97	2356.61	2356.88	12833.0
2016-08-26 08:00:00	ES	Futures	2356.88	2359.05	2355.8	2357.97	23298.0
2016-08-26 09:00:00	ES	Futures	2358.24	2365.56	2357.42	2361.22	224668.0
2016-08-26 10:00:00	ES	Futures	2360.95	2372.07	2354.17	2367.19	450920.0
2016-08-26 11:00:00	ES	Futures	2367.46	2368.54	2352.81	2354.98	291863.0
2016-08-26 12:00:00	ES	Futures	2354.98	2355.25	2343.86	2350.64	400109.0
2016-08-26 13:00:00	ES	Futures	2350.37	2352.54	2344.14	2345.76	187433.0
2016-08-26 14:00:00	ES	Futures	2346.03	2349.02	2340.34	2344.95	279886.0
2016-08-26 15:00:00	ES	Futures	2344.95	2354.17	2343.59	2351.73	454064.0
2016-08-26 16:00:00	ES	Futures	2351.46	2353.36	2350.64	2350.92	84663.0
2016-08-26 00:00:00	NQ	Futures	5702.92	5703.81	5702.02	5703.51	157.0
2016-08-26 01:00:00	NQ	Futures	5703.81	5703.81	5700.53	5701.43	491.0
2016-08-26 02:00:00	NQ	Futures	5700.53	5703.51	5699.94	5702.32	1087.0
2016-08-26 03:00:00	NQ	Futures	5702.32	5706.5	5695.47	5702.32	4122.0
2016-08-26 04:00:00	NQ	Futures	5702.62	5703.22	5696.96	5702.02	1765.0
2016-08-26 05:00:00	NQ	Futures	5702.32	5703.81	5696.66	5702.32	1901.0
2016-08-26 06:00:00	NQ	Futures	5702.02	5702.32	5696.66	5697.26	971.0
2016-08-26 07:00:00	NQ	Futures	5697.26	5699.64	5696.96	5697.55	1310.0
2016-08-26 08:00:00	NQ	Futures	5697.55	5700.53	5693.68	5696.66	4292.0
2016-08-26 09:00:00	NQ	Futures	5696.36	5723.78	5693.68	5710.07	34298.0
2016-08-26 10:00:00	NQ	Futures	5709.48	5743.45	5691.0	5730.94	62431.0
2016-08-26 11:00:00	NQ	Futures	5730.64	5736.9	5697.55	5702.32	33995.0
2016-08-26 12:00:00	NQ	Futures	5702.32	5702.32	5671.62	5692.49	45476.0
2016-08-26 13:00:00	NQ	Futures	5692.49	5698.15	5678.48	5682.05	17637.0
2016-08-26 14:00:00	NQ	Futures	5682.05	5691.0	5671.92	5684.14	25296.0
2016-08-26 15:00:00	NQ	Futures	5683.84	5709.48	5681.16	5704.71	35926.0
2016-08-26 16:00:00	NQ	Futures	5704.71	5709.18	5702.32	5702.62	5402.0
2016-08-26 00:00:00	YM	Futures	19857.1	19862.4	19854.9	19861.4	231.0
2016-08-26 01:00:00	YM	Futures	19862.4	19864.6	19851.7	19852.8	544.0
2016-08-26 02:00:00	YM	Futures	19852.8	19863.5	19849.5	19862.4	1222.0
2016-08-26 03:00:00	YM	Futures	19861.4	19876.4	19839.8	19857.1	3796.0
2016-08-26 04:00:00	YM	Futures	19857.1	19861.4	19845.2	19857.1	1129.0
2016-08-26 05:00:00	YM	Futures	19856.0	19863.5	19849.5	19862.4	728.0
2016-08-26 06:00:00	YM	Futures	19862.4	19862.4	19846.3	19846.3	949.0
2016-08-26 07:00:00	YM	Futures	19846.3	19851.7	19843.1	19845.2	1031.0
2016-08-26 08:00:00	YM	Futures	19846.3	19863.5	19832.3	19856.0	2675.0
2016-08-26 09:00:00	YM	Futures	19857.1	19927.0	19854.9	19889.3	27122.0
2016-08-26 10:00:00	YM	Futures	19887.2	19967.9	19836.6	19930.2	41602.0
2016-08-26 11:00:00	YM	Futures	19931.3	19934.5	19787.1	19804.3	25286.0
2016-08-26 12:00:00	YM	Futures	19804.3	19804.3	19720.4	19775.3	29663.0
2016-08-26 13:00:00	YM	Futures	19776.3	19791.4	19729.0	19743.0	11398.0
2016-08-26 14:00:00	YM	Futures	19743.0	19763.4	19706.4	19739.8	16732.0
2016-08-26 15:00:00	YM	Futures	19738.7	19807.6	19730.1	19778.5	22994.0

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

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