PREVIEW / futures_1hour / 2008-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-22.parquet
  size:    42 KB
  rows:    1,206

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-22 00:00:00	ES	Futures	1299.27	1300.43	1298.1	1300.2	2161.0
2008-05-22 01:00:00	ES	Futures	1300.2	1300.9	1299.5	1300.66	2624.0
2008-05-22 02:00:00	ES	Futures	1300.9	1301.36	1298.57	1299.73	7550.0
2008-05-22 03:00:00	ES	Futures	1299.97	1302.99	1299.5	1301.6	20233.0
2008-05-22 04:00:00	ES	Futures	1301.36	1303.23	1299.97	1300.66	15848.0
2008-05-22 05:00:00	ES	Futures	1300.9	1302.06	1299.97	1300.2	9041.0
2008-05-22 06:00:00	ES	Futures	1300.2	1300.9	1297.87	1299.73	10177.0
2008-05-22 07:00:00	ES	Futures	1299.73	1299.97	1295.08	1295.54	34034.0
2008-05-22 08:00:00	ES	Futures	1295.78	1299.73	1294.84	1298.8	78527.0
2008-05-22 09:00:00	ES	Futures	1299.04	1299.27	1295.31	1297.17	209398.0
2008-05-22 10:00:00	ES	Futures	1296.94	1303.69	1296.94	1300.66	355604.0
2008-05-22 11:00:00	ES	Futures	1300.9	1302.53	1295.54	1297.17	235145.0
2008-05-22 12:00:00	ES	Futures	1297.17	1300.43	1295.08	1299.73	133278.0
2008-05-22 13:00:00	ES	Futures	1299.73	1303.46	1297.87	1301.13	144357.0
2008-05-22 14:00:00	ES	Futures	1301.36	1302.76	1296.24	1300.2	216603.0
2008-05-22 15:00:00	ES	Futures	1300.2	1301.36	1295.78	1298.1	177327.0
2008-05-22 16:00:00	ES	Futures	1298.1	1298.57	1296.01	1297.17	54235.0
2008-05-22 17:00:00	ES	Futures	1297.41	1297.87	1297.17	1297.64	497.0
2008-05-22 18:00:00	ES	Futures	1297.64	1297.87	1297.17	1297.64	532.0
2008-05-22 19:00:00	ES	Futures	1297.87	1298.34	1296.71	1296.94	1205.0
2008-05-22 20:00:00	ES	Futures	1296.94	1297.87	1296.47	1297.64	936.0
2008-05-22 21:00:00	ES	Futures	1297.64	1299.27	1297.64	1298.8	841.0
2008-05-22 22:00:00	ES	Futures	1298.8	1299.27	1298.34	1298.8	573.0
2008-05-22 23:00:00	ES	Futures	1298.57	1299.04	1297.64	1298.34	1063.0
2008-05-22 00:00:00	NQ	Futures	2225.3	2228.41	2222.75	2228.12	242.0
2008-05-22 01:00:00	NQ	Futures	2228.12	2229.54	2227.28	2229.54	306.0
2008-05-22 02:00:00	NQ	Futures	2229.54	2232.08	2226.71	2228.12	782.0
2008-05-22 03:00:00	NQ	Futures	2228.12	2233.21	2226.99	2231.23	1417.0
2008-05-22 04:00:00	NQ	Futures	2231.23	2232.93	2228.41	2229.82	1316.0
2008-05-22 05:00:00	NQ	Futures	2229.82	2232.08	2228.97	2229.26	641.0
2008-05-22 06:00:00	NQ	Futures	2229.26	2229.26	2223.88	2228.69	1311.0
2008-05-22 07:00:00	NQ	Futures	2228.69	2228.69	2217.66	2218.22	4205.0
2008-05-22 08:00:00	NQ	Futures	2218.22	2224.16	2214.55	2223.6	5860.0
2008-05-22 09:00:00	NQ	Futures	2223.88	2231.8	2215.96	2222.47	61014.0
2008-05-22 10:00:00	NQ	Futures	2222.18	2241.7	2222.18	2231.52	78198.0
2008-05-22 11:00:00	NQ	Futures	2231.8	2235.48	2219.36	2226.43	42725.0
2008-05-22 12:00:00	NQ	Futures	2226.43	2237.74	2220.77	2234.06	37950.0
2008-05-22 13:00:00	NQ	Futures	2234.06	2238.87	2228.12	2230.1	35200.0
2008-05-22 14:00:00	NQ	Futures	2230.1	2236.89	2215.11	2225.3	56791.0
2008-05-22 15:00:00	NQ	Futures	2225.3	2228.97	2215.96	2226.14	39821.0
2008-05-22 16:00:00	NQ	Futures	2226.43	2226.71	2222.75	2223.88	7861.0
2008-05-22 17:00:00	NQ	Futures	2223.6	2226.71	2223.6	2225.86	212.0
2008-05-22 18:00:00	NQ	Futures	2225.86	2226.43	2224.73	2225.58	72.0
2008-05-22 19:00:00	NQ	Futures	2225.86	2226.99	2223.88	2223.88	187.0
2008-05-22 20:00:00	NQ	Futures	2224.73	2225.58	2223.88	2225.3	25.0
2008-05-22 21:00:00	NQ	Futures	2225.58	2228.12	2225.58	2227.56	174.0
2008-05-22 22:00:00	NQ	Futures	2227.28	2227.84	2226.71	2227.28	26.0
2008-05-22 23:00:00	NQ	Futures	2226.99	2228.12	2225.58	2226.43	71.0
2008-05-22 00:00:00	YM	Futures	11478.1	11488.1	11476.3	11486.3	165.0
2008-05-22 01:00:00	YM	Futures	11488.1	11490.8	11480.8	11489.9	229.0

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

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