PREVIEW / futures_1hour / 2014-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-01.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-04-01 00:00:00	ES	Futures	1937.93	1938.45	1937.15	1938.19	1438.0
2014-04-01 01:00:00	ES	Futures	1938.19	1938.71	1937.67	1938.19	2097.0
2014-04-01 02:00:00	ES	Futures	1938.19	1939.22	1937.67	1938.96	6434.0
2014-04-01 03:00:00	ES	Futures	1938.96	1939.48	1937.15	1939.22	15142.0
2014-04-01 04:00:00	ES	Futures	1939.22	1940.26	1938.45	1939.74	9569.0
2014-04-01 05:00:00	ES	Futures	1939.48	1940.0	1938.45	1939.48	7209.0
2014-04-01 06:00:00	ES	Futures	1939.48	1942.34	1938.71	1941.82	19185.0
2014-04-01 07:00:00	ES	Futures	1941.82	1942.08	1940.26	1942.08	13753.0
2014-04-01 08:00:00	ES	Futures	1942.08	1942.34	1940.78	1941.3	17606.0
2014-04-01 09:00:00	ES	Futures	1941.04	1947.53	1941.04	1947.27	214397.0
2014-04-01 10:00:00	ES	Futures	1947.27	1949.87	1944.16	1945.46	231642.0
2014-04-01 11:00:00	ES	Futures	1945.2	1946.24	1943.12	1943.38	123550.0
2014-04-01 12:00:00	ES	Futures	1943.38	1945.46	1941.56	1944.42	98924.0
2014-04-01 13:00:00	ES	Futures	1944.16	1946.24	1942.34	1945.98	79836.0
2014-04-01 14:00:00	ES	Futures	1945.98	1948.05	1945.46	1947.53	75023.0
2014-04-01 15:00:00	ES	Futures	1947.53	1951.17	1946.5	1950.13	183355.0
2014-04-01 16:00:00	ES	Futures	1950.13	1951.43	1949.61	1950.91	82043.0
2014-04-01 17:00:00	ES	Futures	1950.65	1951.17	1950.13	1950.91	2881.0
2014-04-01 18:00:00	ES	Futures	1950.39	1951.43	1949.61	1949.87	5075.0
2014-04-01 19:00:00	ES	Futures	1950.13	1950.65	1949.61	1950.39	2474.0
2014-04-01 20:00:00	ES	Futures	1950.39	1952.21	1950.13	1951.95	3797.0
2014-04-01 21:00:00	ES	Futures	1951.95	1956.36	1951.43	1953.51	18735.0
2014-04-01 22:00:00	ES	Futures	1953.51	1953.77	1951.95	1953.51	3812.0
2014-04-01 23:00:00	ES	Futures	1953.51	1954.03	1952.99	1953.51	2672.0
2014-04-01 00:00:00	NQ	Futures	4178.46	4178.75	4177.0	4178.17	241.0
2014-04-01 01:00:00	NQ	Futures	4178.17	4179.33	4177.0	4178.17	332.0
2014-04-01 02:00:00	NQ	Futures	4178.17	4181.08	4176.71	4178.75	1090.0
2014-04-01 03:00:00	NQ	Futures	4179.04	4179.91	4174.67	4179.62	2451.0
2014-04-01 04:00:00	NQ	Futures	4179.62	4181.95	4177.0	4180.5	2437.0
2014-04-01 05:00:00	NQ	Futures	4180.2	4182.83	4177.29	4180.5	2372.0
2014-04-01 06:00:00	NQ	Futures	4180.79	4190.69	4178.75	4190.11	4301.0
2014-04-01 07:00:00	NQ	Futures	4189.81	4192.14	4184.28	4191.27	3748.0
2014-04-01 08:00:00	NQ	Futures	4191.27	4191.27	4186.9	4188.36	4146.0
2014-04-01 09:00:00	NQ	Futures	4188.65	4231.46	4188.07	4229.42	57345.0
2014-04-01 10:00:00	NQ	Futures	4228.84	4243.4	4227.96	4236.7	57828.0
2014-04-01 11:00:00	NQ	Futures	4236.41	4238.74	4229.42	4230.29	29096.0
2014-04-01 12:00:00	NQ	Futures	4230.0	4234.08	4225.05	4229.13	18436.0
2014-04-01 13:00:00	NQ	Futures	4229.13	4235.54	4222.43	4234.08	15780.0
2014-04-01 14:00:00	NQ	Futures	4234.37	4241.07	4233.21	4240.49	16287.0
2014-04-01 15:00:00	NQ	Futures	4240.2	4253.88	4236.7	4251.26	37178.0
2014-04-01 16:00:00	NQ	Futures	4250.97	4255.05	4249.81	4254.17	7283.0
2014-04-01 17:00:00	NQ	Futures	4254.17	4254.17	4252.72	4253.88	239.0
2014-04-01 18:00:00	NQ	Futures	4252.43	4254.76	4249.81	4250.1	855.0
2014-04-01 19:00:00	NQ	Futures	4250.1	4251.55	4248.93	4250.97	378.0
2014-04-01 20:00:00	NQ	Futures	4251.26	4254.76	4249.52	4254.47	738.0
2014-04-01 21:00:00	NQ	Futures	4254.17	4266.41	4253.59	4258.83	2296.0
2014-04-01 22:00:00	NQ	Futures	4258.25	4260.58	4255.63	4260.58	693.0
2014-04-01 23:00:00	NQ	Futures	4260.29	4261.46	4259.13	4260.29	456.0
2014-04-01 00:00:00	YM	Futures	16879.4	16882.5	16873.2	16880.4	211.0
2014-04-01 01:00:00	YM	Futures	16880.4	16884.5	16876.3	16879.4	501.0

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

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