PREVIEW / futures_1hour / 2014-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-13.parquet
  size:    52 KB
  rows:    1,561

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-13 00:00:00	ES	Futures	1973.66	1974.97	1973.4	1974.71	5939.0
2014-10-13 01:00:00	ES	Futures	1974.71	1975.5	1973.92	1975.5	6455.0
2014-10-13 02:00:00	ES	Futures	1975.5	1977.85	1973.66	1977.33	15825.0
2014-10-13 03:00:00	ES	Futures	1977.07	1980.47	1976.54	1979.95	41474.0
2014-10-13 04:00:00	ES	Futures	1979.95	1989.64	1979.43	1988.59	49224.0
2014-10-13 05:00:00	ES	Futures	1988.59	1989.38	1985.19	1987.02	30262.0
2014-10-13 06:00:00	ES	Futures	1987.02	1992.26	1986.5	1991.48	32937.0
2014-10-13 07:00:00	ES	Futures	1991.48	1991.48	1988.07	1989.12	30634.0
2014-10-13 08:00:00	ES	Futures	1988.86	1994.1	1987.81	1992.79	62798.0
2014-10-13 09:00:00	ES	Futures	1992.79	1997.24	1980.74	1985.97	366883.0
2014-10-13 10:00:00	ES	Futures	1986.24	1989.9	1974.19	1981.78	498048.0
2014-10-13 11:00:00	ES	Futures	1981.78	1988.86	1978.64	1984.4	377586.0
2014-10-13 12:00:00	ES	Futures	1984.14	1997.24	1982.05	1992.0	237226.0
2014-10-13 13:00:00	ES	Futures	1992.0	1994.62	1984.66	1987.81	172412.0
2014-10-13 14:00:00	ES	Futures	1987.55	1990.17	1981.0	1982.31	141566.0
2014-10-13 15:00:00	ES	Futures	1982.05	1983.09	1956.63	1957.42	564868.0
2014-10-13 16:00:00	ES	Futures	1957.42	1959.78	1954.01	1954.54	147874.0
2014-10-13 17:00:00	ES	Futures	1954.54	1955.59	1952.97	1955.59	7990.0
2014-10-13 18:00:00	ES	Futures	1955.59	1958.99	1955.32	1957.42	18710.0
2014-10-13 19:00:00	ES	Futures	1957.42	1961.09	1956.9	1961.09	10821.0
2014-10-13 20:00:00	ES	Futures	1960.83	1965.54	1960.56	1964.23	18418.0
2014-10-13 21:00:00	ES	Futures	1964.23	1965.54	1962.14	1965.02	8901.0
2014-10-13 22:00:00	ES	Futures	1965.28	1967.9	1964.76	1967.11	11321.0
2014-10-13 23:00:00	ES	Futures	1967.11	1967.38	1964.23	1966.07	5011.0
2014-10-13 00:00:00	NQ	Futures	4485.33	4487.68	4482.99	4487.38	1445.0
2014-10-13 01:00:00	NQ	Futures	4486.8	4488.85	4484.75	4487.97	1090.0
2014-10-13 02:00:00	NQ	Futures	4487.97	4495.59	4483.57	4494.12	1874.0
2014-10-13 03:00:00	NQ	Futures	4494.12	4499.1	4490.02	4497.64	5588.0
2014-10-13 04:00:00	NQ	Futures	4497.64	4519.91	4495.88	4518.15	5907.0
2014-10-13 05:00:00	NQ	Futures	4518.15	4519.03	4507.6	4510.82	4756.0
2014-10-13 06:00:00	NQ	Futures	4510.82	4523.42	4508.48	4520.79	5136.0
2014-10-13 07:00:00	NQ	Futures	4520.49	4521.37	4512.87	4515.22	4515.0
2014-10-13 08:00:00	NQ	Futures	4515.22	4526.65	4512.58	4523.72	8550.0
2014-10-13 09:00:00	NQ	Futures	4523.42	4541.59	4493.54	4509.36	82242.0
2014-10-13 10:00:00	NQ	Futures	4509.36	4517.86	4463.65	4495.88	111390.0
2014-10-13 11:00:00	NQ	Futures	4496.17	4530.16	4488.55	4519.32	87527.0
2014-10-13 12:00:00	NQ	Futures	4519.32	4554.19	4510.82	4540.12	58551.0
2014-10-13 13:00:00	NQ	Futures	4540.12	4547.16	4517.27	4524.01	49484.0
2014-10-13 14:00:00	NQ	Futures	4524.01	4539.83	4507.01	4509.65	46100.0
2014-10-13 15:00:00	NQ	Futures	4509.36	4512.58	4453.69	4458.08	113526.0
2014-10-13 16:00:00	NQ	Futures	4458.38	4464.53	4447.53	4448.41	27215.0
2014-10-13 17:00:00	NQ	Futures	4448.41	4450.46	4444.9	4450.46	876.0
2014-10-13 18:00:00	NQ	Futures	4451.34	4461.31	4450.17	4455.74	2826.0
2014-10-13 19:00:00	NQ	Futures	4455.44	4463.94	4453.98	4463.65	1090.0
2014-10-13 20:00:00	NQ	Futures	4463.36	4474.49	4463.36	4471.27	1904.0
2014-10-13 21:00:00	NQ	Futures	4471.56	4475.37	4468.04	4474.49	1130.0
2014-10-13 22:00:00	NQ	Futures	4474.2	4481.52	4473.61	4479.76	1091.0
2014-10-13 23:00:00	NQ	Futures	4480.06	4480.64	4473.32	4478.89	839.0
2014-10-13 00:00:00	YM	Futures	16992.8	17011.6	16991.8	17009.5	988.0
2014-10-13 01:00:00	YM	Futures	17011.6	17019.9	17006.4	17019.9	1141.0

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

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