PREVIEW / futures_1hour / 2016-02-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-03.parquet
  size:    56 KB
  rows:    1,639

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-02-03 00:00:00	ES	Futures	2033.32	2036.28	2031.17	2035.47	10011.0
2016-02-03 01:00:00	ES	Futures	2035.47	2036.81	2031.71	2036.01	6284.0
2016-02-03 02:00:00	ES	Futures	2036.01	2044.07	2036.01	2043.53	26597.0
2016-02-03 03:00:00	ES	Futures	2043.53	2049.71	2040.04	2048.37	48389.0
2016-02-03 04:00:00	ES	Futures	2048.1	2051.59	2038.7	2040.58	41915.0
2016-02-03 05:00:00	ES	Futures	2040.85	2042.73	2035.47	2036.01	34746.0
2016-02-03 06:00:00	ES	Futures	2036.01	2047.03	2035.74	2044.88	24374.0
2016-02-03 07:00:00	ES	Futures	2044.88	2048.91	2039.23	2040.31	31859.0
2016-02-03 08:00:00	ES	Futures	2040.31	2052.4	2039.77	2050.79	75063.0
2016-02-03 09:00:00	ES	Futures	2050.79	2053.74	2035.74	2037.35	242337.0
2016-02-03 10:00:00	ES	Futures	2037.08	2037.08	2004.57	2024.19	645568.0
2016-02-03 11:00:00	ES	Futures	2024.45	2033.86	2011.56	2027.95	439706.0
2016-02-03 12:00:00	ES	Futures	2027.95	2031.71	2018.81	2027.14	204252.0
2016-02-03 13:00:00	ES	Futures	2026.87	2030.63	2013.97	2013.97	155393.0
2016-02-03 14:00:00	ES	Futures	2013.97	2051.59	2013.97	2050.52	385931.0
2016-02-03 15:00:00	ES	Futures	2050.25	2055.36	2038.96	2048.91	308656.0
2016-02-03 16:00:00	ES	Futures	2048.64	2051.86	2048.1	2050.79	62651.0
2016-02-03 18:00:00	ES	Futures	2050.52	2054.82	2048.64	2051.32	8574.0
2016-02-03 19:00:00	ES	Futures	2051.59	2053.47	2048.91	2049.18	11926.0
2016-02-03 20:00:00	ES	Futures	2049.18	2062.61	2048.91	2060.19	24395.0
2016-02-03 21:00:00	ES	Futures	2060.19	2064.22	2058.85	2061.0	17318.0
2016-02-03 22:00:00	ES	Futures	2061.27	2062.61	2058.85	2062.07	9330.0
2016-02-03 23:00:00	ES	Futures	2062.07	2065.84	2060.19	2062.07	11659.0
2016-02-03 00:00:00	NQ	Futures	4955.78	4960.54	4948.66	4959.05	2236.0
2016-02-03 01:00:00	NQ	Futures	4959.05	4961.13	4948.36	4960.54	1478.0
2016-02-03 02:00:00	NQ	Futures	4960.24	4983.7	4960.24	4983.1	2908.0
2016-02-03 03:00:00	NQ	Futures	4983.4	4996.17	4972.41	4992.6	7119.0
2016-02-03 04:00:00	NQ	Futures	4992.01	5000.62	4966.18	4970.33	5228.0
2016-02-03 05:00:00	NQ	Futures	4970.63	4976.27	4956.67	4959.64	5169.0
2016-02-03 06:00:00	NQ	Futures	4959.05	4987.56	4959.05	4982.21	4066.0
2016-02-03 07:00:00	NQ	Futures	4982.8	4993.2	4970.93	4973.01	4490.0
2016-02-03 08:00:00	NQ	Futures	4973.01	5003.89	4971.22	4998.25	10372.0
2016-02-03 09:00:00	NQ	Futures	4998.54	5006.26	4951.03	4954.6	42240.0
2016-02-03 10:00:00	NQ	Futures	4954.0	4954.0	4865.81	4915.7	105940.0
2016-02-03 11:00:00	NQ	Futures	4916.0	4932.03	4875.02	4916.29	73536.0
2016-02-03 12:00:00	NQ	Futures	4916.59	4927.87	4880.96	4902.93	41440.0
2016-02-03 13:00:00	NQ	Futures	4902.63	4912.43	4858.39	4858.69	32419.0
2016-02-03 14:00:00	NQ	Futures	4858.69	4964.4	4858.39	4960.83	69448.0
2016-02-03 15:00:00	NQ	Futures	4960.24	4972.71	4926.39	4945.09	52577.0
2016-02-03 16:00:00	NQ	Futures	4945.09	4956.97	4943.91	4955.19	6647.0
2016-02-03 18:00:00	NQ	Futures	4952.52	4963.5	4946.58	4955.78	1391.0
2016-02-03 19:00:00	NQ	Futures	4955.49	4962.32	4948.95	4949.55	1981.0
2016-02-03 20:00:00	NQ	Futures	4949.85	4988.45	4949.25	4981.02	3599.0
2016-02-03 21:00:00	NQ	Futures	4980.73	4989.63	4976.87	4982.21	1771.0
2016-02-03 22:00:00	NQ	Futures	4982.21	4984.88	4975.08	4983.7	1223.0
2016-02-03 23:00:00	NQ	Futures	4983.99	4996.17	4978.94	4983.7	1847.0
2016-02-03 00:00:00	YM	Futures	17063.6	17084.9	17049.7	17079.6	1773.0
2016-02-03 01:00:00	YM	Futures	17080.6	17093.4	17056.1	17088.1	972.0
2016-02-03 02:00:00	YM	Futures	17088.1	17155.1	17088.1	17155.1	2730.0
2016-02-03 03:00:00	YM	Futures	17154.1	17198.8	17124.3	17188.1	7441.0

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

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