PREVIEW / futures_1hour / 2014-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-21.parquet
  size:    51 KB
  rows:    1,590

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-21 00:00:00	ES	Futures	1939.74	1940.78	1939.22	1940.26	2248.0
2014-05-21 01:00:00	ES	Futures	1940.26	1942.08	1940.0	1941.82	3347.0
2014-05-21 02:00:00	ES	Futures	1942.08	1943.9	1940.26	1941.82	13485.0
2014-05-21 03:00:00	ES	Futures	1941.82	1945.46	1939.74	1943.9	32919.0
2014-05-21 04:00:00	ES	Futures	1943.9	1944.68	1942.6	1944.42	11358.0
2014-05-21 05:00:00	ES	Futures	1944.42	1946.75	1943.9	1945.2	20735.0
2014-05-21 06:00:00	ES	Futures	1944.94	1945.98	1942.6	1943.12	15357.0
2014-05-21 07:00:00	ES	Futures	1943.38	1945.72	1943.12	1945.2	12677.0
2014-05-21 08:00:00	ES	Futures	1945.2	1948.31	1943.9	1947.53	44055.0
2014-05-21 09:00:00	ES	Futures	1947.79	1955.32	1947.01	1953.25	250135.0
2014-05-21 10:00:00	ES	Futures	1953.51	1956.36	1952.73	1954.29	169242.0
2014-05-21 11:00:00	ES	Futures	1954.03	1955.32	1949.35	1950.91	171555.0
2014-05-21 12:00:00	ES	Futures	1950.91	1954.8	1950.13	1954.03	89557.0
2014-05-21 13:00:00	ES	Futures	1954.29	1955.84	1953.25	1954.54	65593.0
2014-05-21 14:00:00	ES	Futures	1954.8	1957.92	1951.69	1956.62	185746.0
2014-05-21 15:00:00	ES	Futures	1956.62	1959.48	1955.58	1958.18	152646.0
2014-05-21 16:00:00	ES	Futures	1957.92	1958.7	1956.36	1956.36	75579.0
2014-05-21 17:00:00	ES	Futures	1956.36	1956.88	1955.84	1956.36	3129.0
2014-05-21 18:00:00	ES	Futures	1956.62	1957.4	1956.1	1956.88	2477.0
2014-05-21 19:00:00	ES	Futures	1956.88	1957.92	1956.36	1957.4	2191.0
2014-05-21 20:00:00	ES	Futures	1957.4	1957.4	1955.84	1956.88	3311.0
2014-05-21 21:00:00	ES	Futures	1956.88	1961.82	1956.36	1959.74	17072.0
2014-05-21 22:00:00	ES	Futures	1959.74	1961.56	1959.48	1961.3	5730.0
2014-05-21 23:00:00	ES	Futures	1961.04	1961.82	1960.78	1961.56	3081.0
2014-05-21 00:00:00	NQ	Futures	4188.36	4191.27	4187.19	4189.81	373.0
2014-05-21 01:00:00	NQ	Futures	4190.11	4194.18	4189.52	4193.89	543.0
2014-05-21 02:00:00	NQ	Futures	4194.18	4198.26	4190.11	4192.73	1308.0
2014-05-21 03:00:00	NQ	Futures	4192.44	4203.21	4187.19	4199.13	4958.0
2014-05-21 04:00:00	NQ	Futures	4198.84	4200.59	4195.35	4199.72	1400.0
2014-05-21 05:00:00	NQ	Futures	4199.72	4206.12	4197.97	4201.46	3295.0
2014-05-21 06:00:00	NQ	Futures	4201.46	4203.79	4195.64	4196.8	2340.0
2014-05-21 07:00:00	NQ	Futures	4196.51	4202.05	4195.93	4201.46	1602.0
2014-05-21 08:00:00	NQ	Futures	4201.17	4204.96	4196.51	4203.5	8119.0
2014-05-21 09:00:00	NQ	Futures	4203.5	4223.31	4197.39	4217.19	49047.0
2014-05-21 10:00:00	NQ	Futures	4217.19	4225.64	4211.07	4218.35	44076.0
2014-05-21 11:00:00	NQ	Futures	4218.35	4221.27	4204.38	4211.37	32230.0
2014-05-21 12:00:00	NQ	Futures	4211.66	4221.27	4209.33	4219.23	15958.0
2014-05-21 13:00:00	NQ	Futures	4218.94	4224.47	4218.65	4221.56	16040.0
2014-05-21 14:00:00	NQ	Futures	4221.56	4230.59	4215.73	4227.67	34905.0
2014-05-21 15:00:00	NQ	Futures	4227.67	4235.25	4225.64	4232.92	28973.0
2014-05-21 16:00:00	NQ	Futures	4232.62	4234.95	4230.29	4231.46	5660.0
2014-05-21 17:00:00	NQ	Futures	4230.88	4232.62	4230.0	4230.59	334.0
2014-05-21 18:00:00	NQ	Futures	4230.29	4232.62	4230.0	4232.33	421.0
2014-05-21 19:00:00	NQ	Futures	4231.46	4234.08	4231.17	4232.62	177.0
2014-05-21 20:00:00	NQ	Futures	4233.21	4233.21	4230.0	4232.04	474.0
2014-05-21 21:00:00	NQ	Futures	4232.04	4245.44	4230.88	4238.45	2562.0
2014-05-21 22:00:00	NQ	Futures	4238.45	4240.78	4238.16	4239.91	1031.0
2014-05-21 23:00:00	NQ	Futures	4239.61	4242.23	4239.32	4241.94	516.0
2014-05-21 00:00:00	YM	Futures	16820.7	16832.0	16819.7	16826.9	932.0
2014-05-21 01:00:00	YM	Futures	16826.9	16840.3	16826.9	16838.2	1299.0

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

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