PREVIEW / futures_1hour / 2014-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-09.parquet
  size:    51 KB
  rows:    1,563

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-04-09 00:00:00	ES	Futures	1915.85	1917.93	1915.85	1917.67	1831.0
2014-04-09 01:00:00	ES	Futures	1917.67	1917.67	1915.33	1915.59	3159.0
2014-04-09 02:00:00	ES	Futures	1915.59	1917.67	1915.33	1916.89	7078.0
2014-04-09 03:00:00	ES	Futures	1916.89	1917.41	1915.33	1916.63	15520.0
2014-04-09 04:00:00	ES	Futures	1916.63	1920.79	1916.37	1919.75	19064.0
2014-04-09 05:00:00	ES	Futures	1919.75	1920.01	1918.71	1918.97	8384.0
2014-04-09 06:00:00	ES	Futures	1918.97	1919.23	1917.15	1917.93	8666.0
2014-04-09 07:00:00	ES	Futures	1917.67	1919.49	1916.89	1919.23	11984.0
2014-04-09 08:00:00	ES	Futures	1919.23	1922.87	1918.45	1921.83	27019.0
2014-04-09 09:00:00	ES	Futures	1921.83	1923.38	1917.15	1919.23	204405.0
2014-04-09 10:00:00	ES	Futures	1919.23	1924.16	1916.63	1920.01	211727.0
2014-04-09 11:00:00	ES	Futures	1920.01	1923.64	1918.45	1923.12	99827.0
2014-04-09 12:00:00	ES	Futures	1923.12	1926.5	1922.09	1924.68	102670.0
2014-04-09 13:00:00	ES	Futures	1924.68	1925.98	1923.12	1924.16	69015.0
2014-04-09 14:00:00	ES	Futures	1924.16	1936.11	1924.16	1932.73	314141.0
2014-04-09 15:00:00	ES	Futures	1932.73	1938.71	1931.95	1937.93	196925.0
2014-04-09 16:00:00	ES	Futures	1938.19	1938.19	1936.63	1937.67	80637.0
2014-04-09 17:00:00	ES	Futures	1937.67	1938.19	1937.41	1937.93	2286.0
2014-04-09 18:00:00	ES	Futures	1937.93	1938.96	1937.67	1938.45	3750.0
2014-04-09 19:00:00	ES	Futures	1938.45	1939.74	1938.45	1938.96	3344.0
2014-04-09 20:00:00	ES	Futures	1938.96	1939.22	1937.93	1938.45	4975.0
2014-04-09 21:00:00	ES	Futures	1938.45	1938.96	1937.41	1937.41	3150.0
2014-04-09 22:00:00	ES	Futures	1937.41	1937.67	1935.07	1936.11	9432.0
2014-04-09 23:00:00	ES	Futures	1935.85	1936.11	1934.55	1935.33	2595.0
2014-04-09 00:00:00	NQ	Futures	4110.6	4115.26	4110.31	4114.97	253.0
2014-04-09 01:00:00	NQ	Futures	4114.68	4115.26	4108.56	4108.86	673.0
2014-04-09 02:00:00	NQ	Futures	4108.56	4114.68	4108.56	4112.93	620.0
2014-04-09 03:00:00	NQ	Futures	4112.64	4114.1	4108.86	4111.77	2078.0
2014-04-09 04:00:00	NQ	Futures	4112.06	4125.16	4111.77	4123.12	3389.0
2014-04-09 05:00:00	NQ	Futures	4122.83	4124.0	4119.34	4121.96	2550.0
2014-04-09 06:00:00	NQ	Futures	4121.96	4123.12	4116.14	4119.05	1648.0
2014-04-09 07:00:00	NQ	Futures	4119.05	4121.96	4116.14	4121.09	2408.0
2014-04-09 08:00:00	NQ	Futures	4121.38	4131.28	4119.34	4129.82	6798.0
2014-04-09 09:00:00	NQ	Futures	4130.11	4135.94	4117.88	4128.95	63147.0
2014-04-09 10:00:00	NQ	Futures	4129.53	4143.51	4118.17	4134.77	70561.0
2014-04-09 11:00:00	NQ	Futures	4135.36	4145.26	4128.95	4141.18	24274.0
2014-04-09 12:00:00	NQ	Futures	4141.47	4151.66	4138.56	4146.42	20624.0
2014-04-09 13:00:00	NQ	Futures	4146.42	4150.5	4140.31	4141.18	13594.0
2014-04-09 14:00:00	NQ	Futures	4140.6	4177.29	4140.6	4167.68	67269.0
2014-04-09 15:00:00	NQ	Futures	4167.68	4186.9	4165.35	4183.41	42385.0
2014-04-09 16:00:00	NQ	Futures	4183.12	4186.32	4182.53	4186.03	7566.0
2014-04-09 17:00:00	NQ	Futures	4186.32	4186.61	4185.45	4186.61	182.0
2014-04-09 18:00:00	NQ	Futures	4185.74	4186.61	4183.99	4185.74	1278.0
2014-04-09 19:00:00	NQ	Futures	4185.74	4188.65	4185.16	4188.65	640.0
2014-04-09 20:00:00	NQ	Futures	4188.36	4188.36	4185.45	4186.32	493.0
2014-04-09 21:00:00	NQ	Futures	4186.32	4188.36	4185.45	4185.45	560.0
2014-04-09 22:00:00	NQ	Futures	4185.74	4186.03	4178.75	4180.5	1488.0
2014-04-09 23:00:00	NQ	Futures	4180.2	4180.5	4177.87	4178.75	398.0
2014-04-09 00:00:00	YM	Futures	16668.3	16681.7	16667.2	16679.6	232.0
2014-04-09 01:00:00	YM	Futures	16679.6	16681.7	16664.2	16664.2	542.0

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

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