PREVIEW / futures_1hour / 2010-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-06.parquet
  size:    46 KB
  rows:    1,367

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
2010-07-06 00:00:00	ES	Futures	994.28	996.73	992.56	996.73	6136.0
2010-07-06 01:00:00	ES	Futures	996.49	997.71	996.0	996.98	6729.0
2010-07-06 02:00:00	ES	Futures	996.98	998.2	996.49	997.47	11775.0
2010-07-06 03:00:00	ES	Futures	997.47	1004.09	996.24	1003.85	38671.0
2010-07-06 04:00:00	ES	Futures	1003.85	1004.83	1002.13	1004.09	22695.0
2010-07-06 05:00:00	ES	Futures	1004.09	1007.28	1003.36	1006.3	25774.0
2010-07-06 06:00:00	ES	Futures	1006.55	1008.02	1005.81	1007.28	28199.0
2010-07-06 07:00:00	ES	Futures	1007.28	1007.77	1005.07	1006.06	25560.0
2010-07-06 08:00:00	ES	Futures	1005.81	1010.23	1005.81	1009.74	64560.0
2010-07-06 09:00:00	ES	Futures	1009.74	1014.64	1009.49	1012.93	244764.0
2010-07-06 10:00:00	ES	Futures	1013.17	1019.31	1010.47	1015.14	378118.0
2010-07-06 11:00:00	ES	Futures	1015.38	1016.61	1012.19	1014.64	197366.0
2010-07-06 12:00:00	ES	Futures	1014.89	1016.36	1005.57	1006.55	192613.0
2010-07-06 13:00:00	ES	Futures	1006.79	1008.51	999.68	1000.66	249710.0
2010-07-06 14:00:00	ES	Futures	1000.9	1003.85	996.98	999.43	232012.0
2010-07-06 15:00:00	ES	Futures	999.43	1004.83	994.77	1004.83	422060.0
2010-07-06 16:00:00	ES	Futures	1004.58	1006.79	1003.85	1005.57	127435.0
2010-07-06 17:00:00	ES	Futures	1005.57	1006.55	1005.32	1006.06	1331.0
2010-07-06 18:00:00	ES	Futures	1006.06	1006.3	1004.58	1004.83	2223.0
2010-07-06 19:00:00	ES	Futures	1004.83	1006.06	1004.58	1005.07	1861.0
2010-07-06 20:00:00	ES	Futures	1005.32	1005.32	1002.38	1002.38	9249.0
2010-07-06 21:00:00	ES	Futures	1002.38	1002.62	1000.66	1001.15	7328.0
2010-07-06 22:00:00	ES	Futures	1001.39	1002.38	1000.17	1001.64	3555.0
2010-07-06 23:00:00	ES	Futures	1001.64	1003.36	1001.39	1001.64	2776.0
2010-07-06 00:00:00	NQ	Futures	1972.15	1976.45	1969.0	1976.45	417.0
2010-07-06 01:00:00	NQ	Futures	1976.45	1978.17	1975.59	1977.59	411.0
2010-07-06 02:00:00	NQ	Futures	1977.31	1979.88	1977.31	1979.31	578.0
2010-07-06 03:00:00	NQ	Futures	1979.31	1992.49	1977.31	1991.63	2503.0
2010-07-06 04:00:00	NQ	Futures	1991.63	1994.79	1989.34	1993.93	1797.0
2010-07-06 05:00:00	NQ	Futures	1994.21	2000.23	1993.07	1998.51	1807.0
2010-07-06 06:00:00	NQ	Futures	1998.8	2005.68	1997.94	2004.53	3664.0
2010-07-06 07:00:00	NQ	Futures	2004.53	2004.82	1998.8	2001.38	2496.0
2010-07-06 08:00:00	NQ	Futures	2001.09	2007.97	2000.8	2006.82	8705.0
2010-07-06 09:00:00	NQ	Futures	2006.82	2011.98	2001.09	2006.82	51571.0
2010-07-06 10:00:00	NQ	Futures	2006.82	2020.29	2000.8	2012.84	58646.0
2010-07-06 11:00:00	NQ	Futures	2012.55	2015.71	2006.25	2010.55	36072.0
2010-07-06 12:00:00	NQ	Futures	2010.55	2012.84	1987.34	1990.2	37933.0
2010-07-06 13:00:00	NQ	Futures	1989.91	1994.5	1976.16	1978.74	33207.0
2010-07-06 14:00:00	NQ	Futures	1978.45	1986.19	1971.0	1978.17	33857.0
2010-07-06 15:00:00	NQ	Futures	1977.88	1984.76	1967.85	1984.47	55982.0
2010-07-06 16:00:00	NQ	Futures	1984.76	1990.49	1983.61	1988.2	12543.0
2010-07-06 17:00:00	NQ	Futures	1987.34	1990.49	1987.34	1989.63	187.0
2010-07-06 18:00:00	NQ	Futures	1989.91	1989.91	1987.05	1987.91	288.0
2010-07-06 19:00:00	NQ	Futures	1987.62	1989.63	1987.05	1987.91	166.0
2010-07-06 20:00:00	NQ	Futures	1988.2	1988.2	1981.89	1981.89	453.0
2010-07-06 21:00:00	NQ	Futures	1981.89	1982.18	1978.74	1979.02	493.0
2010-07-06 22:00:00	NQ	Futures	1979.31	1982.75	1977.88	1981.32	718.0
2010-07-06 23:00:00	NQ	Futures	1981.32	1985.04	1980.74	1981.6	365.0
2010-07-06 00:00:00	YM	Futures	9078.0	9095.9	9061.9	9095.9	527.0
2010-07-06 01:00:00	YM	Futures	9095.0	9104.5	9091.2	9096.9	602.0

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

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