PREVIEW / futures_1hour / 2008-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-31.parquet
  size:    42 KB
  rows:    1,224

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-07-31 00:00:00	ES	Futures	1191.83	1192.76	1191.59	1192.06	801.0
2008-07-31 01:00:00	ES	Futures	1192.29	1193.69	1192.06	1193.45	1251.0
2008-07-31 02:00:00	ES	Futures	1193.45	1194.38	1191.59	1194.15	6253.0
2008-07-31 03:00:00	ES	Futures	1194.15	1194.61	1190.43	1190.9	21818.0
2008-07-31 04:00:00	ES	Futures	1190.66	1193.22	1190.43	1192.52	7402.0
2008-07-31 05:00:00	ES	Futures	1192.52	1193.22	1190.9	1191.59	7368.0
2008-07-31 06:00:00	ES	Futures	1191.59	1194.61	1191.59	1193.92	6763.0
2008-07-31 07:00:00	ES	Futures	1193.69	1197.17	1193.69	1196.47	29257.0
2008-07-31 08:00:00	ES	Futures	1196.71	1199.26	1184.85	1185.09	196997.0
2008-07-31 09:00:00	ES	Futures	1185.09	1191.59	1181.83	1189.5	364325.0
2008-07-31 10:00:00	ES	Futures	1189.27	1194.38	1186.48	1193.92	379157.0
2008-07-31 11:00:00	ES	Futures	1193.92	1194.38	1185.32	1187.18	227999.0
2008-07-31 12:00:00	ES	Futures	1186.95	1187.64	1181.37	1184.85	176076.0
2008-07-31 13:00:00	ES	Futures	1184.85	1189.04	1184.62	1185.32	129168.0
2008-07-31 14:00:00	ES	Futures	1185.32	1192.06	1184.85	1189.27	195580.0
2008-07-31 15:00:00	ES	Futures	1189.27	1191.13	1176.02	1177.65	433764.0
2008-07-31 16:00:00	ES	Futures	1177.65	1178.81	1176.72	1178.11	127299.0
2008-07-31 17:00:00	ES	Futures	1178.11	1178.58	1177.65	1177.88	845.0
2008-07-31 18:00:00	ES	Futures	1177.88	1178.58	1176.72	1178.35	3603.0
2008-07-31 19:00:00	ES	Futures	1178.35	1178.58	1178.11	1178.35	674.0
2008-07-31 20:00:00	ES	Futures	1178.35	1178.35	1176.49	1176.72	2165.0
2008-07-31 21:00:00	ES	Futures	1176.72	1177.65	1176.49	1177.18	893.0
2008-07-31 22:00:00	ES	Futures	1177.18	1177.42	1176.02	1176.95	2145.0
2008-07-31 23:00:00	ES	Futures	1176.95	1177.18	1175.56	1175.79	1376.0
2008-07-31 00:00:00	NQ	Futures	2084.91	2085.48	2083.51	2083.79	68.0
2008-07-31 01:00:00	NQ	Futures	2085.19	2086.88	2085.19	2086.04	92.0
2008-07-31 02:00:00	NQ	Futures	2086.04	2091.38	2083.79	2090.26	554.0
2008-07-31 03:00:00	NQ	Futures	2090.26	2091.1	2082.94	2083.51	1308.0
2008-07-31 04:00:00	NQ	Futures	2082.94	2087.16	2082.66	2086.6	466.0
2008-07-31 05:00:00	NQ	Futures	2086.6	2088.57	2083.79	2085.76	664.0
2008-07-31 06:00:00	NQ	Futures	2086.04	2091.38	2086.04	2090.54	717.0
2008-07-31 07:00:00	NQ	Futures	2090.26	2096.73	2090.26	2095.04	1460.0
2008-07-31 08:00:00	NQ	Futures	2095.6	2099.54	2069.72	2070.85	16419.0
2008-07-31 09:00:00	NQ	Futures	2070.57	2102.35	2061.85	2097.29	80906.0
2008-07-31 10:00:00	NQ	Futures	2097.57	2113.89	2091.66	2110.23	97181.0
2008-07-31 11:00:00	NQ	Futures	2110.23	2111.35	2095.04	2100.1	48801.0
2008-07-31 12:00:00	NQ	Futures	2099.82	2103.48	2086.04	2098.13	46216.0
2008-07-31 13:00:00	NQ	Futures	2098.41	2107.7	2097.85	2100.66	32316.0
2008-07-31 14:00:00	NQ	Futures	2100.66	2111.35	2099.82	2104.6	40709.0
2008-07-31 15:00:00	NQ	Futures	2105.17	2109.1	2081.54	2082.94	66883.0
2008-07-31 16:00:00	NQ	Futures	2082.66	2088.29	2081.82	2087.73	12166.0
2008-07-31 17:00:00	NQ	Futures	2087.73	2088.01	2086.04	2086.04	179.0
2008-07-31 18:00:00	NQ	Futures	2086.32	2086.32	2083.22	2084.35	408.0
2008-07-31 19:00:00	NQ	Futures	2084.91	2084.91	2084.07	2084.35	237.0
2008-07-31 20:00:00	NQ	Futures	2084.35	2084.91	2079.85	2080.13	372.0
2008-07-31 21:00:00	NQ	Futures	2080.41	2081.54	2080.13	2081.26	132.0
2008-07-31 22:00:00	NQ	Futures	2081.26	2081.26	2078.44	2080.69	170.0
2008-07-31 23:00:00	NQ	Futures	2080.41	2080.41	2077.32	2077.88	80.0
2008-07-31 00:00:00	YM	Futures	10496.6	10502.0	10493.0	10493.9	106.0
2008-07-31 01:00:00	YM	Futures	10501.1	10512.0	10497.5	10512.0	160.0

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

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