PREVIEW / futures_1hour / 2014-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-08.parquet
  size:    50 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-05-08 00:00:00	ES	Futures	1947.01	1947.79	1946.5	1946.75	3041.0
2014-05-08 01:00:00	ES	Futures	1947.01	1947.53	1945.46	1946.5	3989.0
2014-05-08 02:00:00	ES	Futures	1946.24	1947.01	1945.2	1945.98	5770.0
2014-05-08 03:00:00	ES	Futures	1945.98	1949.09	1945.46	1948.05	20060.0
2014-05-08 04:00:00	ES	Futures	1948.05	1948.31	1946.5	1947.53	11004.0
2014-05-08 05:00:00	ES	Futures	1947.79	1948.31	1946.24	1946.75	10908.0
2014-05-08 06:00:00	ES	Futures	1946.75	1947.53	1945.72	1946.75	11626.0
2014-05-08 07:00:00	ES	Futures	1946.5	1948.57	1943.64	1944.68	22480.0
2014-05-08 08:00:00	ES	Futures	1944.68	1945.72	1940.26	1943.38	62899.0
2014-05-08 09:00:00	ES	Futures	1943.12	1953.77	1941.3	1952.47	288465.0
2014-05-08 10:00:00	ES	Futures	1952.47	1955.58	1950.65	1952.21	243213.0
2014-05-08 11:00:00	ES	Futures	1952.47	1957.66	1951.69	1956.36	160116.0
2014-05-08 12:00:00	ES	Futures	1956.36	1956.88	1952.47	1953.51	90306.0
2014-05-08 13:00:00	ES	Futures	1953.25	1954.54	1948.05	1949.61	182979.0
2014-05-08 14:00:00	ES	Futures	1949.87	1949.87	1940.52	1941.3	242808.0
2014-05-08 15:00:00	ES	Futures	1941.56	1944.68	1937.15	1943.64	305176.0
2014-05-08 16:00:00	ES	Futures	1943.64	1945.2	1942.34	1942.34	59936.0
2014-05-08 17:00:00	ES	Futures	1942.34	1942.86	1942.34	1942.34	1428.0
2014-05-08 18:00:00	ES	Futures	1942.6	1942.6	1940.26	1941.56	7010.0
2014-05-08 19:00:00	ES	Futures	1941.56	1942.34	1941.3	1941.56	1370.0
2014-05-08 20:00:00	ES	Futures	1941.82	1942.86	1940.52	1942.6	5057.0
2014-05-08 21:00:00	ES	Futures	1942.34	1943.38	1942.08	1943.12	3497.0
2014-05-08 22:00:00	ES	Futures	1943.12	1943.64	1942.86	1942.86	2364.0
2014-05-08 23:00:00	ES	Futures	1942.86	1943.9	1942.86	1943.38	2023.0
2014-05-08 00:00:00	NQ	Futures	4125.75	4128.08	4124.58	4127.49	851.0
2014-05-08 01:00:00	NQ	Futures	4127.78	4128.95	4124.29	4126.91	913.0
2014-05-08 02:00:00	NQ	Futures	4126.62	4127.2	4123.42	4123.42	935.0
2014-05-08 03:00:00	NQ	Futures	4123.71	4129.82	4122.54	4126.62	3168.0
2014-05-08 04:00:00	NQ	Futures	4126.62	4127.49	4123.71	4126.91	1096.0
2014-05-08 05:00:00	NQ	Futures	4126.91	4128.37	4124.0	4125.16	1680.0
2014-05-08 06:00:00	NQ	Futures	4125.16	4126.91	4121.09	4121.96	1989.0
2014-05-08 07:00:00	NQ	Futures	4122.83	4128.37	4115.84	4118.76	4420.0
2014-05-08 08:00:00	NQ	Futures	4119.05	4119.05	4103.61	4108.56	13864.0
2014-05-08 09:00:00	NQ	Futures	4108.86	4141.47	4098.66	4138.56	66262.0
2014-05-08 10:00:00	NQ	Futures	4138.56	4164.48	4138.56	4153.7	66481.0
2014-05-08 11:00:00	NQ	Futures	4153.7	4170.01	4151.66	4165.35	35163.0
2014-05-08 12:00:00	NQ	Futures	4165.35	4168.56	4150.5	4153.41	26669.0
2014-05-08 13:00:00	NQ	Futures	4153.7	4159.53	4136.23	4138.56	36581.0
2014-05-08 14:00:00	NQ	Futures	4138.85	4139.14	4108.86	4113.81	59649.0
2014-05-08 15:00:00	NQ	Futures	4114.1	4121.96	4103.61	4119.34	58606.0
2014-05-08 16:00:00	NQ	Futures	4119.34	4121.67	4115.84	4115.84	4783.0
2014-05-08 17:00:00	NQ	Futures	4116.14	4117.88	4115.84	4117.59	153.0
2014-05-08 18:00:00	NQ	Futures	4116.14	4116.43	4109.44	4113.22	867.0
2014-05-08 19:00:00	NQ	Futures	4112.64	4115.84	4112.06	4115.26	469.0
2014-05-08 20:00:00	NQ	Futures	4114.97	4117.59	4111.48	4116.43	905.0
2014-05-08 21:00:00	NQ	Futures	4116.72	4120.21	4115.55	4119.05	788.0
2014-05-08 22:00:00	NQ	Futures	4119.34	4120.5	4117.59	4118.17	658.0
2014-05-08 23:00:00	NQ	Futures	4117.88	4120.21	4117.59	4119.05	311.0
2014-05-08 00:00:00	YM	Futures	16969.0	16976.2	16959.7	16966.9	1752.0
2014-05-08 01:00:00	YM	Futures	16968.0	16980.3	16961.8	16971.1	1289.0

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

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