PREVIEW / futures_1hour / 2009-10-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1044.46	1044.7	1043.49	1044.22	1687.0
2009-10-26 01:00:00	ES	Futures	1043.98	1045.67	1043.49	1045.43	2046.0
2009-10-26 02:00:00	ES	Futures	1045.43	1046.88	1044.7	1046.64	3428.0
2009-10-26 03:00:00	ES	Futures	1046.64	1047.85	1044.7	1047.85	9125.0
2009-10-26 04:00:00	ES	Futures	1047.85	1049.06	1044.7	1044.94	21425.0
2009-10-26 05:00:00	ES	Futures	1045.19	1048.34	1044.7	1047.85	12368.0
2009-10-26 06:00:00	ES	Futures	1047.85	1049.06	1046.4	1046.4	14007.0
2009-10-26 07:00:00	ES	Futures	1046.4	1046.64	1043.73	1043.98	19257.0
2009-10-26 08:00:00	ES	Futures	1044.22	1045.67	1043.73	1045.43	21804.0
2009-10-26 09:00:00	ES	Futures	1045.43	1053.18	1042.76	1052.21	297391.0
2009-10-26 10:00:00	ES	Futures	1052.21	1054.63	1050.52	1051.97	308938.0
2009-10-26 11:00:00	ES	Futures	1051.73	1053.66	1031.86	1032.35	561140.0
2009-10-26 12:00:00	ES	Futures	1032.11	1035.98	1029.2	1035.26	280684.0
2009-10-26 13:00:00	ES	Futures	1035.26	1035.74	1030.9	1033.32	151785.0
2009-10-26 14:00:00	ES	Futures	1033.32	1034.29	1028.72	1031.38	231692.0
2009-10-26 15:00:00	ES	Futures	1031.38	1034.29	1028.23	1030.41	299805.0
2009-10-26 16:00:00	ES	Futures	1030.65	1033.56	1030.41	1032.35	76951.0
2009-10-26 17:00:00	ES	Futures	1032.35	1032.83	1031.86	1032.59	1920.0
2009-10-26 18:00:00	ES	Futures	1031.86	1032.11	1030.9	1031.14	5720.0
2009-10-26 19:00:00	ES	Futures	1031.14	1031.62	1030.65	1031.62	2300.0
2009-10-26 20:00:00	ES	Futures	1031.86	1033.08	1031.38	1031.38	4884.0
2009-10-26 21:00:00	ES	Futures	1031.38	1031.62	1030.41	1031.14	5251.0
2009-10-26 22:00:00	ES	Futures	1031.14	1031.86	1030.9	1031.38	3278.0
2009-10-26 23:00:00	ES	Futures	1031.62	1032.11	1030.65	1031.86	3031.0
2009-10-26 00:00:00	NQ	Futures	2002.06	2002.06	2000.35	2001.49	75.0
2009-10-26 01:00:00	NQ	Futures	2001.21	2004.06	2000.35	2004.06	131.0
2009-10-26 02:00:00	NQ	Futures	2003.49	2006.06	2002.92	2005.77	340.0
2009-10-26 03:00:00	NQ	Futures	2006.06	2007.77	2002.92	2007.77	895.0
2009-10-26 04:00:00	NQ	Futures	2007.77	2010.05	2002.92	2002.92	1846.0
2009-10-26 05:00:00	NQ	Futures	2002.92	2008.05	2002.35	2007.77	1396.0
2009-10-26 06:00:00	NQ	Futures	2007.48	2009.76	2004.34	2004.34	1375.0
2009-10-26 07:00:00	NQ	Futures	2004.63	2004.63	1999.21	1999.78	2025.0
2009-10-26 08:00:00	NQ	Futures	1999.5	2002.63	1998.93	2001.78	3175.0
2009-10-26 09:00:00	NQ	Futures	2001.49	2024.59	1997.5	2022.31	62852.0
2009-10-26 10:00:00	NQ	Futures	2022.31	2027.45	2020.03	2024.02	50015.0
2009-10-26 11:00:00	NQ	Futures	2023.74	2026.59	1989.23	1989.8	90238.0
2009-10-26 12:00:00	NQ	Futures	1989.8	1996.07	1982.1	1993.22	56735.0
2009-10-26 13:00:00	NQ	Futures	1992.94	1994.93	1985.24	1991.51	29548.0
2009-10-26 14:00:00	NQ	Futures	1991.51	1993.51	1984.1	1989.23	35237.0
2009-10-26 15:00:00	NQ	Futures	1988.94	1996.93	1985.52	1990.94	45907.0
2009-10-26 16:00:00	NQ	Futures	1990.94	1994.36	1990.08	1992.65	8936.0
2009-10-26 17:00:00	NQ	Futures	1992.65	1993.51	1991.8	1992.94	238.0
2009-10-26 18:00:00	NQ	Futures	1988.37	1988.37	1986.38	1986.38	2024.0
2009-10-26 19:00:00	NQ	Futures	1986.66	1987.23	1986.09	1987.23	292.0
2009-10-26 20:00:00	NQ	Futures	1987.23	1990.37	1987.23	1987.8	552.0
2009-10-26 21:00:00	NQ	Futures	1987.52	1987.8	1986.09	1986.95	446.0
2009-10-26 22:00:00	NQ	Futures	1986.95	1988.37	1986.95	1988.37	246.0
2009-10-26 23:00:00	NQ	Futures	1988.37	1989.51	1986.95	1988.37	254.0
2009-10-26 00:00:00	YM	Futures	9249.8	9249.8	9240.5	9245.1	177.0
2009-10-26 01:00:00	YM	Futures	9243.2	9256.3	9239.5	9256.3	181.0

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

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