PREVIEW / futures_1hour / 2016-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-04.parquet
  size:    55 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-04 00:00:00	ES	Futures	2062.07	2062.61	2059.12	2059.92	9550.0
2016-02-04 01:00:00	ES	Futures	2059.92	2066.1	2059.92	2064.76	7089.0
2016-02-04 02:00:00	ES	Futures	2064.76	2065.84	2059.65	2060.73	18210.0
2016-02-04 03:00:00	ES	Futures	2060.46	2062.34	2054.28	2056.97	46415.0
2016-02-04 04:00:00	ES	Futures	2056.7	2061.8	2051.59	2061.54	34318.0
2016-02-04 05:00:00	ES	Futures	2061.54	2063.15	2055.89	2057.51	28128.0
2016-02-04 06:00:00	ES	Futures	2057.51	2058.85	2051.86	2052.67	15051.0
2016-02-04 07:00:00	ES	Futures	2052.94	2056.43	2043.53	2045.68	43276.0
2016-02-04 08:00:00	ES	Futures	2045.41	2045.41	2031.71	2036.81	113516.0
2016-02-04 09:00:00	ES	Futures	2036.81	2050.79	2035.47	2047.03	352499.0
2016-02-04 10:00:00	ES	Futures	2046.76	2065.57	2037.62	2065.03	425394.0
2016-02-04 11:00:00	ES	Futures	2064.76	2065.3	2039.23	2042.73	308377.0
2016-02-04 12:00:00	ES	Futures	2042.73	2056.16	2041.38	2049.98	184561.0
2016-02-04 13:00:00	ES	Futures	2050.25	2057.77	2045.14	2047.56	141848.0
2016-02-04 14:00:00	ES	Futures	2047.83	2048.64	2039.77	2048.37	168195.0
2016-02-04 15:00:00	ES	Futures	2048.37	2053.74	2042.73	2052.67	215578.0
2016-02-04 16:00:00	ES	Futures	2052.67	2053.47	2048.1	2048.37	51534.0
2016-02-04 18:00:00	ES	Futures	2047.83	2048.1	2043.8	2046.22	6226.0
2016-02-04 19:00:00	ES	Futures	2045.95	2048.37	2044.61	2045.95	7428.0
2016-02-04 20:00:00	ES	Futures	2046.22	2052.13	2045.14	2050.25	10240.0
2016-02-04 21:00:00	ES	Futures	2050.25	2050.52	2046.76	2048.1	5632.0
2016-02-04 22:00:00	ES	Futures	2047.56	2050.79	2045.68	2046.76	4833.0
2016-02-04 23:00:00	ES	Futures	2046.76	2048.37	2044.61	2047.56	6266.0
2016-02-04 00:00:00	NQ	Futures	4982.8	4986.07	4976.57	4978.94	1393.0
2016-02-04 01:00:00	NQ	Futures	4979.24	4994.39	4979.24	4990.82	1140.0
2016-02-04 02:00:00	NQ	Futures	4990.82	4993.2	4976.87	4980.13	2343.0
2016-02-04 03:00:00	NQ	Futures	4979.24	4984.29	4960.83	4969.44	7004.0
2016-02-04 04:00:00	NQ	Futures	4969.15	4982.51	4954.3	4981.91	4340.0
2016-02-04 05:00:00	NQ	Futures	4981.62	4986.96	4969.15	4972.71	3098.0
2016-02-04 06:00:00	NQ	Futures	4972.71	4976.27	4960.24	4960.54	2788.0
2016-02-04 07:00:00	NQ	Futures	4960.83	4968.26	4938.27	4942.13	5265.0
2016-02-04 08:00:00	NQ	Futures	4941.83	4941.83	4903.82	4916.89	14206.0
2016-02-04 09:00:00	NQ	Futures	4916.59	4945.09	4885.71	4914.51	56716.0
2016-02-04 10:00:00	NQ	Futures	4913.62	4983.99	4890.16	4975.68	78644.0
2016-02-04 11:00:00	NQ	Futures	4975.38	4977.16	4905.9	4911.24	55584.0
2016-02-04 12:00:00	NQ	Futures	4911.54	4949.55	4906.2	4931.14	34960.0
2016-02-04 13:00:00	NQ	Futures	4931.44	4955.78	4917.48	4925.2	26645.0
2016-02-04 14:00:00	NQ	Futures	4925.79	4928.47	4899.07	4927.87	30946.0
2016-02-04 15:00:00	NQ	Futures	4927.87	4947.77	4909.76	4944.8	38187.0
2016-02-04 16:00:00	NQ	Futures	4944.8	4946.58	4926.09	4926.09	6379.0
2016-02-04 18:00:00	NQ	Futures	4924.9	4925.5	4915.4	4921.93	1328.0
2016-02-04 19:00:00	NQ	Futures	4921.64	4929.06	4918.67	4922.53	1201.0
2016-02-04 20:00:00	NQ	Futures	4922.82	4939.75	4920.45	4935.0	1327.0
2016-02-04 21:00:00	NQ	Futures	4934.41	4935.0	4924.31	4927.28	702.0
2016-02-04 22:00:00	NQ	Futures	4927.58	4935.89	4920.75	4924.61	902.0
2016-02-04 23:00:00	NQ	Futures	4923.42	4928.17	4918.07	4925.5	820.0
2016-02-04 00:00:00	YM	Futures	17393.6	17398.9	17371.2	17381.9	1696.0
2016-02-04 01:00:00	YM	Futures	17379.7	17425.5	17379.7	17415.9	1191.0
2016-02-04 02:00:00	YM	Futures	17418.1	17423.4	17379.7	17390.4	2419.0
2016-02-04 03:00:00	YM	Futures	17389.3	17403.2	17337.2	17361.6	7934.0

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

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