PREVIEW / futures_1hour / 2008-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-04.parquet
  size:    42 KB
  rows:    1,224

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-04 00:00:00	ES	Futures	1284.6	1284.6	1283.2	1283.43	708.0
2008-06-04 01:00:00	ES	Futures	1283.67	1285.06	1283.67	1284.37	1025.0
2008-06-04 02:00:00	ES	Futures	1284.37	1286.0	1283.9	1285.3	4535.0
2008-06-04 03:00:00	ES	Futures	1285.53	1285.76	1281.34	1281.34	13859.0
2008-06-04 04:00:00	ES	Futures	1281.57	1281.57	1277.85	1278.78	21141.0
2008-06-04 05:00:00	ES	Futures	1279.01	1280.17	1277.61	1279.71	9561.0
2008-06-04 06:00:00	ES	Futures	1279.71	1279.94	1278.08	1279.48	8499.0
2008-06-04 07:00:00	ES	Futures	1279.48	1279.48	1277.15	1278.08	25361.0
2008-06-04 08:00:00	ES	Futures	1278.08	1282.04	1277.61	1278.08	67674.0
2008-06-04 09:00:00	ES	Futures	1278.08	1286.69	1276.91	1284.13	252554.0
2008-06-04 10:00:00	ES	Futures	1284.37	1290.42	1281.8	1289.49	362244.0
2008-06-04 11:00:00	ES	Futures	1289.49	1292.52	1288.32	1289.72	197763.0
2008-06-04 12:00:00	ES	Futures	1289.95	1293.21	1286.93	1287.39	208248.0
2008-06-04 13:00:00	ES	Futures	1287.39	1291.12	1284.6	1290.19	179240.0
2008-06-04 14:00:00	ES	Futures	1289.95	1290.65	1277.38	1278.54	332031.0
2008-06-04 15:00:00	ES	Futures	1278.54	1285.53	1277.61	1282.97	309431.0
2008-06-04 16:00:00	ES	Futures	1282.74	1284.6	1281.11	1282.5	63740.0
2008-06-04 17:00:00	ES	Futures	1282.74	1283.2	1282.04	1282.27	812.0
2008-06-04 18:00:00	ES	Futures	1282.27	1283.2	1281.8	1282.74	1113.0
2008-06-04 19:00:00	ES	Futures	1282.74	1283.9	1281.8	1283.43	809.0
2008-06-04 20:00:00	ES	Futures	1283.43	1283.43	1282.04	1282.97	1309.0
2008-06-04 21:00:00	ES	Futures	1282.97	1283.2	1281.57	1282.97	1347.0
2008-06-04 22:00:00	ES	Futures	1282.97	1283.67	1282.97	1283.43	820.0
2008-06-04 23:00:00	ES	Futures	1283.2	1284.13	1282.97	1283.9	760.0
2008-06-04 00:00:00	NQ	Futures	2262.63	2263.19	2261.5	2262.06	89.0
2008-06-04 01:00:00	NQ	Futures	2262.06	2263.76	2261.21	2262.91	33.0
2008-06-04 02:00:00	NQ	Futures	2262.91	2266.02	2262.06	2264.61	393.0
2008-06-04 03:00:00	NQ	Futures	2264.04	2265.17	2257.54	2257.82	948.0
2008-06-04 04:00:00	NQ	Futures	2257.82	2257.82	2252.16	2253.01	1432.0
2008-06-04 05:00:00	NQ	Futures	2252.73	2255.84	2252.45	2255.56	613.0
2008-06-04 06:00:00	NQ	Futures	2255.28	2255.84	2253.01	2255.84	364.0
2008-06-04 07:00:00	NQ	Futures	2255.84	2255.84	2251.32	2253.01	2330.0
2008-06-04 08:00:00	NQ	Futures	2253.01	2258.1	2247.64	2248.49	7958.0
2008-06-04 09:00:00	NQ	Futures	2248.77	2274.79	2246.79	2269.13	55964.0
2008-06-04 10:00:00	NQ	Futures	2269.42	2297.7	2265.17	2295.15	92298.0
2008-06-04 11:00:00	NQ	Futures	2295.44	2303.36	2294.59	2296.57	60036.0
2008-06-04 12:00:00	NQ	Futures	2296.29	2305.62	2292.33	2292.61	54348.0
2008-06-04 13:00:00	NQ	Futures	2292.89	2301.09	2287.24	2299.4	40938.0
2008-06-04 14:00:00	NQ	Futures	2299.4	2300.53	2272.25	2276.49	72027.0
2008-06-04 15:00:00	NQ	Futures	2276.49	2291.19	2274.22	2288.93	67684.0
2008-06-04 16:00:00	NQ	Futures	2288.93	2289.5	2282.14	2284.97	10727.0
2008-06-04 17:00:00	NQ	Futures	2284.97	2284.97	2283.56	2284.41	102.0
2008-06-04 18:00:00	NQ	Futures	2283.28	2284.97	2282.43	2284.69	384.0
2008-06-04 19:00:00	NQ	Futures	2284.69	2287.24	2283.28	2285.82	62.0
2008-06-04 20:00:00	NQ	Futures	2286.95	2286.95	2284.12	2284.12	35.0
2008-06-04 21:00:00	NQ	Futures	2284.41	2285.26	2283.28	2284.97	84.0
2008-06-04 22:00:00	NQ	Futures	2285.26	2285.82	2285.26	2285.82	89.0
2008-06-04 23:00:00	NQ	Futures	2285.82	2286.39	2285.26	2286.39	41.0
2008-06-04 00:00:00	YM	Futures	11278.2	11279.1	11268.2	11269.1	81.0
2008-06-04 01:00:00	YM	Futures	11270.9	11281.8	11269.1	11277.3	97.0

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

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