PREVIEW / futures_1hour / 2014-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-16.parquet
  size:    56 KB
  rows:    1,652

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-10-16 00:00:00	ES	Futures	1941.44	1941.7	1939.61	1939.87	4024.0
2014-10-16 01:00:00	ES	Futures	1939.61	1941.18	1938.3	1939.61	7655.0
2014-10-16 02:00:00	ES	Futures	1939.61	1943.54	1938.56	1940.92	16805.0
2014-10-16 03:00:00	ES	Futures	1940.92	1946.16	1933.58	1938.3	73198.0
2014-10-16 04:00:00	ES	Futures	1938.3	1941.18	1931.49	1933.58	43871.0
2014-10-16 05:00:00	ES	Futures	1934.11	1934.37	1905.81	1914.72	117479.0
2014-10-16 06:00:00	ES	Futures	1914.46	1921.79	1903.45	1910.0	114598.0
2014-10-16 07:00:00	ES	Futures	1909.74	1917.08	1902.15	1916.03	86526.0
2014-10-16 08:00:00	ES	Futures	1916.03	1921.27	1905.03	1910.53	124647.0
2014-10-16 09:00:00	ES	Futures	1910.53	1934.89	1909.74	1933.32	466435.0
2014-10-16 10:00:00	ES	Futures	1933.58	1945.37	1915.24	1937.77	694952.0
2014-10-16 11:00:00	ES	Futures	1937.77	1950.87	1932.53	1937.25	376254.0
2014-10-16 12:00:00	ES	Futures	1937.51	1947.73	1933.06	1946.42	218321.0
2014-10-16 13:00:00	ES	Futures	1946.42	1959.25	1946.16	1949.04	293306.0
2014-10-16 14:00:00	ES	Futures	1949.04	1954.54	1940.39	1943.01	243067.0
2014-10-16 15:00:00	ES	Futures	1943.01	1950.87	1938.03	1945.11	302779.0
2014-10-16 16:00:00	ES	Futures	1945.37	1945.37	1936.46	1939.34	115337.0
2014-10-16 17:00:00	ES	Futures	1939.34	1941.96	1938.82	1941.7	3382.0
2014-10-16 18:00:00	ES	Futures	1941.7	1946.16	1941.7	1945.89	8603.0
2014-10-16 19:00:00	ES	Futures	1945.89	1945.89	1942.49	1945.37	3068.0
2014-10-16 20:00:00	ES	Futures	1945.37	1950.61	1945.11	1947.99	10204.0
2014-10-16 21:00:00	ES	Futures	1947.99	1953.49	1947.73	1950.61	8365.0
2014-10-16 22:00:00	ES	Futures	1950.35	1952.18	1948.25	1950.61	6164.0
2014-10-16 23:00:00	ES	Futures	1950.35	1951.66	1943.01	1943.27	6466.0
2014-10-16 00:00:00	NQ	Futures	4408.86	4409.15	4403.0	4403.88	480.0
2014-10-16 01:00:00	NQ	Futures	4402.41	4406.81	4398.89	4402.12	744.0
2014-10-16 02:00:00	NQ	Futures	4401.82	4411.79	4400.07	4403.29	1564.0
2014-10-16 03:00:00	NQ	Futures	4403.88	4414.13	4386.0	4398.02	9868.0
2014-10-16 04:00:00	NQ	Futures	4398.6	4399.77	4380.14	4384.24	7455.0
2014-10-16 05:00:00	NQ	Futures	4384.83	4385.42	4334.43	4354.06	18122.0
2014-10-16 06:00:00	NQ	Futures	4354.36	4361.98	4320.96	4334.73	14469.0
2014-10-16 07:00:00	NQ	Futures	4334.14	4349.38	4317.73	4348.79	8821.0
2014-10-16 08:00:00	NQ	Futures	4349.38	4364.32	4326.82	4342.05	21590.0
2014-10-16 09:00:00	NQ	Futures	4341.47	4384.24	4333.26	4382.19	98169.0
2014-10-16 10:00:00	NQ	Futures	4382.49	4404.46	4336.78	4388.64	155099.0
2014-10-16 11:00:00	NQ	Futures	4388.64	4416.77	4376.63	4384.83	94591.0
2014-10-16 12:00:00	NQ	Futures	4384.83	4407.98	4372.82	4403.58	49420.0
2014-10-16 13:00:00	NQ	Futures	4403.58	4437.86	4403.29	4413.55	69385.0
2014-10-16 14:00:00	NQ	Futures	4412.96	4423.21	4395.09	4397.72	50438.0
2014-10-16 15:00:00	NQ	Futures	4398.02	4418.82	4386.3	4401.82	64225.0
2014-10-16 16:00:00	NQ	Futures	4401.53	4401.82	4371.94	4387.47	23710.0
2014-10-16 17:00:00	NQ	Futures	4387.76	4392.74	4385.42	4390.98	284.0
2014-10-16 18:00:00	NQ	Futures	4392.74	4401.24	4390.69	4400.95	1290.0
2014-10-16 19:00:00	NQ	Futures	4400.65	4401.24	4393.33	4400.65	601.0
2014-10-16 20:00:00	NQ	Futures	4400.36	4410.62	4400.36	4403.29	1586.0
2014-10-16 21:00:00	NQ	Futures	4403.29	4413.84	4401.24	4405.63	1894.0
2014-10-16 22:00:00	NQ	Futures	4405.05	4408.86	4401.24	4405.63	977.0
2014-10-16 23:00:00	NQ	Futures	4405.63	4407.39	4390.4	4390.4	963.0
2014-10-16 00:00:00	YM	Futures	16696.5	16697.6	16684.0	16685.1	447.0
2014-10-16 01:00:00	YM	Futures	16684.0	16695.5	16677.8	16690.3	975.0

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

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