PREVIEW / futures_1hour / 2008-03-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1251.12	1251.58	1249.72	1249.72	1276.0
2008-03-06 01:00:00	ES	Futures	1249.72	1251.35	1249.02	1249.02	1520.0
2008-03-06 02:00:00	ES	Futures	1249.25	1249.72	1246.22	1246.69	4557.0
2008-03-06 03:00:00	ES	Futures	1246.69	1247.39	1240.86	1241.09	24793.0
2008-03-06 04:00:00	ES	Futures	1241.09	1243.42	1240.62	1240.86	11791.0
2008-03-06 05:00:00	ES	Futures	1240.62	1240.86	1237.59	1239.46	21646.0
2008-03-06 06:00:00	ES	Futures	1239.46	1242.96	1238.53	1241.56	18583.0
2008-03-06 07:00:00	ES	Futures	1241.56	1243.42	1237.83	1238.53	25309.0
2008-03-06 08:00:00	ES	Futures	1238.29	1238.99	1232.7	1234.56	89134.0
2008-03-06 09:00:00	ES	Futures	1234.56	1239.92	1232.23	1234.1	268234.0
2008-03-06 10:00:00	ES	Futures	1234.1	1235.26	1227.57	1232.0	411926.0
2008-03-06 11:00:00	ES	Futures	1232.23	1233.4	1227.1	1230.6	278019.0
2008-03-06 12:00:00	ES	Futures	1230.37	1230.6	1223.84	1226.17	229306.0
2008-03-06 13:00:00	ES	Futures	1226.4	1229.2	1223.14	1226.87	191700.0
2008-03-06 14:00:00	ES	Futures	1226.63	1229.67	1223.6	1225.47	198598.0
2008-03-06 15:00:00	ES	Futures	1225.7	1227.33	1215.68	1217.31	508829.0
2008-03-06 16:00:00	ES	Futures	1217.31	1221.51	1214.51	1221.27	152565.0
2008-03-06 17:00:00	ES	Futures	1221.27	1221.51	1219.17	1219.41	3083.0
2008-03-06 18:00:00	ES	Futures	1219.64	1221.04	1217.08	1220.57	7862.0
2008-03-06 19:00:00	ES	Futures	1220.57	1220.81	1217.77	1219.87	3301.0
2008-03-06 20:00:00	ES	Futures	1220.11	1220.11	1218.47	1218.71	4116.0
2008-03-06 21:00:00	ES	Futures	1218.71	1219.87	1217.54	1217.54	4111.0
2008-03-06 22:00:00	ES	Futures	1217.54	1218.94	1217.31	1217.77	2257.0
2008-03-06 23:00:00	ES	Futures	1218.01	1221.51	1218.01	1220.57	2658.0
2008-03-06 00:00:00	NQ	Futures	2010.75	2011.6	2005.64	2006.77	272.0
2008-03-06 01:00:00	NQ	Futures	2006.21	2009.33	2005.64	2006.21	125.0
2008-03-06 02:00:00	NQ	Futures	2006.21	2007.91	2001.67	2002.8	425.0
2008-03-06 03:00:00	NQ	Futures	2003.08	2003.37	1991.73	1992.3	1491.0
2008-03-06 04:00:00	NQ	Futures	1992.01	1996.56	1991.45	1992.3	511.0
2008-03-06 05:00:00	NQ	Futures	1992.3	1992.3	1988.32	1991.45	815.0
2008-03-06 06:00:00	NQ	Futures	1991.73	1997.12	1990.03	1993.15	746.0
2008-03-06 07:00:00	NQ	Futures	1993.15	1999.96	1991.73	1992.58	3301.0
2008-03-06 08:00:00	NQ	Futures	1992.87	1993.15	1981.23	1985.49	7848.0
2008-03-06 09:00:00	NQ	Futures	1985.77	1997.98	1985.49	1990.6	50266.0
2008-03-06 10:00:00	NQ	Futures	1990.6	1997.41	1981.8	1991.16	68071.0
2008-03-06 11:00:00	NQ	Futures	1991.45	1993.72	1981.23	1985.49	50126.0
2008-03-06 12:00:00	NQ	Futures	1985.77	1985.77	1968.17	1969.31	52932.0
2008-03-06 13:00:00	NQ	Futures	1969.31	1973.85	1960.22	1963.91	47637.0
2008-03-06 14:00:00	NQ	Futures	1963.91	1970.44	1960.22	1964.48	36110.0
2008-03-06 15:00:00	NQ	Futures	1964.2	1967.6	1943.76	1946.32	85294.0
2008-03-06 16:00:00	NQ	Futures	1946.32	1951.99	1942.63	1951.14	19072.0
2008-03-06 17:00:00	NQ	Futures	1951.43	1952.56	1948.59	1949.15	398.0
2008-03-06 18:00:00	NQ	Futures	1947.74	1951.71	1945.46	1950.57	1148.0
2008-03-06 19:00:00	NQ	Futures	1951.14	1951.99	1947.17	1948.59	607.0
2008-03-06 20:00:00	NQ	Futures	1948.59	1950.57	1948.3	1949.15	278.0
2008-03-06 21:00:00	NQ	Futures	1948.87	1949.44	1946.32	1946.6	164.0
2008-03-06 22:00:00	NQ	Futures	1946.32	1948.02	1945.18	1945.75	76.0
2008-03-06 23:00:00	NQ	Futures	1946.32	1950.86	1945.75	1950.01	66.0
2008-03-06 00:00:00	YM	Futures	11199.1	11202.7	11185.4	11186.3	121.0
2008-03-06 01:00:00	YM	Futures	11187.2	11202.7	11180.9	11180.9	100.0

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

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