PREVIEW / futures_1hour / 2008-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-04.parquet
  size:    45 KB
  rows:    1,247

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-09-04 00:00:00	ES	Futures	1185.09	1185.55	1184.16	1184.62	1071.0
2008-09-04 01:00:00	ES	Futures	1184.85	1185.55	1183.92	1184.16	1161.0
2008-09-04 02:00:00	ES	Futures	1184.39	1185.55	1183.46	1184.85	3208.0
2008-09-04 03:00:00	ES	Futures	1184.85	1187.18	1182.06	1183.69	15519.0
2008-09-04 04:00:00	ES	Futures	1183.69	1184.39	1180.21	1180.44	12250.0
2008-09-04 05:00:00	ES	Futures	1180.44	1181.13	1178.81	1180.21	12238.0
2008-09-04 06:00:00	ES	Futures	1180.21	1183.69	1179.28	1183.23	9984.0
2008-09-04 07:00:00	ES	Futures	1183.23	1183.46	1180.44	1182.53	20755.0
2008-09-04 08:00:00	ES	Futures	1182.53	1182.99	1177.65	1179.51	56552.0
2008-09-04 09:00:00	ES	Futures	1179.51	1179.97	1172.77	1175.09	256794.0
2008-09-04 10:00:00	ES	Futures	1175.09	1179.04	1163.47	1165.8	557441.0
2008-09-04 11:00:00	ES	Futures	1165.56	1166.96	1159.99	1161.61	384455.0
2008-09-04 12:00:00	ES	Futures	1161.61	1164.4	1158.36	1159.29	191637.0
2008-09-04 13:00:00	ES	Futures	1159.29	1159.99	1153.94	1156.73	271611.0
2008-09-04 14:00:00	ES	Futures	1156.73	1156.73	1149.53	1154.17	341369.0
2008-09-04 15:00:00	ES	Futures	1154.41	1158.13	1148.6	1149.76	529132.0
2008-09-04 16:00:00	ES	Futures	1149.76	1150.46	1148.13	1150.22	136554.0
2008-09-04 17:00:00	ES	Futures	1150.22	1150.69	1148.6	1149.06	2945.0
2008-09-04 18:00:00	ES	Futures	1148.83	1149.06	1139.76	1142.09	20239.0
2008-09-04 19:00:00	ES	Futures	1142.09	1145.11	1142.09	1144.41	5435.0
2008-09-04 20:00:00	ES	Futures	1144.18	1144.65	1143.02	1143.95	3290.0
2008-09-04 21:00:00	ES	Futures	1143.95	1146.74	1143.95	1145.58	4163.0
2008-09-04 22:00:00	ES	Futures	1145.81	1147.43	1145.81	1146.04	2096.0
2008-09-04 23:00:00	ES	Futures	1146.04	1147.67	1145.34	1146.04	1713.0
2008-09-04 00:00:00	NQ	Futures	2061.57	2063.25	2061.28	2061.28	59.0
2008-09-04 01:00:00	NQ	Futures	2061.28	2062.41	2060.16	2060.72	77.0
2008-09-04 02:00:00	NQ	Futures	2061.28	2062.69	2059.03	2060.44	251.0
2008-09-04 03:00:00	NQ	Futures	2061.28	2065.78	2058.19	2059.88	2062.0
2008-09-04 04:00:00	NQ	Futures	2060.44	2062.13	2053.69	2053.69	1218.0
2008-09-04 05:00:00	NQ	Futures	2053.69	2055.94	2052.56	2053.69	1295.0
2008-09-04 06:00:00	NQ	Futures	2053.69	2057.63	2051.72	2056.5	1942.0
2008-09-04 07:00:00	NQ	Futures	2056.22	2058.19	2052.0	2056.5	1660.0
2008-09-04 08:00:00	NQ	Futures	2056.78	2057.06	2048.91	2051.72	9367.0
2008-09-04 09:00:00	NQ	Futures	2051.44	2053.13	2042.16	2044.97	52280.0
2008-09-04 10:00:00	NQ	Futures	2044.97	2055.38	2029.22	2034.0	97750.0
2008-09-04 11:00:00	NQ	Futures	2034.0	2038.5	2025.28	2032.03	64019.0
2008-09-04 12:00:00	NQ	Futures	2031.75	2041.88	2022.19	2026.12	48108.0
2008-09-04 13:00:00	NQ	Futures	2026.12	2027.81	2011.5	2015.15	54461.0
2008-09-04 14:00:00	NQ	Futures	2014.87	2014.87	2003.9	2009.81	54330.0
2008-09-04 15:00:00	NQ	Futures	2009.81	2017.4	1997.99	1998.56	78296.0
2008-09-04 16:00:00	NQ	Futures	1998.28	2000.53	1995.74	1997.99	21905.0
2008-09-04 17:00:00	NQ	Futures	1998.28	1998.56	1994.9	1995.46	577.0
2008-09-04 18:00:00	NQ	Futures	1995.46	1996.31	1980.55	1986.18	1810.0
2008-09-04 19:00:00	NQ	Futures	1986.46	1989.27	1986.46	1988.71	323.0
2008-09-04 20:00:00	NQ	Futures	1988.15	1988.15	1986.18	1988.15	227.0
2008-09-04 21:00:00	NQ	Futures	1988.15	1992.09	1987.59	1990.12	160.0
2008-09-04 22:00:00	NQ	Futures	1991.81	1993.21	1990.68	1991.52	224.0
2008-09-04 23:00:00	NQ	Futures	1991.24	1993.77	1989.56	1989.84	98.0
2008-09-04 00:00:00	YM	Futures	10483.0	10489.3	10479.3	10483.0	89.0
2008-09-04 01:00:00	YM	Futures	10481.1	10489.3	10478.4	10483.0	71.0

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

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