PREVIEW / futures_1hour / 2015-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-07.parquet
  size:    36 KB
  rows:    1,052

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
2015-09-07 00:00:00	ES	Futures	2066.89	2068.22	2062.09	2062.89	3286.0
2015-09-07 01:00:00	ES	Futures	2062.89	2063.42	2058.37	2058.63	4896.0
2015-09-07 02:00:00	ES	Futures	2058.9	2067.95	2058.37	2063.69	12729.0
2015-09-07 03:00:00	ES	Futures	2063.96	2068.75	2060.76	2063.69	22027.0
2015-09-07 04:00:00	ES	Futures	2063.96	2066.09	2058.63	2058.63	12070.0
2015-09-07 05:00:00	ES	Futures	2058.63	2060.5	2055.17	2058.63	8982.0
2015-09-07 06:00:00	ES	Futures	2058.63	2061.03	2055.17	2057.83	7110.0
2015-09-07 07:00:00	ES	Futures	2057.83	2059.96	2055.7	2056.5	5348.0
2015-09-07 08:00:00	ES	Futures	2056.5	2058.1	2054.64	2057.83	6418.0
2015-09-07 09:00:00	ES	Futures	2058.1	2059.43	2055.97	2058.1	6370.0
2015-09-07 10:00:00	ES	Futures	2058.37	2058.37	2055.44	2057.57	8113.0
2015-09-07 11:00:00	ES	Futures	2057.83	2061.83	2057.83	2059.96	10695.0
2015-09-07 12:00:00	ES	Futures	2060.23	2060.5	2052.77	2056.5	9151.0
2015-09-07 18:00:00	ES	Futures	2055.44	2060.5	2055.44	2057.57	4536.0
2015-09-07 19:00:00	ES	Futures	2057.57	2065.02	2056.24	2064.76	8627.0
2015-09-07 20:00:00	ES	Futures	2065.02	2068.22	2063.16	2065.55	11668.0
2015-09-07 21:00:00	ES	Futures	2065.82	2067.95	2058.9	2061.03	13322.0
2015-09-07 22:00:00	ES	Futures	2061.03	2065.29	2060.76	2063.42	8337.0
2015-09-07 23:00:00	ES	Futures	2063.42	2063.42	2056.24	2058.63	10012.0
2015-09-07 00:00:00	NQ	Futures	5011.86	5016.29	5004.17	5008.31	821.0
2015-09-07 01:00:00	NQ	Futures	5009.19	5010.08	4991.74	4994.4	1049.0
2015-09-07 02:00:00	NQ	Futures	4993.22	5013.63	4991.15	5006.53	1421.0
2015-09-07 03:00:00	NQ	Futures	5006.83	5015.41	4997.07	5004.46	3797.0
2015-09-07 04:00:00	NQ	Futures	5004.76	5009.49	4993.52	4993.81	1623.0
2015-09-07 05:00:00	NQ	Futures	4993.22	4994.7	4984.64	4992.33	1600.0
2015-09-07 06:00:00	NQ	Futures	4992.33	4996.47	4981.98	4989.97	1175.0
2015-09-07 07:00:00	NQ	Futures	4990.26	4995.29	4984.94	4987.9	876.0
2015-09-07 08:00:00	NQ	Futures	4988.19	4992.93	4985.53	4992.33	1642.0
2015-09-07 09:00:00	NQ	Futures	4992.04	4993.22	4983.16	4983.76	3097.0
2015-09-07 10:00:00	NQ	Futures	4984.05	4984.64	4976.95	4981.09	3539.0
2015-09-07 11:00:00	NQ	Futures	4981.69	4991.74	4981.69	4988.49	2572.0
2015-09-07 12:00:00	NQ	Futures	4988.78	4989.38	4971.63	4982.87	1589.0
2015-09-07 18:00:00	NQ	Futures	4980.8	4991.45	4973.99	4984.94	579.0
2015-09-07 19:00:00	NQ	Futures	4985.83	5002.09	4982.87	5001.8	1206.0
2015-09-07 20:00:00	NQ	Futures	5001.8	5008.31	4995.0	5001.8	2580.0
2015-09-07 21:00:00	NQ	Futures	5001.5	5006.53	4988.19	4992.63	2127.0
2015-09-07 22:00:00	NQ	Futures	4992.04	5002.98	4991.15	4997.36	1483.0
2015-09-07 23:00:00	NQ	Futures	4997.07	4997.95	4979.02	4983.76	1565.0
2015-09-07 00:00:00	YM	Futures	17126.1	17132.4	17098.7	17105.0	549.0
2015-09-07 01:00:00	YM	Futures	17105.0	17108.2	17062.9	17062.9	1003.0
2015-09-07 02:00:00	YM	Futures	17066.1	17124.0	17056.6	17097.7	1248.0
2015-09-07 03:00:00	YM	Futures	17098.7	17138.7	17078.7	17101.9	2286.0
2015-09-07 04:00:00	YM	Futures	17100.8	17116.6	17059.7	17060.8	1813.0
2015-09-07 05:00:00	YM	Futures	17058.7	17074.5	17037.6	17054.5	2039.0
2015-09-07 06:00:00	YM	Futures	17056.6	17072.4	17030.2	17048.1	1399.0
2015-09-07 07:00:00	YM	Futures	17049.2	17066.1	17030.2	17034.5	1471.0
2015-09-07 08:00:00	YM	Futures	17036.6	17050.3	17023.9	17047.1	1254.0
2015-09-07 09:00:00	YM	Futures	17049.2	17060.8	17039.7	17053.4	2066.0
2015-09-07 10:00:00	YM	Futures	17054.5	17054.5	17031.3	17043.9	2186.0
2015-09-07 11:00:00	YM	Futures	17045.0	17085.0	17045.0	17067.1	2455.0

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

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