PREVIEW / futures_1hour / 2008-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-03-19.parquet
  size:    45 KB
  rows:    1,262

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-19 00:00:00	ES	Futures	1241.76	1242.22	1240.13	1241.06	3513.0
2008-03-19 01:00:00	ES	Futures	1241.06	1241.99	1239.66	1239.66	3630.0
2008-03-19 02:00:00	ES	Futures	1239.66	1242.45	1239.19	1241.99	3800.0
2008-03-19 03:00:00	ES	Futures	1242.22	1242.22	1238.73	1239.89	7430.0
2008-03-19 04:00:00	ES	Futures	1239.89	1240.13	1230.58	1231.74	44281.0
2008-03-19 05:00:00	ES	Futures	1231.51	1235.7	1230.81	1233.14	35935.0
2008-03-19 06:00:00	ES	Futures	1233.14	1236.4	1231.51	1234.3	28260.0
2008-03-19 07:00:00	ES	Futures	1234.3	1239.43	1229.88	1236.17	70891.0
2008-03-19 08:00:00	ES	Futures	1235.93	1242.22	1234.3	1241.76	68853.0
2008-03-19 09:00:00	ES	Futures	1241.29	1251.53	1241.29	1242.92	382549.0
2008-03-19 10:00:00	ES	Futures	1242.92	1246.65	1235.93	1240.36	366143.0
2008-03-19 11:00:00	ES	Futures	1240.36	1247.34	1239.19	1243.15	237416.0
2008-03-19 12:00:00	ES	Futures	1243.15	1244.55	1232.21	1234.07	290433.0
2008-03-19 13:00:00	ES	Futures	1234.07	1237.56	1222.2	1225.92	345347.0
2008-03-19 14:00:00	ES	Futures	1225.92	1227.78	1217.07	1226.39	381826.0
2008-03-19 15:00:00	ES	Futures	1226.15	1230.35	1209.86	1210.79	467945.0
2008-03-19 16:00:00	ES	Futures	1210.79	1211.72	1207.76	1209.62	146722.0
2008-03-19 17:00:00	ES	Futures	1208.92	1210.09	1208.46	1208.46	2689.0
2008-03-19 18:00:00	ES	Futures	1208.23	1209.62	1206.13	1206.13	6532.0
2008-03-19 19:00:00	ES	Futures	1206.13	1208.92	1204.03	1204.97	4449.0
2008-03-19 20:00:00	ES	Futures	1204.97	1206.13	1204.27	1204.97	2262.0
2008-03-19 21:00:00	ES	Futures	1204.73	1204.97	1202.64	1204.27	5943.0
2008-03-19 22:00:00	ES	Futures	1204.27	1204.5	1198.21	1201.24	7101.0
2008-03-19 23:00:00	ES	Futures	1201.47	1202.64	1200.77	1202.4	2784.0
2008-03-19 00:00:00	NQ	Futures	2003.56	2003.56	2001.3	2001.58	70.0
2008-03-19 01:00:00	NQ	Futures	2001.86	2003.28	1999.03	2000.16	152.0
2008-03-19 02:00:00	NQ	Futures	2000.45	2002.99	1998.18	2002.99	155.0
2008-03-19 03:00:00	NQ	Futures	2001.86	2002.43	1995.07	1998.47	707.0
2008-03-19 04:00:00	NQ	Futures	1998.18	1998.18	1984.89	1986.59	1791.0
2008-03-19 05:00:00	NQ	Futures	1986.02	1992.81	1984.61	1988.0	1806.0
2008-03-19 06:00:00	NQ	Futures	1987.72	1993.66	1984.89	1991.68	1190.0
2008-03-19 07:00:00	NQ	Futures	1991.11	1999.03	1985.74	1992.53	2473.0
2008-03-19 08:00:00	NQ	Futures	1992.24	2000.73	1989.42	1999.88	8175.0
2008-03-19 09:00:00	NQ	Futures	1999.6	2016.0	1997.9	1999.6	65634.0
2008-03-19 10:00:00	NQ	Futures	1999.6	2006.95	1982.63	1993.38	78701.0
2008-03-19 11:00:00	NQ	Futures	1993.38	2009.5	1991.11	1999.6	48232.0
2008-03-19 12:00:00	NQ	Futures	1999.88	2002.99	1983.19	1987.15	61874.0
2008-03-19 13:00:00	NQ	Futures	1987.44	1992.81	1974.43	1976.97	68559.0
2008-03-19 14:00:00	NQ	Futures	1977.25	1983.76	1965.94	1975.84	76592.0
2008-03-19 15:00:00	NQ	Futures	1975.56	1984.61	1947.28	1948.69	100766.0
2008-03-19 16:00:00	NQ	Futures	1948.69	1952.37	1947.28	1950.39	20597.0
2008-03-19 17:00:00	NQ	Futures	1948.69	1949.82	1947.28	1948.41	119.0
2008-03-19 18:00:00	NQ	Futures	1949.25	1950.1	1944.45	1945.01	496.0
2008-03-19 19:00:00	NQ	Futures	1944.73	1944.73	1940.77	1942.47	296.0
2008-03-19 20:00:00	NQ	Futures	1942.75	1945.01	1941.9	1943.6	113.0
2008-03-19 21:00:00	NQ	Futures	1942.47	1943.03	1937.66	1943.03	277.0
2008-03-19 22:00:00	NQ	Futures	1943.03	1943.03	1934.26	1936.81	629.0
2008-03-19 23:00:00	NQ	Futures	1937.38	1938.79	1935.4	1938.79	39.0
2008-03-19 00:00:00	YM	Futures	11261.8	11262.7	11250.9	11258.2	204.0
2008-03-19 01:00:00	YM	Futures	11258.2	11261.8	11247.3	11249.1	131.0

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

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