PREVIEW / futures_1hour / 2009-10-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	1053.66	1054.39	1053.42	1053.91	1562.0
2009-10-15 01:00:00	ES	Futures	1053.91	1054.88	1053.66	1054.63	1590.0
2009-10-15 02:00:00	ES	Futures	1054.88	1055.12	1053.66	1053.91	6372.0
2009-10-15 03:00:00	ES	Futures	1053.91	1055.36	1053.18	1053.66	23520.0
2009-10-15 04:00:00	ES	Futures	1053.66	1055.12	1052.7	1054.88	15862.0
2009-10-15 05:00:00	ES	Futures	1054.88	1055.12	1054.15	1054.39	12879.0
2009-10-15 06:00:00	ES	Futures	1054.63	1054.88	1053.66	1054.63	17018.0
2009-10-15 07:00:00	ES	Futures	1054.63	1056.09	1048.58	1049.3	81044.0
2009-10-15 08:00:00	ES	Futures	1049.3	1050.76	1046.88	1048.82	103586.0
2009-10-15 09:00:00	ES	Futures	1048.58	1053.66	1048.58	1053.42	199585.0
2009-10-15 10:00:00	ES	Futures	1053.66	1053.66	1049.06	1051.48	318747.0
2009-10-15 11:00:00	ES	Futures	1051.48	1052.94	1049.79	1051.73	146937.0
2009-10-15 12:00:00	ES	Futures	1051.97	1054.15	1051.73	1052.21	142593.0
2009-10-15 13:00:00	ES	Futures	1051.97	1054.15	1051.48	1053.18	93322.0
2009-10-15 14:00:00	ES	Futures	1053.42	1057.3	1052.7	1056.81	187870.0
2009-10-15 15:00:00	ES	Futures	1056.81	1058.51	1054.39	1057.78	279148.0
2009-10-15 16:00:00	ES	Futures	1057.78	1059.24	1055.36	1055.84	186259.0
2009-10-15 17:00:00	ES	Futures	1056.09	1057.78	1056.09	1056.57	4330.0
2009-10-15 18:00:00	ES	Futures	1056.81	1057.78	1056.57	1056.81	2989.0
2009-10-15 19:00:00	ES	Futures	1056.81	1058.02	1056.57	1057.54	2056.0
2009-10-15 20:00:00	ES	Futures	1057.54	1058.75	1057.3	1058.02	3770.0
2009-10-15 21:00:00	ES	Futures	1058.27	1058.51	1056.57	1056.81	3127.0
2009-10-15 22:00:00	ES	Futures	1056.81	1058.51	1056.57	1057.3	3377.0
2009-10-15 23:00:00	ES	Futures	1057.06	1057.54	1056.33	1056.81	2204.0
2009-10-15 00:00:00	NQ	Futures	1992.08	1992.94	1991.23	1992.08	119.0
2009-10-15 01:00:00	NQ	Futures	1992.08	1994.36	1991.8	1994.36	214.0
2009-10-15 02:00:00	NQ	Futures	1994.08	1994.93	1992.94	1993.22	495.0
2009-10-15 03:00:00	NQ	Futures	1992.94	1994.93	1991.51	1992.37	2258.0
2009-10-15 04:00:00	NQ	Futures	1991.8	1994.65	1990.94	1994.08	1629.0
2009-10-15 05:00:00	NQ	Futures	1994.08	1994.93	1992.65	1992.94	1230.0
2009-10-15 06:00:00	NQ	Futures	1993.22	1994.08	1991.23	1993.51	1439.0
2009-10-15 07:00:00	NQ	Futures	1993.79	1995.22	1983.81	1984.38	6356.0
2009-10-15 08:00:00	NQ	Futures	1984.67	1989.23	1981.53	1984.67	9037.0
2009-10-15 09:00:00	NQ	Futures	1984.67	1997.21	1984.67	1996.36	34878.0
2009-10-15 10:00:00	NQ	Futures	1996.36	1997.21	1985.52	1988.94	47095.0
2009-10-15 11:00:00	NQ	Futures	1988.94	1991.23	1986.38	1990.37	24792.0
2009-10-15 12:00:00	NQ	Futures	1990.37	1993.79	1988.66	1989.23	19848.0
2009-10-15 13:00:00	NQ	Futures	1989.23	1992.37	1988.94	1990.37	15712.0
2009-10-15 14:00:00	NQ	Futures	1990.37	1996.93	1987.8	1996.07	26993.0
2009-10-15 15:00:00	NQ	Futures	1996.07	1997.5	1990.94	1995.22	38248.0
2009-10-15 16:00:00	NQ	Futures	1994.93	2001.21	1993.22	1995.22	27493.0
2009-10-15 17:00:00	NQ	Futures	1994.65	1997.5	1994.08	1995.5	522.0
2009-10-15 18:00:00	NQ	Futures	1995.79	1997.21	1995.79	1996.36	197.0
2009-10-15 19:00:00	NQ	Futures	1996.36	1999.21	1996.36	1998.64	407.0
2009-10-15 20:00:00	NQ	Futures	1998.36	2001.21	1997.5	2000.64	1053.0
2009-10-15 21:00:00	NQ	Futures	2000.92	2000.92	1997.21	1997.79	414.0
2009-10-15 22:00:00	NQ	Futures	1998.07	2000.35	1997.21	1998.07	345.0
2009-10-15 23:00:00	NQ	Futures	1998.07	1998.07	1996.07	1997.5	386.0
2009-10-15 00:00:00	YM	Futures	9258.1	9263.7	9255.3	9260.0	157.0
2009-10-15 01:00:00	YM	Futures	9260.9	9266.5	9257.2	9265.6	126.0

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

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