PREVIEW / futures_1hour / 2008-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-30.parquet
  size:    42 KB
  rows:    1,190

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-30 00:00:00	ES	Futures	1192.06	1192.76	1191.59	1191.83	1074.0
2008-06-30 01:00:00	ES	Futures	1191.83	1192.29	1191.59	1192.06	2078.0
2008-06-30 02:00:00	ES	Futures	1192.29	1194.61	1191.59	1193.69	5993.0
2008-06-30 03:00:00	ES	Futures	1193.69	1196.71	1191.13	1192.06	20704.0
2008-06-30 04:00:00	ES	Futures	1192.06	1192.29	1185.78	1187.41	26316.0
2008-06-30 05:00:00	ES	Futures	1187.18	1189.5	1185.55	1189.27	17763.0
2008-06-30 06:00:00	ES	Futures	1189.27	1191.36	1186.95	1189.27	22248.0
2008-06-30 07:00:00	ES	Futures	1189.27	1190.66	1186.25	1186.71	20880.0
2008-06-30 08:00:00	ES	Futures	1186.71	1191.83	1186.25	1191.83	43795.0
2008-06-30 09:00:00	ES	Futures	1191.83	1195.31	1188.34	1188.34	231438.0
2008-06-30 10:00:00	ES	Futures	1188.34	1197.64	1185.55	1197.4	375854.0
2008-06-30 11:00:00	ES	Futures	1197.4	1200.43	1194.85	1197.87	290129.0
2008-06-30 12:00:00	ES	Futures	1198.1	1201.12	1196.47	1197.87	182598.0
2008-06-30 13:00:00	ES	Futures	1197.87	1198.8	1191.13	1193.69	207135.0
2008-06-30 14:00:00	ES	Futures	1193.69	1196.71	1192.29	1194.15	182880.0
2008-06-30 15:00:00	ES	Futures	1194.38	1198.33	1189.27	1190.66	372677.0
2008-06-30 16:00:00	ES	Futures	1190.66	1195.31	1189.04	1194.15	148056.0
2008-06-30 17:00:00	ES	Futures	1193.92	1194.38	1192.99	1193.22	1688.0
2008-06-30 18:00:00	ES	Futures	1193.22	1193.69	1192.06	1193.22	3914.0
2008-06-30 19:00:00	ES	Futures	1193.22	1195.08	1192.76	1194.38	1940.0
2008-06-30 20:00:00	ES	Futures	1194.38	1195.31	1193.69	1195.31	2862.0
2008-06-30 21:00:00	ES	Futures	1195.31	1195.54	1193.92	1195.54	1437.0
2008-06-30 22:00:00	ES	Futures	1195.54	1196.01	1193.92	1193.92	1425.0
2008-06-30 23:00:00	ES	Futures	1194.15	1194.85	1193.22	1194.61	925.0
2008-06-30 00:00:00	NQ	Futures	2100.66	2102.07	2100.1	2100.1	55.0
2008-06-30 01:00:00	NQ	Futures	2100.38	2101.23	2099.82	2100.1	37.0
2008-06-30 02:00:00	NQ	Futures	2100.38	2105.45	2100.38	2103.2	352.0
2008-06-30 03:00:00	NQ	Futures	2103.2	2107.42	2096.73	2098.13	2189.0
2008-06-30 04:00:00	NQ	Futures	2098.13	2098.13	2084.91	2088.01	2532.0
2008-06-30 05:00:00	NQ	Futures	2087.44	2092.79	2085.48	2090.26	2334.0
2008-06-30 06:00:00	NQ	Futures	2090.54	2094.76	2086.6	2090.54	2055.0
2008-06-30 07:00:00	NQ	Futures	2090.26	2094.76	2082.94	2084.63	3165.0
2008-06-30 08:00:00	NQ	Futures	2084.63	2096.45	2083.51	2095.88	6799.0
2008-06-30 09:00:00	NQ	Futures	2096.16	2101.51	2084.07	2084.07	47267.0
2008-06-30 10:00:00	NQ	Futures	2084.07	2097.57	2077.88	2097.29	67426.0
2008-06-30 11:00:00	NQ	Futures	2097.29	2105.45	2091.94	2096.45	46673.0
2008-06-30 12:00:00	NQ	Futures	2096.73	2100.66	2088.85	2090.82	31983.0
2008-06-30 13:00:00	NQ	Futures	2090.82	2094.48	2075.63	2078.72	39176.0
2008-06-30 14:00:00	NQ	Futures	2078.72	2089.41	2077.88	2084.07	35589.0
2008-06-30 15:00:00	NQ	Futures	2084.63	2094.48	2073.1	2073.94	62397.0
2008-06-30 16:00:00	NQ	Futures	2073.66	2082.66	2072.82	2081.26	16958.0
2008-06-30 17:00:00	NQ	Futures	2081.26	2082.1	2080.69	2081.26	119.0
2008-06-30 18:00:00	NQ	Futures	2081.26	2081.54	2079.29	2080.97	275.0
2008-06-30 19:00:00	NQ	Futures	2081.82	2083.79	2079.57	2083.79	182.0
2008-06-30 20:00:00	NQ	Futures	2083.22	2084.35	2081.54	2084.35	235.0
2008-06-30 21:00:00	NQ	Futures	2084.35	2084.91	2082.94	2084.35	147.0
2008-06-30 22:00:00	NQ	Futures	2084.63	2085.19	2082.38	2082.38	114.0
2008-06-30 23:00:00	NQ	Futures	2082.66	2084.63	2082.1	2082.66	88.0
2008-06-30 00:00:00	YM	Futures	10334.8	10337.5	10329.4	10332.1	51.0
2008-06-30 01:00:00	YM	Futures	10334.8	10336.6	10328.4	10330.3	159.0

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

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