PREVIEW / futures_1hour / 2016-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-25.parquet
  size:    53 KB
  rows:    1,605

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-01-25 00:00:00	ES	Futures	2043.8	2045.14	2039.5	2041.65	6247.0
2016-01-25 01:00:00	ES	Futures	2041.38	2043.53	2040.58	2042.46	5379.0
2016-01-25 02:00:00	ES	Futures	2042.46	2043.26	2037.35	2040.85	18404.0
2016-01-25 03:00:00	ES	Futures	2040.85	2040.85	2029.29	2033.05	38656.0
2016-01-25 04:00:00	ES	Futures	2032.78	2038.96	2028.75	2035.47	27427.0
2016-01-25 05:00:00	ES	Futures	2035.74	2041.92	2033.86	2037.89	20945.0
2016-01-25 06:00:00	ES	Futures	2037.89	2039.23	2034.4	2037.08	14594.0
2016-01-25 07:00:00	ES	Futures	2037.08	2040.04	2036.01	2039.23	15732.0
2016-01-25 08:00:00	ES	Futures	2039.23	2039.23	2027.68	2029.29	51167.0
2016-01-25 09:00:00	ES	Futures	2029.29	2037.35	2027.95	2031.71	215993.0
2016-01-25 10:00:00	ES	Futures	2031.71	2037.62	2025.53	2027.95	246944.0
2016-01-25 11:00:00	ES	Futures	2027.95	2030.63	2022.57	2028.22	168628.0
2016-01-25 12:00:00	ES	Futures	2028.22	2032.25	2025.53	2031.98	82011.0
2016-01-25 13:00:00	ES	Futures	2031.71	2037.35	2026.33	2026.87	118442.0
2016-01-25 14:00:00	ES	Futures	2026.6	2029.56	2022.84	2024.99	127503.0
2016-01-25 15:00:00	ES	Futures	2024.72	2027.41	2007.79	2011.02	323751.0
2016-01-25 16:00:00	ES	Futures	2011.02	2012.36	2007.26	2011.82	79166.0
2016-01-25 18:00:00	ES	Futures	2011.82	2012.63	2005.11	2006.99	8285.0
2016-01-25 19:00:00	ES	Futures	2006.99	2009.41	2004.57	2006.99	15829.0
2016-01-25 20:00:00	ES	Futures	2006.99	2010.48	2004.57	2006.72	12180.0
2016-01-25 21:00:00	ES	Futures	2006.72	2011.82	2005.64	2011.56	7825.0
2016-01-25 22:00:00	ES	Futures	2011.56	2012.9	2008.06	2009.41	8876.0
2016-01-25 23:00:00	ES	Futures	2009.41	2010.48	2005.11	2005.11	5454.0
2016-01-25 00:00:00	NQ	Futures	5048.72	5051.4	5035.06	5040.71	1495.0
2016-01-25 01:00:00	NQ	Futures	5040.11	5047.54	5038.03	5044.27	1059.0
2016-01-25 02:00:00	NQ	Futures	5044.27	5046.35	5030.31	5038.92	2507.0
2016-01-25 03:00:00	NQ	Futures	5038.33	5038.33	5012.79	5023.48	7269.0
2016-01-25 04:00:00	NQ	Futures	5023.78	5038.33	5010.42	5028.53	6019.0
2016-01-25 05:00:00	NQ	Futures	5029.42	5044.27	5024.67	5033.28	4331.0
2016-01-25 06:00:00	NQ	Futures	5033.58	5036.85	5025.27	5031.5	2986.0
2016-01-25 07:00:00	NQ	Futures	5031.2	5040.11	5028.83	5039.82	2270.0
2016-01-25 08:00:00	NQ	Futures	5039.52	5040.11	5015.17	5017.55	7131.0
2016-01-25 09:00:00	NQ	Futures	5017.84	5044.86	5017.84	5035.06	41230.0
2016-01-25 10:00:00	NQ	Futures	5034.47	5049.91	5025.86	5033.58	46496.0
2016-01-25 11:00:00	NQ	Futures	5033.28	5036.55	5016.95	5028.53	27243.0
2016-01-25 12:00:00	NQ	Futures	5028.53	5047.24	5022.89	5045.16	16090.0
2016-01-25 13:00:00	NQ	Futures	5045.46	5059.41	5029.13	5029.72	20040.0
2016-01-25 14:00:00	NQ	Futures	5029.13	5033.88	5016.95	5024.67	21204.0
2016-01-25 15:00:00	NQ	Futures	5024.08	5032.1	4968.55	4975.38	51988.0
2016-01-25 16:00:00	NQ	Futures	4975.08	4979.84	4963.8	4976.87	8667.0
2016-01-25 18:00:00	NQ	Futures	4976.57	4978.35	4960.24	4965.29	1025.0
2016-01-25 19:00:00	NQ	Futures	4964.4	4969.44	4956.67	4964.99	2640.0
2016-01-25 20:00:00	NQ	Futures	4965.29	4973.3	4957.57	4963.5	2118.0
2016-01-25 21:00:00	NQ	Futures	4963.21	4979.24	4960.54	4977.16	1708.0
2016-01-25 22:00:00	NQ	Futures	4977.16	4982.21	4969.74	4973.01	1796.0
2016-01-25 23:00:00	NQ	Futures	4973.9	4975.68	4960.83	4960.83	1036.0
2016-01-25 00:00:00	YM	Futures	17052.9	17062.5	17018.9	17031.7	1241.0
2016-01-25 01:00:00	YM	Futures	17031.7	17050.8	17024.2	17040.2	942.0
2016-01-25 02:00:00	YM	Futures	17042.3	17043.4	16992.3	17018.9	2214.0
2016-01-25 03:00:00	YM	Futures	17018.9	17018.9	16926.3	16957.1	8215.0

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

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