PREVIEW / futures_1hour / 2008-03-05

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-03-05.parquet
  size:    43 KB
  rows:    1,210

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
2008-03-05 00:00:00	ES	Futures	1238.99	1239.46	1237.13	1237.59	1206.0
2008-03-05 01:00:00	ES	Futures	1237.59	1238.29	1236.66	1237.83	2154.0
2008-03-05 02:00:00	ES	Futures	1237.83	1240.86	1237.13	1240.39	5767.0
2008-03-05 03:00:00	ES	Futures	1240.62	1240.62	1236.19	1236.43	16562.0
2008-03-05 04:00:00	ES	Futures	1236.43	1240.16	1235.49	1239.23	12710.0
2008-03-05 05:00:00	ES	Futures	1239.46	1240.39	1238.06	1240.16	11029.0
2008-03-05 06:00:00	ES	Futures	1239.92	1244.59	1239.46	1243.89	26219.0
2008-03-05 07:00:00	ES	Futures	1243.89	1245.52	1241.32	1244.82	35627.0
2008-03-05 08:00:00	ES	Futures	1245.05	1245.05	1239.23	1240.86	63846.0
2008-03-05 09:00:00	ES	Futures	1240.62	1245.05	1239.23	1244.12	192430.0
2008-03-05 10:00:00	ES	Futures	1243.89	1252.05	1243.66	1247.15	404043.0
2008-03-05 11:00:00	ES	Futures	1247.15	1249.95	1245.29	1247.62	182150.0
2008-03-05 12:00:00	ES	Futures	1247.85	1254.38	1242.49	1245.75	400897.0
2008-03-05 13:00:00	ES	Futures	1245.99	1248.32	1231.3	1235.26	442563.0
2008-03-05 14:00:00	ES	Futures	1235.49	1243.66	1232.46	1240.86	256793.0
2008-03-05 15:00:00	ES	Futures	1240.86	1245.05	1234.8	1244.12	294568.0
2008-03-05 16:00:00	ES	Futures	1244.35	1245.99	1243.89	1245.75	70480.0
2008-03-05 17:00:00	ES	Futures	1245.75	1248.32	1244.82	1247.85	3868.0
2008-03-05 18:00:00	ES	Futures	1247.39	1247.62	1244.59	1244.59	3534.0
2008-03-05 19:00:00	ES	Futures	1244.59	1245.05	1244.12	1244.59	3959.0
2008-03-05 20:00:00	ES	Futures	1244.59	1248.32	1244.59	1247.85	2820.0
2008-03-05 21:00:00	ES	Futures	1247.85	1249.02	1246.69	1248.55	2539.0
2008-03-05 22:00:00	ES	Futures	1248.55	1251.58	1248.55	1250.88	3524.0
2008-03-05 23:00:00	ES	Futures	1250.65	1252.51	1250.42	1251.12	2788.0
2008-03-05 00:00:00	NQ	Futures	1982.36	1983.22	1980.66	1981.8	154.0
2008-03-05 01:00:00	NQ	Futures	1981.51	1983.22	1980.94	1983.22	46.0
2008-03-05 02:00:00	NQ	Futures	1983.22	1986.34	1981.8	1986.05	199.0
2008-03-05 03:00:00	NQ	Futures	1984.35	1984.35	1979.53	1980.09	882.0
2008-03-05 04:00:00	NQ	Futures	1979.53	1984.92	1977.82	1984.63	576.0
2008-03-05 05:00:00	NQ	Futures	1984.63	1989.18	1983.5	1988.61	1414.0
2008-03-05 06:00:00	NQ	Futures	1988.32	1995.7	1987.47	1994.85	2557.0
2008-03-05 07:00:00	NQ	Futures	1995.14	1997.69	1992.58	1996.27	3885.0
2008-03-05 08:00:00	NQ	Futures	1995.99	1996.27	1986.34	1991.16	7094.0
2008-03-05 09:00:00	NQ	Futures	1990.88	1997.41	1983.5	1992.87	54003.0
2008-03-05 10:00:00	NQ	Futures	1992.58	2004.22	1992.3	1997.98	78044.0
2008-03-05 11:00:00	NQ	Futures	1997.98	2001.95	1994.57	1997.69	38171.0
2008-03-05 12:00:00	NQ	Futures	1997.69	2010.46	1992.01	1997.41	67967.0
2008-03-05 13:00:00	NQ	Futures	1997.69	2001.67	1974.42	1979.53	73679.0
2008-03-05 14:00:00	NQ	Futures	1978.96	1996.84	1974.13	1991.16	45664.0
2008-03-05 15:00:00	NQ	Futures	1991.16	1992.58	1981.8	1991.16	51316.0
2008-03-05 16:00:00	NQ	Futures	1991.45	1998.26	1990.31	1994.85	13500.0
2008-03-05 17:00:00	NQ	Futures	1994.85	1998.26	1994.85	1998.26	192.0
2008-03-05 18:00:00	NQ	Futures	1997.41	1997.41	1994.57	1994.57	251.0
2008-03-05 19:00:00	NQ	Futures	1994.57	1995.42	1994.29	1995.42	43.0
2008-03-05 20:00:00	NQ	Futures	1995.42	2003.94	1995.42	2003.65	512.0
2008-03-05 21:00:00	NQ	Futures	2003.65	2006.49	2002.52	2006.21	228.0
2008-03-05 22:00:00	NQ	Futures	2004.79	2012.45	2004.79	2009.61	475.0
2008-03-05 23:00:00	NQ	Futures	2009.61	2013.02	2008.76	2010.18	161.0
2008-03-05 00:00:00	YM	Futures	11107.3	11109.1	11098.2	11100.9	72.0
2008-03-05 01:00:00	YM	Futures	11098.2	11105.5	11094.6	11100.0	112.0

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

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