PREVIEW / futures_1hour / 2011-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-23.parquet
  size:    50 KB
  rows:    1,484

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-06-23 00:00:00	ES	Futures	1271.97	1272.97	1271.97	1272.22	3221.0
2011-06-23 01:00:00	ES	Futures	1271.97	1273.96	1271.72	1272.22	6159.0
2011-06-23 02:00:00	ES	Futures	1272.22	1274.96	1272.22	1273.96	15967.0
2011-06-23 03:00:00	ES	Futures	1274.21	1274.71	1270.47	1273.22	47845.0
2011-06-23 04:00:00	ES	Futures	1273.22	1274.21	1271.22	1272.47	23217.0
2011-06-23 05:00:00	ES	Futures	1272.47	1272.97	1270.22	1271.72	24792.0
2011-06-23 06:00:00	ES	Futures	1271.72	1272.72	1269.22	1269.72	24561.0
2011-06-23 07:00:00	ES	Futures	1269.72	1270.97	1268.48	1268.48	45655.0
2011-06-23 08:00:00	ES	Futures	1268.48	1268.73	1260.25	1261.99	187369.0
2011-06-23 09:00:00	ES	Futures	1262.24	1265.23	1255.51	1259.25	440915.0
2011-06-23 10:00:00	ES	Futures	1259.25	1262.49	1254.01	1258.0	528925.0
2011-06-23 11:00:00	ES	Futures	1258.0	1261.74	1256.01	1260.74	274125.0
2011-06-23 12:00:00	ES	Futures	1260.99	1263.74	1258.25	1263.24	224087.0
2011-06-23 13:00:00	ES	Futures	1263.49	1267.73	1262.74	1265.23	260340.0
2011-06-23 14:00:00	ES	Futures	1265.23	1270.72	1258.5	1270.22	305210.0
2011-06-23 15:00:00	ES	Futures	1270.47	1276.21	1264.98	1275.46	734413.0
2011-06-23 16:00:00	ES	Futures	1275.46	1276.46	1272.47	1276.46	107156.0
2011-06-23 17:00:00	ES	Futures	1276.46	1276.96	1275.21	1275.71	4309.0
2011-06-23 18:00:00	ES	Futures	1275.96	1280.95	1275.96	1278.45	19747.0
2011-06-23 19:00:00	ES	Futures	1278.7	1278.95	1277.46	1277.7	2550.0
2011-06-23 20:00:00	ES	Futures	1277.95	1280.7	1277.46	1279.2	10030.0
2011-06-23 21:00:00	ES	Futures	1278.95	1280.45	1277.95	1278.95	7807.0
2011-06-23 22:00:00	ES	Futures	1278.95	1280.45	1278.95	1280.2	3818.0
2011-06-23 23:00:00	ES	Futures	1280.45	1280.7	1279.7	1279.95	3385.0
2011-06-23 00:00:00	NQ	Futures	2557.37	2559.1	2555.93	2557.66	1049.0
2011-06-23 01:00:00	NQ	Futures	2557.95	2559.96	2554.2	2555.64	954.0
2011-06-23 02:00:00	NQ	Futures	2555.36	2561.69	2555.36	2559.1	1252.0
2011-06-23 03:00:00	NQ	Futures	2559.38	2559.38	2551.9	2555.93	3629.0
2011-06-23 04:00:00	NQ	Futures	2555.64	2559.38	2553.34	2558.23	3491.0
2011-06-23 05:00:00	NQ	Futures	2558.23	2559.1	2555.07	2557.66	3653.0
2011-06-23 06:00:00	NQ	Futures	2557.66	2558.52	2552.77	2553.34	1715.0
2011-06-23 07:00:00	NQ	Futures	2553.34	2555.93	2550.46	2550.75	3235.0
2011-06-23 08:00:00	NQ	Futures	2551.04	2551.04	2538.67	2541.26	13855.0
2011-06-23 09:00:00	NQ	Futures	2541.26	2545.57	2531.76	2537.23	55894.0
2011-06-23 10:00:00	NQ	Futures	2537.51	2549.6	2531.76	2538.95	67835.0
2011-06-23 11:00:00	NQ	Futures	2539.24	2553.63	2536.08	2552.19	32894.0
2011-06-23 12:00:00	NQ	Futures	2552.48	2562.55	2550.75	2562.26	39408.0
2011-06-23 13:00:00	NQ	Futures	2562.55	2574.06	2561.69	2566.0	41944.0
2011-06-23 14:00:00	NQ	Futures	2566.29	2576.36	2552.48	2575.79	39636.0
2011-06-23 15:00:00	NQ	Futures	2576.07	2593.92	2567.73	2592.77	84866.0
2011-06-23 16:00:00	NQ	Futures	2592.48	2593.05	2574.35	2579.53	16424.0
2011-06-23 17:00:00	NQ	Futures	2580.1	2585.86	2578.38	2583.84	675.0
2011-06-23 18:00:00	NQ	Futures	2582.98	2591.61	2582.41	2587.01	780.0
2011-06-23 19:00:00	NQ	Futures	2587.01	2587.3	2584.71	2585.86	365.0
2011-06-23 20:00:00	NQ	Futures	2585.57	2591.61	2585.28	2587.87	774.0
2011-06-23 21:00:00	NQ	Futures	2588.45	2590.46	2585.28	2588.45	401.0
2011-06-23 22:00:00	NQ	Futures	2588.16	2591.04	2588.16	2589.89	188.0
2011-06-23 23:00:00	NQ	Futures	2590.18	2591.33	2589.89	2590.46	196.0
2011-06-23 00:00:00	YM	Futures	11615.0	11620.8	11612.1	11615.0	251.0
2011-06-23 01:00:00	YM	Futures	11615.0	11625.6	11609.2	11614.0	399.0

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

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