PREVIEW / futures_1hour / 2011-07-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	1320.1	1321.35	1319.85	1321.35	1737.0
2011-07-20 01:00:00	ES	Futures	1321.35	1321.35	1319.6	1320.85	4430.0
2011-07-20 02:00:00	ES	Futures	1320.85	1322.35	1320.6	1321.6	14424.0
2011-07-20 03:00:00	ES	Futures	1321.6	1322.35	1319.6	1321.85	32313.0
2011-07-20 04:00:00	ES	Futures	1322.1	1323.84	1321.1	1321.85	27344.0
2011-07-20 05:00:00	ES	Futures	1321.6	1323.84	1319.11	1323.35	41631.0
2011-07-20 06:00:00	ES	Futures	1323.35	1326.09	1322.35	1325.34	35455.0
2011-07-20 07:00:00	ES	Futures	1325.09	1326.59	1324.09	1324.59	41064.0
2011-07-20 08:00:00	ES	Futures	1324.84	1325.59	1323.6	1324.34	50523.0
2011-07-20 09:00:00	ES	Futures	1324.09	1325.09	1317.61	1319.36	268251.0
2011-07-20 10:00:00	ES	Futures	1319.11	1321.6	1316.11	1320.1	316207.0
2011-07-20 11:00:00	ES	Futures	1320.1	1321.85	1317.36	1318.11	200435.0
2011-07-20 12:00:00	ES	Futures	1318.11	1319.36	1317.11	1318.86	114923.0
2011-07-20 13:00:00	ES	Futures	1318.86	1322.1	1318.11	1321.6	89565.0
2011-07-20 14:00:00	ES	Futures	1321.6	1322.85	1319.36	1320.6	104968.0
2011-07-20 15:00:00	ES	Futures	1320.6	1321.85	1317.36	1318.36	178767.0
2011-07-20 16:00:00	ES	Futures	1318.61	1319.85	1313.87	1314.12	76210.0
2011-07-20 17:00:00	ES	Futures	1314.37	1314.87	1313.37	1313.37	3092.0
2011-07-20 18:00:00	ES	Futures	1313.62	1321.35	1312.62	1320.6	19369.0
2011-07-20 19:00:00	ES	Futures	1320.6	1322.6	1320.1	1320.85	13247.0
2011-07-20 20:00:00	ES	Futures	1320.85	1321.35	1318.86	1318.86	12414.0
2011-07-20 21:00:00	ES	Futures	1319.11	1321.35	1318.36	1319.85	9215.0
2011-07-20 22:00:00	ES	Futures	1319.85	1320.1	1317.61	1317.86	4934.0
2011-07-20 23:00:00	ES	Futures	1317.86	1319.6	1317.36	1319.11	2096.0
2011-07-20 00:00:00	NQ	Futures	2768.3	2770.6	2768.01	2769.17	159.0
2011-07-20 01:00:00	NQ	Futures	2768.88	2769.17	2766.29	2768.88	313.0
2011-07-20 02:00:00	NQ	Futures	2768.59	2770.89	2767.44	2769.45	1061.0
2011-07-20 03:00:00	NQ	Futures	2769.17	2773.19	2765.42	2771.18	4001.0
2011-07-20 04:00:00	NQ	Futures	2770.89	2774.35	2769.17	2770.32	2545.0
2011-07-20 05:00:00	NQ	Futures	2769.74	2773.19	2766.0	2772.33	4554.0
2011-07-20 06:00:00	NQ	Futures	2772.33	2778.09	2770.32	2776.07	3853.0
2011-07-20 07:00:00	NQ	Futures	2776.07	2777.22	2773.48	2774.92	5385.0
2011-07-20 08:00:00	NQ	Futures	2774.63	2775.21	2772.04	2773.48	5139.0
2011-07-20 09:00:00	NQ	Futures	2773.19	2775.21	2751.9	2756.79	49171.0
2011-07-20 10:00:00	NQ	Futures	2755.93	2758.52	2744.99	2755.93	40159.0
2011-07-20 11:00:00	NQ	Futures	2755.64	2759.38	2742.98	2743.55	25745.0
2011-07-20 12:00:00	NQ	Futures	2743.84	2747.3	2740.68	2745.57	21076.0
2011-07-20 13:00:00	NQ	Futures	2745.57	2756.22	2743.84	2754.49	14664.0
2011-07-20 14:00:00	NQ	Futures	2754.2	2755.93	2745.86	2748.73	21820.0
2011-07-20 15:00:00	NQ	Futures	2748.73	2752.76	2742.98	2744.99	29559.0
2011-07-20 16:00:00	NQ	Futures	2744.71	2749.89	2728.01	2728.88	9199.0
2011-07-20 17:00:00	NQ	Futures	2728.88	2732.33	2728.3	2728.59	756.0
2011-07-20 18:00:00	NQ	Futures	2728.88	2734.63	2722.26	2732.33	1525.0
2011-07-20 19:00:00	NQ	Futures	2732.62	2738.95	2732.33	2734.92	1056.0
2011-07-20 20:00:00	NQ	Futures	2735.5	2737.22	2731.76	2732.62	938.0
2011-07-20 21:00:00	NQ	Futures	2731.76	2737.22	2730.89	2735.21	583.0
2011-07-20 22:00:00	NQ	Futures	2734.63	2734.92	2730.03	2730.03	318.0
2011-07-20 23:00:00	NQ	Futures	2730.32	2734.92	2729.74	2734.63	337.0
2011-07-20 00:00:00	YM	Futures	12130.2	12136.9	12129.2	12136.0	112.0
2011-07-20 01:00:00	YM	Futures	12136.0	12136.0	12125.3	12134.0	343.0

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

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