PREVIEW / futures_1hour / 2014-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-26.parquet
  size:    49 KB
  rows:    1,522

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-03-26 00:00:00	ES	Futures	1933.25	1934.03	1932.99	1933.25	896.0
2014-03-26 01:00:00	ES	Futures	1933.25	1934.03	1932.73	1933.25	2405.0
2014-03-26 02:00:00	ES	Futures	1933.25	1933.77	1932.21	1933.77	4518.0
2014-03-26 03:00:00	ES	Futures	1933.51	1934.03	1931.69	1932.21	5934.0
2014-03-26 04:00:00	ES	Futures	1932.21	1933.25	1930.91	1932.99	23541.0
2014-03-26 05:00:00	ES	Futures	1932.99	1935.59	1932.47	1934.03	26943.0
2014-03-26 06:00:00	ES	Futures	1934.03	1937.67	1934.03	1937.67	22838.0
2014-03-26 07:00:00	ES	Futures	1937.67	1938.71	1936.63	1937.93	24239.0
2014-03-26 08:00:00	ES	Futures	1937.93	1939.74	1936.89	1938.45	39047.0
2014-03-26 09:00:00	ES	Futures	1938.71	1941.04	1935.33	1936.63	223644.0
2014-03-26 10:00:00	ES	Futures	1936.37	1938.96	1932.21	1932.73	225398.0
2014-03-26 11:00:00	ES	Futures	1932.47	1937.15	1931.43	1934.55	181533.0
2014-03-26 12:00:00	ES	Futures	1934.29	1935.33	1931.17	1935.07	161727.0
2014-03-26 13:00:00	ES	Futures	1935.07	1935.33	1922.09	1925.72	281098.0
2014-03-26 14:00:00	ES	Futures	1925.72	1927.54	1920.79	1927.02	226909.0
2014-03-26 15:00:00	ES	Futures	1927.28	1927.8	1915.59	1916.11	298721.0
2014-03-26 16:00:00	ES	Futures	1915.85	1916.37	1912.74	1915.59	119851.0
2014-03-26 17:00:00	ES	Futures	1915.59	1916.89	1915.33	1916.63	6918.0
2014-03-26 18:00:00	ES	Futures	1916.37	1916.89	1914.04	1914.3	6513.0
2014-03-26 19:00:00	ES	Futures	1914.3	1916.63	1914.04	1916.63	4736.0
2014-03-26 20:00:00	ES	Futures	1916.63	1916.89	1914.82	1916.11	6687.0
2014-03-26 21:00:00	ES	Futures	1916.11	1916.89	1915.33	1916.63	3581.0
2014-03-26 22:00:00	ES	Futures	1916.63	1916.89	1914.3	1914.3	4802.0
2014-03-26 23:00:00	ES	Futures	1914.3	1917.15	1913.52	1916.89	5722.0
2014-03-26 00:00:00	NQ	Futures	4225.93	4227.09	4225.93	4226.51	107.0
2014-03-26 01:00:00	NQ	Futures	4226.51	4227.09	4223.89	4225.05	444.0
2014-03-26 02:00:00	NQ	Futures	4225.05	4226.51	4223.6	4226.51	468.0
2014-03-26 03:00:00	NQ	Futures	4225.93	4226.51	4223.01	4224.18	516.0
2014-03-26 04:00:00	NQ	Futures	4223.89	4227.67	4221.56	4227.38	2120.0
2014-03-26 05:00:00	NQ	Futures	4227.38	4234.08	4226.51	4231.75	2780.0
2014-03-26 06:00:00	NQ	Futures	4231.46	4240.78	4231.46	4240.49	2893.0
2014-03-26 07:00:00	NQ	Futures	4240.49	4243.11	4235.83	4239.91	3516.0
2014-03-26 08:00:00	NQ	Futures	4239.91	4246.89	4238.45	4243.4	7744.0
2014-03-26 09:00:00	NQ	Futures	4243.4	4248.93	4225.64	4235.83	50867.0
2014-03-26 10:00:00	NQ	Futures	4235.83	4243.11	4213.99	4214.86	50657.0
2014-03-26 11:00:00	NQ	Futures	4215.15	4230.29	4209.62	4216.9	37264.0
2014-03-26 12:00:00	NQ	Futures	4217.48	4219.52	4205.54	4216.61	28820.0
2014-03-26 13:00:00	NQ	Futures	4216.32	4217.77	4181.08	4192.44	51463.0
2014-03-26 14:00:00	NQ	Futures	4192.44	4200.59	4174.96	4198.26	43835.0
2014-03-26 15:00:00	NQ	Futures	4198.26	4200.59	4163.02	4164.19	55435.0
2014-03-26 16:00:00	NQ	Futures	4164.19	4165.35	4159.53	4165.06	10455.0
2014-03-26 17:00:00	NQ	Futures	4165.06	4169.14	4164.77	4168.56	338.0
2014-03-26 18:00:00	NQ	Futures	4167.68	4168.85	4161.86	4161.86	1001.0
2014-03-26 19:00:00	NQ	Futures	4161.57	4166.81	4161.57	4166.52	661.0
2014-03-26 20:00:00	NQ	Futures	4166.52	4166.81	4162.15	4165.06	749.0
2014-03-26 21:00:00	NQ	Futures	4165.35	4166.81	4163.31	4166.52	842.0
2014-03-26 22:00:00	NQ	Futures	4166.81	4166.81	4160.69	4161.28	668.0
2014-03-26 23:00:00	NQ	Futures	4161.28	4167.97	4159.82	4167.68	1025.0
2014-03-26 00:00:00	YM	Futures	16801.1	16807.3	16801.1	16803.2	79.0
2014-03-26 01:00:00	YM	Futures	16805.2	16807.3	16800.1	16804.2	420.0

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

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