PREVIEW / futures_1hour / 2014-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-29.parquet
  size:    49 KB
  rows:    1,565

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-29 00:00:00	ES	Futures	1941.3	1941.56	1940.52	1941.3	1189.0
2014-04-29 01:00:00	ES	Futures	1941.3	1941.82	1939.74	1940.78	3536.0
2014-04-29 02:00:00	ES	Futures	1940.78	1941.82	1940.26	1941.3	7242.0
2014-04-29 03:00:00	ES	Futures	1941.56	1943.9	1941.3	1942.08	27060.0
2014-04-29 04:00:00	ES	Futures	1941.82	1943.12	1941.04	1942.86	18503.0
2014-04-29 05:00:00	ES	Futures	1942.86	1944.16	1941.82	1944.16	15615.0
2014-04-29 06:00:00	ES	Futures	1944.16	1945.2	1943.64	1944.42	16690.0
2014-04-29 07:00:00	ES	Futures	1944.42	1945.2	1942.86	1944.16	15921.0
2014-04-29 08:00:00	ES	Futures	1944.16	1944.94	1942.34	1942.86	30346.0
2014-04-29 09:00:00	ES	Futures	1942.86	1947.01	1940.52	1944.16	225615.0
2014-04-29 10:00:00	ES	Futures	1944.16	1945.98	1937.41	1942.6	275201.0
2014-04-29 11:00:00	ES	Futures	1942.34	1945.72	1940.26	1944.42	137618.0
2014-04-29 12:00:00	ES	Futures	1944.42	1947.79	1943.38	1946.75	91795.0
2014-04-29 13:00:00	ES	Futures	1946.75	1947.27	1943.64	1946.5	95517.0
2014-04-29 14:00:00	ES	Futures	1946.5	1947.01	1944.94	1945.2	55477.0
2014-04-29 15:00:00	ES	Futures	1945.46	1946.5	1943.9	1944.42	123434.0
2014-04-29 16:00:00	ES	Futures	1944.68	1944.68	1942.34	1942.86	52142.0
2014-04-29 17:00:00	ES	Futures	1942.86	1943.12	1942.6	1942.86	1419.0
2014-04-29 18:00:00	ES	Futures	1942.86	1943.64	1942.34	1943.12	2565.0
2014-04-29 19:00:00	ES	Futures	1943.12	1943.38	1941.82	1942.08	1658.0
2014-04-29 20:00:00	ES	Futures	1942.08	1942.08	1940.78	1941.82	5587.0
2014-04-29 21:00:00	ES	Futures	1941.82	1942.08	1941.3	1942.08	1960.0
2014-04-29 22:00:00	ES	Futures	1941.82	1942.34	1941.3	1941.56	2379.0
2014-04-29 23:00:00	ES	Futures	1941.56	1942.34	1941.04	1941.3	2446.0
2014-04-29 00:00:00	NQ	Futures	4133.9	4133.9	4132.44	4133.32	439.0
2014-04-29 01:00:00	NQ	Futures	4133.61	4134.48	4129.82	4131.86	792.0
2014-04-29 02:00:00	NQ	Futures	4131.86	4136.52	4130.99	4134.77	1439.0
2014-04-29 03:00:00	NQ	Futures	4135.07	4140.6	4133.32	4135.65	5001.0
2014-04-29 04:00:00	NQ	Futures	4135.36	4138.56	4132.15	4137.39	3181.0
2014-04-29 05:00:00	NQ	Futures	4137.69	4143.22	4135.36	4142.64	2629.0
2014-04-29 06:00:00	NQ	Futures	4142.64	4146.13	4142.05	4143.8	2874.0
2014-04-29 07:00:00	NQ	Futures	4143.8	4145.55	4137.98	4140.31	3414.0
2014-04-29 08:00:00	NQ	Futures	4140.6	4141.76	4130.41	4132.15	9036.0
2014-04-29 09:00:00	NQ	Futures	4132.44	4147.01	4121.09	4134.19	59012.0
2014-04-29 10:00:00	NQ	Futures	4134.19	4140.31	4112.06	4132.74	78873.0
2014-04-29 11:00:00	NQ	Futures	4133.03	4146.71	4124.58	4141.47	39915.0
2014-04-29 12:00:00	NQ	Futures	4141.47	4160.11	4140.02	4155.45	31533.0
2014-04-29 13:00:00	NQ	Futures	4155.16	4159.24	4147.59	4158.07	20534.0
2014-04-29 14:00:00	NQ	Futures	4158.07	4159.53	4153.7	4156.32	12046.0
2014-04-29 15:00:00	NQ	Futures	4156.32	4159.24	4149.63	4152.25	24338.0
2014-04-29 16:00:00	NQ	Futures	4152.25	4153.12	4143.22	4143.22	7108.0
2014-04-29 17:00:00	NQ	Futures	4143.8	4145.84	4143.8	4144.38	327.0
2014-04-29 18:00:00	NQ	Futures	4143.8	4145.26	4142.64	4144.38	749.0
2014-04-29 19:00:00	NQ	Futures	4144.38	4144.68	4141.76	4142.05	292.0
2014-04-29 20:00:00	NQ	Futures	4141.76	4142.05	4139.14	4141.47	810.0
2014-04-29 21:00:00	NQ	Futures	4141.18	4142.64	4140.31	4142.05	412.0
2014-04-29 22:00:00	NQ	Futures	4141.76	4142.35	4140.89	4141.47	391.0
2014-04-29 23:00:00	NQ	Futures	4141.47	4142.05	4137.98	4138.85	1044.0
2014-04-29 00:00:00	YM	Futures	16910.3	16915.4	16907.2	16915.4	203.0
2014-04-29 01:00:00	YM	Futures	16916.5	16917.5	16902.1	16905.1	467.0

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

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