PREVIEW / futures_1hour / 2016-02-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-11.parquet
  size:    56 KB
  rows:    1,628

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
2016-02-11 00:00:00	ES	Futures	1974.74	1977.16	1973.4	1973.67	5666.0
2016-02-11 01:00:00	ES	Futures	1973.67	1974.74	1970.44	1974.47	6757.0
2016-02-11 02:00:00	ES	Futures	1974.47	1978.24	1971.79	1977.16	22120.0
2016-02-11 03:00:00	ES	Futures	1977.16	1977.43	1948.68	1952.98	118729.0
2016-02-11 04:00:00	ES	Futures	1952.98	1954.86	1944.11	1949.48	80149.0
2016-02-11 05:00:00	ES	Futures	1949.48	1953.25	1944.92	1951.36	43618.0
2016-02-11 06:00:00	ES	Futures	1951.63	1952.71	1941.69	1942.77	50415.0
2016-02-11 07:00:00	ES	Futures	1942.77	1954.59	1937.39	1947.6	115268.0
2016-02-11 08:00:00	ES	Futures	1947.6	1955.93	1946.26	1950.56	81463.0
2016-02-11 09:00:00	ES	Futures	1950.56	1970.71	1949.48	1966.14	350615.0
2016-02-11 10:00:00	ES	Futures	1965.88	1969.64	1951.1	1952.17	365575.0
2016-02-11 11:00:00	ES	Futures	1952.17	1955.93	1942.77	1951.1	377221.0
2016-02-11 12:00:00	ES	Futures	1951.1	1956.2	1945.72	1954.86	238201.0
2016-02-11 13:00:00	ES	Futures	1954.86	1959.16	1947.07	1949.22	210070.0
2016-02-11 14:00:00	ES	Futures	1949.48	1969.64	1940.08	1962.11	507112.0
2016-02-11 15:00:00	ES	Futures	1962.11	1972.06	1952.44	1960.77	448114.0
2016-02-11 16:00:00	ES	Futures	1961.04	1963.46	1958.62	1962.11	80582.0
2016-02-11 18:00:00	ES	Futures	1963.99	1967.76	1963.46	1966.68	8911.0
2016-02-11 19:00:00	ES	Futures	1966.95	1968.83	1962.92	1967.22	18846.0
2016-02-11 20:00:00	ES	Futures	1966.95	1970.71	1964.8	1969.91	16842.0
2016-02-11 21:00:00	ES	Futures	1970.17	1970.17	1961.58	1962.65	15849.0
2016-02-11 22:00:00	ES	Futures	1962.38	1974.47	1962.11	1973.4	23519.0
2016-02-11 23:00:00	ES	Futures	1973.13	1974.74	1965.34	1970.44	16503.0
2016-02-11 00:00:00	NQ	Futures	4687.95	4695.97	4685.58	4686.47	844.0
2016-02-11 01:00:00	NQ	Futures	4686.76	4688.55	4676.67	4687.66	1084.0
2016-02-11 02:00:00	NQ	Futures	4687.66	4698.34	4678.75	4695.67	2214.0
2016-02-11 03:00:00	NQ	Futures	4695.67	4695.67	4613.13	4625.3	17463.0
2016-02-11 04:00:00	NQ	Futures	4625.0	4630.05	4597.98	4612.83	12212.0
2016-02-11 05:00:00	NQ	Futures	4612.23	4620.85	4599.76	4616.09	6178.0
2016-02-11 06:00:00	NQ	Futures	4616.39	4627.08	4597.98	4598.58	7313.0
2016-02-11 07:00:00	NQ	Futures	4598.28	4631.83	4587.29	4616.39	13778.0
2016-02-11 08:00:00	NQ	Futures	4616.39	4646.68	4611.94	4633.02	13039.0
2016-02-11 09:00:00	NQ	Futures	4632.13	4698.94	4629.75	4686.47	66325.0
2016-02-11 10:00:00	NQ	Futures	4686.17	4696.86	4650.54	4653.51	63253.0
2016-02-11 11:00:00	NQ	Futures	4653.21	4666.28	4628.27	4658.85	46113.0
2016-02-11 12:00:00	NQ	Futures	4658.85	4682.01	4644.6	4677.86	32141.0
2016-02-11 13:00:00	NQ	Futures	4678.15	4688.55	4651.73	4658.56	33027.0
2016-02-11 14:00:00	NQ	Futures	4658.26	4714.68	4632.43	4697.16	81444.0
2016-02-11 15:00:00	NQ	Futures	4696.86	4733.68	4677.56	4698.05	84843.0
2016-02-11 16:00:00	NQ	Futures	4698.05	4709.92	4694.19	4706.66	10706.0
2016-02-11 18:00:00	NQ	Futures	4707.25	4718.54	4705.17	4716.16	1210.0
2016-02-11 19:00:00	NQ	Futures	4715.57	4720.61	4704.88	4716.16	1944.0
2016-02-11 20:00:00	NQ	Futures	4715.27	4724.77	4708.44	4723.29	1564.0
2016-02-11 21:00:00	NQ	Futures	4722.69	4723.58	4696.86	4698.94	2047.0
2016-02-11 22:00:00	NQ	Futures	4699.53	4733.09	4698.05	4730.71	2950.0
2016-02-11 23:00:00	NQ	Futures	4730.41	4732.79	4709.63	4722.4	2553.0
2016-02-11 00:00:00	YM	Futures	16800.7	16819.8	16792.1	16793.2	1133.0
2016-02-11 01:00:00	YM	Futures	16796.4	16804.9	16769.8	16801.7	1238.0
2016-02-11 02:00:00	YM	Futures	16801.7	16828.3	16782.6	16818.8	2408.0
2016-02-11 03:00:00	YM	Futures	16817.7	16817.7	16573.9	16611.2	22007.0

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

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