PREVIEW / futures_1hour / 2014-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-09.parquet
  size:    42 KB
  rows:    1,264

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
2014-05-09 00:00:00	ES	Futures	1943.64	1943.9	1943.12	1943.9	761.0
2014-05-09 01:00:00	ES	Futures	1943.64	1944.42	1943.12	1944.16	2351.0
2014-05-09 02:00:00	ES	Futures	1944.16	1944.68	1943.38	1944.42	5872.0
2014-05-09 03:00:00	ES	Futures	1944.68	1945.2	1942.08	1942.6	18850.0
2014-05-09 04:00:00	ES	Futures	1942.86	1943.64	1941.3	1941.3	14158.0
2014-05-09 05:00:00	ES	Futures	1941.56	1942.6	1940.26	1941.82	15897.0
2014-05-09 06:00:00	ES	Futures	1941.82	1942.86	1940.26	1942.08	15249.0
2014-05-09 07:00:00	ES	Futures	1942.34	1942.6	1938.71	1939.74	19604.0
2014-05-09 08:00:00	ES	Futures	1939.74	1944.16	1939.48	1943.38	35351.0
2014-05-09 09:00:00	ES	Futures	1943.64	1944.16	1934.81	1937.41	292109.0
2014-05-09 10:00:00	ES	Futures	1937.41	1942.34	1934.81	1936.63	287839.0
2014-05-09 11:00:00	ES	Futures	1936.63	1941.56	1934.55	1939.74	168452.0
2014-05-09 12:00:00	ES	Futures	1939.74	1947.53	1938.19	1946.75	149998.0
2014-05-09 13:00:00	ES	Futures	1946.5	1947.27	1942.08	1942.34	95105.0
2014-05-09 14:00:00	ES	Futures	1942.34	1943.9	1939.22	1943.12	112786.0
2014-05-09 15:00:00	ES	Futures	1943.38	1947.27	1942.86	1947.27	150698.0
2014-05-09 16:00:00	ES	Futures	1947.01	1947.27	1945.46	1947.27	67096.0
2014-05-09 17:00:00	ES	Futures	1947.27	1947.27	1946.75	1947.27	1896.0
2014-05-09 00:00:00	NQ	Futures	4119.34	4119.63	4117.59	4119.05	162.0
2014-05-09 01:00:00	NQ	Futures	4118.76	4120.8	4117.3	4119.92	361.0
2014-05-09 02:00:00	NQ	Futures	4120.21	4120.8	4117.88	4120.5	852.0
2014-05-09 03:00:00	NQ	Futures	4120.8	4122.25	4113.51	4114.68	3422.0
2014-05-09 04:00:00	NQ	Futures	4114.39	4115.55	4108.56	4109.44	2958.0
2014-05-09 05:00:00	NQ	Futures	4109.44	4112.06	4106.53	4111.48	1925.0
2014-05-09 06:00:00	NQ	Futures	4111.77	4113.51	4107.69	4112.06	1965.0
2014-05-09 07:00:00	NQ	Futures	4112.35	4113.81	4100.7	4104.49	5268.0
2014-05-09 08:00:00	NQ	Futures	4104.78	4119.92	4103.03	4117.01	7589.0
2014-05-09 09:00:00	NQ	Futures	4117.01	4118.17	4089.34	4109.15	66660.0
2014-05-09 10:00:00	NQ	Futures	4108.86	4126.33	4097.21	4097.79	70261.0
2014-05-09 11:00:00	NQ	Futures	4097.5	4116.43	4090.8	4111.48	33141.0
2014-05-09 12:00:00	NQ	Futures	4111.77	4132.74	4106.82	4128.37	33641.0
2014-05-09 13:00:00	NQ	Futures	4128.37	4131.57	4115.84	4117.59	21632.0
2014-05-09 14:00:00	NQ	Futures	4117.88	4127.78	4109.15	4125.45	26477.0
2014-05-09 15:00:00	NQ	Futures	4125.45	4137.98	4125.45	4135.07	34308.0
2014-05-09 16:00:00	NQ	Futures	4134.77	4136.81	4133.03	4135.65	5006.0
2014-05-09 17:00:00	NQ	Futures	4135.07	4135.94	4134.77	4135.36	271.0
2014-05-09 00:00:00	YM	Futures	16989.6	16990.6	16986.5	16990.6	201.0
2014-05-09 01:00:00	YM	Futures	16989.6	16991.7	16984.4	16989.6	684.0
2014-05-09 02:00:00	YM	Futures	16990.6	16991.7	16985.5	16990.6	958.0
2014-05-09 03:00:00	YM	Futures	16991.7	16997.8	16976.2	16979.3	2312.0
2014-05-09 04:00:00	YM	Futures	16978.3	16990.6	16974.1	16974.1	1510.0
2014-05-09 05:00:00	YM	Futures	16975.2	16984.4	16968.0	16983.4	2276.0
2014-05-09 06:00:00	YM	Futures	16983.4	16989.6	16973.1	16986.5	1583.0
2014-05-09 07:00:00	YM	Futures	16986.5	16988.6	16959.7	16969.0	2243.0
2014-05-09 08:00:00	YM	Futures	16969.0	16998.9	16962.8	16990.6	3254.0
2014-05-09 09:00:00	YM	Futures	16990.6	17013.3	16945.3	16961.8	22226.0
2014-05-09 10:00:00	YM	Futures	16960.8	17000.9	16942.2	16961.8	28953.0
2014-05-09 11:00:00	YM	Futures	16961.8	17002.0	16952.5	16986.5	16195.0
2014-05-09 12:00:00	YM	Futures	16987.5	17035.9	16978.3	17030.8	17393.0
2014-05-09 13:00:00	YM	Futures	17030.8	17034.9	16996.8	16999.9	8925.0

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

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