PREVIEW / futures_1hour / 2016-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-09.parquet
  size:    55 KB
  rows:    1,644

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-09 00:00:00	ES	Futures	1972.32	1975.28	1969.64	1974.74	7700.0
2016-02-09 01:00:00	ES	Futures	1974.74	1976.09	1971.79	1975.28	5881.0
2016-02-09 02:00:00	ES	Futures	1975.28	1984.68	1970.71	1982.54	25585.0
2016-02-09 03:00:00	ES	Futures	1982.27	1992.48	1977.16	1988.72	64119.0
2016-02-09 04:00:00	ES	Futures	1988.45	1995.7	1984.42	1984.68	50136.0
2016-02-09 05:00:00	ES	Futures	1984.68	1991.67	1982.27	1988.45	24310.0
2016-02-09 06:00:00	ES	Futures	1988.18	1989.79	1978.5	1982.8	31884.0
2016-02-09 07:00:00	ES	Futures	1983.07	1983.61	1970.71	1973.4	82741.0
2016-02-09 08:00:00	ES	Futures	1973.4	1976.35	1963.99	1966.95	112452.0
2016-02-09 09:00:00	ES	Futures	1967.22	1990.6	1962.38	1984.42	418327.0
2016-02-09 10:00:00	ES	Futures	1984.42	1995.7	1971.52	1972.32	451241.0
2016-02-09 11:00:00	ES	Futures	1972.32	1990.06	1971.52	1977.43	302355.0
2016-02-09 12:00:00	ES	Futures	1977.43	1982.8	1973.4	1975.28	192993.0
2016-02-09 13:00:00	ES	Futures	1975.28	1977.7	1966.41	1975.28	193640.0
2016-02-09 14:00:00	ES	Futures	1975.28	1992.75	1975.01	1989.79	271194.0
2016-02-09 15:00:00	ES	Futures	1989.79	2003.23	1982.27	1986.3	398833.0
2016-02-09 16:00:00	ES	Futures	1986.3	1988.98	1984.15	1984.42	55376.0
2016-02-09 18:00:00	ES	Futures	1988.45	1997.58	1986.57	1991.67	10462.0
2016-02-09 19:00:00	ES	Futures	1991.67	1993.01	1985.49	1986.57	13674.0
2016-02-09 20:00:00	ES	Futures	1986.57	1987.37	1976.09	1979.58	21374.0
2016-02-09 21:00:00	ES	Futures	1979.58	1982.0	1976.09	1982.0	10506.0
2016-02-09 22:00:00	ES	Futures	1981.73	1983.88	1979.85	1981.46	7503.0
2016-02-09 23:00:00	ES	Futures	1981.46	1983.07	1976.09	1978.77	10602.0
2016-02-09 00:00:00	NQ	Futures	4663.01	4673.4	4657.07	4671.32	1244.0
2016-02-09 01:00:00	NQ	Futures	4670.73	4672.81	4662.42	4669.84	1047.0
2016-02-09 02:00:00	NQ	Futures	4669.84	4701.91	4657.37	4695.97	5925.0
2016-02-09 03:00:00	NQ	Futures	4695.08	4720.61	4682.31	4709.63	12262.0
2016-02-09 04:00:00	NQ	Futures	4709.63	4726.85	4697.45	4698.94	8355.0
2016-02-09 05:00:00	NQ	Futures	4698.94	4714.68	4693.59	4706.36	4055.0
2016-02-09 06:00:00	NQ	Futures	4706.36	4710.22	4678.75	4689.73	5603.0
2016-02-09 07:00:00	NQ	Futures	4690.03	4690.62	4660.04	4671.92	12923.0
2016-02-09 08:00:00	NQ	Futures	4671.32	4678.15	4635.69	4640.15	15360.0
2016-02-09 09:00:00	NQ	Futures	4640.15	4734.87	4629.16	4712.3	74159.0
2016-02-09 10:00:00	NQ	Futures	4712.0	4755.65	4664.79	4668.06	96910.0
2016-02-09 11:00:00	NQ	Futures	4668.06	4718.24	4665.39	4681.42	51540.0
2016-02-09 12:00:00	NQ	Futures	4680.53	4696.86	4657.67	4661.53	36016.0
2016-02-09 13:00:00	NQ	Futures	4661.23	4665.39	4632.72	4659.74	37694.0
2016-02-09 14:00:00	NQ	Futures	4659.74	4714.08	4658.26	4707.25	46317.0
2016-02-09 15:00:00	NQ	Futures	4706.66	4743.78	4676.37	4683.5	66837.0
2016-02-09 16:00:00	NQ	Futures	4683.5	4692.41	4679.34	4682.01	6804.0
2016-02-09 18:00:00	NQ	Futures	4696.86	4712.3	4687.36	4701.31	1615.0
2016-02-09 19:00:00	NQ	Futures	4700.42	4704.28	4686.17	4687.95	1625.0
2016-02-09 20:00:00	NQ	Futures	4687.95	4689.44	4658.85	4668.35	2327.0
2016-02-09 21:00:00	NQ	Futures	4668.06	4675.18	4659.15	4673.11	1811.0
2016-02-09 22:00:00	NQ	Futures	4673.7	4679.64	4669.54	4673.7	1235.0
2016-02-09 23:00:00	NQ	Futures	4674.29	4677.86	4658.56	4666.57	1306.0
2016-02-09 00:00:00	YM	Futures	16868.8	16893.3	16850.7	16887.9	1596.0
2016-02-09 01:00:00	YM	Futures	16886.9	16895.4	16866.7	16891.1	1157.0
2016-02-09 02:00:00	YM	Futures	16889.0	16968.8	16856.0	16952.9	4219.0
2016-02-09 03:00:00	YM	Futures	16951.8	17026.3	16907.1	16997.6	12747.0

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

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