PREVIEW / futures_1hour / 2016-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-01-20.parquet
  size:    56 KB
  rows:    1,645

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-01-20 00:00:00	ES	Futures	1980.12	1983.88	1977.7	1980.65	22514.0
2016-01-20 01:00:00	ES	Futures	1980.39	1982.27	1976.09	1979.58	15256.0
2016-01-20 02:00:00	ES	Futures	1979.31	1984.68	1975.55	1979.85	32456.0
2016-01-20 03:00:00	ES	Futures	1980.12	1982.27	1967.76	1969.91	65316.0
2016-01-20 04:00:00	ES	Futures	1970.17	1980.92	1966.14	1977.97	60753.0
2016-01-20 05:00:00	ES	Futures	1978.24	1978.5	1972.06	1973.67	31376.0
2016-01-20 06:00:00	ES	Futures	1973.4	1980.39	1973.4	1976.89	28647.0
2016-01-20 07:00:00	ES	Futures	1976.89	1979.31	1972.32	1976.62	37559.0
2016-01-20 08:00:00	ES	Futures	1976.62	1985.49	1975.55	1982.8	90163.0
2016-01-20 09:00:00	ES	Futures	1983.07	1991.13	1971.52	1973.13	408849.0
2016-01-20 10:00:00	ES	Futures	1973.13	1976.62	1953.25	1953.78	578803.0
2016-01-20 11:00:00	ES	Futures	1953.78	1966.95	1952.44	1955.13	414343.0
2016-01-20 12:00:00	ES	Futures	1954.86	1958.62	1939.27	1956.74	426985.0
2016-01-20 13:00:00	ES	Futures	1957.01	1977.16	1947.33	1972.86	457711.0
2016-01-20 14:00:00	ES	Futures	1972.86	1981.46	1965.34	1976.62	376864.0
2016-01-20 15:00:00	ES	Futures	1976.62	2009.14	1973.94	1990.33	640061.0
2016-01-20 16:00:00	ES	Futures	1990.33	1995.43	1987.1	1990.6	89716.0
2016-01-20 18:00:00	ES	Futures	1993.55	2004.03	1993.01	2000.27	22767.0
2016-01-20 19:00:00	ES	Futures	2000.27	2007.26	1999.46	2005.91	20850.0
2016-01-20 20:00:00	ES	Futures	2005.64	2012.36	2001.88	2011.56	26920.0
2016-01-20 21:00:00	ES	Futures	2011.56	2015.05	2008.33	2014.24	19550.0
2016-01-20 22:00:00	ES	Futures	2014.24	2016.39	2002.15	2002.42	19912.0
2016-01-20 23:00:00	ES	Futures	2002.42	2004.03	1994.63	1997.31	25420.0
2016-01-20 00:00:00	NQ	Futures	4832.26	4839.39	4820.38	4831.67	5340.0
2016-01-20 01:00:00	NQ	Futures	4831.96	4836.12	4816.82	4829.89	2867.0
2016-01-20 02:00:00	NQ	Futures	4829.89	4843.84	4817.71	4831.07	6156.0
2016-01-20 03:00:00	NQ	Futures	4830.78	4838.2	4796.63	4804.65	10309.0
2016-01-20 04:00:00	NQ	Futures	4804.94	4831.96	4792.77	4823.95	9431.0
2016-01-20 05:00:00	NQ	Futures	4825.43	4826.03	4808.8	4811.18	4386.0
2016-01-20 06:00:00	NQ	Futures	4812.07	4831.07	4812.07	4822.17	3499.0
2016-01-20 07:00:00	NQ	Futures	4823.35	4829.29	4814.15	4823.95	4592.0
2016-01-20 08:00:00	NQ	Futures	4823.35	4848.89	4820.38	4842.36	10477.0
2016-01-20 09:00:00	NQ	Futures	4842.06	4858.69	4797.52	4803.46	66834.0
2016-01-20 10:00:00	NQ	Futures	4803.76	4818.6	4753.87	4757.43	100211.0
2016-01-20 11:00:00	NQ	Futures	4757.73	4807.62	4757.14	4774.95	59893.0
2016-01-20 12:00:00	NQ	Futures	4774.95	4788.91	4731.3	4787.42	58811.0
2016-01-20 13:00:00	NQ	Futures	4787.13	4863.44	4762.78	4855.42	73691.0
2016-01-20 14:00:00	NQ	Futures	4855.42	4875.02	4826.32	4857.5	61148.0
2016-01-20 15:00:00	NQ	Futures	4857.2	4954.6	4849.48	4902.93	110431.0
2016-01-20 16:00:00	NQ	Futures	4902.34	4915.4	4891.35	4903.23	10804.0
2016-01-20 18:00:00	NQ	Futures	4906.2	4936.78	4906.2	4926.68	3286.0
2016-01-20 19:00:00	NQ	Futures	4927.58	4946.88	4925.2	4941.23	4629.0
2016-01-20 20:00:00	NQ	Futures	4940.34	4953.71	4928.47	4950.74	6606.0
2016-01-20 21:00:00	NQ	Futures	4951.63	4959.94	4943.02	4958.46	3782.0
2016-01-20 22:00:00	NQ	Futures	4958.16	4962.32	4925.79	4926.39	4260.0
2016-01-20 23:00:00	NQ	Futures	4927.58	4931.73	4906.2	4912.14	5427.0
2016-01-20 00:00:00	YM	Futures	16663.3	16684.6	16632.5	16660.1	4642.0
2016-01-20 01:00:00	YM	Futures	16661.2	16671.9	16618.6	16651.6	3213.0
2016-01-20 02:00:00	YM	Futures	16651.6	16688.9	16621.8	16651.6	4278.0
2016-01-20 03:00:00	YM	Futures	16652.7	16671.9	16549.4	16567.5	9469.0

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

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