PREVIEW / futures_1hour / 2008-02-07

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-02-07.parquet
  size:    31 KB
  rows:    844

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-02-07 00:00:00	ES	Futures	1233.63	1235.96	1233.16	1235.26	2368.0
2008-02-07 01:00:00	ES	Futures	1235.49	1238.06	1235.26	1237.13	3086.0
2008-02-07 02:00:00	ES	Futures	1237.13	1239.92	1236.89	1239.92	9182.0
2008-02-07 03:00:00	ES	Futures	1239.92	1243.42	1238.06	1239.92	27513.0
2008-02-07 04:00:00	ES	Futures	1239.92	1242.96	1239.69	1240.86	9517.0
2008-02-07 05:00:00	ES	Futures	1240.86	1242.49	1238.06	1238.29	9135.0
2008-02-07 06:00:00	ES	Futures	1238.53	1239.69	1236.19	1238.53	13952.0
2008-02-07 07:00:00	ES	Futures	1238.53	1239.69	1226.17	1229.67	63383.0
2008-02-07 08:00:00	ES	Futures	1229.43	1231.06	1224.3	1227.33	84844.0
2008-02-07 09:00:00	ES	Futures	1227.1	1239.23	1226.63	1230.83	345853.0
2008-02-07 10:00:00	ES	Futures	1230.83	1248.78	1229.67	1239.46	526716.0
2008-02-07 11:00:00	ES	Futures	1239.23	1241.79	1233.16	1238.99	272257.0
2008-02-07 12:00:00	ES	Futures	1238.76	1247.85	1237.13	1247.39	203089.0
2008-02-07 13:00:00	ES	Futures	1247.15	1255.55	1241.56	1254.38	280127.0
2008-02-07 14:00:00	ES	Futures	1254.61	1257.64	1240.39	1241.79	466444.0
2008-02-07 15:00:00	ES	Futures	1242.02	1248.32	1234.33	1248.09	435968.0
2008-02-07 16:00:00	ES	Futures	1248.32	1251.35	1246.92	1249.25	80337.0
2008-02-07 17:00:00	ES	Futures	1249.25	1251.35	1249.25	1251.12	2016.0
2008-02-07 18:00:00	ES	Futures	1251.12	1252.75	1246.92	1247.15	7205.0
2008-02-07 19:00:00	ES	Futures	1247.15	1249.72	1246.92	1249.25	1993.0
2008-02-07 20:00:00	ES	Futures	1249.48	1249.48	1247.85	1248.09	1203.0
2008-02-07 21:00:00	ES	Futures	1248.32	1251.35	1248.09	1250.65	1261.0
2008-02-07 22:00:00	ES	Futures	1250.42	1250.88	1247.85	1249.48	1772.0
2008-02-07 23:00:00	ES	Futures	1249.48	1249.72	1247.85	1248.32	869.0
2008-02-07 00:00:00	NQ	Futures	1957.95	1959.66	1957.1	1959.09	217.0
2008-02-07 01:00:00	NQ	Futures	1959.66	1964.77	1958.81	1963.35	1167.0
2008-02-07 02:00:00	NQ	Futures	1963.35	1969.88	1963.35	1969.02	1449.0
2008-02-07 03:00:00	NQ	Futures	1969.02	1974.13	1966.19	1966.75	1521.0
2008-02-07 04:00:00	NQ	Futures	1966.47	1971.58	1966.19	1967.04	1085.0
2008-02-07 05:00:00	NQ	Futures	1966.75	1969.02	1963.06	1963.35	988.0
2008-02-07 06:00:00	NQ	Futures	1963.91	1964.48	1958.24	1962.78	1314.0
2008-02-07 07:00:00	NQ	Futures	1962.21	1963.35	1948.3	1950.29	4635.0
2008-02-07 08:00:00	NQ	Futures	1950.29	1954.26	1944.9	1949.44	10473.0
2008-02-07 09:00:00	NQ	Futures	1949.44	1974.7	1948.87	1954.83	91917.0
2008-02-07 10:00:00	NQ	Futures	1954.55	1993.15	1954.26	1975.84	132942.0
2008-02-07 11:00:00	NQ	Futures	1975.84	1980.38	1967.6	1978.96	48549.0
2008-02-07 12:00:00	NQ	Futures	1978.67	1997.12	1977.25	1995.42	59267.0
2008-02-07 13:00:00	NQ	Futures	1995.42	2020.68	1988.04	2018.7	64719.0
2008-02-07 14:00:00	NQ	Futures	2018.7	2026.93	1984.07	1984.63	119437.0
2008-02-07 15:00:00	NQ	Futures	1984.92	1996.84	1966.47	1995.42	90732.0
2008-02-07 16:00:00	NQ	Futures	1995.42	2008.19	1994.57	2003.94	14676.0
2008-02-07 17:00:00	NQ	Futures	2003.94	2006.49	2003.94	2005.07	818.0
2008-02-07 18:00:00	NQ	Futures	2007.91	2009.05	2001.38	2001.67	500.0
2008-02-07 19:00:00	NQ	Futures	2001.67	2006.49	2000.81	2004.79	251.0
2008-02-07 20:00:00	NQ	Futures	2004.79	2005.07	2001.67	2001.67	99.0
2008-02-07 21:00:00	NQ	Futures	2002.8	2008.19	2002.23	2007.91	130.0
2008-02-07 22:00:00	NQ	Futures	2006.49	2007.91	2003.37	2003.65	201.0
2008-02-07 23:00:00	NQ	Futures	2003.94	2003.94	2001.1	2003.08	50.0
2008-02-07 00:00:00	YM	Futures	11068.2	11083.7	11068.2	11078.2	148.0
2008-02-07 01:00:00	YM	Futures	11081.0	11100.0	11078.2	11091.9	234.0

> showing 50 of 844 rows — these rows as CSV

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