PREVIEW / futures_1hour / 2014-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-05.parquet
  size:    44 KB
  rows:    1,414

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-05 00:00:00	ES	Futures	1944.68	1944.94	1944.16	1944.68	1203.0
2014-05-05 01:00:00	ES	Futures	1944.68	1945.98	1944.42	1945.72	1491.0
2014-05-05 02:00:00	ES	Futures	1945.72	1946.75	1945.46	1946.75	5520.0
2014-05-05 03:00:00	ES	Futures	1946.5	1947.79	1945.98	1946.75	10530.0
2014-05-05 04:00:00	ES	Futures	1947.01	1947.01	1939.74	1940.52	27437.0
2014-05-05 05:00:00	ES	Futures	1940.52	1940.52	1937.41	1939.22	18694.0
2014-05-05 06:00:00	ES	Futures	1939.22	1940.26	1938.71	1939.48	13493.0
2014-05-05 07:00:00	ES	Futures	1939.48	1939.74	1937.67	1939.22	16987.0
2014-05-05 08:00:00	ES	Futures	1939.22	1939.74	1937.93	1938.45	18060.0
2014-05-05 09:00:00	ES	Futures	1938.45	1940.78	1932.47	1940.26	254358.0
2014-05-05 10:00:00	ES	Futures	1940.78	1949.35	1938.71	1947.53	282427.0
2014-05-05 11:00:00	ES	Futures	1947.53	1950.91	1945.98	1949.35	131848.0
2014-05-05 12:00:00	ES	Futures	1949.35	1949.87	1946.75	1947.27	59529.0
2014-05-05 13:00:00	ES	Futures	1947.01	1948.31	1945.72	1948.05	53363.0
2014-05-05 14:00:00	ES	Futures	1948.05	1952.73	1948.05	1951.69	81657.0
2014-05-05 15:00:00	ES	Futures	1951.43	1951.95	1949.61	1951.17	104293.0
2014-05-05 16:00:00	ES	Futures	1951.17	1951.43	1948.05	1949.87	66932.0
2014-05-05 17:00:00	ES	Futures	1949.87	1950.91	1949.87	1950.65	2853.0
2014-05-05 18:00:00	ES	Futures	1950.13	1950.39	1949.35	1950.13	1783.0
2014-05-05 19:00:00	ES	Futures	1949.87	1950.13	1949.35	1949.87	1200.0
2014-05-05 20:00:00	ES	Futures	1949.87	1950.65	1949.35	1950.39	1620.0
2014-05-05 21:00:00	ES	Futures	1950.39	1951.69	1950.13	1951.43	2915.0
2014-05-05 22:00:00	ES	Futures	1951.43	1951.69	1950.65	1951.43	1313.0
2014-05-05 23:00:00	ES	Futures	1951.17	1951.43	1950.91	1951.43	1103.0
2014-05-05 00:00:00	NQ	Futures	4165.35	4165.35	4163.02	4164.77	133.0
2014-05-05 01:00:00	NQ	Futures	4164.77	4167.1	4163.6	4166.81	384.0
2014-05-05 02:00:00	NQ	Futures	4166.81	4169.72	4166.23	4169.72	703.0
2014-05-05 03:00:00	NQ	Futures	4169.43	4172.63	4167.68	4169.72	1733.0
2014-05-05 04:00:00	NQ	Futures	4169.43	4170.3	4153.41	4154.87	6274.0
2014-05-05 05:00:00	NQ	Futures	4154.87	4154.87	4146.42	4151.08	3641.0
2014-05-05 06:00:00	NQ	Futures	4151.37	4155.16	4149.92	4153.12	2429.0
2014-05-05 07:00:00	NQ	Futures	4153.12	4153.12	4147.01	4151.37	3186.0
2014-05-05 08:00:00	NQ	Futures	4151.66	4152.83	4147.01	4147.59	4005.0
2014-05-05 09:00:00	NQ	Futures	4147.59	4163.31	4133.03	4162.44	50777.0
2014-05-05 10:00:00	NQ	Futures	4163.31	4184.86	4156.03	4176.71	66304.0
2014-05-05 11:00:00	NQ	Futures	4177.0	4183.12	4170.89	4180.5	21461.0
2014-05-05 12:00:00	NQ	Futures	4180.5	4181.95	4172.05	4173.51	13697.0
2014-05-05 13:00:00	NQ	Futures	4173.22	4179.33	4170.3	4178.17	12939.0
2014-05-05 14:00:00	NQ	Futures	4178.75	4190.98	4177.87	4188.36	17048.0
2014-05-05 15:00:00	NQ	Futures	4188.36	4191.27	4184.57	4190.11	20201.0
2014-05-05 16:00:00	NQ	Futures	4189.81	4191.27	4181.37	4187.49	5958.0
2014-05-05 17:00:00	NQ	Futures	4187.78	4189.81	4187.49	4189.52	198.0
2014-05-05 18:00:00	NQ	Futures	4187.78	4187.78	4183.99	4185.16	952.0
2014-05-05 19:00:00	NQ	Futures	4184.86	4186.32	4183.99	4186.03	249.0
2014-05-05 20:00:00	NQ	Futures	4185.74	4186.32	4184.86	4186.32	219.0
2014-05-05 21:00:00	NQ	Futures	4186.32	4189.52	4186.03	4189.23	424.0
2014-05-05 22:00:00	NQ	Futures	4189.23	4189.23	4187.49	4188.07	214.0
2014-05-05 23:00:00	NQ	Futures	4188.36	4189.23	4187.78	4188.65	119.0
2014-05-05 00:00:00	YM	Futures	16918.5	16919.6	16913.4	16916.5	160.0
2014-05-05 01:00:00	YM	Futures	16917.5	16927.8	16915.4	16924.7	269.0

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

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