PREVIEW / futures_1hour / 2011-07-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	1324.59	1325.34	1323.84	1323.84	2272.0
2011-07-27 01:00:00	ES	Futures	1323.84	1324.84	1323.35	1324.59	3794.0
2011-07-27 02:00:00	ES	Futures	1324.34	1324.84	1323.1	1324.09	7673.0
2011-07-27 03:00:00	ES	Futures	1324.09	1324.59	1321.35	1322.35	44297.0
2011-07-27 04:00:00	ES	Futures	1322.1	1324.09	1321.6	1323.1	18739.0
2011-07-27 05:00:00	ES	Futures	1323.1	1325.09	1322.35	1323.6	11364.0
2011-07-27 06:00:00	ES	Futures	1323.6	1323.6	1321.6	1322.1	11702.0
2011-07-27 07:00:00	ES	Futures	1322.1	1323.1	1320.35	1320.35	25409.0
2011-07-27 08:00:00	ES	Futures	1320.6	1320.85	1315.61	1317.11	113544.0
2011-07-27 09:00:00	ES	Futures	1316.86	1319.36	1312.37	1312.62	270459.0
2011-07-27 10:00:00	ES	Futures	1312.62	1313.37	1304.14	1309.63	522907.0
2011-07-27 11:00:00	ES	Futures	1309.63	1313.12	1307.38	1308.13	322599.0
2011-07-27 12:00:00	ES	Futures	1308.13	1309.63	1306.39	1306.64	172529.0
2011-07-27 13:00:00	ES	Futures	1306.64	1308.38	1305.14	1307.63	135418.0
2011-07-27 14:00:00	ES	Futures	1307.38	1307.88	1299.65	1301.4	250850.0
2011-07-27 15:00:00	ES	Futures	1301.4	1302.65	1296.16	1298.16	434795.0
2011-07-27 16:00:00	ES	Futures	1298.41	1298.41	1294.91	1297.41	161242.0
2011-07-27 17:00:00	ES	Futures	1297.41	1297.66	1295.91	1296.16	4089.0
2011-07-27 18:00:00	ES	Futures	1295.66	1298.16	1295.66	1298.16	5976.0
2011-07-27 19:00:00	ES	Futures	1298.16	1298.41	1294.91	1295.41	6447.0
2011-07-27 20:00:00	ES	Futures	1295.66	1299.65	1295.16	1298.41	10720.0
2011-07-27 21:00:00	ES	Futures	1298.65	1298.9	1296.91	1297.91	3950.0
2011-07-27 22:00:00	ES	Futures	1298.16	1298.65	1296.66	1297.66	3119.0
2011-07-27 23:00:00	ES	Futures	1297.41	1300.4	1297.16	1299.65	4240.0
2011-07-27 00:00:00	NQ	Futures	2791.04	2792.19	2789.6	2789.88	73.0
2011-07-27 01:00:00	NQ	Futures	2789.6	2791.61	2788.45	2790.75	113.0
2011-07-27 02:00:00	NQ	Futures	2790.46	2791.04	2787.87	2789.88	297.0
2011-07-27 03:00:00	NQ	Futures	2790.46	2791.04	2781.83	2783.27	3558.0
2011-07-27 04:00:00	NQ	Futures	2783.55	2788.45	2782.98	2786.14	1853.0
2011-07-27 05:00:00	NQ	Futures	2786.43	2791.04	2784.7	2786.43	1825.0
2011-07-27 06:00:00	NQ	Futures	2786.43	2787.58	2784.99	2786.43	1401.0
2011-07-27 07:00:00	NQ	Futures	2786.72	2788.73	2782.98	2783.27	2025.0
2011-07-27 08:00:00	NQ	Futures	2783.55	2784.13	2770.32	2771.76	10783.0
2011-07-27 09:00:00	NQ	Futures	2772.04	2778.09	2759.09	2761.11	44292.0
2011-07-27 10:00:00	NQ	Futures	2760.82	2760.82	2730.89	2748.16	71589.0
2011-07-27 11:00:00	NQ	Futures	2747.87	2758.52	2743.55	2745.86	37087.0
2011-07-27 12:00:00	NQ	Futures	2745.86	2748.45	2740.39	2742.12	21645.0
2011-07-27 13:00:00	NQ	Futures	2742.4	2747.01	2737.22	2742.69	17560.0
2011-07-27 14:00:00	NQ	Futures	2742.69	2743.55	2722.55	2729.74	37735.0
2011-07-27 15:00:00	NQ	Futures	2730.03	2732.62	2714.49	2721.97	60983.0
2011-07-27 16:00:00	NQ	Futures	2721.97	2722.55	2715.35	2717.94	13321.0
2011-07-27 17:00:00	NQ	Futures	2717.94	2718.52	2715.35	2715.35	241.0
2011-07-27 18:00:00	NQ	Futures	2717.08	2718.81	2715.64	2718.52	429.0
2011-07-27 19:00:00	NQ	Futures	2718.23	2718.81	2712.19	2712.76	504.0
2011-07-27 20:00:00	NQ	Futures	2712.76	2721.97	2712.48	2719.67	682.0
2011-07-27 21:00:00	NQ	Futures	2719.67	2719.96	2716.5	2718.23	332.0
2011-07-27 22:00:00	NQ	Futures	2717.94	2719.38	2715.93	2717.66	184.0
2011-07-27 23:00:00	NQ	Futures	2717.94	2723.99	2716.79	2722.26	437.0
2011-07-27 00:00:00	YM	Futures	12059.5	12064.3	12056.6	12057.5	116.0
2011-07-27 01:00:00	YM	Futures	12056.6	12061.4	12050.8	12057.5	336.0

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

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