PREVIEW / futures_1hour / 2014-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-19.parquet
  size:    51 KB
  rows:    1,552

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-19 00:00:00	ES	Futures	1933.51	1936.89	1933.25	1936.37	4370.0
2014-03-19 01:00:00	ES	Futures	1936.37	1937.41	1934.29	1934.55	3765.0
2014-03-19 02:00:00	ES	Futures	1934.29	1936.63	1934.03	1936.37	3792.0
2014-03-19 03:00:00	ES	Futures	1936.37	1937.93	1935.59	1937.93	6584.0
2014-03-19 04:00:00	ES	Futures	1937.67	1937.67	1935.07	1936.89	22875.0
2014-03-19 05:00:00	ES	Futures	1936.63	1939.74	1936.37	1937.15	18974.0
2014-03-19 06:00:00	ES	Futures	1937.15	1938.19	1936.37	1937.15	18629.0
2014-03-19 07:00:00	ES	Futures	1937.15	1938.96	1936.37	1938.71	23975.0
2014-03-19 08:00:00	ES	Futures	1938.45	1939.48	1937.67	1938.19	22033.0
2014-03-19 09:00:00	ES	Futures	1938.19	1938.96	1934.03	1938.19	134990.0
2014-03-19 10:00:00	ES	Futures	1938.45	1939.48	1936.11	1937.15	122470.0
2014-03-19 11:00:00	ES	Futures	1937.15	1938.19	1935.07	1935.85	63334.0
2014-03-19 12:00:00	ES	Futures	1936.11	1937.67	1935.07	1937.67	83735.0
2014-03-19 13:00:00	ES	Futures	1937.41	1938.96	1936.63	1938.45	52080.0
2014-03-19 14:00:00	ES	Futures	1938.45	1938.71	1926.76	1931.95	415856.0
2014-03-19 15:00:00	ES	Futures	1932.21	1932.47	1913.26	1925.98	492011.0
2014-03-19 16:00:00	ES	Futures	1925.72	1926.24	1921.31	1921.31	76140.0
2014-03-19 17:00:00	ES	Futures	1921.57	1923.12	1921.31	1922.61	2531.0
2014-03-19 18:00:00	ES	Futures	1922.87	1924.42	1922.87	1923.64	5450.0
2014-03-19 19:00:00	ES	Futures	1923.64	1925.46	1923.12	1924.94	2843.0
2014-03-19 20:00:00	ES	Futures	1925.2	1925.2	1920.79	1922.35	9823.0
2014-03-19 21:00:00	ES	Futures	1922.35	1922.35	1918.19	1920.27	10723.0
2014-03-19 22:00:00	ES	Futures	1920.27	1922.09	1918.45	1920.27	7033.0
2014-03-19 23:00:00	ES	Futures	1920.27	1920.27	1917.15	1917.93	6610.0
2014-03-19 00:00:00	NQ	Futures	4302.52	4309.51	4301.64	4308.63	892.0
2014-03-19 01:00:00	NQ	Futures	4308.63	4311.55	4303.1	4303.39	816.0
2014-03-19 02:00:00	NQ	Futures	4303.39	4308.05	4302.52	4307.47	368.0
2014-03-19 03:00:00	NQ	Futures	4308.05	4311.55	4305.43	4311.55	631.0
2014-03-19 04:00:00	NQ	Futures	4311.25	4312.42	4306.6	4310.67	3401.0
2014-03-19 05:00:00	NQ	Futures	4311.25	4316.21	4308.63	4310.09	2994.0
2014-03-19 06:00:00	NQ	Futures	4310.09	4313.58	4309.51	4310.67	2674.0
2014-03-19 07:00:00	NQ	Futures	4310.38	4313.88	4308.92	4312.71	3136.0
2014-03-19 08:00:00	NQ	Futures	4312.71	4314.17	4310.09	4310.96	5905.0
2014-03-19 09:00:00	NQ	Futures	4310.67	4312.71	4296.4	4310.96	39632.0
2014-03-19 10:00:00	NQ	Futures	4311.25	4313.29	4292.91	4300.77	32425.0
2014-03-19 11:00:00	NQ	Futures	4300.77	4307.18	4298.15	4303.39	13422.0
2014-03-19 12:00:00	NQ	Futures	4303.68	4308.92	4301.06	4307.76	15543.0
2014-03-19 13:00:00	NQ	Futures	4307.76	4311.25	4306.6	4310.96	8821.0
2014-03-19 14:00:00	NQ	Futures	4310.96	4310.96	4287.37	4294.07	64669.0
2014-03-19 15:00:00	NQ	Futures	4294.36	4294.95	4254.76	4283.3	83679.0
2014-03-19 16:00:00	NQ	Futures	4283.59	4284.46	4274.56	4275.14	6393.0
2014-03-19 17:00:00	NQ	Futures	4275.14	4280.09	4275.14	4279.22	276.0
2014-03-19 18:00:00	NQ	Futures	4279.51	4282.13	4278.06	4280.38	495.0
2014-03-19 19:00:00	NQ	Futures	4279.51	4284.17	4278.93	4283.59	462.0
2014-03-19 20:00:00	NQ	Futures	4283.59	4283.59	4272.23	4274.85	1348.0
2014-03-19 21:00:00	NQ	Futures	4275.14	4275.43	4266.41	4272.23	1341.0
2014-03-19 22:00:00	NQ	Futures	4271.65	4274.85	4267.57	4270.77	859.0
2014-03-19 23:00:00	NQ	Futures	4271.65	4271.65	4265.53	4267.28	1309.0
2014-03-19 00:00:00	YM	Futures	16732.1	16761.0	16728.0	16758.9	863.0
2014-03-19 01:00:00	YM	Futures	16757.9	16765.1	16738.3	16740.4	784.0

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

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