PREVIEW / futures_1hour / 2010-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-29.parquet
  size:    46 KB
  rows:    1,415

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
2010-09-29 00:00:00	ES	Futures	1127.64	1128.13	1125.92	1126.16	3644.0
2010-09-29 01:00:00	ES	Futures	1126.16	1126.9	1124.44	1124.93	5551.0
2010-09-29 02:00:00	ES	Futures	1124.93	1128.38	1124.93	1128.13	8941.0
2010-09-29 03:00:00	ES	Futures	1128.13	1130.6	1123.2	1124.68	39889.0
2010-09-29 04:00:00	ES	Futures	1124.68	1125.42	1121.23	1121.73	37261.0
2010-09-29 05:00:00	ES	Futures	1121.48	1126.9	1121.48	1125.92	23916.0
2010-09-29 06:00:00	ES	Futures	1125.92	1126.41	1123.45	1124.44	14293.0
2010-09-29 07:00:00	ES	Futures	1124.68	1126.16	1123.45	1126.16	20784.0
2010-09-29 08:00:00	ES	Futures	1126.16	1127.64	1123.2	1123.7	55804.0
2010-09-29 09:00:00	ES	Futures	1123.45	1126.16	1121.23	1122.71	257078.0
2010-09-29 10:00:00	ES	Futures	1122.46	1125.92	1119.51	1121.73	376291.0
2010-09-29 11:00:00	ES	Futures	1121.73	1126.9	1121.23	1125.92	207303.0
2010-09-29 12:00:00	ES	Futures	1125.92	1127.89	1124.93	1126.16	122862.0
2010-09-29 13:00:00	ES	Futures	1126.16	1127.15	1123.7	1126.41	120530.0
2010-09-29 14:00:00	ES	Futures	1126.65	1128.38	1125.92	1127.64	120600.0
2010-09-29 15:00:00	ES	Futures	1127.64	1127.89	1120.0	1123.45	316071.0
2010-09-29 16:00:00	ES	Futures	1123.7	1125.18	1122.71	1124.44	94877.0
2010-09-29 17:00:00	ES	Futures	1124.68	1124.68	1123.7	1123.94	1123.0
2010-09-29 18:00:00	ES	Futures	1124.19	1124.93	1123.94	1124.44	2365.0
2010-09-29 19:00:00	ES	Futures	1124.44	1124.68	1123.45	1123.94	1928.0
2010-09-29 20:00:00	ES	Futures	1123.7	1125.18	1123.45	1124.68	5076.0
2010-09-29 21:00:00	ES	Futures	1124.68	1125.18	1123.45	1123.7	5285.0
2010-09-29 22:00:00	ES	Futures	1123.94	1124.19	1122.22	1123.2	5297.0
2010-09-29 23:00:00	ES	Futures	1123.2	1123.94	1122.46	1122.96	3555.0
2010-09-29 00:00:00	NQ	Futures	2310.71	2311.57	2307.56	2308.13	233.0
2010-09-29 01:00:00	NQ	Futures	2308.13	2308.99	2304.97	2305.55	293.0
2010-09-29 02:00:00	NQ	Futures	2305.26	2311.86	2305.26	2311.57	660.0
2010-09-29 03:00:00	NQ	Futures	2311.29	2316.45	2302.97	2305.26	2939.0
2010-09-29 04:00:00	NQ	Futures	2305.26	2307.56	2297.8	2298.66	3410.0
2010-09-29 05:00:00	NQ	Futures	2298.38	2309.57	2298.38	2308.13	1589.0
2010-09-29 06:00:00	NQ	Futures	2308.13	2308.99	2302.68	2304.4	1189.0
2010-09-29 07:00:00	NQ	Futures	2304.69	2307.27	2302.39	2306.98	1635.0
2010-09-29 08:00:00	NQ	Futures	2307.27	2310.71	2302.11	2302.39	5295.0
2010-09-29 09:00:00	NQ	Futures	2302.39	2313.01	2297.8	2303.25	45288.0
2010-09-29 10:00:00	NQ	Futures	2302.97	2311.57	2294.07	2298.95	47486.0
2010-09-29 11:00:00	NQ	Futures	2298.95	2307.84	2298.38	2305.26	36859.0
2010-09-29 12:00:00	NQ	Futures	2305.26	2309.28	2301.82	2304.97	24383.0
2010-09-29 13:00:00	NQ	Futures	2304.69	2306.7	2296.65	2304.97	27064.0
2010-09-29 14:00:00	NQ	Futures	2304.97	2309.28	2302.39	2308.13	18211.0
2010-09-29 15:00:00	NQ	Futures	2308.13	2308.42	2293.5	2301.53	48347.0
2010-09-29 16:00:00	NQ	Futures	2301.82	2306.7	2300.96	2304.4	7518.0
2010-09-29 17:00:00	NQ	Futures	2304.97	2305.26	2303.54	2304.69	43.0
2010-09-29 18:00:00	NQ	Futures	2304.69	2305.26	2302.97	2305.26	326.0
2010-09-29 19:00:00	NQ	Futures	2305.55	2305.55	2303.54	2304.11	152.0
2010-09-29 20:00:00	NQ	Futures	2303.83	2305.84	2303.54	2305.26	206.0
2010-09-29 21:00:00	NQ	Futures	2305.84	2306.12	2302.39	2302.39	237.0
2010-09-29 22:00:00	NQ	Futures	2302.97	2304.11	2300.96	2301.82	410.0
2010-09-29 23:00:00	NQ	Futures	2301.53	2303.25	2301.24	2302.11	97.0
2010-09-29 00:00:00	YM	Futures	10293.4	10296.3	10280.1	10281.0	223.0
2010-09-29 01:00:00	YM	Futures	10282.9	10284.8	10268.6	10271.5	183.0

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

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