PREVIEW / futures_1hour / 2011-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-14.parquet
  size:    48 KB
  rows:    1,444

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
2011-06-14 00:00:00	ES	Futures	1270.97	1271.97	1270.47	1271.72	2565.0
2011-06-14 01:00:00	ES	Futures	1271.47	1273.22	1271.22	1271.47	7475.0
2011-06-14 02:00:00	ES	Futures	1271.47	1273.22	1271.47	1272.47	11125.0
2011-06-14 03:00:00	ES	Futures	1272.22	1275.46	1271.47	1272.47	42424.0
2011-06-14 04:00:00	ES	Futures	1272.47	1275.71	1272.47	1274.46	28773.0
2011-06-14 05:00:00	ES	Futures	1274.46	1275.46	1272.72	1273.71	20398.0
2011-06-14 06:00:00	ES	Futures	1273.96	1273.96	1270.22	1270.97	24109.0
2011-06-14 07:00:00	ES	Futures	1270.97	1272.72	1270.47	1272.22	34220.0
2011-06-14 08:00:00	ES	Futures	1272.47	1277.46	1271.97	1276.71	89853.0
2011-06-14 09:00:00	ES	Futures	1276.96	1278.7	1274.46	1277.7	289195.0
2011-06-14 10:00:00	ES	Futures	1277.46	1280.7	1276.46	1279.45	335482.0
2011-06-14 11:00:00	ES	Futures	1279.45	1280.2	1277.46	1280.2	170119.0
2011-06-14 12:00:00	ES	Futures	1280.2	1281.94	1278.45	1281.2	158908.0
2011-06-14 13:00:00	ES	Futures	1280.95	1283.44	1279.95	1281.2	174968.0
2011-06-14 14:00:00	ES	Futures	1280.95	1283.19	1280.2	1282.69	137040.0
2011-06-14 15:00:00	ES	Futures	1282.69	1283.94	1277.95	1279.45	352247.0
2011-06-14 16:00:00	ES	Futures	1279.45	1281.94	1278.95	1279.95	136278.0
2011-06-14 17:00:00	ES	Futures	1279.95	1280.45	1279.7	1279.95	2565.0
2011-06-14 18:00:00	ES	Futures	1279.95	1280.7	1279.2	1280.2	4472.0
2011-06-14 19:00:00	ES	Futures	1280.2	1280.45	1278.95	1279.45	3994.0
2011-06-14 20:00:00	ES	Futures	1279.2	1279.45	1278.45	1279.2	5071.0
2011-06-14 21:00:00	ES	Futures	1279.2	1279.7	1277.7	1277.95	6443.0
2011-06-14 22:00:00	ES	Futures	1278.2	1278.45	1276.21	1276.96	8879.0
2011-06-14 23:00:00	ES	Futures	1276.71	1277.7	1275.96	1276.71	5071.0
2011-06-14 00:00:00	NQ	Futures	2569.46	2570.61	2568.59	2570.32	192.0
2011-06-14 01:00:00	NQ	Futures	2570.03	2572.62	2569.74	2570.32	644.0
2011-06-14 02:00:00	NQ	Futures	2570.32	2572.62	2570.03	2571.18	780.0
2011-06-14 03:00:00	NQ	Futures	2570.9	2575.5	2568.31	2570.03	2975.0
2011-06-14 04:00:00	NQ	Futures	2570.32	2575.5	2570.32	2572.91	2737.0
2011-06-14 05:00:00	NQ	Futures	2573.2	2575.5	2570.32	2571.76	1027.0
2011-06-14 06:00:00	NQ	Futures	2572.05	2572.05	2565.72	2566.0	1696.0
2011-06-14 07:00:00	NQ	Futures	2566.0	2570.03	2566.0	2569.74	3063.0
2011-06-14 08:00:00	NQ	Futures	2569.74	2580.1	2569.17	2578.95	7914.0
2011-06-14 09:00:00	NQ	Futures	2578.66	2582.98	2571.47	2581.25	48463.0
2011-06-14 10:00:00	NQ	Futures	2580.97	2589.89	2579.82	2588.16	32533.0
2011-06-14 11:00:00	NQ	Futures	2588.16	2588.74	2583.84	2586.72	19822.0
2011-06-14 12:00:00	NQ	Futures	2586.43	2588.74	2584.71	2586.72	23368.0
2011-06-14 13:00:00	NQ	Futures	2586.72	2592.48	2584.13	2589.31	22619.0
2011-06-14 14:00:00	NQ	Futures	2589.31	2592.19	2587.3	2590.46	21990.0
2011-06-14 15:00:00	NQ	Futures	2590.75	2593.05	2585.0	2585.86	30519.0
2011-06-14 16:00:00	NQ	Futures	2585.86	2588.45	2582.98	2584.71	11145.0
2011-06-14 17:00:00	NQ	Futures	2584.42	2585.57	2584.42	2584.71	91.0
2011-06-14 18:00:00	NQ	Futures	2585.57	2585.86	2584.13	2585.0	141.0
2011-06-14 19:00:00	NQ	Futures	2584.71	2585.0	2582.98	2583.27	412.0
2011-06-14 20:00:00	NQ	Futures	2583.27	2583.27	2581.83	2582.98	113.0
2011-06-14 21:00:00	NQ	Futures	2583.27	2583.27	2580.39	2580.97	293.0
2011-06-14 22:00:00	NQ	Futures	2581.25	2581.83	2577.8	2578.66	729.0
2011-06-14 23:00:00	NQ	Futures	2578.95	2579.82	2577.23	2577.51	269.0
2011-06-14 00:00:00	YM	Futures	11570.4	11578.2	11567.5	11574.3	244.0
2011-06-14 01:00:00	YM	Futures	11574.3	11585.0	11571.4	11576.2	627.0

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

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