PREVIEW / futures_1hour / 2010-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-01.parquet
  size:    47 KB
  rows:    1,399

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-01 00:00:00	ES	Futures	1043.34	1043.82	1042.36	1042.85	2673.0
2010-02-01 01:00:00	ES	Futures	1043.09	1044.55	1041.63	1043.09	4263.0
2010-02-01 02:00:00	ES	Futures	1043.09	1045.04	1042.85	1044.55	12269.0
2010-02-01 03:00:00	ES	Futures	1044.31	1046.01	1043.09	1045.77	35875.0
2010-02-01 04:00:00	ES	Futures	1045.53	1048.2	1044.8	1046.74	30518.0
2010-02-01 05:00:00	ES	Futures	1046.5	1046.99	1045.28	1045.77	12331.0
2010-02-01 06:00:00	ES	Futures	1046.01	1047.47	1045.04	1045.77	13150.0
2010-02-01 07:00:00	ES	Futures	1045.77	1047.96	1044.8	1047.72	27845.0
2010-02-01 08:00:00	ES	Futures	1047.72	1048.93	1046.26	1046.74	47738.0
2010-02-01 09:00:00	ES	Futures	1046.5	1051.36	1046.5	1049.42	219730.0
2010-02-01 10:00:00	ES	Futures	1049.66	1054.28	1047.47	1049.42	422534.0
2010-02-01 11:00:00	ES	Futures	1049.42	1054.77	1048.69	1050.63	214279.0
2010-02-01 12:00:00	ES	Futures	1050.63	1054.28	1049.9	1053.31	140320.0
2010-02-01 13:00:00	ES	Futures	1053.07	1055.5	1052.09	1053.8	141482.0
2010-02-01 14:00:00	ES	Futures	1053.8	1055.26	1051.12	1053.55	160172.0
2010-02-01 15:00:00	ES	Futures	1053.8	1056.96	1051.85	1055.99	257146.0
2010-02-01 16:00:00	ES	Futures	1056.23	1057.2	1055.99	1056.47	102914.0
2010-02-01 17:00:00	ES	Futures	1056.47	1056.96	1056.47	1056.72	737.0
2010-02-01 18:00:00	ES	Futures	1056.47	1057.2	1055.99	1056.72	4349.0
2010-02-01 19:00:00	ES	Futures	1056.72	1058.18	1056.47	1057.69	5317.0
2010-02-01 20:00:00	ES	Futures	1057.69	1057.93	1055.74	1056.47	4804.0
2010-02-01 21:00:00	ES	Futures	1056.23	1056.96	1055.5	1055.5	2869.0
2010-02-01 22:00:00	ES	Futures	1055.5	1056.47	1055.01	1055.26	5466.0
2010-02-01 23:00:00	ES	Futures	1055.26	1055.74	1053.07	1055.26	7191.0
2010-02-01 00:00:00	NQ	Futures	1993.12	1993.69	1991.12	1991.69	318.0
2010-02-01 01:00:00	NQ	Futures	1991.41	1994.26	1989.98	1991.69	487.0
2010-02-01 02:00:00	NQ	Futures	1991.98	1995.98	1991.69	1993.98	680.0
2010-02-01 03:00:00	NQ	Futures	1994.26	1996.83	1991.98	1996.26	2463.0
2010-02-01 04:00:00	NQ	Futures	1995.98	1999.12	1993.41	1995.41	3220.0
2010-02-01 05:00:00	NQ	Futures	1995.69	1996.55	1991.98	1993.12	1974.0
2010-02-01 06:00:00	NQ	Futures	1993.12	1996.55	1991.41	1992.83	1921.0
2010-02-01 07:00:00	NQ	Futures	1992.83	1995.98	1990.84	1995.41	1638.0
2010-02-01 08:00:00	NQ	Futures	1995.12	1997.4	1990.55	1990.84	4836.0
2010-02-01 09:00:00	NQ	Futures	1990.84	2003.4	1990.26	1999.12	49866.0
2010-02-01 10:00:00	NQ	Futures	1999.4	2004.83	1991.12	1991.69	70955.0
2010-02-01 11:00:00	NQ	Futures	1991.41	2003.4	1989.98	1993.12	44972.0
2010-02-01 12:00:00	NQ	Futures	1993.12	2003.97	1992.55	2001.4	35298.0
2010-02-01 13:00:00	NQ	Futures	2001.4	2006.26	1999.12	2004.55	27562.0
2010-02-01 14:00:00	NQ	Futures	2004.55	2007.4	2000.83	2004.55	30259.0
2010-02-01 15:00:00	NQ	Futures	2004.55	2008.26	2000.55	2006.83	49468.0
2010-02-01 16:00:00	NQ	Futures	2006.83	2008.83	2005.97	2007.97	12906.0
2010-02-01 17:00:00	NQ	Futures	2007.4	2007.97	2007.12	2007.4	127.0
2010-02-01 18:00:00	NQ	Futures	2007.12	2007.69	2006.26	2007.4	185.0
2010-02-01 19:00:00	NQ	Futures	2007.12	2009.69	2007.12	2009.12	363.0
2010-02-01 20:00:00	NQ	Futures	2009.12	2009.4	2005.69	2006.54	350.0
2010-02-01 21:00:00	NQ	Futures	2006.83	2007.69	2005.4	2005.69	125.0
2010-02-01 22:00:00	NQ	Futures	2005.4	2007.12	2004.55	2004.83	514.0
2010-02-01 23:00:00	NQ	Futures	2004.83	2005.69	2000.83	2003.97	672.0
2010-02-01 00:00:00	YM	Futures	9393.7	9399.3	9387.1	9391.8	159.0
2010-02-01 01:00:00	YM	Futures	9389.9	9402.1	9381.5	9392.7	362.0

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

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