PREVIEW / futures_1hour / 2008-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-07.parquet
  size:    43 KB
  rows:    1,238

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-05-07 00:00:00	ES	Futures	1320.46	1321.39	1318.36	1319.06	4056.0
2008-05-07 01:00:00	ES	Futures	1319.06	1319.06	1317.9	1318.83	2428.0
2008-05-07 02:00:00	ES	Futures	1318.83	1320.69	1318.36	1319.06	5441.0
2008-05-07 03:00:00	ES	Futures	1319.06	1319.99	1317.2	1317.9	14280.0
2008-05-07 04:00:00	ES	Futures	1317.9	1319.76	1316.73	1319.53	12197.0
2008-05-07 05:00:00	ES	Futures	1319.53	1321.85	1318.83	1321.62	11281.0
2008-05-07 06:00:00	ES	Futures	1321.62	1322.32	1320.69	1321.39	8380.0
2008-05-07 07:00:00	ES	Futures	1321.62	1322.32	1319.29	1319.76	14331.0
2008-05-07 08:00:00	ES	Futures	1319.76	1323.95	1319.53	1322.55	54382.0
2008-05-07 09:00:00	ES	Futures	1322.32	1323.02	1318.59	1319.53	146199.0
2008-05-07 10:00:00	ES	Futures	1319.53	1323.02	1316.96	1317.66	263306.0
2008-05-07 11:00:00	ES	Futures	1317.66	1318.59	1313.24	1314.4	213671.0
2008-05-07 12:00:00	ES	Futures	1314.17	1316.03	1313.47	1315.1	109876.0
2008-05-07 13:00:00	ES	Futures	1315.33	1315.57	1309.51	1310.68	169779.0
2008-05-07 14:00:00	ES	Futures	1310.68	1311.61	1299.97	1302.29	343124.0
2008-05-07 15:00:00	ES	Futures	1302.53	1302.76	1295.08	1296.47	455101.0
2008-05-07 16:00:00	ES	Futures	1296.47	1300.66	1296.24	1299.5	95946.0
2008-05-07 17:00:00	ES	Futures	1299.27	1299.5	1299.04	1299.04	1173.0
2008-05-07 18:00:00	ES	Futures	1299.04	1300.66	1298.57	1299.04	3651.0
2008-05-07 19:00:00	ES	Futures	1299.04	1300.66	1298.8	1300.43	1197.0
2008-05-07 20:00:00	ES	Futures	1300.43	1301.13	1299.27	1300.66	1335.0
2008-05-07 21:00:00	ES	Futures	1300.66	1302.76	1300.66	1302.76	3002.0
2008-05-07 22:00:00	ES	Futures	1302.76	1302.99	1301.13	1302.29	4671.0
2008-05-07 23:00:00	ES	Futures	1302.29	1302.53	1301.6	1302.06	1409.0
2008-05-07 00:00:00	NQ	Futures	2255.84	2256.12	2253.58	2255.28	264.0
2008-05-07 01:00:00	NQ	Futures	2254.43	2255.56	2253.3	2254.43	188.0
2008-05-07 02:00:00	NQ	Futures	2254.43	2256.41	2253.86	2254.71	248.0
2008-05-07 03:00:00	NQ	Futures	2254.43	2256.41	2252.45	2254.43	883.0
2008-05-07 04:00:00	NQ	Futures	2254.14	2256.41	2252.45	2255.84	749.0
2008-05-07 05:00:00	NQ	Futures	2255.56	2258.67	2255.28	2258.39	1139.0
2008-05-07 06:00:00	NQ	Futures	2258.1	2260.08	2255.84	2256.41	1036.0
2008-05-07 07:00:00	NQ	Futures	2256.41	2257.54	2251.03	2251.6	1809.0
2008-05-07 08:00:00	NQ	Futures	2251.6	2261.21	2250.75	2257.54	5420.0
2008-05-07 09:00:00	NQ	Futures	2257.26	2260.08	2247.92	2255.28	33445.0
2008-05-07 10:00:00	NQ	Futures	2255.56	2268.85	2250.47	2257.82	48639.0
2008-05-07 11:00:00	NQ	Futures	2257.54	2261.5	2245.09	2247.64	39495.0
2008-05-07 12:00:00	NQ	Futures	2247.64	2251.6	2241.7	2247.64	27559.0
2008-05-07 13:00:00	NQ	Futures	2247.36	2247.92	2226.14	2229.54	46719.0
2008-05-07 14:00:00	NQ	Futures	2229.54	2233.21	2212.0	2217.94	69378.0
2008-05-07 15:00:00	NQ	Futures	2217.94	2219.92	2206.06	2215.11	78410.0
2008-05-07 16:00:00	NQ	Futures	2215.11	2221.05	2214.83	2218.51	15642.0
2008-05-07 17:00:00	NQ	Futures	2218.79	2219.07	2218.51	2218.51	149.0
2008-05-07 18:00:00	NQ	Futures	2218.51	2219.64	2217.94	2219.07	348.0
2008-05-07 19:00:00	NQ	Futures	2218.79	2220.2	2218.22	2219.64	174.0
2008-05-07 20:00:00	NQ	Futures	2219.64	2221.9	2219.64	2221.62	199.0
2008-05-07 21:00:00	NQ	Futures	2221.62	2225.58	2221.62	2224.73	225.0
2008-05-07 22:00:00	NQ	Futures	2224.16	2224.73	2222.75	2223.03	142.0
2008-05-07 23:00:00	NQ	Futures	2223.03	2223.88	2221.9	2223.32	63.0
2008-05-07 00:00:00	YM	Futures	11807.9	11810.7	11797.0	11803.4	245.0
2008-05-07 01:00:00	YM	Futures	11803.4	11805.2	11794.3	11802.5	229.0

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

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