PREVIEW / futures_1hour / 2014-10-15

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-15.parquet
  size:    57 KB
  rows:    1,636

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-15 00:00:00	ES	Futures	1963.71	1964.23	1962.14	1964.23	4951.0
2014-10-15 01:00:00	ES	Futures	1964.23	1966.33	1963.45	1965.54	6080.0
2014-10-15 02:00:00	ES	Futures	1965.8	1968.95	1965.28	1967.9	13538.0
2014-10-15 03:00:00	ES	Futures	1968.16	1968.16	1959.52	1959.78	36081.0
2014-10-15 04:00:00	ES	Futures	1959.78	1960.83	1956.11	1957.42	42141.0
2014-10-15 05:00:00	ES	Futures	1957.68	1962.14	1955.06	1960.83	30628.0
2014-10-15 06:00:00	ES	Futures	1961.09	1963.18	1958.73	1959.25	29271.0
2014-10-15 07:00:00	ES	Futures	1959.25	1960.83	1946.16	1946.16	113951.0
2014-10-15 08:00:00	ES	Futures	1946.16	1954.01	1936.99	1939.61	201111.0
2014-10-15 09:00:00	ES	Futures	1939.61	1944.58	1918.13	1941.44	651612.0
2014-10-15 10:00:00	ES	Futures	1941.44	1949.82	1931.49	1937.77	651695.0
2014-10-15 11:00:00	ES	Futures	1937.77	1944.32	1924.41	1930.96	451571.0
2014-10-15 12:00:00	ES	Futures	1930.96	1931.22	1913.41	1915.77	438950.0
2014-10-15 13:00:00	ES	Futures	1915.51	1920.74	1899.79	1910.27	546045.0
2014-10-15 14:00:00	ES	Futures	1910.27	1930.96	1905.29	1929.65	484389.0
2014-10-15 15:00:00	ES	Futures	1929.39	1952.18	1923.89	1946.16	736227.0
2014-10-15 16:00:00	ES	Futures	1946.42	1947.2	1931.22	1934.11	148928.0
2014-10-15 17:00:00	ES	Futures	1934.11	1934.89	1932.8	1934.89	3834.0
2014-10-15 18:00:00	ES	Futures	1935.15	1936.99	1930.18	1933.32	13983.0
2014-10-15 19:00:00	ES	Futures	1933.32	1938.03	1931.49	1935.42	6880.0
2014-10-15 20:00:00	ES	Futures	1935.42	1937.77	1934.63	1937.25	10889.0
2014-10-15 21:00:00	ES	Futures	1936.99	1938.82	1936.46	1938.82	7178.0
2014-10-15 22:00:00	ES	Futures	1938.82	1940.65	1938.03	1939.61	9316.0
2014-10-15 23:00:00	ES	Futures	1939.61	1941.44	1938.82	1941.18	6022.0
2014-10-15 00:00:00	NQ	Futures	4468.34	4469.8	4462.18	4467.75	732.0
2014-10-15 01:00:00	NQ	Futures	4467.17	4473.9	4465.7	4473.9	523.0
2014-10-15 02:00:00	NQ	Futures	4472.73	4480.35	4472.15	4477.42	1162.0
2014-10-15 03:00:00	NQ	Futures	4478.01	4478.01	4459.25	4461.6	5205.0
2014-10-15 04:00:00	NQ	Futures	4461.31	4465.11	4454.27	4458.38	5429.0
2014-10-15 05:00:00	NQ	Futures	4458.08	4469.22	4453.1	4466.58	4061.0
2014-10-15 06:00:00	NQ	Futures	4466.87	4471.27	4460.72	4462.48	3465.0
2014-10-15 07:00:00	NQ	Futures	4462.48	4466.58	4429.07	4430.25	18970.0
2014-10-15 08:00:00	NQ	Futures	4430.25	4452.22	4408.27	4411.2	35710.0
2014-10-15 09:00:00	NQ	Futures	4410.91	4423.8	4373.11	4411.49	126468.0
2014-10-15 10:00:00	NQ	Futures	4411.79	4435.81	4398.6	4409.44	126607.0
2014-10-15 11:00:00	NQ	Futures	4408.86	4431.13	4379.56	4398.6	86793.0
2014-10-15 12:00:00	NQ	Futures	4398.6	4398.89	4353.48	4362.27	78598.0
2014-10-15 13:00:00	NQ	Futures	4361.98	4374.58	4326.23	4349.08	100216.0
2014-10-15 14:00:00	NQ	Futures	4349.08	4395.09	4338.24	4391.57	84496.0
2014-10-15 15:00:00	NQ	Futures	4392.16	4446.36	4379.85	4429.07	124296.0
2014-10-15 16:00:00	NQ	Futures	4429.07	4429.95	4381.31	4388.35	20044.0
2014-10-15 17:00:00	NQ	Futures	4388.35	4391.86	4384.54	4391.28	609.0
2014-10-15 18:00:00	NQ	Futures	4396.26	4401.53	4384.24	4391.57	2777.0
2014-10-15 19:00:00	NQ	Futures	4391.57	4400.95	4386.59	4395.67	920.0
2014-10-15 20:00:00	NQ	Futures	4395.38	4401.53	4394.21	4400.65	983.0
2014-10-15 21:00:00	NQ	Futures	4399.48	4405.34	4396.84	4405.34	1006.0
2014-10-15 22:00:00	NQ	Futures	4405.05	4409.15	4402.7	4405.63	1031.0
2014-10-15 23:00:00	NQ	Futures	4405.63	4408.56	4403.58	4407.98	689.0
2014-10-15 00:00:00	YM	Futures	16902.4	16916.9	16897.2	16915.9	1073.0
2014-10-15 01:00:00	YM	Futures	16916.9	16927.3	16908.6	16923.2	1239.0

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

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