PREVIEW / futures_1hour / 2009-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-09.parquet
  size:    44 KB
  rows:    1,331

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
2009-11-09 00:00:00	ES	Futures	1037.19	1037.44	1035.5	1035.98	2565.0
2009-11-09 01:00:00	ES	Futures	1035.98	1036.22	1035.01	1036.22	3872.0
2009-11-09 02:00:00	ES	Futures	1036.22	1039.86	1035.98	1038.89	15474.0
2009-11-09 03:00:00	ES	Futures	1038.89	1041.07	1038.89	1040.1	31079.0
2009-11-09 04:00:00	ES	Futures	1040.1	1043.01	1039.37	1042.52	26545.0
2009-11-09 05:00:00	ES	Futures	1042.76	1043.01	1041.07	1043.01	19434.0
2009-11-09 06:00:00	ES	Futures	1043.25	1044.94	1042.28	1042.76	30319.0
2009-11-09 07:00:00	ES	Futures	1042.52	1044.22	1042.04	1043.49	18048.0
2009-11-09 08:00:00	ES	Futures	1043.73	1043.73	1041.55	1041.8	29822.0
2009-11-09 09:00:00	ES	Futures	1042.04	1044.94	1040.58	1044.46	249871.0
2009-11-09 10:00:00	ES	Futures	1044.46	1048.58	1044.22	1047.85	298327.0
2009-11-09 11:00:00	ES	Futures	1048.09	1050.76	1046.64	1049.55	216087.0
2009-11-09 12:00:00	ES	Futures	1049.55	1051.48	1049.06	1051.48	112912.0
2009-11-09 13:00:00	ES	Futures	1051.24	1053.66	1050.27	1053.18	173918.0
2009-11-09 14:00:00	ES	Futures	1052.94	1055.36	1052.21	1055.12	171772.0
2009-11-09 15:00:00	ES	Futures	1054.88	1057.3	1053.18	1057.06	284117.0
2009-11-09 16:00:00	ES	Futures	1057.06	1058.02	1056.81	1057.54	120456.0
2009-11-09 17:00:00	ES	Futures	1057.54	1057.54	1056.57	1057.54	4751.0
2009-11-09 18:00:00	ES	Futures	1057.54	1057.78	1056.81	1057.06	4636.0
2009-11-09 19:00:00	ES	Futures	1057.06	1057.78	1056.81	1057.54	5417.0
2009-11-09 20:00:00	ES	Futures	1057.54	1057.54	1056.33	1056.57	6399.0
2009-11-09 21:00:00	ES	Futures	1056.57	1057.3	1056.57	1056.57	2234.0
2009-11-09 22:00:00	ES	Futures	1056.57	1056.81	1055.6	1055.84	4750.0
2009-11-09 23:00:00	ES	Futures	1055.84	1056.81	1055.84	1056.09	2498.0
2009-11-09 00:00:00	NQ	Futures	1980.1	1980.96	1977.25	1978.68	227.0
2009-11-09 01:00:00	NQ	Futures	1978.39	1978.39	1976.97	1978.11	200.0
2009-11-09 02:00:00	NQ	Futures	1978.11	1984.67	1977.82	1984.1	1833.0
2009-11-09 03:00:00	NQ	Futures	1984.1	1984.95	1981.53	1983.53	3646.0
2009-11-09 04:00:00	NQ	Futures	1983.53	1989.23	1982.1	1989.23	2095.0
2009-11-09 05:00:00	NQ	Futures	1988.94	1989.8	1986.38	1989.8	1295.0
2009-11-09 06:00:00	NQ	Futures	1990.08	1994.08	1990.08	1992.08	2985.0
2009-11-09 07:00:00	NQ	Futures	1992.08	1993.22	1989.8	1992.37	2439.0
2009-11-09 08:00:00	NQ	Futures	1992.37	1992.94	1990.66	1991.8	4484.0
2009-11-09 09:00:00	NQ	Futures	1991.8	1998.36	1985.81	1996.93	53613.0
2009-11-09 10:00:00	NQ	Futures	1996.93	2005.49	1996.93	2004.06	46581.0
2009-11-09 11:00:00	NQ	Futures	2004.06	2006.91	1998.93	2004.91	32584.0
2009-11-09 12:00:00	NQ	Futures	2004.63	2007.77	2003.49	2006.91	18369.0
2009-11-09 13:00:00	NQ	Futures	2006.91	2011.47	2004.91	2008.05	28252.0
2009-11-09 14:00:00	NQ	Futures	2008.05	2012.33	2006.06	2011.47	21262.0
2009-11-09 15:00:00	NQ	Futures	2011.47	2015.47	2007.77	2015.18	40264.0
2009-11-09 16:00:00	NQ	Futures	2015.18	2016.32	2013.76	2015.18	14898.0
2009-11-09 17:00:00	NQ	Futures	2014.9	2014.9	2013.19	2014.04	319.0
2009-11-09 18:00:00	NQ	Futures	2014.04	2014.33	2013.47	2014.04	268.0
2009-11-09 19:00:00	NQ	Futures	2013.76	2014.9	2013.76	2014.33	411.0
2009-11-09 20:00:00	NQ	Futures	2014.33	2014.33	2012.04	2012.33	315.0
2009-11-09 21:00:00	NQ	Futures	2012.33	2013.76	2012.33	2012.62	244.0
2009-11-09 22:00:00	NQ	Futures	2012.62	2012.62	2010.9	2011.47	197.0
2009-11-09 23:00:00	NQ	Futures	2011.47	2012.9	2011.47	2012.33	100.0
2009-11-09 00:00:00	YM	Futures	9314.9	9317.7	9301.8	9306.5	239.0
2009-11-09 01:00:00	YM	Futures	9305.6	9308.4	9299.1	9308.4	218.0

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

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