PREVIEW / futures_1hour / 2008-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-26.parquet
  size:    44 KB
  rows:    1,229

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-06-26 00:00:00	ES	Futures	1226.69	1227.39	1225.76	1226.92	1039.0
2008-06-26 01:00:00	ES	Futures	1226.92	1227.39	1224.6	1225.29	2095.0
2008-06-26 02:00:00	ES	Futures	1225.06	1225.76	1224.13	1225.06	5270.0
2008-06-26 03:00:00	ES	Futures	1225.06	1225.99	1222.74	1225.53	14204.0
2008-06-26 04:00:00	ES	Futures	1225.29	1225.76	1222.5	1223.2	11709.0
2008-06-26 05:00:00	ES	Futures	1223.43	1223.9	1220.88	1222.04	15336.0
2008-06-26 06:00:00	ES	Futures	1222.04	1224.83	1221.58	1223.9	14940.0
2008-06-26 07:00:00	ES	Futures	1224.13	1225.29	1216.23	1217.62	57763.0
2008-06-26 08:00:00	ES	Futures	1217.86	1218.55	1214.37	1216.23	77503.0
2008-06-26 09:00:00	ES	Futures	1216.0	1217.62	1212.98	1215.76	256028.0
2008-06-26 10:00:00	ES	Futures	1215.76	1218.09	1206.47	1206.7	490834.0
2008-06-26 11:00:00	ES	Futures	1206.7	1210.19	1205.07	1209.02	327007.0
2008-06-26 12:00:00	ES	Futures	1209.02	1209.02	1201.59	1203.68	266539.0
2008-06-26 13:00:00	ES	Futures	1203.45	1206.0	1200.43	1204.84	187125.0
2008-06-26 14:00:00	ES	Futures	1204.84	1206.93	1196.71	1197.64	319510.0
2008-06-26 15:00:00	ES	Futures	1197.64	1202.28	1193.69	1194.15	428053.0
2008-06-26 16:00:00	ES	Futures	1194.15	1195.78	1192.76	1194.38	145225.0
2008-06-26 17:00:00	ES	Futures	1194.38	1196.01	1194.15	1195.08	4735.0
2008-06-26 18:00:00	ES	Futures	1195.31	1196.01	1195.08	1195.54	3570.0
2008-06-26 19:00:00	ES	Futures	1195.54	1195.78	1194.38	1194.38	1053.0
2008-06-26 20:00:00	ES	Futures	1194.38	1195.54	1193.92	1194.85	1888.0
2008-06-26 21:00:00	ES	Futures	1194.61	1196.47	1194.61	1196.47	2237.0
2008-06-26 22:00:00	ES	Futures	1196.47	1197.4	1196.01	1196.24	2191.0
2008-06-26 23:00:00	ES	Futures	1196.01	1197.17	1196.01	1196.71	668.0
2008-06-26 00:00:00	NQ	Futures	2165.92	2167.61	2165.64	2167.61	171.0
2008-06-26 01:00:00	NQ	Futures	2167.33	2167.33	2163.11	2164.24	126.0
2008-06-26 02:00:00	NQ	Futures	2165.08	2167.05	2162.83	2165.08	286.0
2008-06-26 03:00:00	NQ	Futures	2165.36	2167.33	2161.7	2166.77	1016.0
2008-06-26 04:00:00	NQ	Futures	2166.49	2169.58	2163.95	2165.08	2058.0
2008-06-26 05:00:00	NQ	Futures	2165.08	2165.64	2160.58	2162.55	950.0
2008-06-26 06:00:00	NQ	Futures	2161.99	2164.24	2158.33	2160.58	2010.0
2008-06-26 07:00:00	NQ	Futures	2160.58	2162.83	2145.67	2148.77	3596.0
2008-06-26 08:00:00	NQ	Futures	2149.33	2150.17	2140.05	2141.17	10734.0
2008-06-26 09:00:00	NQ	Futures	2141.73	2147.36	2131.61	2136.39	55473.0
2008-06-26 10:00:00	NQ	Futures	2136.67	2141.73	2115.01	2117.54	89558.0
2008-06-26 11:00:00	NQ	Futures	2117.82	2125.14	2114.73	2121.48	50809.0
2008-06-26 12:00:00	NQ	Futures	2121.48	2121.76	2112.2	2117.82	50272.0
2008-06-26 13:00:00	NQ	Futures	2117.82	2120.92	2106.01	2113.6	48556.0
2008-06-26 14:00:00	NQ	Futures	2113.89	2118.95	2098.7	2102.07	67422.0
2008-06-26 15:00:00	NQ	Futures	2102.35	2115.57	2095.88	2096.45	85278.0
2008-06-26 16:00:00	NQ	Futures	2097.01	2106.01	2095.6	2101.79	19455.0
2008-06-26 17:00:00	NQ	Futures	2101.79	2103.48	2099.82	2101.23	372.0
2008-06-26 18:00:00	NQ	Futures	2101.23	2103.2	2099.54	2101.23	363.0
2008-06-26 19:00:00	NQ	Futures	2101.51	2102.07	2100.66	2100.66	85.0
2008-06-26 20:00:00	NQ	Futures	2101.23	2102.35	2098.41	2099.54	230.0
2008-06-26 21:00:00	NQ	Futures	2101.23	2103.76	2100.66	2103.48	114.0
2008-06-26 22:00:00	NQ	Futures	2103.2	2106.01	2102.63	2104.32	140.0
2008-06-26 23:00:00	NQ	Futures	2104.04	2104.88	2104.04	2104.6	14.0
2008-06-26 00:00:00	YM	Futures	10718.4	10722.9	10715.6	10720.2	111.0
2008-06-26 01:00:00	YM	Futures	10720.2	10722.9	10700.2	10702.9	293.0

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

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