PREVIEW / futures_1hour / 2008-08-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1179.04	1180.21	1178.81	1179.51	740.0
2008-08-26 01:00:00	ES	Futures	1179.28	1180.21	1179.04	1179.97	710.0
2008-08-26 02:00:00	ES	Futures	1180.21	1180.21	1177.88	1179.04	3248.0
2008-08-26 03:00:00	ES	Futures	1179.04	1181.6	1177.65	1177.65	14611.0
2008-08-26 04:00:00	ES	Futures	1177.88	1177.88	1174.63	1177.88	18211.0
2008-08-26 05:00:00	ES	Futures	1177.65	1181.37	1176.02	1179.51	11166.0
2008-08-26 06:00:00	ES	Futures	1179.51	1180.9	1177.65	1180.44	9228.0
2008-08-26 07:00:00	ES	Futures	1180.44	1181.37	1176.95	1177.42	20169.0
2008-08-26 08:00:00	ES	Futures	1177.42	1178.81	1173.7	1178.58	42747.0
2008-08-26 09:00:00	ES	Futures	1178.58	1180.9	1174.39	1179.28	209827.0
2008-08-26 10:00:00	ES	Futures	1179.28	1186.02	1178.81	1184.39	272393.0
2008-08-26 11:00:00	ES	Futures	1184.39	1184.85	1178.11	1180.44	149954.0
2008-08-26 12:00:00	ES	Futures	1180.67	1182.53	1179.28	1179.74	105359.0
2008-08-26 13:00:00	ES	Futures	1179.74	1180.21	1176.25	1178.35	108567.0
2008-08-26 14:00:00	ES	Futures	1178.11	1179.51	1173.7	1175.09	195754.0
2008-08-26 15:00:00	ES	Futures	1175.09	1182.3	1174.16	1182.06	188839.0
2008-08-26 16:00:00	ES	Futures	1182.06	1182.53	1180.9	1182.06	61433.0
2008-08-26 17:00:00	ES	Futures	1182.3	1182.53	1181.83	1182.06	664.0
2008-08-26 18:00:00	ES	Futures	1181.6	1182.53	1181.6	1182.06	1071.0
2008-08-26 19:00:00	ES	Futures	1182.06	1182.3	1181.83	1181.83	508.0
2008-08-26 20:00:00	ES	Futures	1181.83	1182.06	1180.21	1180.44	1645.0
2008-08-26 21:00:00	ES	Futures	1180.44	1181.83	1179.51	1181.6	1510.0
2008-08-26 22:00:00	ES	Futures	1181.6	1183.69	1181.6	1183.46	2344.0
2008-08-26 23:00:00	ES	Futures	1183.23	1183.46	1182.06	1182.3	872.0
2008-08-26 00:00:00	NQ	Futures	2135.54	2136.67	2135.26	2136.67	49.0
2008-08-26 01:00:00	NQ	Futures	2135.54	2137.51	2134.98	2137.23	137.0
2008-08-26 02:00:00	NQ	Futures	2136.39	2137.51	2133.29	2134.7	253.0
2008-08-26 03:00:00	NQ	Futures	2134.42	2138.64	2131.89	2132.17	1554.0
2008-08-26 04:00:00	NQ	Futures	2132.17	2133.86	2128.51	2133.86	1995.0
2008-08-26 05:00:00	NQ	Futures	2133.58	2139.2	2130.2	2136.11	971.0
2008-08-26 06:00:00	NQ	Futures	2136.11	2138.08	2133.29	2136.11	1220.0
2008-08-26 07:00:00	NQ	Futures	2136.11	2138.64	2131.04	2132.17	2138.0
2008-08-26 08:00:00	NQ	Futures	2132.45	2133.29	2125.7	2132.73	5678.0
2008-08-26 09:00:00	NQ	Futures	2133.01	2136.95	2125.14	2131.33	39104.0
2008-08-26 10:00:00	NQ	Futures	2131.61	2142.01	2127.67	2138.92	48609.0
2008-08-26 11:00:00	NQ	Futures	2138.92	2140.33	2127.67	2131.04	29107.0
2008-08-26 12:00:00	NQ	Futures	2130.76	2136.39	2126.82	2127.95	21622.0
2008-08-26 13:00:00	NQ	Futures	2127.95	2129.07	2116.14	2118.95	23921.0
2008-08-26 14:00:00	NQ	Futures	2118.95	2124.57	2111.35	2113.04	40660.0
2008-08-26 15:00:00	NQ	Futures	2113.04	2127.11	2112.76	2125.7	37222.0
2008-08-26 16:00:00	NQ	Futures	2126.26	2128.79	2125.14	2127.95	8035.0
2008-08-26 17:00:00	NQ	Futures	2127.67	2128.51	2127.39	2127.95	131.0
2008-08-26 18:00:00	NQ	Futures	2127.39	2128.23	2127.11	2127.11	35.0
2008-08-26 19:00:00	NQ	Futures	2127.11	2128.23	2126.82	2126.82	71.0
2008-08-26 20:00:00	NQ	Futures	2127.95	2127.95	2124.29	2124.86	75.0
2008-08-26 21:00:00	NQ	Futures	2124.57	2126.82	2123.45	2126.82	136.0
2008-08-26 22:00:00	NQ	Futures	2127.11	2130.76	2127.11	2129.36	191.0
2008-08-26 23:00:00	NQ	Futures	2129.92	2129.92	2127.39	2129.07	54.0
2008-08-26 00:00:00	YM	Futures	10358.4	10364.8	10353.9	10362.1	92.0
2008-08-26 01:00:00	YM	Futures	10363.0	10366.6	10355.7	10366.6	133.0

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

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