PREVIEW / futures_1hour / 2014-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-20.parquet
  size:    50 KB
  rows:    1,547

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-03-20 00:00:00	ES	Futures	1917.93	1920.79	1917.15	1920.79	5507.0
2014-03-20 01:00:00	ES	Futures	1920.79	1921.57	1918.97	1919.75	5439.0
2014-03-20 02:00:00	ES	Futures	1919.75	1921.05	1917.67	1919.49	5689.0
2014-03-20 03:00:00	ES	Futures	1919.49	1921.83	1917.93	1921.83	12991.0
2014-03-20 04:00:00	ES	Futures	1922.09	1924.68	1921.31	1922.61	31203.0
2014-03-20 05:00:00	ES	Futures	1922.35	1923.12	1920.01	1921.57	18058.0
2014-03-20 06:00:00	ES	Futures	1921.57	1921.83	1916.11	1917.67	33452.0
2014-03-20 07:00:00	ES	Futures	1917.67	1921.57	1917.41	1920.27	26620.0
2014-03-20 08:00:00	ES	Futures	1920.27	1921.31	1918.45	1918.71	32594.0
2014-03-20 09:00:00	ES	Futures	1918.71	1924.16	1917.41	1921.57	185357.0
2014-03-20 10:00:00	ES	Futures	1921.31	1932.21	1919.23	1928.84	305498.0
2014-03-20 11:00:00	ES	Futures	1928.84	1931.17	1925.98	1930.91	169378.0
2014-03-20 12:00:00	ES	Futures	1930.66	1937.41	1929.36	1936.89	167251.0
2014-03-20 13:00:00	ES	Futures	1936.63	1938.19	1934.55	1937.15	88965.0
2014-03-20 14:00:00	ES	Futures	1937.15	1938.19	1935.85	1935.85	56983.0
2014-03-20 15:00:00	ES	Futures	1935.85	1936.89	1932.47	1936.89	183037.0
2014-03-20 16:00:00	ES	Futures	1936.63	1938.71	1936.37	1937.41	83680.0
2014-03-20 17:00:00	ES	Futures	1937.41	1937.93	1937.15	1937.15	3274.0
2014-03-20 18:00:00	ES	Futures	1936.89	1937.15	1934.81	1936.37	6778.0
2014-03-20 19:00:00	ES	Futures	1936.37	1936.63	1935.33	1936.63	2522.0
2014-03-20 20:00:00	ES	Futures	1936.37	1936.89	1936.11	1936.63	1386.0
2014-03-20 21:00:00	ES	Futures	1936.63	1937.41	1935.59	1936.11	2596.0
2014-03-20 22:00:00	ES	Futures	1935.85	1937.41	1935.85	1937.15	2074.0
2014-03-20 23:00:00	ES	Futures	1937.15	1938.71	1937.15	1938.19	2347.0
2014-03-20 00:00:00	NQ	Futures	4266.99	4273.69	4265.53	4273.69	724.0
2014-03-20 01:00:00	NQ	Futures	4273.69	4275.73	4269.61	4271.07	707.0
2014-03-20 02:00:00	NQ	Futures	4271.65	4274.27	4267.57	4271.94	764.0
2014-03-20 03:00:00	NQ	Futures	4271.65	4276.6	4268.15	4276.31	1221.0
2014-03-20 04:00:00	NQ	Futures	4276.31	4282.71	4275.43	4277.76	4099.0
2014-03-20 05:00:00	NQ	Futures	4277.47	4279.22	4270.77	4274.56	2279.0
2014-03-20 06:00:00	NQ	Futures	4274.56	4274.85	4262.04	4265.82	4069.0
2014-03-20 07:00:00	NQ	Futures	4266.41	4274.27	4265.24	4271.07	3222.0
2014-03-20 08:00:00	NQ	Futures	4271.07	4273.98	4266.41	4268.15	6232.0
2014-03-20 09:00:00	NQ	Futures	4268.15	4281.55	4260.29	4271.65	39731.0
2014-03-20 10:00:00	NQ	Futures	4272.23	4298.15	4266.7	4288.54	53078.0
2014-03-20 11:00:00	NQ	Futures	4288.25	4292.03	4279.22	4291.16	28912.0
2014-03-20 12:00:00	NQ	Futures	4290.87	4303.68	4287.67	4303.68	22895.0
2014-03-20 13:00:00	NQ	Futures	4303.68	4307.76	4296.69	4300.48	17005.0
2014-03-20 14:00:00	NQ	Futures	4300.48	4304.27	4296.98	4297.28	10200.0
2014-03-20 15:00:00	NQ	Futures	4296.98	4296.98	4285.92	4294.36	26800.0
2014-03-20 16:00:00	NQ	Futures	4294.65	4301.64	4293.49	4299.9	10172.0
2014-03-20 17:00:00	NQ	Futures	4299.9	4301.64	4299.31	4299.31	380.0
2014-03-20 18:00:00	NQ	Futures	4298.73	4299.9	4294.07	4297.86	648.0
2014-03-20 19:00:00	NQ	Futures	4297.86	4298.15	4295.24	4297.86	237.0
2014-03-20 20:00:00	NQ	Futures	4297.57	4298.73	4296.69	4297.57	262.0
2014-03-20 21:00:00	NQ	Futures	4297.57	4299.61	4295.53	4296.11	363.0
2014-03-20 22:00:00	NQ	Futures	4296.4	4298.44	4296.4	4298.44	340.0
2014-03-20 23:00:00	NQ	Futures	4298.73	4302.23	4298.73	4300.77	383.0
2014-03-20 00:00:00	YM	Futures	16570.4	16599.3	16565.3	16596.2	988.0
2014-03-20 01:00:00	YM	Futures	16598.2	16605.5	16582.8	16587.9	694.0

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

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