PREVIEW / futures_1hour / 2011-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-19.parquet
  size:    50 KB
  rows:    1,482

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-19 00:00:00	ES	Futures	1301.4	1303.64	1300.9	1302.65	6477.0
2011-07-19 01:00:00	ES	Futures	1302.65	1303.14	1299.9	1300.15	4741.0
2011-07-19 02:00:00	ES	Futures	1300.4	1302.65	1299.15	1301.9	11440.0
2011-07-19 03:00:00	ES	Futures	1302.15	1305.64	1300.9	1304.89	50106.0
2011-07-19 04:00:00	ES	Futures	1305.14	1306.64	1303.89	1305.89	23244.0
2011-07-19 05:00:00	ES	Futures	1305.64	1308.38	1304.14	1305.14	29183.0
2011-07-19 06:00:00	ES	Futures	1304.89	1307.38	1304.89	1305.89	11321.0
2011-07-19 07:00:00	ES	Futures	1305.89	1307.38	1304.64	1306.39	23937.0
2011-07-19 08:00:00	ES	Futures	1306.64	1307.88	1302.15	1305.39	125576.0
2011-07-19 09:00:00	ES	Futures	1305.14	1311.37	1303.64	1309.88	313195.0
2011-07-19 10:00:00	ES	Futures	1309.88	1313.12	1309.38	1311.37	255978.0
2011-07-19 11:00:00	ES	Futures	1311.62	1311.62	1307.13	1308.38	257324.0
2011-07-19 12:00:00	ES	Futures	1308.63	1311.37	1308.13	1310.38	125510.0
2011-07-19 13:00:00	ES	Futures	1310.38	1318.36	1308.13	1316.11	238786.0
2011-07-19 14:00:00	ES	Futures	1316.36	1320.35	1314.37	1319.6	196876.0
2011-07-19 15:00:00	ES	Futures	1319.6	1321.1	1317.86	1319.6	276827.0
2011-07-19 16:00:00	ES	Futures	1319.36	1321.6	1317.86	1319.6	128161.0
2011-07-19 17:00:00	ES	Futures	1319.36	1320.1	1318.61	1319.85	3670.0
2011-07-19 18:00:00	ES	Futures	1319.85	1320.1	1318.86	1319.6	2438.0
2011-07-19 19:00:00	ES	Futures	1319.36	1320.85	1318.86	1320.85	3876.0
2011-07-19 20:00:00	ES	Futures	1320.85	1322.1	1319.85	1321.35	10911.0
2011-07-19 21:00:00	ES	Futures	1321.6	1323.35	1320.6	1322.35	7767.0
2011-07-19 22:00:00	ES	Futures	1322.35	1322.6	1320.35	1320.6	2861.0
2011-07-19 23:00:00	ES	Futures	1320.85	1321.1	1319.6	1320.1	2613.0
2011-07-19 00:00:00	NQ	Futures	2701.25	2703.84	2700.1	2702.4	391.0
2011-07-19 01:00:00	NQ	Futures	2702.4	2702.98	2697.22	2698.09	256.0
2011-07-19 02:00:00	NQ	Futures	2697.8	2702.12	2697.22	2700.68	678.0
2011-07-19 03:00:00	NQ	Futures	2700.96	2713.05	2698.66	2711.9	3911.0
2011-07-19 04:00:00	NQ	Futures	2712.19	2717.08	2710.17	2712.76	2063.0
2011-07-19 05:00:00	NQ	Futures	2712.76	2718.52	2708.73	2710.46	3033.0
2011-07-19 06:00:00	NQ	Futures	2710.75	2715.35	2710.75	2713.34	1487.0
2011-07-19 07:00:00	NQ	Futures	2713.34	2715.64	2711.04	2714.78	2018.0
2011-07-19 08:00:00	NQ	Futures	2714.78	2723.99	2708.45	2723.41	15525.0
2011-07-19 09:00:00	NQ	Futures	2723.7	2742.98	2718.52	2738.95	54040.0
2011-07-19 10:00:00	NQ	Futures	2738.95	2747.3	2737.51	2742.12	34119.0
2011-07-19 11:00:00	NQ	Futures	2742.4	2742.98	2734.35	2738.95	28682.0
2011-07-19 12:00:00	NQ	Futures	2739.24	2742.98	2736.65	2741.83	19789.0
2011-07-19 13:00:00	NQ	Futures	2741.83	2754.49	2736.07	2749.89	32276.0
2011-07-19 14:00:00	NQ	Futures	2749.89	2756.79	2746.72	2754.78	24403.0
2011-07-19 15:00:00	NQ	Futures	2755.06	2759.96	2751.32	2757.65	36953.0
2011-07-19 16:00:00	NQ	Futures	2757.65	2775.21	2748.73	2767.15	27129.0
2011-07-19 17:00:00	NQ	Futures	2767.15	2770.32	2766.86	2769.74	1100.0
2011-07-19 18:00:00	NQ	Futures	2769.45	2769.74	2766.58	2767.73	524.0
2011-07-19 19:00:00	NQ	Futures	2767.15	2769.17	2766.0	2769.17	321.0
2011-07-19 20:00:00	NQ	Futures	2769.17	2771.18	2767.73	2770.6	505.0
2011-07-19 21:00:00	NQ	Futures	2770.6	2772.62	2768.59	2770.32	587.0
2011-07-19 22:00:00	NQ	Futures	2770.6	2772.04	2769.45	2770.03	526.0
2011-07-19 23:00:00	NQ	Futures	2770.32	2771.18	2767.73	2768.59	233.0
2011-07-19 00:00:00	YM	Futures	11979.1	11998.5	11976.2	11990.7	350.0
2011-07-19 01:00:00	YM	Futures	11991.7	11994.6	11967.5	11969.4	642.0

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

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