PREVIEW / futures_1hour / 2008-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-03.parquet
  size:    43 KB
  rows:    1,228

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-03 00:00:00	ES	Futures	1290.42	1290.65	1287.63	1288.32	3623.0
2008-06-03 01:00:00	ES	Futures	1288.09	1288.32	1286.46	1286.46	3690.0
2008-06-03 02:00:00	ES	Futures	1286.46	1287.86	1285.3	1286.23	6044.0
2008-06-03 03:00:00	ES	Futures	1286.23	1291.58	1286.0	1291.35	15420.0
2008-06-03 04:00:00	ES	Futures	1291.12	1291.82	1288.56	1289.95	12117.0
2008-06-03 05:00:00	ES	Futures	1289.95	1293.21	1289.26	1292.98	12461.0
2008-06-03 06:00:00	ES	Futures	1292.98	1293.45	1289.49	1289.95	13617.0
2008-06-03 07:00:00	ES	Futures	1289.72	1293.68	1289.49	1293.45	24636.0
2008-06-03 08:00:00	ES	Futures	1293.21	1295.31	1292.28	1293.21	51903.0
2008-06-03 09:00:00	ES	Futures	1292.98	1295.54	1290.19	1291.35	193070.0
2008-06-03 10:00:00	ES	Futures	1291.58	1297.41	1291.35	1294.61	259356.0
2008-06-03 11:00:00	ES	Futures	1294.84	1297.41	1293.68	1297.17	149023.0
2008-06-03 12:00:00	ES	Futures	1297.41	1297.87	1291.58	1292.28	140942.0
2008-06-03 13:00:00	ES	Futures	1292.52	1293.68	1278.31	1281.57	351234.0
2008-06-03 14:00:00	ES	Futures	1281.34	1282.27	1275.28	1280.41	354347.0
2008-06-03 15:00:00	ES	Futures	1280.41	1288.56	1278.54	1282.97	447240.0
2008-06-03 16:00:00	ES	Futures	1282.74	1284.37	1282.5	1282.97	70079.0
2008-06-03 17:00:00	ES	Futures	1282.74	1283.2	1282.74	1283.2	485.0
2008-06-03 18:00:00	ES	Futures	1283.2	1283.67	1281.57	1281.57	2214.0
2008-06-03 19:00:00	ES	Futures	1281.8	1283.2	1281.11	1283.2	1291.0
2008-06-03 20:00:00	ES	Futures	1283.2	1283.43	1282.27	1282.97	1464.0
2008-06-03 21:00:00	ES	Futures	1282.74	1284.6	1282.5	1284.13	1969.0
2008-06-03 22:00:00	ES	Futures	1284.13	1284.6	1282.97	1283.2	1169.0
2008-06-03 23:00:00	ES	Futures	1283.2	1284.6	1282.5	1284.37	813.0
2008-06-03 00:00:00	NQ	Futures	2275.92	2275.92	2271.96	2271.96	183.0
2008-06-03 01:00:00	NQ	Futures	2271.96	2272.53	2269.42	2269.7	549.0
2008-06-03 02:00:00	NQ	Futures	2269.13	2270.83	2266.59	2268.57	512.0
2008-06-03 03:00:00	NQ	Futures	2268.85	2276.77	2268.29	2276.2	1362.0
2008-06-03 04:00:00	NQ	Futures	2276.2	2277.9	2271.11	2274.22	1111.0
2008-06-03 05:00:00	NQ	Futures	2274.22	2280.16	2273.66	2279.32	1137.0
2008-06-03 06:00:00	NQ	Futures	2279.32	2281.3	2273.09	2274.79	929.0
2008-06-03 07:00:00	NQ	Futures	2274.51	2280.16	2274.51	2280.16	1286.0
2008-06-03 08:00:00	NQ	Futures	2279.88	2283.56	2277.62	2278.18	4580.0
2008-06-03 09:00:00	NQ	Futures	2278.18	2282.99	2275.36	2281.3	41979.0
2008-06-03 10:00:00	NQ	Futures	2281.58	2295.72	2281.01	2288.08	56805.0
2008-06-03 11:00:00	NQ	Futures	2288.08	2295.44	2287.24	2292.33	30277.0
2008-06-03 12:00:00	NQ	Futures	2292.04	2292.89	2279.6	2281.58	35438.0
2008-06-03 13:00:00	NQ	Futures	2281.58	2284.41	2248.2	2254.71	88475.0
2008-06-03 14:00:00	NQ	Futures	2254.99	2258.1	2238.59	2249.9	94737.0
2008-06-03 15:00:00	NQ	Futures	2249.62	2271.4	2245.09	2261.78	91832.0
2008-06-03 16:00:00	NQ	Futures	2261.21	2263.76	2258.95	2259.8	10099.0
2008-06-03 17:00:00	NQ	Futures	2259.8	2260.37	2258.95	2260.08	123.0
2008-06-03 18:00:00	NQ	Futures	2260.08	2260.65	2258.39	2258.39	196.0
2008-06-03 19:00:00	NQ	Futures	2258.1	2260.37	2256.12	2260.08	166.0
2008-06-03 20:00:00	NQ	Futures	2258.95	2260.37	2258.95	2259.8	21.0
2008-06-03 21:00:00	NQ	Futures	2259.52	2262.91	2259.52	2262.35	135.0
2008-06-03 22:00:00	NQ	Futures	2262.06	2263.19	2260.93	2260.93	82.0
2008-06-03 23:00:00	NQ	Futures	2260.65	2262.63	2260.37	2262.63	33.0
2008-06-03 00:00:00	YM	Futures	11354.5	11355.4	11337.2	11339.1	321.0
2008-06-03 01:00:00	YM	Futures	11340.9	11343.6	11327.2	11330.9	212.0

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

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