PREVIEW / futures_1hour / 2011-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-18.parquet
  size:    48 KB
  rows:    1,453

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-07-18 00:00:00	ES	Futures	1304.64	1306.14	1304.39	1306.14	1551.0
2011-07-18 01:00:00	ES	Futures	1306.14	1306.64	1304.39	1304.89	2863.0
2011-07-18 02:00:00	ES	Futures	1305.14	1305.39	1302.15	1303.64	14623.0
2011-07-18 03:00:00	ES	Futures	1303.64	1306.14	1300.4	1302.65	56426.0
2011-07-18 04:00:00	ES	Futures	1302.65	1305.39	1301.9	1304.14	21931.0
2011-07-18 05:00:00	ES	Futures	1304.39	1304.89	1302.15	1302.15	17782.0
2011-07-18 06:00:00	ES	Futures	1302.4	1303.14	1300.4	1301.65	21279.0
2011-07-18 07:00:00	ES	Futures	1301.65	1303.89	1298.41	1302.65	57190.0
2011-07-18 08:00:00	ES	Futures	1302.65	1303.89	1301.9	1303.64	43142.0
2011-07-18 09:00:00	ES	Futures	1303.64	1305.14	1298.41	1299.9	264047.0
2011-07-18 10:00:00	ES	Futures	1299.9	1300.9	1291.17	1292.92	469512.0
2011-07-18 11:00:00	ES	Futures	1293.17	1295.16	1288.18	1289.43	258190.0
2011-07-18 12:00:00	ES	Futures	1289.18	1292.92	1288.68	1292.42	149274.0
2011-07-18 13:00:00	ES	Futures	1292.17	1295.91	1289.93	1295.66	134879.0
2011-07-18 14:00:00	ES	Futures	1295.66	1296.66	1292.42	1296.41	155092.0
2011-07-18 15:00:00	ES	Futures	1296.41	1298.65	1294.17	1297.91	354796.0
2011-07-18 16:00:00	ES	Futures	1297.91	1300.15	1295.41	1298.41	95907.0
2011-07-18 17:00:00	ES	Futures	1298.41	1298.65	1297.41	1298.16	3153.0
2011-07-18 18:00:00	ES	Futures	1297.91	1298.16	1297.16	1297.41	2683.0
2011-07-18 19:00:00	ES	Futures	1297.41	1299.9	1297.41	1299.65	3893.0
2011-07-18 20:00:00	ES	Futures	1299.4	1300.9	1298.65	1300.4	7105.0
2011-07-18 21:00:00	ES	Futures	1300.65	1301.65	1299.15	1299.9	7527.0
2011-07-18 22:00:00	ES	Futures	1299.65	1300.65	1299.4	1299.9	2138.0
2011-07-18 23:00:00	ES	Futures	1299.9	1302.15	1298.9	1301.4	3792.0
2011-07-18 00:00:00	NQ	Futures	2697.51	2700.1	2697.22	2700.1	109.0
2011-07-18 01:00:00	NQ	Futures	2700.39	2700.68	2697.51	2698.38	207.0
2011-07-18 02:00:00	NQ	Futures	2698.38	2698.66	2692.33	2694.35	1090.0
2011-07-18 03:00:00	NQ	Futures	2694.63	2698.66	2687.15	2691.47	4001.0
2011-07-18 04:00:00	NQ	Futures	2691.47	2696.36	2690.03	2694.35	1674.0
2011-07-18 05:00:00	NQ	Futures	2694.63	2695.5	2689.45	2689.45	2090.0
2011-07-18 06:00:00	NQ	Futures	2689.45	2691.47	2686.0	2688.59	1704.0
2011-07-18 07:00:00	NQ	Futures	2688.88	2694.35	2683.12	2691.76	5737.0
2011-07-18 08:00:00	NQ	Futures	2692.04	2697.51	2691.76	2695.79	5934.0
2011-07-18 09:00:00	NQ	Futures	2696.07	2707.01	2691.47	2694.06	36582.0
2011-07-18 10:00:00	NQ	Futures	2694.06	2699.53	2675.07	2679.38	52831.0
2011-07-18 11:00:00	NQ	Futures	2679.38	2685.14	2669.02	2671.61	32034.0
2011-07-18 12:00:00	NQ	Futures	2671.33	2678.81	2669.02	2677.37	14901.0
2011-07-18 13:00:00	NQ	Futures	2677.37	2686.29	2672.48	2685.43	16988.0
2011-07-18 14:00:00	NQ	Futures	2685.43	2690.03	2680.53	2689.74	20951.0
2011-07-18 15:00:00	NQ	Futures	2689.74	2695.79	2687.15	2694.92	39394.0
2011-07-18 16:00:00	NQ	Futures	2694.63	2704.71	2689.45	2696.94	8192.0
2011-07-18 17:00:00	NQ	Futures	2696.94	2696.94	2693.77	2695.21	295.0
2011-07-18 18:00:00	NQ	Futures	2694.63	2695.21	2692.33	2692.62	343.0
2011-07-18 19:00:00	NQ	Futures	2692.62	2697.51	2692.33	2696.94	198.0
2011-07-18 20:00:00	NQ	Futures	2696.94	2701.25	2696.36	2700.39	503.0
2011-07-18 21:00:00	NQ	Futures	2700.96	2702.69	2697.8	2698.66	452.0
2011-07-18 22:00:00	NQ	Futures	2698.95	2700.1	2698.09	2698.95	100.0
2011-07-18 23:00:00	NQ	Futures	2698.95	2702.4	2697.22	2701.25	199.0
2011-07-18 00:00:00	YM	Futures	11997.5	12011.1	11994.6	12009.1	112.0
2011-07-18 01:00:00	YM	Futures	12011.1	12012.0	11995.6	12001.4	126.0

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

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