PREVIEW / futures_1hour / 2008-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-27.parquet
  size:    42 KB
  rows:    1,203

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-08-27 00:00:00	ES	Futures	1182.53	1184.39	1181.83	1183.46	1085.0
2008-08-27 01:00:00	ES	Futures	1183.69	1184.16	1182.99	1183.69	769.0
2008-08-27 02:00:00	ES	Futures	1183.46	1184.62	1182.3	1182.53	4223.0
2008-08-27 03:00:00	ES	Futures	1182.53	1182.76	1180.67	1181.83	9390.0
2008-08-27 04:00:00	ES	Futures	1181.6	1181.83	1178.58	1179.04	8442.0
2008-08-27 05:00:00	ES	Futures	1178.81	1179.51	1176.49	1178.11	14399.0
2008-08-27 06:00:00	ES	Futures	1178.11	1179.04	1176.95	1178.35	8921.0
2008-08-27 07:00:00	ES	Futures	1178.11	1180.67	1177.65	1179.74	16181.0
2008-08-27 08:00:00	ES	Futures	1179.51	1186.71	1178.11	1184.85	72416.0
2008-08-27 09:00:00	ES	Futures	1184.85	1185.09	1180.21	1181.83	154895.0
2008-08-27 10:00:00	ES	Futures	1181.6	1189.73	1181.13	1187.64	258781.0
2008-08-27 11:00:00	ES	Futures	1187.41	1187.64	1183.69	1186.25	139006.0
2008-08-27 12:00:00	ES	Futures	1186.25	1194.85	1184.85	1193.69	232890.0
2008-08-27 13:00:00	ES	Futures	1193.69	1193.92	1190.66	1191.13	85031.0
2008-08-27 14:00:00	ES	Futures	1191.36	1194.61	1189.73	1191.36	99955.0
2008-08-27 15:00:00	ES	Futures	1191.36	1192.99	1186.48	1191.13	220868.0
2008-08-27 16:00:00	ES	Futures	1190.9	1192.76	1188.8	1190.9	89144.0
2008-08-27 17:00:00	ES	Futures	1190.66	1191.36	1190.43	1190.9	3404.0
2008-08-27 18:00:00	ES	Futures	1191.13	1192.06	1190.43	1191.36	2711.0
2008-08-27 19:00:00	ES	Futures	1191.13	1191.36	1190.43	1190.66	591.0
2008-08-27 20:00:00	ES	Futures	1190.43	1190.9	1190.2	1190.66	885.0
2008-08-27 21:00:00	ES	Futures	1190.66	1190.9	1189.73	1190.2	1768.0
2008-08-27 22:00:00	ES	Futures	1190.2	1190.2	1189.5	1189.73	759.0
2008-08-27 23:00:00	ES	Futures	1189.97	1190.2	1189.5	1189.73	289.0
2008-08-27 00:00:00	NQ	Futures	2129.07	2131.89	2127.67	2129.36	152.0
2008-08-27 01:00:00	NQ	Futures	2131.33	2131.89	2129.36	2130.48	34.0
2008-08-27 02:00:00	NQ	Futures	2131.04	2132.17	2128.23	2129.07	341.0
2008-08-27 03:00:00	NQ	Futures	2128.51	2129.36	2125.98	2127.11	831.0
2008-08-27 04:00:00	NQ	Futures	2127.11	2127.39	2121.76	2122.32	829.0
2008-08-27 05:00:00	NQ	Futures	2122.04	2122.61	2117.54	2120.35	816.0
2008-08-27 06:00:00	NQ	Futures	2120.92	2121.76	2118.67	2120.92	548.0
2008-08-27 07:00:00	NQ	Futures	2120.64	2125.14	2120.07	2123.17	1305.0
2008-08-27 08:00:00	NQ	Futures	2123.73	2133.86	2121.48	2130.2	7812.0
2008-08-27 09:00:00	NQ	Futures	2130.2	2132.17	2119.23	2123.73	28790.0
2008-08-27 10:00:00	NQ	Futures	2123.45	2138.36	2122.32	2133.01	51904.0
2008-08-27 11:00:00	NQ	Futures	2133.01	2134.42	2126.26	2131.04	25740.0
2008-08-27 12:00:00	NQ	Futures	2131.04	2154.11	2129.36	2152.7	53730.0
2008-08-27 13:00:00	NQ	Futures	2152.7	2153.27	2145.95	2147.92	32740.0
2008-08-27 14:00:00	NQ	Futures	2147.92	2156.36	2145.95	2147.92	30580.0
2008-08-27 15:00:00	NQ	Futures	2147.92	2150.17	2132.73	2140.61	49429.0
2008-08-27 16:00:00	NQ	Futures	2140.61	2141.17	2133.01	2137.23	11489.0
2008-08-27 17:00:00	NQ	Futures	2137.51	2138.64	2137.23	2137.23	74.0
2008-08-27 18:00:00	NQ	Futures	2137.23	2138.92	2137.23	2138.36	101.0
2008-08-27 19:00:00	NQ	Futures	2138.08	2138.92	2137.79	2137.79	55.0
2008-08-27 20:00:00	NQ	Futures	2137.79	2138.36	2137.51	2137.79	64.0
2008-08-27 21:00:00	NQ	Futures	2137.79	2137.79	2136.39	2136.67	102.0
2008-08-27 22:00:00	NQ	Futures	2136.67	2136.95	2135.54	2136.67	65.0
2008-08-27 23:00:00	NQ	Futures	2136.39	2137.23	2136.11	2136.95	48.0
2008-08-27 00:00:00	YM	Futures	10373.0	10385.7	10371.2	10375.7	121.0
2008-08-27 01:00:00	YM	Futures	10380.3	10383.9	10377.5	10379.3	102.0

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

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