PREVIEW / futures_1hour / 2009-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-20.parquet
  size:    46 KB
  rows:    1,324

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-20 00:00:00	ES	Futures	1060.93	1061.66	1060.93	1061.42	680.0
2009-10-20 01:00:00	ES	Futures	1061.42	1061.66	1059.96	1061.17	2301.0
2009-10-20 02:00:00	ES	Futures	1061.17	1063.35	1061.17	1063.11	12210.0
2009-10-20 03:00:00	ES	Futures	1062.87	1063.11	1058.02	1058.51	38948.0
2009-10-20 04:00:00	ES	Futures	1058.27	1058.51	1055.12	1056.57	31637.0
2009-10-20 05:00:00	ES	Futures	1056.57	1060.2	1056.33	1059.48	14876.0
2009-10-20 06:00:00	ES	Futures	1059.48	1060.69	1058.02	1058.51	15375.0
2009-10-20 07:00:00	ES	Futures	1058.51	1064.81	1058.27	1062.87	52717.0
2009-10-20 08:00:00	ES	Futures	1062.63	1063.11	1057.3	1060.2	67208.0
2009-10-20 09:00:00	ES	Futures	1060.2	1061.9	1054.63	1057.54	288466.0
2009-10-20 10:00:00	ES	Futures	1057.54	1058.99	1053.42	1057.3	319150.0
2009-10-20 11:00:00	ES	Futures	1057.3	1057.78	1049.79	1051.48	269470.0
2009-10-20 12:00:00	ES	Futures	1051.48	1052.21	1048.34	1050.52	206970.0
2009-10-20 13:00:00	ES	Futures	1050.76	1052.7	1049.79	1050.27	123028.0
2009-10-20 14:00:00	ES	Futures	1050.03	1054.15	1049.79	1053.42	173372.0
2009-10-20 15:00:00	ES	Futures	1053.42	1054.63	1050.52	1053.66	245755.0
2009-10-20 16:00:00	ES	Futures	1053.91	1056.09	1053.42	1054.15	83224.0
2009-10-20 17:00:00	ES	Futures	1053.91	1054.15	1052.94	1053.66	5106.0
2009-10-20 18:00:00	ES	Futures	1053.66	1055.12	1053.66	1053.91	2540.0
2009-10-20 19:00:00	ES	Futures	1053.91	1054.88	1053.66	1054.15	1776.0
2009-10-20 20:00:00	ES	Futures	1053.91	1054.88	1053.66	1054.15	3724.0
2009-10-20 21:00:00	ES	Futures	1054.15	1054.63	1052.94	1053.42	2363.0
2009-10-20 22:00:00	ES	Futures	1053.18	1054.15	1052.7	1053.18	2593.0
2009-10-20 23:00:00	ES	Futures	1053.42	1053.66	1052.7	1052.94	2235.0
2009-10-20 00:00:00	NQ	Futures	2016.61	2017.75	2016.32	2017.75	57.0
2009-10-20 01:00:00	NQ	Futures	2017.18	2017.18	2015.18	2016.61	281.0
2009-10-20 02:00:00	NQ	Futures	2017.18	2018.6	2016.04	2018.03	1863.0
2009-10-20 03:00:00	NQ	Futures	2018.03	2018.03	2010.33	2010.9	3430.0
2009-10-20 04:00:00	NQ	Futures	2010.9	2010.9	2005.77	2006.91	3369.0
2009-10-20 05:00:00	NQ	Futures	2006.91	2014.33	2006.63	2012.9	1513.0
2009-10-20 06:00:00	NQ	Futures	2012.9	2014.33	2009.48	2010.62	1786.0
2009-10-20 07:00:00	NQ	Futures	2010.05	2021.17	2009.76	2016.32	4576.0
2009-10-20 08:00:00	NQ	Futures	2016.32	2018.89	2008.05	2013.76	11328.0
2009-10-20 09:00:00	NQ	Futures	2013.76	2017.46	1999.21	2006.63	63382.0
2009-10-20 10:00:00	NQ	Futures	2006.63	2009.76	1997.5	2007.77	45109.0
2009-10-20 11:00:00	NQ	Futures	2007.77	2008.91	1994.08	1996.64	33566.0
2009-10-20 12:00:00	NQ	Futures	1996.64	1998.07	1988.94	1992.65	35860.0
2009-10-20 13:00:00	NQ	Futures	1992.65	1998.93	1992.37	1994.65	21221.0
2009-10-20 14:00:00	NQ	Futures	1994.36	2002.63	1993.79	2000.07	28672.0
2009-10-20 15:00:00	NQ	Futures	2000.35	2002.63	1995.5	2001.49	37882.0
2009-10-20 16:00:00	NQ	Futures	2001.78	2006.63	2001.21	2003.77	11168.0
2009-10-20 17:00:00	NQ	Futures	2003.49	2003.49	2000.92	2002.06	488.0
2009-10-20 18:00:00	NQ	Futures	2002.35	2004.06	2002.35	2002.63	527.0
2009-10-20 19:00:00	NQ	Futures	2002.63	2004.34	2002.35	2002.92	230.0
2009-10-20 20:00:00	NQ	Futures	2002.63	2004.63	2002.35	2003.49	443.0
2009-10-20 21:00:00	NQ	Futures	2003.2	2004.06	2001.78	2002.06	339.0
2009-10-20 22:00:00	NQ	Futures	2002.06	2003.77	2001.49	2002.63	207.0
2009-10-20 23:00:00	NQ	Futures	2002.06	2002.63	2001.78	2002.06	121.0
2009-10-20 00:00:00	YM	Futures	9335.3	9340.0	9334.4	9340.0	73.0
2009-10-20 01:00:00	YM	Futures	9339.1	9340.0	9326.0	9337.2	231.0

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

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