PREVIEW / futures_1hour / 2011-07-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1312.62	1312.87	1310.38	1310.38	2509.0
2011-07-13 01:00:00	ES	Futures	1310.38	1313.12	1310.38	1312.37	5757.0
2011-07-13 02:00:00	ES	Futures	1312.37	1312.62	1310.63	1312.62	15333.0
2011-07-13 03:00:00	ES	Futures	1312.37	1316.36	1311.37	1314.37	52006.0
2011-07-13 04:00:00	ES	Futures	1314.37	1315.61	1312.87	1314.62	20262.0
2011-07-13 05:00:00	ES	Futures	1314.62	1318.61	1314.37	1317.61	36782.0
2011-07-13 06:00:00	ES	Futures	1317.61	1318.11	1314.12	1314.87	20258.0
2011-07-13 07:00:00	ES	Futures	1314.87	1316.61	1313.62	1313.87	32203.0
2011-07-13 08:00:00	ES	Futures	1314.12	1315.12	1311.12	1311.37	52411.0
2011-07-13 09:00:00	ES	Futures	1311.37	1315.61	1310.63	1311.62	227356.0
2011-07-13 10:00:00	ES	Futures	1311.37	1323.6	1311.12	1323.1	521566.0
2011-07-13 11:00:00	ES	Futures	1322.85	1324.59	1320.6	1321.6	268514.0
2011-07-13 12:00:00	ES	Futures	1321.6	1323.35	1320.6	1321.6	149400.0
2011-07-13 13:00:00	ES	Futures	1321.6	1321.85	1317.61	1318.11	148056.0
2011-07-13 14:00:00	ES	Futures	1318.36	1319.36	1314.37	1316.36	187326.0
2011-07-13 15:00:00	ES	Futures	1316.36	1318.36	1307.38	1310.63	419033.0
2011-07-13 16:00:00	ES	Futures	1310.63	1311.12	1308.88	1309.38	101075.0
2011-07-13 17:00:00	ES	Futures	1309.38	1309.38	1299.15	1300.65	45951.0
2011-07-13 18:00:00	ES	Futures	1301.4	1306.14	1301.4	1305.39	17027.0
2011-07-13 19:00:00	ES	Futures	1305.39	1306.14	1302.65	1305.14	9378.0
2011-07-13 20:00:00	ES	Futures	1304.89	1306.89	1302.89	1306.39	12072.0
2011-07-13 21:00:00	ES	Futures	1306.39	1307.38	1304.89	1305.14	7789.0
2011-07-13 22:00:00	ES	Futures	1304.89	1306.89	1304.64	1305.89	3275.0
2011-07-13 23:00:00	ES	Futures	1305.64	1306.39	1302.89	1302.89	3947.0
2011-07-13 00:00:00	NQ	Futures	2708.16	2708.16	2701.83	2701.83	265.0
2011-07-13 01:00:00	NQ	Futures	2701.54	2709.89	2701.54	2708.73	536.0
2011-07-13 02:00:00	NQ	Futures	2708.16	2709.31	2706.43	2709.31	2022.0
2011-07-13 03:00:00	NQ	Futures	2709.02	2718.52	2707.87	2716.22	5027.0
2011-07-13 04:00:00	NQ	Futures	2716.22	2719.67	2715.07	2718.52	2738.0
2011-07-13 05:00:00	NQ	Futures	2718.23	2723.41	2717.08	2721.97	2977.0
2011-07-13 06:00:00	NQ	Futures	2721.68	2722.55	2714.78	2715.93	2191.0
2011-07-13 07:00:00	NQ	Futures	2715.93	2720.25	2714.49	2716.22	4930.0
2011-07-13 08:00:00	NQ	Futures	2716.22	2716.79	2710.75	2711.61	6101.0
2011-07-13 09:00:00	NQ	Futures	2711.9	2719.96	2705.57	2707.87	33974.0
2011-07-13 10:00:00	NQ	Futures	2707.58	2733.77	2707.01	2732.33	56070.0
2011-07-13 11:00:00	NQ	Futures	2732.62	2733.48	2727.15	2729.17	23237.0
2011-07-13 12:00:00	NQ	Futures	2729.45	2731.76	2725.71	2727.15	20381.0
2011-07-13 13:00:00	NQ	Futures	2727.15	2728.01	2718.52	2719.96	20261.0
2011-07-13 14:00:00	NQ	Futures	2719.96	2723.12	2713.05	2717.08	22365.0
2011-07-13 15:00:00	NQ	Futures	2717.08	2720.82	2696.07	2705.57	51320.0
2011-07-13 16:00:00	NQ	Futures	2705.57	2707.3	2698.09	2700.39	8649.0
2011-07-13 17:00:00	NQ	Futures	2700.1	2700.1	2679.96	2681.68	2547.0
2011-07-13 18:00:00	NQ	Futures	2683.12	2691.76	2683.12	2690.61	822.0
2011-07-13 19:00:00	NQ	Futures	2690.61	2691.47	2686.58	2690.89	534.0
2011-07-13 20:00:00	NQ	Futures	2690.89	2693.2	2687.44	2693.2	965.0
2011-07-13 21:00:00	NQ	Futures	2693.2	2695.5	2690.61	2690.89	859.0
2011-07-13 22:00:00	NQ	Futures	2691.18	2695.21	2690.03	2692.91	382.0
2011-07-13 23:00:00	NQ	Futures	2692.62	2693.2	2687.73	2688.02	398.0
2011-07-13 00:00:00	YM	Futures	12063.4	12064.3	12043.0	12045.0	156.0
2011-07-13 01:00:00	YM	Futures	12045.9	12063.4	12045.0	12059.5	197.0

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

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