PREVIEW / futures_1hour / 2014-05-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	1955.06	1955.06	1954.29	1954.54	710.0
2014-05-20 01:00:00	ES	Futures	1954.8	1954.8	1954.03	1954.03	1112.0
2014-05-20 02:00:00	ES	Futures	1954.03	1954.29	1952.73	1953.25	6116.0
2014-05-20 03:00:00	ES	Futures	1952.99	1957.4	1952.47	1955.58	33065.0
2014-05-20 04:00:00	ES	Futures	1955.32	1955.58	1951.69	1952.47	31270.0
2014-05-20 05:00:00	ES	Futures	1952.47	1954.03	1952.21	1952.73	13000.0
2014-05-20 06:00:00	ES	Futures	1952.73	1954.29	1952.47	1954.03	22254.0
2014-05-20 07:00:00	ES	Futures	1953.77	1956.1	1953.77	1955.06	25069.0
2014-05-20 08:00:00	ES	Futures	1955.06	1956.1	1952.99	1953.51	27802.0
2014-05-20 09:00:00	ES	Futures	1953.25	1953.51	1946.5	1947.53	205857.0
2014-05-20 10:00:00	ES	Futures	1947.53	1952.73	1946.5	1952.21	212959.0
2014-05-20 11:00:00	ES	Futures	1952.47	1952.73	1949.35	1949.87	133986.0
2014-05-20 12:00:00	ES	Futures	1950.13	1950.13	1942.34	1944.68	201507.0
2014-05-20 13:00:00	ES	Futures	1944.42	1944.68	1936.89	1937.15	198730.0
2014-05-20 14:00:00	ES	Futures	1936.89	1941.56	1936.89	1938.96	149690.0
2014-05-20 15:00:00	ES	Futures	1938.96	1945.46	1938.45	1941.56	200890.0
2014-05-20 16:00:00	ES	Futures	1941.56	1942.08	1940.0	1941.04	75781.0
2014-05-20 17:00:00	ES	Futures	1941.3	1941.3	1940.78	1940.78	1233.0
2014-05-20 18:00:00	ES	Futures	1940.78	1941.04	1939.48	1939.74	5091.0
2014-05-20 19:00:00	ES	Futures	1939.74	1940.0	1938.71	1939.48	2025.0
2014-05-20 20:00:00	ES	Futures	1939.48	1940.26	1939.48	1939.74	3218.0
2014-05-20 21:00:00	ES	Futures	1939.74	1940.26	1938.71	1940.26	2833.0
2014-05-20 22:00:00	ES	Futures	1940.26	1941.82	1939.74	1940.26	4630.0
2014-05-20 23:00:00	ES	Futures	1940.26	1941.04	1939.22	1939.48	3811.0
2014-05-20 00:00:00	NQ	Futures	4211.37	4211.37	4209.91	4210.2	231.0
2014-05-20 01:00:00	NQ	Futures	4210.2	4211.07	4209.04	4209.33	231.0
2014-05-20 02:00:00	NQ	Futures	4209.62	4209.62	4205.54	4206.12	720.0
2014-05-20 03:00:00	NQ	Futures	4205.83	4218.06	4204.38	4213.99	4410.0
2014-05-20 04:00:00	NQ	Futures	4213.7	4213.7	4202.05	4202.92	4372.0
2014-05-20 05:00:00	NQ	Futures	4203.21	4207.87	4202.63	4204.96	2071.0
2014-05-20 06:00:00	NQ	Futures	4204.96	4208.74	4203.5	4207.0	2195.0
2014-05-20 07:00:00	NQ	Futures	4207.29	4214.86	4207.29	4210.78	6739.0
2014-05-20 08:00:00	NQ	Futures	4210.78	4214.57	4206.41	4207.87	5744.0
2014-05-20 09:00:00	NQ	Futures	4207.87	4211.37	4191.56	4195.35	37810.0
2014-05-20 10:00:00	NQ	Futures	4195.35	4213.4	4191.85	4212.53	44442.0
2014-05-20 11:00:00	NQ	Futures	4212.53	4221.27	4206.71	4216.32	34622.0
2014-05-20 12:00:00	NQ	Futures	4216.32	4217.19	4194.47	4199.43	39363.0
2014-05-20 13:00:00	NQ	Futures	4198.84	4199.13	4175.54	4176.13	34227.0
2014-05-20 14:00:00	NQ	Futures	4175.84	4189.23	4175.54	4180.2	31184.0
2014-05-20 15:00:00	NQ	Futures	4180.2	4199.13	4179.04	4193.31	39331.0
2014-05-20 16:00:00	NQ	Futures	4193.02	4194.18	4188.94	4193.02	6555.0
2014-05-20 17:00:00	NQ	Futures	4193.02	4193.31	4191.85	4192.14	299.0
2014-05-20 18:00:00	NQ	Futures	4192.44	4193.02	4187.78	4187.78	418.0
2014-05-20 19:00:00	NQ	Futures	4187.78	4188.07	4185.74	4187.78	337.0
2014-05-20 20:00:00	NQ	Futures	4187.78	4189.81	4187.78	4188.36	399.0
2014-05-20 21:00:00	NQ	Futures	4187.78	4190.11	4186.03	4190.11	391.0
2014-05-20 22:00:00	NQ	Futures	4190.11	4194.18	4188.65	4190.69	990.0
2014-05-20 23:00:00	NQ	Futures	4190.69	4192.14	4188.07	4188.07	488.0
2014-05-20 00:00:00	YM	Futures	16979.3	16979.3	16973.1	16975.2	184.0
2014-05-20 01:00:00	YM	Futures	16975.2	16977.2	16971.1	16971.1	154.0

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

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