PREVIEW / futures_1hour / 2008-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-15.parquet
  size:    30 KB
  rows:    782

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-15 00:00:00	ES	Futures	1319.9	1320.36	1318.5	1319.2	3861.0
2008-01-15 01:00:00	ES	Futures	1318.96	1319.66	1317.1	1318.73	2293.0
2008-01-15 02:00:00	ES	Futures	1318.27	1320.13	1317.8	1318.5	5287.0
2008-01-15 03:00:00	ES	Futures	1318.5	1319.9	1317.57	1318.73	11114.0
2008-01-15 04:00:00	ES	Futures	1318.73	1318.73	1316.4	1316.87	9595.0
2008-01-15 05:00:00	ES	Futures	1316.63	1318.03	1315.47	1317.57	16454.0
2008-01-15 06:00:00	ES	Futures	1317.57	1321.3	1315.47	1318.73	29355.0
2008-01-15 07:00:00	ES	Futures	1318.96	1320.13	1312.67	1314.53	33606.0
2008-01-15 08:00:00	ES	Futures	1314.3	1315.0	1308.01	1309.17	100909.0
2008-01-15 09:00:00	ES	Futures	1309.17	1312.9	1308.01	1310.8	192326.0
2008-01-15 10:00:00	ES	Futures	1310.8	1312.44	1296.58	1299.15	461118.0
2008-01-15 11:00:00	ES	Futures	1299.15	1303.11	1295.18	1299.38	304370.0
2008-01-15 12:00:00	ES	Futures	1299.15	1301.94	1296.58	1299.38	191533.0
2008-01-15 13:00:00	ES	Futures	1299.38	1303.58	1295.42	1297.75	236422.0
2008-01-15 14:00:00	ES	Futures	1297.75	1301.24	1294.02	1295.42	241240.0
2008-01-15 15:00:00	ES	Futures	1295.42	1304.28	1291.92	1293.08	474252.0
2008-01-15 16:00:00	ES	Futures	1293.08	1295.18	1280.96	1281.19	132671.0
2008-01-15 17:00:00	ES	Futures	1281.19	1283.29	1280.73	1283.06	10356.0
2008-01-15 18:00:00	ES	Futures	1282.36	1284.22	1281.66	1282.59	8132.0
2008-01-15 19:00:00	ES	Futures	1282.83	1283.99	1280.73	1282.36	5530.0
2008-01-15 20:00:00	ES	Futures	1282.13	1286.32	1280.96	1286.09	10450.0
2008-01-15 21:00:00	ES	Futures	1285.86	1286.79	1284.92	1285.62	3938.0
2008-01-15 22:00:00	ES	Futures	1285.86	1286.79	1284.92	1285.16	2623.0
2008-01-15 23:00:00	ES	Futures	1285.39	1286.32	1283.06	1283.29	3113.0
2008-01-15 00:00:00	NQ	Futures	2216.25	2216.54	2210.86	2213.98	322.0
2008-01-15 01:00:00	NQ	Futures	2215.12	2215.12	2210.57	2213.98	127.0
2008-01-15 02:00:00	NQ	Futures	2213.41	2216.82	2212.85	2215.68	267.0
2008-01-15 03:00:00	NQ	Futures	2214.83	2217.39	2213.13	2215.97	665.0
2008-01-15 04:00:00	NQ	Futures	2215.68	2215.68	2209.44	2210.86	619.0
2008-01-15 05:00:00	NQ	Futures	2210.86	2211.14	2205.75	2210.57	1635.0
2008-01-15 06:00:00	NQ	Futures	2210.57	2215.97	2207.45	2211.43	1385.0
2008-01-15 07:00:00	NQ	Futures	2211.71	2212.85	2198.65	2202.34	4434.0
2008-01-15 08:00:00	NQ	Futures	2202.34	2204.33	2194.4	2195.81	12385.0
2008-01-15 09:00:00	NQ	Futures	2196.1	2207.45	2195.25	2201.49	44346.0
2008-01-15 10:00:00	NQ	Futures	2200.92	2204.33	2177.08	2183.33	100914.0
2008-01-15 11:00:00	NQ	Futures	2183.33	2191.84	2175.38	2183.61	63366.0
2008-01-15 12:00:00	NQ	Futures	2183.89	2186.16	2168.28	2173.96	59487.0
2008-01-15 13:00:00	NQ	Futures	2173.96	2184.18	2161.75	2163.74	69374.0
2008-01-15 14:00:00	NQ	Futures	2164.02	2172.82	2159.2	2163.17	64094.0
2008-01-15 15:00:00	NQ	Futures	2163.17	2181.62	2152.39	2163.17	95656.0
2008-01-15 16:00:00	NQ	Futures	2163.74	2172.26	2120.88	2121.45	29141.0
2008-01-15 17:00:00	NQ	Futures	2121.45	2125.14	2117.76	2121.73	2926.0
2008-01-15 18:00:00	NQ	Futures	2123.43	2127.12	2123.15	2125.42	919.0
2008-01-15 19:00:00	NQ	Futures	2125.14	2128.26	2123.72	2126.84	536.0
2008-01-15 20:00:00	NQ	Futures	2127.98	2136.49	2127.41	2136.21	1076.0
2008-01-15 21:00:00	NQ	Futures	2136.21	2137.91	2134.5	2136.21	496.0
2008-01-15 22:00:00	NQ	Futures	2136.78	2139.9	2136.78	2139.05	435.0
2008-01-15 23:00:00	NQ	Futures	2138.19	2138.48	2134.5	2134.5	244.0
2008-01-15 00:00:00	YM	Futures	11586.1	11590.6	11575.2	11582.4	262.0
2008-01-15 01:00:00	YM	Futures	11581.5	11587.0	11569.7	11583.4	250.0

> showing 50 of 782 rows — these rows as CSV

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