PREVIEW / futures_1hour / 2009-10-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1052.94	1054.63	1052.94	1054.15	2414.0
2009-10-21 01:00:00	ES	Futures	1054.15	1056.33	1053.91	1055.6	5919.0
2009-10-21 02:00:00	ES	Futures	1055.84	1057.54	1052.7	1055.6	16591.0
2009-10-21 03:00:00	ES	Futures	1055.6	1057.3	1053.42	1054.63	27146.0
2009-10-21 04:00:00	ES	Futures	1054.88	1054.88	1051.0	1053.91	26550.0
2009-10-21 05:00:00	ES	Futures	1053.66	1053.91	1048.34	1050.27	31275.0
2009-10-21 06:00:00	ES	Futures	1050.52	1050.76	1048.34	1049.79	19438.0
2009-10-21 07:00:00	ES	Futures	1049.79	1050.03	1047.12	1049.06	37041.0
2009-10-21 08:00:00	ES	Futures	1049.06	1052.7	1049.06	1051.73	71372.0
2009-10-21 09:00:00	ES	Futures	1051.48	1060.45	1051.0	1058.51	297514.0
2009-10-21 10:00:00	ES	Futures	1058.75	1064.32	1058.51	1061.42	406077.0
2009-10-21 11:00:00	ES	Futures	1061.42	1061.9	1057.78	1058.99	236107.0
2009-10-21 12:00:00	ES	Futures	1058.75	1060.69	1057.3	1060.2	122623.0
2009-10-21 13:00:00	ES	Futures	1060.2	1061.66	1058.27	1061.42	114310.0
2009-10-21 14:00:00	ES	Futures	1061.42	1061.42	1057.3	1059.96	165571.0
2009-10-21 15:00:00	ES	Futures	1059.96	1060.45	1043.49	1044.7	645073.0
2009-10-21 16:00:00	ES	Futures	1044.46	1044.94	1039.13	1043.49	175196.0
2009-10-21 17:00:00	ES	Futures	1043.49	1043.73	1042.76	1043.49	2916.0
2009-10-21 18:00:00	ES	Futures	1043.73	1043.98	1042.52	1043.01	5469.0
2009-10-21 19:00:00	ES	Futures	1043.01	1044.22	1042.76	1044.22	3990.0
2009-10-21 20:00:00	ES	Futures	1044.22	1044.94	1043.49	1044.7	4390.0
2009-10-21 21:00:00	ES	Futures	1044.46	1045.19	1043.25	1043.49	4766.0
2009-10-21 22:00:00	ES	Futures	1043.49	1045.19	1041.8	1042.04	10098.0
2009-10-21 23:00:00	ES	Futures	1042.04	1043.49	1041.55	1042.28	4351.0
2009-10-21 00:00:00	NQ	Futures	2002.35	2004.34	2001.78	2004.34	163.0
2009-10-21 01:00:00	NQ	Futures	2004.34	2007.2	2004.06	2006.34	578.0
2009-10-21 02:00:00	NQ	Futures	2006.06	2009.48	2001.21	2006.34	1541.0
2009-10-21 03:00:00	NQ	Futures	2006.34	2008.91	2002.35	2003.77	2711.0
2009-10-21 04:00:00	NQ	Futures	2003.2	2004.06	1998.07	2002.63	2348.0
2009-10-21 05:00:00	NQ	Futures	2002.92	2002.92	1992.94	1996.64	2821.0
2009-10-21 06:00:00	NQ	Futures	1996.64	1997.5	1993.22	1996.64	1380.0
2009-10-21 07:00:00	NQ	Futures	1996.36	1996.36	1991.8	1994.93	2827.0
2009-10-21 08:00:00	NQ	Futures	1995.5	2000.64	1995.22	1998.93	6231.0
2009-10-21 09:00:00	NQ	Futures	1998.93	2018.6	1998.07	2016.32	48767.0
2009-10-21 10:00:00	NQ	Futures	2016.32	2029.73	2015.47	2022.03	62046.0
2009-10-21 11:00:00	NQ	Futures	2021.74	2024.31	2012.62	2014.33	32551.0
2009-10-21 12:00:00	NQ	Futures	2014.61	2019.46	2011.47	2018.03	18596.0
2009-10-21 13:00:00	NQ	Futures	2017.75	2024.02	2014.9	2023.17	16032.0
2009-10-21 14:00:00	NQ	Futures	2022.88	2024.31	2015.18	2020.32	24256.0
2009-10-21 15:00:00	NQ	Futures	2020.32	2021.17	1994.65	1998.93	81715.0
2009-10-21 16:00:00	NQ	Futures	1998.93	2000.64	1994.36	1996.93	15073.0
2009-10-21 17:00:00	NQ	Futures	1996.64	1996.93	1995.22	1996.64	389.0
2009-10-21 18:00:00	NQ	Futures	1996.36	1998.07	1992.65	1994.08	1018.0
2009-10-21 19:00:00	NQ	Futures	1994.08	1995.5	1993.51	1995.5	630.0
2009-10-21 20:00:00	NQ	Futures	1995.5	1996.93	1994.65	1996.36	368.0
2009-10-21 21:00:00	NQ	Futures	1996.36	1997.5	1994.36	1994.65	346.0
2009-10-21 22:00:00	NQ	Futures	1994.08	1997.5	1990.66	1991.23	1152.0
2009-10-21 23:00:00	NQ	Futures	1991.51	1994.36	1990.66	1992.08	704.0
2009-10-21 00:00:00	YM	Futures	9285.1	9297.2	9285.1	9294.4	158.0
2009-10-21 01:00:00	YM	Futures	9294.4	9310.2	9293.5	9306.5	652.0

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

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