PREVIEW / futures_1hour / 2011-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-18.parquet
  size:    50 KB
  rows:    1,488

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-10-18 00:00:00	ES	Futures	1199.88	1200.13	1198.12	1198.37	3831.0
2011-10-18 01:00:00	ES	Futures	1198.12	1199.38	1195.87	1199.12	5695.0
2011-10-18 02:00:00	ES	Futures	1199.12	1199.38	1195.36	1195.61	11130.0
2011-10-18 03:00:00	ES	Futures	1195.61	1197.12	1190.85	1194.11	49781.0
2011-10-18 04:00:00	ES	Futures	1194.36	1198.37	1193.61	1196.62	38126.0
2011-10-18 05:00:00	ES	Futures	1196.87	1198.62	1192.35	1196.12	41725.0
2011-10-18 06:00:00	ES	Futures	1196.37	1197.87	1194.11	1196.87	20809.0
2011-10-18 07:00:00	ES	Futures	1196.87	1198.12	1189.09	1191.1	65625.0
2011-10-18 08:00:00	ES	Futures	1190.85	1197.62	1190.35	1195.87	86792.0
2011-10-18 09:00:00	ES	Futures	1195.87	1202.64	1190.85	1193.61	344512.0
2011-10-18 10:00:00	ES	Futures	1193.61	1207.15	1189.85	1204.39	483999.0
2011-10-18 11:00:00	ES	Futures	1204.39	1211.41	1200.38	1209.91	324189.0
2011-10-18 12:00:00	ES	Futures	1209.91	1214.42	1207.65	1213.17	194623.0
2011-10-18 13:00:00	ES	Futures	1213.42	1214.92	1209.16	1213.17	143007.0
2011-10-18 14:00:00	ES	Futures	1213.17	1216.93	1212.16	1215.17	168193.0
2011-10-18 15:00:00	ES	Futures	1214.92	1233.48	1214.92	1223.95	818677.0
2011-10-18 16:00:00	ES	Futures	1224.2	1227.71	1219.19	1220.69	146645.0
2011-10-18 17:00:00	ES	Futures	1220.44	1221.94	1219.19	1220.19	9549.0
2011-10-18 18:00:00	ES	Futures	1220.19	1222.95	1218.93	1221.19	8832.0
2011-10-18 19:00:00	ES	Futures	1221.44	1221.94	1220.44	1220.44	3474.0
2011-10-18 20:00:00	ES	Futures	1220.19	1221.94	1219.19	1220.19	7352.0
2011-10-18 21:00:00	ES	Futures	1220.19	1222.7	1219.44	1219.69	6002.0
2011-10-18 22:00:00	ES	Futures	1219.69	1223.2	1219.19	1222.45	5615.0
2011-10-18 23:00:00	ES	Futures	1222.45	1223.7	1220.69	1221.69	5700.0
2011-10-18 00:00:00	NQ	Futures	2685.15	2685.72	2681.69	2682.26	252.0
2011-10-18 01:00:00	NQ	Futures	2682.26	2684.86	2677.65	2684.57	569.0
2011-10-18 02:00:00	NQ	Futures	2684.57	2685.72	2676.21	2677.36	1019.0
2011-10-18 03:00:00	NQ	Futures	2677.94	2679.96	2670.44	2677.36	3651.0
2011-10-18 04:00:00	NQ	Futures	2677.65	2687.74	2674.19	2686.01	5420.0
2011-10-18 05:00:00	NQ	Futures	2686.3	2690.05	2677.07	2686.59	4503.0
2011-10-18 06:00:00	NQ	Futures	2686.59	2690.34	2681.98	2687.45	2260.0
2011-10-18 07:00:00	NQ	Futures	2688.03	2690.34	2669.87	2673.61	5677.0
2011-10-18 08:00:00	NQ	Futures	2673.61	2687.74	2671.88	2684.86	8417.0
2011-10-18 09:00:00	NQ	Futures	2684.86	2694.95	2662.08	2669.87	51093.0
2011-10-18 10:00:00	NQ	Futures	2670.15	2691.49	2658.04	2687.17	61402.0
2011-10-18 11:00:00	NQ	Futures	2687.17	2706.19	2678.52	2702.16	46775.0
2011-10-18 12:00:00	NQ	Futures	2702.16	2706.19	2694.09	2700.72	27728.0
2011-10-18 13:00:00	NQ	Futures	2701.0	2707.35	2691.2	2702.16	32777.0
2011-10-18 14:00:00	NQ	Futures	2702.16	2706.19	2696.68	2701.29	20267.0
2011-10-18 15:00:00	NQ	Futures	2701.29	2735.03	2701.0	2719.46	92722.0
2011-10-18 16:00:00	NQ	Futures	2720.03	2731.28	2695.53	2700.43	22655.0
2011-10-18 17:00:00	NQ	Futures	2701.0	2703.89	2697.83	2698.99	1596.0
2011-10-18 18:00:00	NQ	Futures	2700.14	2703.6	2696.68	2699.27	916.0
2011-10-18 19:00:00	NQ	Futures	2699.27	2701.58	2698.7	2700.14	454.0
2011-10-18 20:00:00	NQ	Futures	2700.14	2702.16	2696.39	2697.26	643.0
2011-10-18 21:00:00	NQ	Futures	2696.97	2702.16	2696.97	2698.12	603.0
2011-10-18 22:00:00	NQ	Futures	2697.83	2703.31	2697.55	2701.87	481.0
2011-10-18 23:00:00	NQ	Futures	2702.45	2703.31	2697.26	2700.14	620.0
2011-10-18 00:00:00	YM	Futures	11130.5	11135.4	11120.6	11120.6	349.0
2011-10-18 01:00:00	YM	Futures	11120.6	11126.5	11103.9	11123.6	574.0

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

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