PREVIEW / futures_1hour / 2011-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-14.parquet
  size:    49 KB
  rows:    1,486

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-14 00:00:00	ES	Futures	1302.89	1304.64	1302.89	1304.64	2757.0
2011-07-14 01:00:00	ES	Futures	1304.89	1306.14	1303.89	1305.39	7908.0
2011-07-14 02:00:00	ES	Futures	1305.64	1309.13	1305.39	1308.13	21230.0
2011-07-14 03:00:00	ES	Futures	1308.13	1312.87	1307.38	1311.62	45636.0
2011-07-14 04:00:00	ES	Futures	1311.62	1314.62	1311.12	1314.12	23921.0
2011-07-14 05:00:00	ES	Futures	1314.12	1315.36	1309.13	1309.38	39162.0
2011-07-14 06:00:00	ES	Futures	1309.13	1311.12	1307.38	1310.13	34683.0
2011-07-14 07:00:00	ES	Futures	1310.13	1314.37	1307.38	1312.87	75480.0
2011-07-14 08:00:00	ES	Futures	1312.62	1314.87	1311.12	1314.12	86413.0
2011-07-14 09:00:00	ES	Futures	1314.12	1319.36	1311.87	1318.61	255865.0
2011-07-14 10:00:00	ES	Futures	1318.86	1320.1	1309.63	1310.63	450811.0
2011-07-14 11:00:00	ES	Futures	1310.38	1312.87	1308.13	1310.13	339349.0
2011-07-14 12:00:00	ES	Futures	1310.13	1310.38	1303.39	1303.89	301622.0
2011-07-14 13:00:00	ES	Futures	1303.89	1309.13	1298.9	1307.13	454979.0
2011-07-14 14:00:00	ES	Futures	1307.13	1309.13	1302.4	1303.89	199018.0
2011-07-14 15:00:00	ES	Futures	1303.89	1305.39	1299.15	1301.65	322981.0
2011-07-14 16:00:00	ES	Futures	1301.9	1305.89	1301.4	1303.64	118057.0
2011-07-14 17:00:00	ES	Futures	1303.64	1304.64	1303.39	1304.39	2643.0
2011-07-14 18:00:00	ES	Futures	1304.64	1305.14	1303.64	1303.89	4066.0
2011-07-14 19:00:00	ES	Futures	1304.14	1304.89	1297.41	1301.15	23195.0
2011-07-14 20:00:00	ES	Futures	1300.9	1304.89	1300.9	1304.89	12659.0
2011-07-14 21:00:00	ES	Futures	1304.89	1305.14	1302.89	1304.39	5973.0
2011-07-14 22:00:00	ES	Futures	1304.39	1306.89	1304.14	1305.89	6851.0
2011-07-14 23:00:00	ES	Futures	1305.64	1305.89	1304.39	1304.89	2076.0
2011-07-14 00:00:00	NQ	Futures	2688.02	2691.47	2687.44	2691.47	165.0
2011-07-14 01:00:00	NQ	Futures	2691.76	2694.06	2690.89	2693.48	620.0
2011-07-14 02:00:00	NQ	Futures	2694.06	2700.96	2693.48	2698.66	1712.0
2011-07-14 03:00:00	NQ	Futures	2698.66	2708.73	2697.22	2707.01	4462.0
2011-07-14 04:00:00	NQ	Futures	2707.01	2713.91	2705.86	2713.05	2643.0
2011-07-14 05:00:00	NQ	Futures	2713.63	2717.08	2706.72	2707.01	4420.0
2011-07-14 06:00:00	NQ	Futures	2706.72	2709.02	2702.98	2707.87	4581.0
2011-07-14 07:00:00	NQ	Futures	2707.87	2715.35	2702.98	2712.48	5793.0
2011-07-14 08:00:00	NQ	Futures	2712.48	2715.07	2708.73	2714.2	7868.0
2011-07-14 09:00:00	NQ	Futures	2713.91	2723.7	2705.28	2723.12	39757.0
2011-07-14 10:00:00	NQ	Futures	2723.12	2726.0	2699.24	2700.39	48036.0
2011-07-14 11:00:00	NQ	Futures	2700.39	2706.43	2692.62	2697.22	40917.0
2011-07-14 12:00:00	NQ	Futures	2696.94	2697.22	2675.35	2675.64	35740.0
2011-07-14 13:00:00	NQ	Futures	2675.64	2685.71	2664.13	2682.26	52641.0
2011-07-14 14:00:00	NQ	Futures	2682.55	2686.86	2671.33	2674.2	26736.0
2011-07-14 15:00:00	NQ	Futures	2673.92	2681.11	2665.86	2674.2	38926.0
2011-07-14 16:00:00	NQ	Futures	2673.92	2692.91	2673.34	2690.03	23427.0
2011-07-14 17:00:00	NQ	Futures	2689.74	2692.33	2689.45	2691.18	186.0
2011-07-14 18:00:00	NQ	Futures	2691.76	2701.25	2690.32	2695.21	1129.0
2011-07-14 19:00:00	NQ	Futures	2694.63	2697.51	2683.99	2694.06	2485.0
2011-07-14 20:00:00	NQ	Futures	2693.48	2699.53	2692.91	2699.24	859.0
2011-07-14 21:00:00	NQ	Futures	2699.24	2699.81	2694.92	2697.8	321.0
2011-07-14 22:00:00	NQ	Futures	2698.66	2702.69	2698.09	2700.68	894.0
2011-07-14 23:00:00	NQ	Futures	2700.39	2702.12	2699.53	2699.81	618.0
2011-07-14 00:00:00	YM	Futures	11984.9	11998.5	11983.9	11996.5	164.0
2011-07-14 01:00:00	YM	Futures	11999.4	12003.3	11991.7	11998.5	326.0

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

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