PREVIEW / futures_1hour / 2014-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-01.parquet
  size:    42 KB
  rows:    1,345

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-01 00:00:00	ES	Futures	1950.65	1950.91	1948.83	1949.61	3585.0
2014-05-01 01:00:00	ES	Futures	1949.87	1950.39	1949.61	1950.13	1595.0
2014-05-01 02:00:00	ES	Futures	1950.13	1950.91	1949.87	1950.39	3078.0
2014-05-01 03:00:00	ES	Futures	1950.39	1952.21	1950.13	1952.21	4046.0
2014-05-01 04:00:00	ES	Futures	1951.95	1953.25	1951.69	1952.21	4402.0
2014-05-01 05:00:00	ES	Futures	1951.95	1952.47	1951.69	1951.95	1413.0
2014-05-01 06:00:00	ES	Futures	1951.95	1952.47	1951.43	1952.47	1972.0
2014-05-01 07:00:00	ES	Futures	1952.47	1952.47	1950.13	1950.39	5549.0
2014-05-01 08:00:00	ES	Futures	1950.65	1951.43	1949.09	1949.61	13527.0
2014-05-01 09:00:00	ES	Futures	1949.61	1952.21	1946.75	1948.05	129513.0
2014-05-01 10:00:00	ES	Futures	1948.31	1952.73	1943.9	1951.69	207656.0
2014-05-01 11:00:00	ES	Futures	1951.43	1955.58	1950.13	1951.95	130684.0
2014-05-01 12:00:00	ES	Futures	1951.95	1954.03	1951.17	1952.21	65528.0
2014-05-01 13:00:00	ES	Futures	1952.21	1953.51	1946.75	1947.79	76993.0
2014-05-01 14:00:00	ES	Futures	1947.79	1950.91	1945.98	1948.31	94952.0
2014-05-01 15:00:00	ES	Futures	1948.31	1950.65	1946.24	1950.39	122358.0
2014-05-01 16:00:00	ES	Futures	1950.65	1951.69	1949.35	1951.43	46728.0
2014-05-01 17:00:00	ES	Futures	1951.69	1952.21	1951.43	1951.69	3272.0
2014-05-01 18:00:00	ES	Futures	1951.43	1952.21	1950.65	1951.43	2841.0
2014-05-01 19:00:00	ES	Futures	1951.69	1952.21	1950.91	1951.43	1141.0
2014-05-01 20:00:00	ES	Futures	1951.43	1951.69	1950.65	1951.69	3098.0
2014-05-01 21:00:00	ES	Futures	1951.43	1951.69	1950.65	1951.43	1429.0
2014-05-01 22:00:00	ES	Futures	1951.43	1951.69	1951.17	1951.43	1827.0
2014-05-01 23:00:00	ES	Futures	1951.17	1951.95	1951.17	1951.17	1120.0
2014-05-01 00:00:00	NQ	Futures	4166.52	4166.81	4161.86	4164.48	799.0
2014-05-01 01:00:00	NQ	Futures	4164.77	4166.81	4164.19	4165.64	326.0
2014-05-01 02:00:00	NQ	Futures	4165.64	4168.26	4165.35	4167.97	481.0
2014-05-01 03:00:00	NQ	Futures	4167.68	4173.51	4167.68	4173.22	1213.0
2014-05-01 04:00:00	NQ	Futures	4173.22	4177.0	4171.76	4173.51	1133.0
2014-05-01 05:00:00	NQ	Futures	4173.22	4174.09	4172.05	4172.05	411.0
2014-05-01 06:00:00	NQ	Futures	4172.63	4174.09	4171.76	4173.51	600.0
2014-05-01 07:00:00	NQ	Futures	4173.51	4174.38	4169.14	4171.47	1090.0
2014-05-01 08:00:00	NQ	Futures	4171.18	4173.51	4167.97	4168.56	2167.0
2014-05-01 09:00:00	NQ	Futures	4168.26	4179.91	4159.24	4172.63	25799.0
2014-05-01 10:00:00	NQ	Futures	4172.63	4190.98	4162.15	4187.49	42874.0
2014-05-01 11:00:00	NQ	Futures	4187.49	4200.01	4182.83	4185.45	29154.0
2014-05-01 12:00:00	NQ	Futures	4185.16	4192.73	4181.66	4186.32	14035.0
2014-05-01 13:00:00	NQ	Futures	4186.32	4189.81	4171.18	4174.09	19554.0
2014-05-01 14:00:00	NQ	Futures	4174.09	4181.95	4167.1	4173.22	18576.0
2014-05-01 15:00:00	NQ	Futures	4172.92	4179.04	4167.97	4176.42	28411.0
2014-05-01 16:00:00	NQ	Futures	4176.42	4181.37	4174.09	4181.37	4989.0
2014-05-01 17:00:00	NQ	Futures	4181.08	4184.57	4181.08	4183.7	673.0
2014-05-01 18:00:00	NQ	Futures	4181.37	4182.24	4179.04	4180.79	614.0
2014-05-01 19:00:00	NQ	Futures	4181.37	4182.83	4179.62	4180.5	222.0
2014-05-01 20:00:00	NQ	Futures	4180.5	4181.95	4179.91	4181.66	366.0
2014-05-01 21:00:00	NQ	Futures	4181.37	4181.66	4179.04	4179.91	412.0
2014-05-01 22:00:00	NQ	Futures	4180.2	4181.37	4179.91	4180.2	270.0
2014-05-01 23:00:00	NQ	Futures	4179.91	4181.66	4179.62	4179.91	353.0
2014-05-01 00:00:00	YM	Futures	17002.0	17002.0	16988.6	16994.7	528.0
2014-05-01 01:00:00	YM	Futures	16994.7	16998.9	16992.7	16995.8	276.0

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

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