PREVIEW / futures_1hour / 2014-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-30.parquet
  size:    50 KB
  rows:    1,564

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-04-30 00:00:00	ES	Futures	1941.04	1941.82	1940.78	1941.3	2867.0
2014-04-30 01:00:00	ES	Futures	1941.56	1941.82	1939.48	1939.74	6071.0
2014-04-30 02:00:00	ES	Futures	1939.74	1940.78	1938.45	1940.26	11428.0
2014-04-30 03:00:00	ES	Futures	1940.26	1941.04	1938.71	1939.48	20858.0
2014-04-30 04:00:00	ES	Futures	1939.74	1941.3	1938.96	1941.04	11631.0
2014-04-30 05:00:00	ES	Futures	1941.04	1942.86	1939.74	1942.34	11992.0
2014-04-30 06:00:00	ES	Futures	1942.08	1942.6	1941.04	1941.82	12774.0
2014-04-30 07:00:00	ES	Futures	1941.82	1943.9	1941.56	1942.6	14714.0
2014-04-30 08:00:00	ES	Futures	1942.86	1946.24	1940.78	1942.6	71014.0
2014-04-30 09:00:00	ES	Futures	1942.6	1944.42	1939.22	1941.04	237733.0
2014-04-30 10:00:00	ES	Futures	1940.78	1948.31	1938.71	1945.98	205488.0
2014-04-30 11:00:00	ES	Futures	1945.98	1946.75	1942.86	1944.94	117378.0
2014-04-30 12:00:00	ES	Futures	1944.94	1947.53	1944.94	1947.27	49947.0
2014-04-30 13:00:00	ES	Futures	1947.01	1948.05	1945.72	1945.98	52406.0
2014-04-30 14:00:00	ES	Futures	1945.72	1952.21	1942.6	1950.39	265653.0
2014-04-30 15:00:00	ES	Futures	1950.39	1951.95	1945.46	1951.17	276634.0
2014-04-30 16:00:00	ES	Futures	1950.91	1952.99	1949.61	1951.69	108523.0
2014-04-30 17:00:00	ES	Futures	1951.69	1952.47	1951.69	1951.95	1800.0
2014-04-30 18:00:00	ES	Futures	1952.21	1952.99	1950.65	1951.95	7216.0
2014-04-30 19:00:00	ES	Futures	1951.69	1952.47	1951.17	1951.95	1740.0
2014-04-30 20:00:00	ES	Futures	1951.95	1952.47	1950.91	1951.17	2906.0
2014-04-30 21:00:00	ES	Futures	1951.17	1951.69	1950.39	1950.91	2668.0
2014-04-30 22:00:00	ES	Futures	1950.91	1951.43	1950.65	1951.17	1652.0
2014-04-30 23:00:00	ES	Futures	1950.91	1951.43	1950.65	1950.65	1188.0
2014-04-30 00:00:00	NQ	Futures	4138.85	4139.72	4136.23	4136.81	1004.0
2014-04-30 01:00:00	NQ	Futures	4136.81	4138.85	4133.32	4134.19	867.0
2014-04-30 02:00:00	NQ	Futures	4134.19	4135.07	4129.53	4133.61	2447.0
2014-04-30 03:00:00	NQ	Futures	4133.61	4137.98	4130.99	4133.03	3126.0
2014-04-30 04:00:00	NQ	Futures	4133.03	4138.27	4131.28	4137.69	1821.0
2014-04-30 05:00:00	NQ	Futures	4137.39	4141.47	4133.03	4140.02	2080.0
2014-04-30 06:00:00	NQ	Futures	4139.72	4141.18	4137.98	4138.56	1555.0
2014-04-30 07:00:00	NQ	Futures	4138.27	4144.09	4136.81	4140.89	3226.0
2014-04-30 08:00:00	NQ	Futures	4140.89	4147.59	4135.07	4141.18	12132.0
2014-04-30 09:00:00	NQ	Futures	4140.89	4146.13	4122.54	4131.57	55783.0
2014-04-30 10:00:00	NQ	Futures	4131.28	4158.95	4123.12	4152.54	48864.0
2014-04-30 11:00:00	NQ	Futures	4152.54	4155.74	4142.35	4148.17	23378.0
2014-04-30 12:00:00	NQ	Futures	4147.88	4155.45	4147.59	4154.87	11607.0
2014-04-30 13:00:00	NQ	Futures	4154.58	4158.95	4150.21	4152.25	10150.0
2014-04-30 14:00:00	NQ	Futures	4151.66	4167.68	4144.97	4161.57	55422.0
2014-04-30 15:00:00	NQ	Futures	4161.57	4166.23	4149.33	4163.9	43855.0
2014-04-30 16:00:00	NQ	Futures	4163.6	4167.97	4162.15	4167.39	7550.0
2014-04-30 17:00:00	NQ	Futures	4167.1	4167.97	4167.1	4167.39	130.0
2014-04-30 18:00:00	NQ	Futures	4166.81	4169.72	4164.77	4167.1	900.0
2014-04-30 19:00:00	NQ	Futures	4167.1	4169.14	4166.81	4168.85	295.0
2014-04-30 20:00:00	NQ	Futures	4168.56	4169.14	4166.23	4166.81	513.0
2014-04-30 21:00:00	NQ	Futures	4166.81	4168.56	4164.77	4165.93	588.0
2014-04-30 22:00:00	NQ	Futures	4165.93	4167.68	4165.35	4165.35	217.0
2014-04-30 23:00:00	NQ	Futures	4165.35	4168.26	4165.35	4166.23	309.0
2014-04-30 00:00:00	YM	Futures	16941.2	16945.3	16938.1	16944.3	299.0
2014-04-30 01:00:00	YM	Futures	16943.2	16946.3	16928.8	16931.9	634.0

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

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