PREVIEW / futures_1hour / 2014-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-07.parquet
  size:    50 KB
  rows:    1,549

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-07 00:00:00	ES	Futures	1935.59	1936.11	1934.55	1935.33	2436.0
2014-05-07 01:00:00	ES	Futures	1935.33	1935.59	1933.51	1934.03	4605.0
2014-05-07 02:00:00	ES	Futures	1934.29	1934.81	1932.99	1933.77	10495.0
2014-05-07 03:00:00	ES	Futures	1934.03	1936.89	1932.99	1936.89	28333.0
2014-05-07 04:00:00	ES	Futures	1936.89	1937.93	1935.33	1937.93	15367.0
2014-05-07 05:00:00	ES	Futures	1937.93	1937.93	1935.33	1935.33	12164.0
2014-05-07 06:00:00	ES	Futures	1935.59	1936.89	1934.81	1936.89	9753.0
2014-05-07 07:00:00	ES	Futures	1936.89	1940.78	1936.37	1939.22	41089.0
2014-05-07 08:00:00	ES	Futures	1939.22	1943.9	1939.22	1940.52	69575.0
2014-05-07 09:00:00	ES	Futures	1940.78	1943.9	1935.59	1936.37	266968.0
2014-05-07 10:00:00	ES	Futures	1936.37	1940.0	1926.24	1934.03	483564.0
2014-05-07 11:00:00	ES	Futures	1934.29	1944.42	1931.95	1942.08	271632.0
2014-05-07 12:00:00	ES	Futures	1942.08	1943.38	1937.15	1937.67	152334.0
2014-05-07 13:00:00	ES	Futures	1937.67	1941.56	1935.59	1935.85	125929.0
2014-05-07 14:00:00	ES	Futures	1935.85	1943.12	1935.07	1941.56	145020.0
2014-05-07 15:00:00	ES	Futures	1941.56	1946.5	1938.71	1945.72	223419.0
2014-05-07 16:00:00	ES	Futures	1945.98	1948.31	1945.2	1947.27	102704.0
2014-05-07 17:00:00	ES	Futures	1947.01	1947.53	1946.75	1947.01	1984.0
2014-05-07 18:00:00	ES	Futures	1947.27	1947.53	1945.98	1946.5	2980.0
2014-05-07 19:00:00	ES	Futures	1946.24	1947.01	1944.94	1945.46	2535.0
2014-05-07 20:00:00	ES	Futures	1945.46	1945.72	1944.68	1944.94	3033.0
2014-05-07 21:00:00	ES	Futures	1945.2	1945.46	1943.64	1943.9	4466.0
2014-05-07 22:00:00	ES	Futures	1943.9	1946.24	1943.9	1945.98	6395.0
2014-05-07 23:00:00	ES	Futures	1946.24	1948.57	1945.98	1947.01	6093.0
2014-05-07 00:00:00	NQ	Futures	4134.77	4135.65	4131.86	4133.9	402.0
2014-05-07 01:00:00	NQ	Futures	4133.9	4134.19	4129.53	4130.7	600.0
2014-05-07 02:00:00	NQ	Futures	4130.7	4131.28	4128.37	4128.66	2022.0
2014-05-07 03:00:00	NQ	Futures	4128.66	4132.74	4125.16	4132.74	5785.0
2014-05-07 04:00:00	NQ	Futures	4132.15	4135.65	4129.82	4135.65	1912.0
2014-05-07 05:00:00	NQ	Futures	4135.65	4135.94	4126.62	4128.37	3446.0
2014-05-07 06:00:00	NQ	Futures	4128.37	4133.32	4127.2	4133.03	1909.0
2014-05-07 07:00:00	NQ	Futures	4133.03	4145.55	4132.15	4142.64	7064.0
2014-05-07 08:00:00	NQ	Futures	4142.64	4154.58	4142.64	4147.59	12462.0
2014-05-07 09:00:00	NQ	Futures	4147.59	4148.17	4103.61	4105.94	59615.0
2014-05-07 10:00:00	NQ	Futures	4105.65	4119.34	4074.2	4090.22	111825.0
2014-05-07 11:00:00	NQ	Futures	4090.51	4116.72	4079.44	4110.02	62120.0
2014-05-07 12:00:00	NQ	Futures	4110.02	4111.77	4088.47	4089.34	34918.0
2014-05-07 13:00:00	NQ	Futures	4089.05	4103.9	4085.85	4086.43	31896.0
2014-05-07 14:00:00	NQ	Futures	4086.43	4110.02	4084.39	4107.69	45221.0
2014-05-07 15:00:00	NQ	Futures	4107.69	4126.04	4099.54	4123.12	51349.0
2014-05-07 16:00:00	NQ	Futures	4123.42	4132.44	4122.54	4125.16	9971.0
2014-05-07 17:00:00	NQ	Futures	4124.87	4125.16	4123.12	4123.12	210.0
2014-05-07 18:00:00	NQ	Futures	4122.83	4124.29	4121.09	4121.96	515.0
2014-05-07 19:00:00	NQ	Futures	4121.38	4123.42	4118.47	4119.05	527.0
2014-05-07 20:00:00	NQ	Futures	4118.76	4119.63	4117.3	4119.05	551.0
2014-05-07 21:00:00	NQ	Futures	4118.76	4119.63	4113.81	4114.68	851.0
2014-05-07 22:00:00	NQ	Futures	4114.68	4119.34	4114.1	4119.05	1362.0
2014-05-07 23:00:00	NQ	Futures	4118.76	4126.33	4118.47	4125.75	1541.0
2014-05-07 00:00:00	YM	Futures	16835.1	16839.2	16828.9	16835.1	454.0
2014-05-07 01:00:00	YM	Futures	16836.1	16836.1	16819.7	16822.8	780.0

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

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