PREVIEW / futures_1hour / 2014-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-06.parquet
  size:    49 KB
  rows:    1,547

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-06 00:00:00	ES	Futures	1951.43	1951.69	1950.91	1951.43	829.0
2014-05-06 01:00:00	ES	Futures	1951.43	1951.69	1951.17	1951.43	914.0
2014-05-06 02:00:00	ES	Futures	1951.69	1952.73	1951.69	1952.47	5472.0
2014-05-06 03:00:00	ES	Futures	1952.47	1954.29	1951.69	1953.25	22421.0
2014-05-06 04:00:00	ES	Futures	1953.25	1953.25	1949.09	1950.39	20905.0
2014-05-06 05:00:00	ES	Futures	1950.65	1952.73	1950.39	1951.17	13368.0
2014-05-06 06:00:00	ES	Futures	1951.17	1951.69	1949.35	1949.61	14699.0
2014-05-06 07:00:00	ES	Futures	1949.87	1949.87	1947.53	1949.09	19954.0
2014-05-06 08:00:00	ES	Futures	1948.83	1949.09	1944.68	1945.2	29564.0
2014-05-06 09:00:00	ES	Futures	1944.94	1947.01	1941.56	1945.46	217515.0
2014-05-06 10:00:00	ES	Futures	1945.46	1948.05	1941.82	1942.6	222626.0
2014-05-06 11:00:00	ES	Futures	1942.6	1945.46	1940.78	1945.2	137481.0
2014-05-06 12:00:00	ES	Futures	1945.2	1945.46	1941.3	1943.38	66232.0
2014-05-06 13:00:00	ES	Futures	1943.12	1943.64	1936.37	1936.63	148737.0
2014-05-06 14:00:00	ES	Futures	1936.89	1938.19	1934.55	1935.85	158089.0
2014-05-06 15:00:00	ES	Futures	1935.85	1938.96	1933.77	1934.55	211638.0
2014-05-06 16:00:00	ES	Futures	1934.55	1937.15	1934.29	1936.63	76009.0
2014-05-06 17:00:00	ES	Futures	1936.37	1936.89	1936.11	1936.37	2017.0
2014-05-06 18:00:00	ES	Futures	1936.11	1936.89	1935.07	1935.59	4218.0
2014-05-06 19:00:00	ES	Futures	1935.59	1936.11	1935.07	1935.59	2678.0
2014-05-06 20:00:00	ES	Futures	1935.59	1936.11	1934.03	1935.07	4891.0
2014-05-06 21:00:00	ES	Futures	1935.33	1935.59	1933.25	1933.51	6843.0
2014-05-06 22:00:00	ES	Futures	1933.51	1935.85	1933.51	1935.59	7052.0
2014-05-06 23:00:00	ES	Futures	1935.85	1935.85	1934.81	1935.59	2547.0
2014-05-06 00:00:00	NQ	Futures	4189.23	4189.52	4187.78	4188.65	97.0
2014-05-06 01:00:00	NQ	Futures	4189.52	4189.81	4188.65	4189.52	153.0
2014-05-06 02:00:00	NQ	Futures	4190.11	4192.14	4190.11	4192.14	816.0
2014-05-06 03:00:00	NQ	Futures	4192.14	4194.47	4188.65	4193.31	4871.0
2014-05-06 04:00:00	NQ	Futures	4193.02	4193.31	4183.99	4191.56	4303.0
2014-05-06 05:00:00	NQ	Futures	4191.56	4197.97	4190.69	4194.18	2549.0
2014-05-06 06:00:00	NQ	Futures	4194.47	4195.35	4189.23	4189.81	1872.0
2014-05-06 07:00:00	NQ	Futures	4189.81	4189.81	4181.95	4184.57	4280.0
2014-05-06 08:00:00	NQ	Futures	4184.57	4185.74	4175.25	4176.71	5440.0
2014-05-06 09:00:00	NQ	Futures	4177.0	4184.86	4169.14	4183.99	43251.0
2014-05-06 10:00:00	NQ	Futures	4183.99	4185.45	4165.35	4166.23	38883.0
2014-05-06 11:00:00	NQ	Futures	4166.23	4173.51	4161.57	4172.92	26116.0
2014-05-06 12:00:00	NQ	Futures	4172.92	4173.8	4165.06	4169.72	10748.0
2014-05-06 13:00:00	NQ	Futures	4169.72	4170.89	4145.55	4145.84	30389.0
2014-05-06 14:00:00	NQ	Futures	4146.13	4149.04	4139.14	4141.76	33212.0
2014-05-06 15:00:00	NQ	Futures	4142.05	4150.21	4133.61	4135.65	43357.0
2014-05-06 16:00:00	NQ	Futures	4135.36	4138.85	4131.57	4136.81	7895.0
2014-05-06 17:00:00	NQ	Futures	4136.81	4138.27	4135.94	4135.94	584.0
2014-05-06 18:00:00	NQ	Futures	4136.52	4138.56	4133.61	4135.07	669.0
2014-05-06 19:00:00	NQ	Futures	4135.07	4137.1	4133.9	4135.94	316.0
2014-05-06 20:00:00	NQ	Futures	4135.94	4135.94	4130.99	4133.61	953.0
2014-05-06 21:00:00	NQ	Futures	4133.9	4134.48	4128.66	4129.82	914.0
2014-05-06 22:00:00	NQ	Futures	4129.82	4134.77	4129.82	4134.77	1079.0
2014-05-06 23:00:00	NQ	Futures	4134.77	4135.36	4133.32	4134.77	568.0
2014-05-06 00:00:00	YM	Futures	16961.8	16963.8	16956.6	16963.8	130.0
2014-05-06 01:00:00	YM	Futures	16961.8	16962.8	16959.7	16961.8	146.0

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

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