PREVIEW / futures_1hour / 2010-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-09.parquet
  size:    48 KB
  rows:    1,422

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-02-09 00:00:00	ES	Futures	1028.98	1030.93	1028.74	1030.2	5876.0
2010-02-09 01:00:00	ES	Futures	1030.44	1031.66	1029.96	1031.66	6570.0
2010-02-09 02:00:00	ES	Futures	1031.66	1035.55	1031.42	1034.58	26638.0
2010-02-09 03:00:00	ES	Futures	1034.58	1035.55	1033.12	1034.34	32329.0
2010-02-09 04:00:00	ES	Futures	1034.09	1038.23	1034.09	1035.8	38812.0
2010-02-09 05:00:00	ES	Futures	1035.8	1036.28	1033.85	1034.58	22031.0
2010-02-09 06:00:00	ES	Futures	1034.34	1034.34	1032.39	1034.09	27589.0
2010-02-09 07:00:00	ES	Futures	1033.85	1037.99	1033.36	1036.28	47112.0
2010-02-09 08:00:00	ES	Futures	1036.53	1038.47	1035.55	1037.01	57633.0
2010-02-09 09:00:00	ES	Futures	1037.01	1039.93	1034.82	1036.04	259139.0
2010-02-09 10:00:00	ES	Futures	1036.04	1040.9	1033.85	1034.34	360780.0
2010-02-09 11:00:00	ES	Futures	1034.34	1042.85	1029.47	1039.69	633239.0
2010-02-09 12:00:00	ES	Futures	1039.93	1047.96	1037.5	1041.88	581365.0
2010-02-09 13:00:00	ES	Futures	1041.88	1044.07	1039.69	1041.63	191902.0
2010-02-09 14:00:00	ES	Futures	1041.63	1042.61	1037.5	1038.47	207019.0
2010-02-09 15:00:00	ES	Futures	1038.47	1043.34	1036.53	1038.96	360718.0
2010-02-09 16:00:00	ES	Futures	1038.96	1039.2	1036.77	1038.47	116874.0
2010-02-09 17:00:00	ES	Futures	1038.47	1038.96	1037.74	1038.72	1444.0
2010-02-09 18:00:00	ES	Futures	1038.72	1039.69	1038.47	1038.72	6023.0
2010-02-09 19:00:00	ES	Futures	1038.72	1039.69	1037.5	1038.96	5964.0
2010-02-09 20:00:00	ES	Futures	1039.2	1039.69	1037.5	1038.23	3782.0
2010-02-09 21:00:00	ES	Futures	1037.99	1038.96	1034.34	1035.8	6311.0
2010-02-09 22:00:00	ES	Futures	1035.55	1036.28	1034.09	1034.34	4136.0
2010-02-09 23:00:00	ES	Futures	1034.34	1035.07	1033.85	1035.07	2936.0
2010-02-09 00:00:00	NQ	Futures	1985.41	1988.26	1985.12	1987.41	541.0
2010-02-09 01:00:00	NQ	Futures	1987.12	1991.98	1986.84	1991.69	661.0
2010-02-09 02:00:00	NQ	Futures	1991.69	1999.4	1991.41	1997.12	1744.0
2010-02-09 03:00:00	NQ	Futures	1997.12	1997.98	1993.69	1995.98	2490.0
2010-02-09 04:00:00	NQ	Futures	1995.69	2001.69	1995.69	1997.12	2472.0
2010-02-09 05:00:00	NQ	Futures	1997.4	1999.12	1994.55	1995.41	1051.0
2010-02-09 06:00:00	NQ	Futures	1995.69	1996.26	1991.98	1995.69	1295.0
2010-02-09 07:00:00	NQ	Futures	1995.12	2002.26	1994.26	1999.12	2481.0
2010-02-09 08:00:00	NQ	Futures	1999.4	2003.12	1997.98	2000.83	3678.0
2010-02-09 09:00:00	NQ	Futures	2000.83	2006.54	1994.83	1998.26	39707.0
2010-02-09 10:00:00	NQ	Futures	1998.83	2007.69	1994.26	1994.83	51482.0
2010-02-09 11:00:00	NQ	Futures	1994.83	2007.69	1983.98	2003.69	81663.0
2010-02-09 12:00:00	NQ	Futures	2003.69	2019.11	1999.69	2005.97	73125.0
2010-02-09 13:00:00	NQ	Futures	2005.97	2009.97	2002.83	2006.83	23799.0
2010-02-09 14:00:00	NQ	Futures	2007.12	2009.4	1999.4	2000.83	31989.0
2010-02-09 15:00:00	NQ	Futures	2001.12	2009.4	1997.98	2000.55	46640.0
2010-02-09 16:00:00	NQ	Futures	2000.26	2005.4	1998.83	2003.97	13686.0
2010-02-09 17:00:00	NQ	Futures	2003.97	2005.12	2003.4	2003.97	123.0
2010-02-09 18:00:00	NQ	Futures	2003.97	2005.97	2003.97	2003.97	311.0
2010-02-09 19:00:00	NQ	Futures	2003.69	2005.97	2002.26	2004.55	477.0
2010-02-09 20:00:00	NQ	Futures	2004.55	2005.69	2002.83	2003.4	356.0
2010-02-09 21:00:00	NQ	Futures	2003.69	2005.4	1997.4	1999.69	634.0
2010-02-09 22:00:00	NQ	Futures	1999.98	2000.55	1996.55	1997.12	321.0
2010-02-09 23:00:00	NQ	Futures	1997.12	1998.83	1996.55	1998.26	266.0
2010-02-09 00:00:00	YM	Futures	9269.2	9282.3	9268.3	9280.4	422.0
2010-02-09 01:00:00	YM	Futures	9280.4	9290.7	9275.8	9289.8	401.0

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

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