PREVIEW / futures_1hour / 2014-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-24.parquet
  size:    48 KB
  rows:    1,545

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-24 00:00:00	ES	Futures	1950.65	1951.17	1950.39	1950.91	1112.0
2014-04-24 01:00:00	ES	Futures	1950.91	1950.91	1949.87	1950.13	2254.0
2014-04-24 02:00:00	ES	Futures	1949.87	1951.95	1949.61	1951.69	7765.0
2014-04-24 03:00:00	ES	Futures	1951.69	1953.51	1950.65	1953.25	17914.0
2014-04-24 04:00:00	ES	Futures	1952.99	1952.99	1951.43	1952.73	8716.0
2014-04-24 05:00:00	ES	Futures	1952.47	1952.99	1951.69	1952.21	6495.0
2014-04-24 06:00:00	ES	Futures	1952.47	1954.8	1952.21	1953.51	15933.0
2014-04-24 07:00:00	ES	Futures	1953.77	1953.77	1950.91	1951.43	31466.0
2014-04-24 08:00:00	ES	Futures	1951.43	1955.32	1951.17	1952.21	50741.0
2014-04-24 09:00:00	ES	Futures	1952.21	1952.73	1937.15	1941.56	375219.0
2014-04-24 10:00:00	ES	Futures	1941.56	1945.2	1935.85	1943.12	376870.0
2014-04-24 11:00:00	ES	Futures	1943.38	1950.13	1942.08	1948.05	194374.0
2014-04-24 12:00:00	ES	Futures	1948.05	1949.61	1946.5	1948.83	78909.0
2014-04-24 13:00:00	ES	Futures	1948.57	1949.35	1941.3	1942.08	102398.0
2014-04-24 14:00:00	ES	Futures	1942.08	1945.72	1941.04	1944.42	109221.0
2014-04-24 15:00:00	ES	Futures	1944.42	1946.75	1943.64	1945.46	120731.0
2014-04-24 16:00:00	ES	Futures	1945.46	1948.05	1944.68	1946.24	53354.0
2014-04-24 17:00:00	ES	Futures	1946.5	1946.75	1945.46	1945.46	2121.0
2014-04-24 18:00:00	ES	Futures	1944.94	1945.2	1943.12	1944.94	3994.0
2014-04-24 19:00:00	ES	Futures	1944.68	1945.72	1944.68	1944.94	1480.0
2014-04-24 20:00:00	ES	Futures	1944.94	1945.46	1943.64	1945.2	2181.0
2014-04-24 21:00:00	ES	Futures	1945.2	1946.24	1944.94	1944.94	2764.0
2014-04-24 22:00:00	ES	Futures	1945.2	1945.72	1944.94	1945.46	1175.0
2014-04-24 23:00:00	ES	Futures	1945.46	1945.46	1943.9	1944.42	2556.0
2014-04-24 00:00:00	NQ	Futures	4183.41	4184.28	4183.12	4183.7	336.0
2014-04-24 01:00:00	NQ	Futures	4183.7	4183.99	4182.24	4182.83	512.0
2014-04-24 02:00:00	NQ	Futures	4182.53	4186.32	4181.08	4185.45	2390.0
2014-04-24 03:00:00	NQ	Futures	4185.74	4191.27	4184.57	4190.69	4829.0
2014-04-24 04:00:00	NQ	Futures	4190.4	4193.02	4188.36	4190.98	3369.0
2014-04-24 05:00:00	NQ	Futures	4190.98	4192.14	4189.23	4191.85	1789.0
2014-04-24 06:00:00	NQ	Futures	4191.56	4203.79	4191.27	4201.46	7084.0
2014-04-24 07:00:00	NQ	Futures	4201.46	4201.75	4195.93	4197.1	5793.0
2014-04-24 08:00:00	NQ	Futures	4197.39	4214.86	4196.8	4206.12	14617.0
2014-04-24 09:00:00	NQ	Futures	4206.12	4207.87	4142.05	4151.96	105867.0
2014-04-24 10:00:00	NQ	Futures	4151.66	4162.73	4128.37	4161.57	90867.0
2014-04-24 11:00:00	NQ	Futures	4161.57	4180.5	4156.03	4175.25	41468.0
2014-04-24 12:00:00	NQ	Futures	4175.25	4181.66	4171.18	4179.62	16189.0
2014-04-24 13:00:00	NQ	Futures	4179.62	4181.37	4161.57	4162.15	22523.0
2014-04-24 14:00:00	NQ	Futures	4162.15	4173.22	4160.69	4170.3	21145.0
2014-04-24 15:00:00	NQ	Futures	4170.59	4178.75	4170.3	4173.51	29472.0
2014-04-24 16:00:00	NQ	Futures	4173.51	4190.4	4172.05	4185.16	17046.0
2014-04-24 17:00:00	NQ	Futures	4185.45	4186.03	4180.2	4181.66	970.0
2014-04-24 18:00:00	NQ	Futures	4179.62	4179.91	4173.8	4177.87	1057.0
2014-04-24 19:00:00	NQ	Futures	4177.58	4179.33	4177.0	4177.0	403.0
2014-04-24 20:00:00	NQ	Futures	4177.0	4178.46	4174.09	4178.17	483.0
2014-04-24 21:00:00	NQ	Futures	4178.17	4181.66	4177.58	4178.17	609.0
2014-04-24 22:00:00	NQ	Futures	4178.17	4179.62	4178.17	4178.46	187.0
2014-04-24 23:00:00	NQ	Futures	4178.46	4178.46	4174.09	4176.42	843.0
2014-04-24 00:00:00	YM	Futures	16974.1	16977.2	16972.1	16972.1	295.0
2014-04-24 01:00:00	YM	Futures	16972.1	16974.1	16969.0	16972.1	488.0

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

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