PREVIEW / futures_1hour / 2014-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-11.parquet
  size:    46 KB
  rows:    1,447

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-11 00:00:00	ES	Futures	1941.45	1941.71	1940.16	1940.42	2881.0
2014-03-11 01:00:00	ES	Futures	1940.42	1940.93	1939.9	1940.68	1878.0
2014-03-11 02:00:00	ES	Futures	1940.68	1942.49	1940.42	1941.71	2316.0
2014-03-11 03:00:00	ES	Futures	1941.71	1943.26	1940.93	1941.71	7020.0
2014-03-11 04:00:00	ES	Futures	1941.45	1942.49	1940.16	1941.19	24235.0
2014-03-11 05:00:00	ES	Futures	1941.45	1941.71	1938.61	1939.9	19787.0
2014-03-11 06:00:00	ES	Futures	1940.16	1941.71	1939.12	1940.93	17571.0
2014-03-11 07:00:00	ES	Futures	1940.93	1941.97	1939.64	1940.68	16553.0
2014-03-11 08:00:00	ES	Futures	1940.68	1944.56	1940.16	1943.78	33884.0
2014-03-11 09:00:00	ES	Futures	1943.52	1945.85	1936.54	1939.12	195365.0
2014-03-11 10:00:00	ES	Futures	1939.38	1947.4	1936.28	1945.85	207139.0
2014-03-11 11:00:00	ES	Futures	1945.85	1946.62	1938.09	1939.38	151900.0
2014-03-11 12:00:00	ES	Futures	1939.12	1939.64	1933.43	1936.28	189530.0
2014-03-11 13:00:00	ES	Futures	1936.28	1937.57	1932.14	1937.31	150352.0
2014-03-11 14:00:00	ES	Futures	1937.31	1938.09	1930.59	1931.11	132499.0
2014-03-11 15:00:00	ES	Futures	1931.36	1932.66	1927.48	1931.36	256657.0
2014-03-11 16:00:00	ES	Futures	1931.62	1932.4	1928.78	1929.04	71547.0
2014-03-11 17:00:00	ES	Futures	1928.78	1929.29	1928.78	1929.29	1299.0
2014-03-11 18:00:00	ES	Futures	1929.29	1930.59	1928.78	1929.55	4723.0
2014-03-11 19:00:00	ES	Futures	1929.55	1929.81	1926.71	1928.26	5021.0
2014-03-11 20:00:00	ES	Futures	1928.26	1929.55	1927.74	1929.04	6594.0
2014-03-11 21:00:00	ES	Futures	1929.04	1929.04	1925.67	1926.45	12547.0
2014-03-11 22:00:00	ES	Futures	1926.45	1929.04	1926.19	1928.26	6653.0
2014-03-11 23:00:00	ES	Futures	1928.26	1928.78	1926.97	1928.0	3122.0
2014-03-11 00:00:00	NQ	Futures	4311.44	4311.73	4308.24	4309.11	436.0
2014-03-11 01:00:00	NQ	Futures	4309.11	4309.98	4307.66	4309.11	294.0
2014-03-11 02:00:00	NQ	Futures	4309.4	4311.73	4309.11	4309.69	486.0
2014-03-11 03:00:00	NQ	Futures	4309.98	4313.18	4308.82	4309.11	650.0
2014-03-11 04:00:00	NQ	Futures	4309.4	4313.76	4307.66	4312.31	2546.0
2014-03-11 05:00:00	NQ	Futures	4312.6	4313.18	4306.49	4309.69	1545.0
2014-03-11 06:00:00	NQ	Futures	4309.69	4312.02	4307.08	4310.56	1564.0
2014-03-11 07:00:00	NQ	Futures	4310.85	4312.89	4309.69	4311.44	1470.0
2014-03-11 08:00:00	NQ	Futures	4311.44	4319.87	4309.98	4318.41	5456.0
2014-03-11 09:00:00	NQ	Futures	4318.12	4323.94	4304.46	4314.34	35122.0
2014-03-11 10:00:00	NQ	Futures	4314.05	4332.37	4306.79	4330.04	40949.0
2014-03-11 11:00:00	NQ	Futures	4330.04	4331.2	4314.05	4319.58	26476.0
2014-03-11 12:00:00	NQ	Futures	4319.28	4321.03	4305.62	4309.69	32382.0
2014-03-11 13:00:00	NQ	Futures	4309.69	4310.56	4299.52	4309.69	28180.0
2014-03-11 14:00:00	NQ	Futures	4309.69	4312.02	4289.05	4289.63	26649.0
2014-03-11 15:00:00	NQ	Futures	4289.93	4293.12	4280.04	4292.54	43746.0
2014-03-11 16:00:00	NQ	Futures	4292.83	4294.29	4286.44	4286.73	4581.0
2014-03-11 17:00:00	NQ	Futures	4286.44	4288.47	4286.44	4287.89	292.0
2014-03-11 18:00:00	NQ	Futures	4289.63	4291.09	4286.44	4288.18	546.0
2014-03-11 19:00:00	NQ	Futures	4287.89	4288.47	4282.08	4285.86	518.0
2014-03-11 20:00:00	NQ	Futures	4285.57	4287.89	4284.11	4287.31	434.0
2014-03-11 21:00:00	NQ	Futures	4287.02	4287.31	4280.04	4281.79	1228.0
2014-03-11 22:00:00	NQ	Futures	4282.08	4287.6	4282.08	4286.44	660.0
2014-03-11 23:00:00	NQ	Futures	4286.15	4286.15	4282.37	4284.69	556.0
2014-03-11 00:00:00	YM	Futures	16831.0	16831.0	16825.8	16825.8	2.0
2014-03-11 01:00:00	YM	Futures	16822.8	16825.8	16822.8	16823.8	6.0

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

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