PREVIEW / futures_1hour / 2008-08-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1194.38	1195.78	1194.15	1195.08	1493.0
2008-08-06 01:00:00	ES	Futures	1195.31	1195.54	1194.61	1195.08	922.0
2008-08-06 02:00:00	ES	Futures	1195.08	1195.08	1192.99	1193.22	5663.0
2008-08-06 03:00:00	ES	Futures	1192.99	1193.45	1190.9	1191.83	18308.0
2008-08-06 04:00:00	ES	Futures	1191.83	1193.45	1190.66	1192.76	13462.0
2008-08-06 05:00:00	ES	Futures	1192.76	1193.69	1190.2	1190.43	12407.0
2008-08-06 06:00:00	ES	Futures	1190.43	1190.9	1187.87	1189.5	23078.0
2008-08-06 07:00:00	ES	Futures	1189.73	1190.43	1188.57	1189.04	13665.0
2008-08-06 08:00:00	ES	Futures	1189.27	1191.36	1188.57	1189.97	25303.0
2008-08-06 09:00:00	ES	Futures	1189.97	1191.13	1186.71	1189.5	210101.0
2008-08-06 10:00:00	ES	Futures	1189.5	1190.66	1185.55	1186.95	309421.0
2008-08-06 11:00:00	ES	Futures	1186.95	1192.99	1185.78	1191.59	249359.0
2008-08-06 12:00:00	ES	Futures	1191.36	1195.31	1190.9	1192.52	184480.0
2008-08-06 13:00:00	ES	Futures	1192.52	1194.61	1190.9	1192.99	117483.0
2008-08-06 14:00:00	ES	Futures	1192.99	1200.89	1192.06	1199.73	238870.0
2008-08-06 15:00:00	ES	Futures	1199.5	1200.66	1195.78	1198.33	215778.0
2008-08-06 16:00:00	ES	Futures	1198.57	1198.8	1196.24	1196.94	67335.0
2008-08-06 17:00:00	ES	Futures	1196.71	1197.17	1193.22	1194.15	6713.0
2008-08-06 18:00:00	ES	Futures	1194.15	1194.61	1192.99	1193.45	3749.0
2008-08-06 19:00:00	ES	Futures	1193.45	1194.61	1192.76	1192.99	2337.0
2008-08-06 20:00:00	ES	Futures	1192.99	1192.99	1192.06	1192.29	3112.0
2008-08-06 21:00:00	ES	Futures	1192.29	1193.22	1191.83	1192.29	1547.0
2008-08-06 22:00:00	ES	Futures	1192.29	1192.52	1191.36	1191.59	2381.0
2008-08-06 23:00:00	ES	Futures	1191.83	1191.83	1190.9	1191.13	1807.0
2008-08-06 00:00:00	NQ	Futures	2115.29	2116.14	2114.17	2116.14	420.0
2008-08-06 01:00:00	NQ	Futures	2116.14	2116.14	2115.01	2115.01	244.0
2008-08-06 02:00:00	NQ	Futures	2115.01	2115.01	2111.07	2111.07	1332.0
2008-08-06 03:00:00	NQ	Futures	2111.07	2111.35	2106.01	2108.54	2070.0
2008-08-06 04:00:00	NQ	Futures	2109.1	2111.35	2106.85	2110.51	2011.0
2008-08-06 05:00:00	NQ	Futures	2110.79	2112.48	2107.98	2108.26	1851.0
2008-08-06 06:00:00	NQ	Futures	2108.26	2108.82	2103.48	2107.13	2493.0
2008-08-06 07:00:00	NQ	Futures	2107.42	2109.38	2106.01	2106.57	2055.0
2008-08-06 08:00:00	NQ	Futures	2106.57	2111.35	2105.45	2107.13	4626.0
2008-08-06 09:00:00	NQ	Futures	2106.85	2107.42	2093.63	2100.66	52337.0
2008-08-06 10:00:00	NQ	Futures	2100.95	2102.92	2088.29	2093.35	69987.0
2008-08-06 11:00:00	NQ	Futures	2093.07	2118.67	2089.13	2118.1	65225.0
2008-08-06 12:00:00	NQ	Futures	2117.82	2127.67	2116.14	2118.95	46232.0
2008-08-06 13:00:00	NQ	Futures	2119.23	2130.48	2116.98	2123.45	31691.0
2008-08-06 14:00:00	NQ	Futures	2123.73	2145.39	2121.76	2140.33	62413.0
2008-08-06 15:00:00	NQ	Futures	2140.33	2143.42	2132.17	2136.39	53349.0
2008-08-06 16:00:00	NQ	Futures	2136.67	2137.51	2132.73	2134.14	10651.0
2008-08-06 17:00:00	NQ	Futures	2133.86	2134.42	2128.51	2130.2	605.0
2008-08-06 18:00:00	NQ	Futures	2130.2	2131.33	2127.95	2129.36	608.0
2008-08-06 19:00:00	NQ	Futures	2129.07	2129.64	2127.67	2127.95	213.0
2008-08-06 20:00:00	NQ	Futures	2127.67	2127.95	2124.57	2125.7	223.0
2008-08-06 21:00:00	NQ	Futures	2125.98	2127.67	2125.98	2125.98	239.0
2008-08-06 22:00:00	NQ	Futures	2125.98	2126.82	2124.86	2125.14	296.0
2008-08-06 23:00:00	NQ	Futures	2125.42	2125.42	2123.45	2123.45	225.0
2008-08-06 00:00:00	YM	Futures	10536.6	10552.9	10534.8	10541.1	339.0
2008-08-06 01:00:00	YM	Futures	10542.0	10547.5	10538.4	10543.8	218.0

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

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