PREVIEW / futures_1hour / 2014-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-20.parquet
  size:    51 KB
  rows:    1,574

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-20 00:00:00	ES	Futures	1982.05	1982.31	1981.26	1981.52	2507.0
2014-10-20 01:00:00	ES	Futures	1981.52	1982.31	1980.74	1981.52	3107.0
2014-10-20 02:00:00	ES	Futures	1981.26	1982.31	1978.38	1978.64	9684.0
2014-10-20 03:00:00	ES	Futures	1978.9	1979.95	1972.09	1975.5	55922.0
2014-10-20 04:00:00	ES	Futures	1975.5	1977.85	1971.57	1971.83	34198.0
2014-10-20 05:00:00	ES	Futures	1971.83	1977.33	1971.57	1975.23	24755.0
2014-10-20 06:00:00	ES	Futures	1975.5	1976.81	1968.16	1968.95	28091.0
2014-10-20 07:00:00	ES	Futures	1968.68	1971.3	1962.92	1965.54	61884.0
2014-10-20 08:00:00	ES	Futures	1965.54	1971.3	1964.76	1968.68	47813.0
2014-10-20 09:00:00	ES	Futures	1968.68	1975.76	1961.87	1973.66	280876.0
2014-10-20 10:00:00	ES	Futures	1973.66	1979.69	1969.21	1975.76	272254.0
2014-10-20 11:00:00	ES	Futures	1975.5	1980.21	1973.14	1978.38	158208.0
2014-10-20 12:00:00	ES	Futures	1978.38	1981.0	1974.71	1975.5	113266.0
2014-10-20 13:00:00	ES	Futures	1975.5	1981.78	1974.71	1979.95	95806.0
2014-10-20 14:00:00	ES	Futures	1979.69	1984.93	1979.43	1984.4	109639.0
2014-10-20 15:00:00	ES	Futures	1984.14	1989.38	1983.88	1988.07	203531.0
2014-10-20 16:00:00	ES	Futures	1988.33	1993.57	1987.28	1992.79	86087.0
2014-10-20 17:00:00	ES	Futures	1992.52	1995.67	1991.74	1994.88	6472.0
2014-10-20 18:00:00	ES	Futures	1994.62	1994.62	1992.79	1993.05	6451.0
2014-10-20 19:00:00	ES	Futures	1993.05	1994.1	1988.07	1989.38	6918.0
2014-10-20 20:00:00	ES	Futures	1989.12	1989.64	1987.28	1988.07	7656.0
2014-10-20 21:00:00	ES	Futures	1987.81	1988.86	1985.19	1987.55	7370.0
2014-10-20 22:00:00	ES	Futures	1987.81	1990.95	1984.93	1987.02	8652.0
2014-10-20 23:00:00	ES	Futures	1986.76	1987.55	1983.36	1985.19	6532.0
2014-10-20 00:00:00	NQ	Futures	4487.38	4489.43	4486.5	4487.97	458.0
2014-10-20 01:00:00	NQ	Futures	4487.68	4488.55	4485.33	4487.38	360.0
2014-10-20 02:00:00	NQ	Futures	4487.38	4488.85	4478.89	4481.23	1320.0
2014-10-20 03:00:00	NQ	Futures	4481.23	4483.87	4462.77	4470.1	7785.0
2014-10-20 04:00:00	NQ	Futures	4469.8	4476.83	4464.53	4464.53	4461.0
2014-10-20 05:00:00	NQ	Futures	4464.82	4477.42	4463.94	4472.73	2648.0
2014-10-20 06:00:00	NQ	Futures	4473.61	4476.83	4459.84	4460.13	3047.0
2014-10-20 07:00:00	NQ	Futures	4460.13	4465.11	4445.78	4453.98	9605.0
2014-10-20 08:00:00	NQ	Futures	4454.27	4468.04	4452.22	4462.18	7064.0
2014-10-20 09:00:00	NQ	Futures	4462.77	4482.69	4446.36	4480.06	52074.0
2014-10-20 10:00:00	NQ	Futures	4479.76	4497.34	4473.03	4489.14	61772.0
2014-10-20 11:00:00	NQ	Futures	4488.85	4494.71	4479.76	4491.19	35896.0
2014-10-20 12:00:00	NQ	Futures	4490.9	4502.91	4490.31	4492.07	27874.0
2014-10-20 13:00:00	NQ	Futures	4492.07	4506.72	4487.38	4500.57	20765.0
2014-10-20 14:00:00	NQ	Futures	4500.57	4517.27	4499.98	4516.68	23274.0
2014-10-20 15:00:00	NQ	Futures	4516.68	4528.7	4515.22	4525.18	38005.0
2014-10-20 16:00:00	NQ	Futures	4524.89	4545.1	4523.72	4543.35	11611.0
2014-10-20 17:00:00	NQ	Futures	4543.05	4550.96	4539.54	4550.38	1028.0
2014-10-20 18:00:00	NQ	Futures	4547.74	4547.74	4541.59	4542.76	1769.0
2014-10-20 19:00:00	NQ	Futures	4543.05	4544.52	4530.45	4533.09	1389.0
2014-10-20 20:00:00	NQ	Futures	4532.21	4533.38	4528.4	4530.45	1380.0
2014-10-20 21:00:00	NQ	Futures	4530.75	4531.63	4524.3	4528.4	1364.0
2014-10-20 22:00:00	NQ	Futures	4528.7	4536.9	4524.3	4527.82	1688.0
2014-10-20 23:00:00	NQ	Futures	4527.23	4529.87	4519.91	4523.13	1143.0
2014-10-20 00:00:00	YM	Futures	17049.0	17049.0	17041.7	17044.8	425.0
2014-10-20 01:00:00	YM	Futures	17045.9	17049.0	17038.6	17041.7	487.0

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

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