PREVIEW / futures_1hour / 2008-06-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	1283.9	1284.13	1282.97	1283.2	1427.0
2008-06-05 01:00:00	ES	Futures	1283.43	1285.3	1283.43	1284.6	1844.0
2008-06-05 02:00:00	ES	Futures	1284.83	1286.0	1283.67	1286.0	4255.0
2008-06-05 03:00:00	ES	Futures	1285.76	1287.39	1283.9	1286.69	12915.0
2008-06-05 04:00:00	ES	Futures	1286.69	1289.02	1285.76	1286.69	12223.0
2008-06-05 05:00:00	ES	Futures	1286.69	1287.86	1286.23	1286.93	5502.0
2008-06-05 06:00:00	ES	Futures	1286.93	1287.39	1283.67	1284.6	10510.0
2008-06-05 07:00:00	ES	Futures	1284.37	1288.79	1283.9	1288.56	25199.0
2008-06-05 08:00:00	ES	Futures	1288.56	1293.68	1286.93	1287.39	76115.0
2008-06-05 09:00:00	ES	Futures	1287.63	1292.98	1285.06	1292.05	227855.0
2008-06-05 10:00:00	ES	Futures	1292.28	1299.04	1289.02	1296.94	390825.0
2008-06-05 11:00:00	ES	Futures	1296.94	1298.8	1294.61	1297.41	172504.0
2008-06-05 12:00:00	ES	Futures	1297.17	1302.76	1296.94	1301.83	203953.0
2008-06-05 13:00:00	ES	Futures	1302.06	1303.23	1300.2	1301.13	137676.0
2008-06-05 14:00:00	ES	Futures	1301.13	1302.29	1294.84	1302.06	264982.0
2008-06-05 15:00:00	ES	Futures	1302.06	1308.81	1301.13	1307.18	318159.0
2008-06-05 16:00:00	ES	Futures	1307.18	1309.51	1306.95	1308.58	104192.0
2008-06-05 17:00:00	ES	Futures	1308.81	1309.05	1308.12	1309.05	2226.0
2008-06-05 18:00:00	ES	Futures	1308.58	1309.05	1308.35	1308.58	3080.0
2008-06-05 19:00:00	ES	Futures	1308.81	1309.28	1308.12	1308.81	1479.0
2008-06-05 20:00:00	ES	Futures	1308.81	1309.98	1308.81	1309.51	2137.0
2008-06-05 21:00:00	ES	Futures	1309.51	1309.51	1308.81	1308.81	758.0
2008-06-05 22:00:00	ES	Futures	1308.81	1309.05	1308.35	1308.81	473.0
2008-06-05 23:00:00	ES	Futures	1308.81	1309.28	1308.35	1308.81	643.0
2008-06-05 00:00:00	NQ	Futures	2286.39	2286.39	2284.12	2284.97	113.0
2008-06-05 01:00:00	NQ	Futures	2286.39	2289.21	2286.39	2288.37	313.0
2008-06-05 02:00:00	NQ	Futures	2288.37	2289.78	2286.39	2289.78	438.0
2008-06-05 03:00:00	NQ	Futures	2289.78	2292.33	2286.67	2291.19	983.0
2008-06-05 04:00:00	NQ	Futures	2290.91	2294.59	2289.5	2293.17	1265.0
2008-06-05 05:00:00	NQ	Futures	2293.46	2294.87	2291.76	2293.74	1064.0
2008-06-05 06:00:00	NQ	Futures	2293.74	2293.74	2287.8	2288.65	1373.0
2008-06-05 07:00:00	NQ	Futures	2288.37	2297.98	2288.37	2297.98	2673.0
2008-06-05 08:00:00	NQ	Futures	2297.98	2303.92	2294.31	2295.15	8811.0
2008-06-05 09:00:00	NQ	Futures	2294.87	2307.88	2285.82	2305.05	49627.0
2008-06-05 10:00:00	NQ	Futures	2305.62	2318.91	2302.51	2315.24	81255.0
2008-06-05 11:00:00	NQ	Futures	2315.24	2319.48	2311.84	2316.37	41557.0
2008-06-05 12:00:00	NQ	Futures	2316.37	2322.31	2315.24	2318.91	39744.0
2008-06-05 13:00:00	NQ	Futures	2318.91	2321.74	2314.95	2318.63	27958.0
2008-06-05 14:00:00	NQ	Futures	2318.63	2318.91	2306.18	2318.06	43050.0
2008-06-05 15:00:00	NQ	Futures	2318.35	2328.81	2316.37	2325.7	63334.0
2008-06-05 16:00:00	NQ	Futures	2325.98	2330.79	2324.29	2327.11	16781.0
2008-06-05 17:00:00	NQ	Futures	2327.4	2327.68	2325.42	2327.4	80.0
2008-06-05 18:00:00	NQ	Futures	2327.11	2327.96	2326.83	2327.11	96.0
2008-06-05 19:00:00	NQ	Futures	2326.83	2327.4	2325.98	2327.4	245.0
2008-06-05 20:00:00	NQ	Futures	2327.4	2327.4	2324.85	2326.83	194.0
2008-06-05 21:00:00	NQ	Futures	2326.83	2327.11	2324.85	2325.98	119.0
2008-06-05 22:00:00	NQ	Futures	2325.98	2326.55	2325.7	2326.55	22.0
2008-06-05 23:00:00	NQ	Futures	2326.55	2326.83	2325.13	2325.13	19.0
2008-06-05 00:00:00	YM	Futures	11274.5	11276.4	11264.6	11271.8	145.0
2008-06-05 01:00:00	YM	Futures	11273.6	11288.2	11273.6	11280.0	254.0

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

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