PREVIEW / futures_1hour / 2008-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-09.parquet
  size:    29 KB
  rows:    729

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-01-09 00:00:00	ES	Futures	1306.37	1308.94	1306.37	1308.71	3472.0
2008-01-09 01:00:00	ES	Futures	1308.47	1309.87	1308.01	1308.24	3066.0
2008-01-09 02:00:00	ES	Futures	1308.47	1311.97	1308.01	1311.27	12303.0
2008-01-09 03:00:00	ES	Futures	1311.27	1311.97	1305.67	1306.61	29308.0
2008-01-09 04:00:00	ES	Futures	1306.37	1308.24	1304.04	1304.98	17817.0
2008-01-09 05:00:00	ES	Futures	1304.98	1308.01	1304.04	1307.54	14196.0
2008-01-09 06:00:00	ES	Futures	1307.54	1310.8	1306.61	1308.71	14606.0
2008-01-09 07:00:00	ES	Futures	1308.94	1310.1	1302.88	1304.51	33726.0
2008-01-09 08:00:00	ES	Futures	1304.51	1306.61	1300.31	1301.48	67489.0
2008-01-09 09:00:00	ES	Futures	1301.48	1309.41	1299.61	1307.31	321378.0
2008-01-09 10:00:00	ES	Futures	1307.31	1312.2	1303.58	1308.94	397414.0
2008-01-09 11:00:00	ES	Futures	1308.94	1310.34	1297.75	1300.78	314901.0
2008-01-09 12:00:00	ES	Futures	1300.78	1307.54	1299.15	1304.98	177842.0
2008-01-09 13:00:00	ES	Futures	1304.98	1306.37	1294.25	1296.58	248252.0
2008-01-09 14:00:00	ES	Futures	1296.58	1307.31	1291.69	1305.21	382147.0
2008-01-09 15:00:00	ES	Futures	1305.44	1321.06	1304.51	1320.83	640479.0
2008-01-09 16:00:00	ES	Futures	1320.83	1321.06	1315.7	1319.2	97897.0
2008-01-09 17:00:00	ES	Futures	1318.96	1320.36	1318.96	1320.13	3236.0
2008-01-09 18:00:00	ES	Futures	1319.9	1320.36	1318.96	1318.96	3185.0
2008-01-09 19:00:00	ES	Futures	1318.96	1319.9	1317.1	1317.57	3272.0
2008-01-09 20:00:00	ES	Futures	1317.57	1317.57	1316.17	1316.87	2953.0
2008-01-09 21:00:00	ES	Futures	1316.87	1317.8	1316.4	1317.33	1008.0
2008-01-09 22:00:00	ES	Futures	1317.33	1318.5	1316.63	1316.87	2810.0
2008-01-09 23:00:00	ES	Futures	1316.63	1318.03	1316.63	1317.8	2169.0
2008-01-09 00:00:00	NQ	Futures	2197.8	2201.49	2196.95	2201.49	334.0
2008-01-09 01:00:00	NQ	Futures	2201.49	2203.76	2199.5	2199.5	398.0
2008-01-09 02:00:00	NQ	Futures	2199.5	2206.03	2199.5	2202.91	853.0
2008-01-09 03:00:00	NQ	Futures	2202.91	2203.76	2191.27	2191.56	2095.0
2008-01-09 04:00:00	NQ	Futures	2191.56	2197.23	2187.58	2190.42	1957.0
2008-01-09 05:00:00	NQ	Futures	2190.71	2195.53	2189.57	2195.53	1126.0
2008-01-09 06:00:00	NQ	Futures	2195.25	2201.49	2193.83	2197.8	1195.0
2008-01-09 07:00:00	NQ	Futures	2198.09	2198.94	2189.29	2191.27	2214.0
2008-01-09 08:00:00	NQ	Futures	2191.56	2196.1	2185.31	2186.73	6968.0
2008-01-09 09:00:00	NQ	Futures	2186.73	2208.3	2179.35	2200.92	85143.0
2008-01-09 10:00:00	NQ	Futures	2200.64	2212.85	2187.87	2203.48	109378.0
2008-01-09 11:00:00	NQ	Futures	2203.48	2206.88	2175.38	2185.88	78082.0
2008-01-09 12:00:00	NQ	Futures	2185.6	2196.95	2182.47	2190.71	51756.0
2008-01-09 13:00:00	NQ	Futures	2190.99	2194.11	2169.7	2175.38	66610.0
2008-01-09 14:00:00	NQ	Futures	2175.38	2204.61	2160.62	2202.06	111204.0
2008-01-09 15:00:00	NQ	Futures	2202.06	2230.73	2200.36	2230.16	126581.0
2008-01-09 16:00:00	NQ	Futures	2229.88	2230.16	2218.24	2226.47	14851.0
2008-01-09 17:00:00	NQ	Futures	2226.19	2227.89	2225.9	2227.61	610.0
2008-01-09 18:00:00	NQ	Futures	2227.89	2228.17	2226.75	2227.04	645.0
2008-01-09 19:00:00	NQ	Futures	2227.04	2227.61	2225.62	2225.9	483.0
2008-01-09 20:00:00	NQ	Futures	2225.9	2225.9	2223.06	2223.35	277.0
2008-01-09 21:00:00	NQ	Futures	2223.06	2226.19	2223.06	2225.9	175.0
2008-01-09 22:00:00	NQ	Futures	2225.9	2226.75	2224.77	2224.77	284.0
2008-01-09 23:00:00	NQ	Futures	2224.77	2226.19	2224.2	2226.19	119.0
2008-01-09 00:00:00	YM	Futures	11522.5	11536.1	11522.5	11536.1	294.0
2008-01-09 01:00:00	YM	Futures	11536.1	11545.2	11525.2	11528.8	462.0

> showing 50 of 729 rows — these rows as CSV

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