PREVIEW / futures_1hour / 2009-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-22.parquet
  size:    45 KB
  rows:    1,336

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-10-22 00:00:00	ES	Futures	1042.28	1043.49	1041.55	1043.25	3745.0
2009-10-22 01:00:00	ES	Futures	1043.25	1044.7	1043.01	1043.98	3908.0
2009-10-22 02:00:00	ES	Futures	1044.22	1044.7	1042.52	1043.73	10089.0
2009-10-22 03:00:00	ES	Futures	1043.49	1045.19	1041.07	1043.98	39410.0
2009-10-22 04:00:00	ES	Futures	1043.98	1043.98	1038.65	1040.1	29603.0
2009-10-22 05:00:00	ES	Futures	1040.1	1042.04	1039.62	1042.04	16612.0
2009-10-22 06:00:00	ES	Futures	1041.8	1043.73	1040.1	1043.01	24072.0
2009-10-22 07:00:00	ES	Futures	1043.01	1043.73	1042.04	1043.25	19557.0
2009-10-22 08:00:00	ES	Futures	1043.49	1046.88	1042.04	1042.28	91892.0
2009-10-22 09:00:00	ES	Futures	1042.52	1046.88	1038.89	1040.83	287830.0
2009-10-22 10:00:00	ES	Futures	1040.83	1044.94	1036.95	1044.46	389816.0
2009-10-22 11:00:00	ES	Futures	1044.22	1046.88	1043.73	1044.46	191015.0
2009-10-22 12:00:00	ES	Futures	1044.46	1048.09	1042.76	1046.88	126009.0
2009-10-22 13:00:00	ES	Futures	1047.12	1047.61	1045.43	1047.12	99912.0
2009-10-22 14:00:00	ES	Futures	1047.37	1054.88	1047.12	1054.15	352459.0
2009-10-22 15:00:00	ES	Futures	1054.15	1058.27	1053.66	1054.63	351402.0
2009-10-22 16:00:00	ES	Futures	1054.63	1057.3	1053.66	1057.06	103656.0
2009-10-22 17:00:00	ES	Futures	1057.3	1057.3	1056.81	1057.3	1978.0
2009-10-22 18:00:00	ES	Futures	1057.06	1059.24	1057.06	1058.99	5271.0
2009-10-22 19:00:00	ES	Futures	1058.75	1059.96	1058.75	1059.48	3350.0
2009-10-22 20:00:00	ES	Futures	1059.72	1059.72	1057.78	1058.02	4030.0
2009-10-22 21:00:00	ES	Futures	1058.02	1058.99	1057.78	1058.27	2927.0
2009-10-22 22:00:00	ES	Futures	1058.27	1059.72	1058.27	1059.48	4403.0
2009-10-22 23:00:00	ES	Futures	1059.72	1060.69	1059.48	1059.96	4840.0
2009-10-22 00:00:00	NQ	Futures	1992.37	1994.08	1990.37	1993.51	287.0
2009-10-22 01:00:00	NQ	Futures	1993.51	1996.07	1993.22	1994.93	317.0
2009-10-22 02:00:00	NQ	Futures	1995.22	1996.36	1991.8	1992.94	1448.0
2009-10-22 03:00:00	NQ	Futures	1993.22	1996.93	1988.94	1994.93	3109.0
2009-10-22 04:00:00	NQ	Futures	1994.93	1994.93	1986.66	1988.66	2294.0
2009-10-22 05:00:00	NQ	Futures	1988.37	1994.36	1988.09	1993.79	1879.0
2009-10-22 06:00:00	NQ	Futures	1993.79	1995.79	1990.66	1994.93	1505.0
2009-10-22 07:00:00	NQ	Futures	1995.22	1996.07	1993.22	1995.5	1241.0
2009-10-22 08:00:00	NQ	Futures	1995.79	2001.21	1989.23	1992.94	12703.0
2009-10-22 09:00:00	NQ	Futures	1992.94	2002.06	1986.09	1988.66	50740.0
2009-10-22 10:00:00	NQ	Futures	1988.66	1994.08	1982.1	1992.65	65218.0
2009-10-22 11:00:00	NQ	Futures	1992.65	1995.79	1988.66	1989.51	32959.0
2009-10-22 12:00:00	NQ	Futures	1989.51	1998.36	1988.94	1996.07	23303.0
2009-10-22 13:00:00	NQ	Futures	1996.36	1998.36	1992.94	1995.79	19652.0
2009-10-22 14:00:00	NQ	Futures	1996.07	2010.05	1995.5	2008.62	54775.0
2009-10-22 15:00:00	NQ	Futures	2008.91	2014.9	2005.49	2006.91	51277.0
2009-10-22 16:00:00	NQ	Futures	2006.91	2012.62	2006.34	2011.76	16267.0
2009-10-22 17:00:00	NQ	Futures	2011.19	2012.62	2010.9	2012.33	265.0
2009-10-22 18:00:00	NQ	Futures	2012.33	2014.9	2012.04	2014.9	643.0
2009-10-22 19:00:00	NQ	Futures	2014.9	2016.04	2014.04	2016.04	320.0
2009-10-22 20:00:00	NQ	Futures	2015.75	2015.75	2013.19	2013.47	537.0
2009-10-22 21:00:00	NQ	Futures	2013.47	2015.47	2013.19	2013.76	461.0
2009-10-22 22:00:00	NQ	Futures	2014.04	2015.75	2013.76	2015.47	354.0
2009-10-22 23:00:00	NQ	Futures	2015.75	2017.46	2015.47	2016.32	457.0
2009-10-22 00:00:00	YM	Futures	9197.7	9205.1	9191.2	9203.2	176.0
2009-10-22 01:00:00	YM	Futures	9203.2	9215.3	9202.3	9210.7	281.0

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

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