PREVIEW / futures_1hour / 2008-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-27.parquet
  size:    37 KB
  rows:    1,026

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-27 00:00:00	ES	Futures	1196.71	1197.87	1196.24	1197.17	1314.0
2008-06-27 01:00:00	ES	Futures	1197.4	1198.8	1196.94	1198.8	3288.0
2008-06-27 02:00:00	ES	Futures	1198.8	1199.96	1198.33	1199.5	7436.0
2008-06-27 03:00:00	ES	Futures	1199.5	1200.89	1193.92	1195.31	37379.0
2008-06-27 04:00:00	ES	Futures	1195.08	1199.03	1194.61	1197.4	18739.0
2008-06-27 05:00:00	ES	Futures	1197.4	1197.4	1192.99	1196.24	17589.0
2008-06-27 06:00:00	ES	Futures	1196.47	1197.4	1194.85	1195.54	8493.0
2008-06-27 07:00:00	ES	Futures	1195.54	1195.54	1188.11	1190.66	51825.0
2008-06-27 08:00:00	ES	Futures	1190.66	1196.47	1189.5	1195.78	67977.0
2008-06-27 09:00:00	ES	Futures	1195.54	1197.64	1190.2	1196.24	265291.0
2008-06-27 10:00:00	ES	Futures	1196.24	1200.19	1190.66	1191.59	413768.0
2008-06-27 11:00:00	ES	Futures	1191.59	1194.61	1189.04	1192.76	214340.0
2008-06-27 12:00:00	ES	Futures	1192.76	1196.24	1189.97	1191.36	164697.0
2008-06-27 13:00:00	ES	Futures	1191.13	1191.83	1183.23	1186.48	328450.0
2008-06-27 14:00:00	ES	Futures	1186.25	1194.85	1186.02	1193.69	316903.0
2008-06-27 15:00:00	ES	Futures	1193.69	1194.38	1187.41	1190.66	294973.0
2008-06-27 16:00:00	ES	Futures	1190.66	1192.06	1189.5	1190.2	101383.0
2008-06-27 00:00:00	NQ	Futures	2104.6	2106.57	2103.76	2104.6	72.0
2008-06-27 01:00:00	NQ	Futures	2106.85	2107.98	2105.17	2107.98	188.0
2008-06-27 02:00:00	NQ	Futures	2108.26	2110.79	2107.13	2109.67	379.0
2008-06-27 03:00:00	NQ	Futures	2109.38	2112.76	2100.1	2101.79	2648.0
2008-06-27 04:00:00	NQ	Futures	2101.23	2107.98	2099.82	2105.73	1938.0
2008-06-27 05:00:00	NQ	Futures	2105.73	2105.73	2096.45	2104.04	1530.0
2008-06-27 06:00:00	NQ	Futures	2104.32	2104.88	2100.38	2100.95	685.0
2008-06-27 07:00:00	NQ	Futures	2101.23	2101.23	2085.19	2091.66	5877.0
2008-06-27 08:00:00	NQ	Futures	2091.94	2098.41	2088.85	2097.29	8846.0
2008-06-27 09:00:00	NQ	Futures	2097.01	2100.66	2080.13	2096.73	60915.0
2008-06-27 10:00:00	NQ	Futures	2096.73	2108.82	2079.85	2085.48	71571.0
2008-06-27 11:00:00	NQ	Futures	2085.76	2092.79	2078.72	2089.41	40192.0
2008-06-27 12:00:00	NQ	Futures	2089.69	2097.85	2082.38	2086.04	35343.0
2008-06-27 13:00:00	NQ	Futures	2086.04	2086.88	2065.78	2072.25	60748.0
2008-06-27 14:00:00	NQ	Futures	2072.25	2100.66	2071.41	2100.66	63905.0
2008-06-27 15:00:00	NQ	Futures	2100.66	2104.32	2088.01	2097.85	61249.0
2008-06-27 16:00:00	NQ	Futures	2097.85	2104.32	2095.6	2098.98	15701.0
2008-06-27 00:00:00	YM	Futures	10439.3	10446.6	10434.8	10439.3	115.0
2008-06-27 01:00:00	YM	Futures	10443.0	10450.2	10440.2	10449.3	338.0
2008-06-27 02:00:00	YM	Futures	10450.2	10457.5	10444.8	10452.1	563.0
2008-06-27 03:00:00	YM	Futures	10450.2	10463.0	10408.4	10418.4	3036.0
2008-06-27 04:00:00	YM	Futures	10417.5	10443.9	10413.0	10432.1	1465.0
2008-06-27 05:00:00	YM	Futures	10432.1	10434.8	10397.5	10429.3	1697.0
2008-06-27 06:00:00	YM	Futures	10430.2	10433.9	10414.8	10420.2	934.0
2008-06-27 07:00:00	YM	Futures	10419.3	10419.3	10359.3	10381.2	2890.0
2008-06-27 08:00:00	YM	Futures	10381.2	10424.8	10371.2	10421.2	4497.0
2008-06-27 09:00:00	YM	Futures	10420.2	10429.3	10357.5	10396.6	24993.0
2008-06-27 10:00:00	YM	Futures	10395.7	10426.6	10334.8	10341.2	38703.0
2008-06-27 11:00:00	YM	Futures	10342.1	10366.6	10318.4	10354.8	21654.0
2008-06-27 12:00:00	YM	Futures	10354.8	10378.4	10321.2	10334.8	18071.0
2008-06-27 13:00:00	YM	Futures	10333.9	10339.4	10255.7	10284.8	34600.0
2008-06-27 14:00:00	YM	Futures	10284.8	10355.7	10280.3	10344.8	32203.0
2008-06-27 15:00:00	YM	Futures	10345.7	10353.9	10294.8	10316.6	25887.0

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

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