PREVIEW / futures_1hour / 2009-11-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-30.parquet
  size:    45 KB
  rows:    1,359

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-30 00:00:00	ES	Futures	1062.63	1063.35	1058.51	1059.96	12068.0
2009-11-30 01:00:00	ES	Futures	1059.72	1060.69	1058.99	1060.2	5421.0
2009-11-30 02:00:00	ES	Futures	1059.96	1063.11	1059.72	1061.9	10799.0
2009-11-30 03:00:00	ES	Futures	1061.9	1062.14	1054.39	1057.3	45271.0
2009-11-30 04:00:00	ES	Futures	1057.3	1058.51	1052.94	1053.66	32405.0
2009-11-30 05:00:00	ES	Futures	1053.91	1056.57	1052.45	1055.12	26873.0
2009-11-30 06:00:00	ES	Futures	1054.88	1056.57	1050.76	1053.91	36092.0
2009-11-30 07:00:00	ES	Futures	1053.91	1056.09	1052.21	1056.09	38410.0
2009-11-30 08:00:00	ES	Futures	1055.84	1059.24	1054.63	1056.81	44681.0
2009-11-30 09:00:00	ES	Futures	1056.57	1058.99	1052.94	1057.3	295587.0
2009-11-30 10:00:00	ES	Futures	1057.06	1062.38	1057.06	1058.27	247441.0
2009-11-30 11:00:00	ES	Futures	1058.51	1058.51	1051.24	1052.7	247825.0
2009-11-30 12:00:00	ES	Futures	1052.45	1055.36	1051.97	1052.45	143792.0
2009-11-30 13:00:00	ES	Futures	1052.45	1056.81	1052.21	1055.84	135433.0
2009-11-30 14:00:00	ES	Futures	1055.84	1056.33	1053.91	1054.63	103887.0
2009-11-30 15:00:00	ES	Futures	1054.63	1062.38	1054.39	1060.69	372258.0
2009-11-30 16:00:00	ES	Futures	1060.69	1061.17	1058.02	1059.72	153460.0
2009-11-30 17:00:00	ES	Futures	1059.48	1059.72	1058.27	1058.75	2349.0
2009-11-30 18:00:00	ES	Futures	1058.99	1059.72	1058.51	1058.75	5903.0
2009-11-30 19:00:00	ES	Futures	1058.99	1061.42	1058.51	1059.24	11647.0
2009-11-30 20:00:00	ES	Futures	1059.48	1060.93	1059.24	1059.96	5166.0
2009-11-30 21:00:00	ES	Futures	1059.96	1062.14	1059.96	1060.69	6720.0
2009-11-30 22:00:00	ES	Futures	1060.93	1062.14	1060.45	1061.42	5156.0
2009-11-30 23:00:00	ES	Futures	1061.66	1062.38	1061.42	1061.66	6575.0
2009-11-30 00:00:00	NQ	Futures	2023.17	2024.31	2014.9	2017.18	806.0
2009-11-30 01:00:00	NQ	Futures	2016.61	2019.46	2015.47	2019.17	491.0
2009-11-30 02:00:00	NQ	Futures	2018.89	2024.02	2017.46	2022.03	833.0
2009-11-30 03:00:00	NQ	Futures	2021.74	2021.74	2005.49	2010.62	4985.0
2009-11-30 04:00:00	NQ	Futures	2010.62	2012.62	2001.21	2002.06	2930.0
2009-11-30 05:00:00	NQ	Futures	2001.78	2008.34	1999.78	2005.77	2844.0
2009-11-30 06:00:00	NQ	Futures	2005.77	2008.34	1996.64	2003.49	3275.0
2009-11-30 07:00:00	NQ	Futures	2003.77	2009.48	2000.92	2008.91	3140.0
2009-11-30 08:00:00	NQ	Futures	2008.91	2014.33	2006.06	2010.05	4984.0
2009-11-30 09:00:00	NQ	Futures	2010.05	2014.04	2002.92	2009.76	53827.0
2009-11-30 10:00:00	NQ	Futures	2009.76	2020.03	2009.76	2010.62	40711.0
2009-11-30 11:00:00	NQ	Futures	2010.62	2010.62	1996.64	1999.78	42585.0
2009-11-30 12:00:00	NQ	Futures	2000.07	2005.49	1999.5	2000.92	27575.0
2009-11-30 13:00:00	NQ	Futures	2000.64	2009.19	2000.07	2007.77	24453.0
2009-11-30 14:00:00	NQ	Futures	2008.05	2008.91	2004.91	2005.77	23183.0
2009-11-30 15:00:00	NQ	Futures	2005.77	2019.17	2005.77	2016.61	52565.0
2009-11-30 16:00:00	NQ	Futures	2016.61	2018.89	2012.04	2016.61	15194.0
2009-11-30 17:00:00	NQ	Futures	2016.61	2016.89	2014.33	2014.61	250.0
2009-11-30 18:00:00	NQ	Futures	2015.18	2016.32	2014.04	2014.9	343.0
2009-11-30 19:00:00	NQ	Futures	2014.9	2018.03	2014.33	2015.18	1031.0
2009-11-30 20:00:00	NQ	Futures	2015.18	2017.46	2015.18	2016.04	356.0
2009-11-30 21:00:00	NQ	Futures	2016.04	2019.75	2016.04	2017.46	578.0
2009-11-30 22:00:00	NQ	Futures	2017.18	2020.89	2016.32	2018.89	755.0
2009-11-30 23:00:00	NQ	Futures	2018.89	2020.32	2018.32	2018.6	469.0
2009-11-30 00:00:00	YM	Futures	9626.5	9630.2	9592.1	9604.2	673.0
2009-11-30 01:00:00	YM	Futures	9604.2	9610.7	9594.9	9606.9	418.0

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

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