PREVIEW / futures_1hour / 2014-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-18.parquet
  size:    49 KB
  rows:    1,533

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-18 00:00:00	ES	Futures	1924.42	1924.68	1923.64	1924.42	1485.0
2014-03-18 01:00:00	ES	Futures	1924.68	1925.2	1922.87	1922.87	2598.0
2014-03-18 02:00:00	ES	Futures	1923.12	1923.12	1921.57	1921.57	4273.0
2014-03-18 03:00:00	ES	Futures	1921.57	1922.09	1920.01	1922.09	7847.0
2014-03-18 04:00:00	ES	Futures	1922.09	1922.35	1917.41	1919.49	27182.0
2014-03-18 05:00:00	ES	Futures	1919.75	1920.01	1918.19	1918.71	11807.0
2014-03-18 06:00:00	ES	Futures	1918.71	1922.61	1917.93	1918.19	24963.0
2014-03-18 07:00:00	ES	Futures	1918.19	1931.43	1916.89	1929.36	87634.0
2014-03-18 08:00:00	ES	Futures	1929.1	1930.66	1927.54	1927.8	37075.0
2014-03-18 09:00:00	ES	Futures	1927.8	1932.73	1924.42	1931.69	221695.0
2014-03-18 10:00:00	ES	Futures	1931.43	1937.41	1930.14	1931.95	282132.0
2014-03-18 11:00:00	ES	Futures	1931.95	1936.63	1931.69	1935.59	162093.0
2014-03-18 12:00:00	ES	Futures	1935.59	1936.89	1932.73	1934.55	104448.0
2014-03-18 13:00:00	ES	Futures	1934.29	1938.96	1933.77	1937.41	92396.0
2014-03-18 14:00:00	ES	Futures	1937.41	1939.22	1936.37	1937.93	62582.0
2014-03-18 15:00:00	ES	Futures	1938.19	1938.45	1935.33	1936.89	149473.0
2014-03-18 16:00:00	ES	Futures	1936.89	1937.67	1935.07	1935.85	78882.0
2014-03-18 17:00:00	ES	Futures	1935.85	1936.89	1935.85	1936.37	2161.0
2014-03-18 18:00:00	ES	Futures	1936.11	1936.11	1934.29	1935.07	3319.0
2014-03-18 19:00:00	ES	Futures	1935.07	1937.15	1934.81	1936.89	2523.0
2014-03-18 20:00:00	ES	Futures	1936.89	1937.41	1935.33	1935.59	3820.0
2014-03-18 21:00:00	ES	Futures	1935.59	1935.85	1933.77	1933.77	5030.0
2014-03-18 22:00:00	ES	Futures	1933.77	1934.55	1933.51	1934.03	4011.0
2014-03-18 23:00:00	ES	Futures	1934.03	1934.03	1932.99	1933.51	3117.0
2014-03-18 00:00:00	NQ	Futures	4258.83	4259.71	4257.09	4259.13	204.0
2014-03-18 01:00:00	NQ	Futures	4259.42	4260.29	4255.05	4255.63	450.0
2014-03-18 02:00:00	NQ	Futures	4254.76	4256.21	4252.14	4253.3	499.0
2014-03-18 03:00:00	NQ	Futures	4252.72	4253.59	4248.64	4251.26	1408.0
2014-03-18 04:00:00	NQ	Futures	4251.26	4251.85	4241.36	4246.6	4857.0
2014-03-18 05:00:00	NQ	Futures	4246.6	4247.19	4242.23	4243.98	1979.0
2014-03-18 06:00:00	NQ	Futures	4243.69	4252.72	4241.94	4243.11	4064.0
2014-03-18 07:00:00	NQ	Futures	4243.4	4271.94	4240.2	4267.57	12489.0
2014-03-18 08:00:00	NQ	Futures	4267.57	4271.36	4264.08	4264.37	7780.0
2014-03-18 09:00:00	NQ	Futures	4264.66	4285.04	4257.67	4283.01	49465.0
2014-03-18 10:00:00	NQ	Futures	4283.3	4298.15	4278.93	4291.45	49571.0
2014-03-18 11:00:00	NQ	Futures	4291.45	4301.35	4290.29	4300.77	33584.0
2014-03-18 12:00:00	NQ	Futures	4300.77	4304.85	4295.53	4299.02	25027.0
2014-03-18 13:00:00	NQ	Futures	4299.02	4310.96	4295.24	4308.34	28251.0
2014-03-18 14:00:00	NQ	Futures	4308.34	4312.71	4304.85	4309.51	15809.0
2014-03-18 15:00:00	NQ	Futures	4309.8	4312.42	4304.27	4307.76	26296.0
2014-03-18 16:00:00	NQ	Futures	4307.18	4308.34	4303.68	4305.72	7281.0
2014-03-18 17:00:00	NQ	Futures	4305.72	4306.89	4305.14	4306.6	250.0
2014-03-18 18:00:00	NQ	Futures	4305.14	4305.14	4301.35	4302.23	501.0
2014-03-18 19:00:00	NQ	Futures	4302.52	4307.47	4302.52	4307.47	335.0
2014-03-18 20:00:00	NQ	Futures	4307.18	4307.47	4302.81	4303.97	577.0
2014-03-18 21:00:00	NQ	Futures	4303.97	4304.27	4300.48	4300.48	783.0
2014-03-18 22:00:00	NQ	Futures	4300.77	4302.52	4300.48	4302.23	685.0
2014-03-18 23:00:00	NQ	Futures	4302.23	4302.81	4300.48	4302.52	381.0
2014-03-18 00:00:00	YM	Futures	16677.5	16678.6	16670.3	16677.5	284.0
2014-03-18 01:00:00	YM	Futures	16677.5	16681.7	16662.1	16662.1	565.0

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

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