PREVIEW / futures_1hour / 2015-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-28.parquet
  size:    53 KB
  rows:    1,571

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-28 00:00:00	ES	Futures	2050.71	2052.85	2050.44	2051.51	4894.0
2015-09-28 01:00:00	ES	Futures	2051.24	2055.26	2050.71	2054.45	7003.0
2015-09-28 02:00:00	ES	Futures	2054.45	2061.41	2052.31	2060.61	17016.0
2015-09-28 03:00:00	ES	Futures	2060.61	2065.42	2055.79	2056.59	36440.0
2015-09-28 04:00:00	ES	Futures	2056.86	2060.34	2048.83	2051.24	24552.0
2015-09-28 05:00:00	ES	Futures	2051.24	2052.31	2043.22	2044.55	28345.0
2015-09-28 06:00:00	ES	Futures	2044.55	2047.5	2037.6	2040.54	34747.0
2015-09-28 07:00:00	ES	Futures	2040.81	2046.69	2035.99	2039.47	58061.0
2015-09-28 08:00:00	ES	Futures	2039.74	2046.43	2038.93	2044.55	49559.0
2015-09-28 09:00:00	ES	Futures	2044.55	2047.23	2032.78	2033.31	239847.0
2015-09-28 10:00:00	ES	Futures	2033.31	2034.65	2025.82	2031.71	308073.0
2015-09-28 11:00:00	ES	Futures	2031.44	2035.19	2018.87	2019.4	267189.0
2015-09-28 12:00:00	ES	Futures	2019.13	2020.2	2010.84	2011.37	224256.0
2015-09-28 13:00:00	ES	Futures	2011.11	2017.53	2007.9	2007.9	218842.0
2015-09-28 14:00:00	ES	Futures	2007.9	2013.25	2001.47	2005.75	287696.0
2015-09-28 15:00:00	ES	Futures	2005.75	2011.11	2000.14	2002.81	357742.0
2015-09-28 16:00:00	ES	Futures	2003.08	2008.16	2002.01	2006.56	107824.0
2015-09-28 18:00:00	ES	Futures	2008.16	2011.37	2006.82	2009.77	7674.0
2015-09-28 19:00:00	ES	Futures	2009.77	2010.84	2008.43	2009.77	3800.0
2015-09-28 20:00:00	ES	Futures	2009.5	2010.04	2003.08	2004.95	12114.0
2015-09-28 21:00:00	ES	Futures	2004.95	2005.22	1996.66	2003.08	22061.0
2015-09-28 22:00:00	ES	Futures	2003.35	2005.49	2000.94	2001.74	8757.0
2015-09-28 23:00:00	ES	Futures	2002.01	2004.42	1999.07	2000.14	5475.0
2015-09-28 00:00:00	NQ	Futures	4988.46	4992.61	4986.39	4988.46	1006.0
2015-09-28 01:00:00	NQ	Futures	4989.05	4999.73	4988.16	4997.06	1430.0
2015-09-28 02:00:00	NQ	Futures	4997.36	5015.74	4991.72	5013.66	3086.0
2015-09-28 03:00:00	NQ	Futures	5013.96	5027.3	4992.32	4993.8	11157.0
2015-09-28 04:00:00	NQ	Futures	4993.5	5004.47	4975.12	4980.46	4557.0
2015-09-28 05:00:00	NQ	Futures	4980.75	4984.01	4963.85	4967.41	3590.0
2015-09-28 06:00:00	NQ	Futures	4968.3	4976.31	4951.4	4961.78	5279.0
2015-09-28 07:00:00	NQ	Futures	4961.78	4975.42	4951.4	4957.03	8595.0
2015-09-28 08:00:00	NQ	Futures	4957.33	4975.42	4954.96	4971.56	8934.0
2015-09-28 09:00:00	NQ	Futures	4971.86	4980.16	4928.87	4929.16	46010.0
2015-09-28 10:00:00	NQ	Futures	4930.05	4936.28	4910.19	4929.76	43706.0
2015-09-28 11:00:00	NQ	Futures	4929.46	4939.84	4892.4	4892.4	38819.0
2015-09-28 12:00:00	NQ	Futures	4892.1	4897.74	4873.13	4874.31	32924.0
2015-09-28 13:00:00	NQ	Futures	4873.72	4893.29	4858.01	4858.89	34235.0
2015-09-28 14:00:00	NQ	Futures	4859.19	4876.98	4838.14	4856.82	45004.0
2015-09-28 15:00:00	NQ	Futures	4856.52	4875.79	4842.59	4852.08	52374.0
2015-09-28 16:00:00	NQ	Futures	4852.08	4866.6	4850.89	4863.94	10730.0
2015-09-28 18:00:00	NQ	Futures	4869.87	4873.72	4863.94	4869.27	1507.0
2015-09-28 19:00:00	NQ	Futures	4869.87	4871.35	4864.53	4867.79	582.0
2015-09-28 20:00:00	NQ	Futures	4867.79	4868.09	4850.89	4857.41	1823.0
2015-09-28 21:00:00	NQ	Futures	4857.41	4858.3	4838.44	4853.56	4702.0
2015-09-28 22:00:00	NQ	Futures	4854.45	4861.27	4846.74	4849.41	3161.0
2015-09-28 23:00:00	NQ	Futures	4848.81	4856.82	4841.7	4844.07	1162.0
2015-09-28 00:00:00	YM	Futures	17141.9	17156.7	17137.7	17147.2	614.0
2015-09-28 01:00:00	YM	Futures	17147.2	17175.8	17139.8	17163.1	1382.0
2015-09-28 02:00:00	YM	Futures	17165.2	17221.3	17148.3	17216.0	3050.0
2015-09-28 03:00:00	YM	Futures	17213.9	17254.2	17180.0	17187.4	5004.0

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

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