PREVIEW / futures_1hour / 2014-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-12.parquet
  size:    48 KB
  rows:    1,493

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-12 00:00:00	ES	Futures	1928.0	1929.29	1927.48	1928.78	2673.0
2014-03-12 01:00:00	ES	Futures	1929.29	1929.29	1927.48	1928.0	3358.0
2014-03-12 02:00:00	ES	Futures	1928.0	1928.52	1926.97	1928.26	3449.0
2014-03-12 03:00:00	ES	Futures	1928.26	1929.55	1925.41	1929.29	14775.0
2014-03-12 04:00:00	ES	Futures	1929.55	1931.11	1928.52	1929.29	34124.0
2014-03-12 05:00:00	ES	Futures	1929.29	1929.29	1926.19	1927.23	28394.0
2014-03-12 06:00:00	ES	Futures	1926.97	1927.48	1923.35	1923.6	34477.0
2014-03-12 07:00:00	ES	Futures	1923.86	1926.45	1923.35	1926.45	28576.0
2014-03-12 08:00:00	ES	Futures	1926.19	1926.71	1921.79	1923.6	42863.0
2014-03-12 09:00:00	ES	Futures	1923.35	1925.67	1917.91	1922.31	292949.0
2014-03-12 10:00:00	ES	Futures	1922.05	1929.55	1921.54	1929.29	269682.0
2014-03-12 11:00:00	ES	Futures	1929.29	1933.17	1927.48	1928.26	167255.0
2014-03-12 12:00:00	ES	Futures	1928.52	1931.62	1926.97	1931.36	117585.0
2014-03-12 13:00:00	ES	Futures	1931.36	1931.36	1926.97	1929.55	67801.0
2014-03-12 14:00:00	ES	Futures	1929.55	1931.88	1928.0	1928.78	82244.0
2014-03-12 15:00:00	ES	Futures	1928.52	1933.17	1926.97	1932.14	193845.0
2014-03-12 16:00:00	ES	Futures	1932.14	1933.69	1931.36	1933.43	78078.0
2014-03-12 17:00:00	ES	Futures	1933.69	1933.69	1933.17	1933.43	1310.0
2014-03-12 18:00:00	ES	Futures	1933.43	1933.43	1931.62	1932.4	3714.0
2014-03-12 19:00:00	ES	Futures	1932.4	1934.73	1932.4	1934.47	5302.0
2014-03-12 20:00:00	ES	Futures	1934.21	1936.28	1934.21	1935.5	7441.0
2014-03-12 21:00:00	ES	Futures	1935.5	1936.54	1934.99	1936.28	3985.0
2014-03-12 22:00:00	ES	Futures	1936.28	1939.64	1935.24	1939.12	11068.0
2014-03-12 23:00:00	ES	Futures	1939.12	1939.38	1937.83	1938.09	3979.0
2014-03-12 00:00:00	NQ	Futures	4284.69	4287.6	4283.24	4287.02	240.0
2014-03-12 01:00:00	NQ	Futures	4287.6	4287.6	4283.53	4284.98	249.0
2014-03-12 02:00:00	NQ	Futures	4284.4	4284.98	4282.08	4284.69	299.0
2014-03-12 03:00:00	NQ	Futures	4284.98	4288.76	4278.88	4288.18	1192.0
2014-03-12 04:00:00	NQ	Futures	4288.47	4291.96	4286.73	4287.6	3186.0
2014-03-12 05:00:00	NQ	Futures	4287.31	4287.6	4280.04	4280.91	2928.0
2014-03-12 06:00:00	NQ	Futures	4280.91	4281.5	4272.19	4273.36	5298.0
2014-03-12 07:00:00	NQ	Futures	4273.36	4279.75	4272.48	4279.46	3793.0
2014-03-12 08:00:00	NQ	Futures	4279.17	4280.04	4269.58	4273.36	6838.0
2014-03-12 09:00:00	NQ	Futures	4273.36	4281.5	4257.37	4268.12	62346.0
2014-03-12 10:00:00	NQ	Futures	4268.12	4296.03	4266.67	4295.45	56325.0
2014-03-12 11:00:00	NQ	Futures	4295.74	4310.85	4291.67	4299.81	40033.0
2014-03-12 12:00:00	NQ	Futures	4299.52	4307.37	4296.61	4307.08	22996.0
2014-03-12 13:00:00	NQ	Futures	4306.79	4307.37	4296.32	4305.33	13748.0
2014-03-12 14:00:00	NQ	Futures	4305.33	4311.73	4300.68	4300.97	21929.0
2014-03-12 15:00:00	NQ	Futures	4300.97	4311.15	4296.03	4309.11	35692.0
2014-03-12 16:00:00	NQ	Futures	4309.11	4313.76	4306.79	4312.89	5265.0
2014-03-12 17:00:00	NQ	Futures	4312.6	4313.47	4312.31	4313.18	249.0
2014-03-12 18:00:00	NQ	Futures	4311.44	4312.02	4309.4	4311.15	415.0
2014-03-12 19:00:00	NQ	Futures	4311.44	4316.67	4311.44	4316.38	691.0
2014-03-12 20:00:00	NQ	Futures	4316.09	4322.19	4315.51	4319.58	1912.0
2014-03-12 21:00:00	NQ	Futures	4319.58	4321.61	4318.99	4320.45	847.0
2014-03-12 22:00:00	NQ	Futures	4320.16	4327.71	4318.41	4326.84	1581.0
2014-03-12 23:00:00	NQ	Futures	4326.84	4326.84	4323.35	4323.64	484.0
2014-03-12 00:00:00	YM	Futures	16735.2	16747.6	16732.1	16747.6	15.0
2014-03-12 01:00:00	YM	Futures	16735.2	16743.5	16734.2	16739.3	13.0

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

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