PREVIEW / futures_1hour / 2011-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-11.parquet
  size:    42 KB
  rows:    1,176

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-03-11 00:00:00	ES	Futures	1284.39	1284.89	1280.19	1280.93	5687.0
2011-03-11 01:00:00	ES	Futures	1280.93	1282.41	1269.8	1276.72	32201.0
2011-03-11 02:00:00	ES	Futures	1276.72	1278.46	1272.27	1274.25	33969.0
2011-03-11 03:00:00	ES	Futures	1274.5	1279.94	1273.51	1279.45	30416.0
2011-03-11 04:00:00	ES	Futures	1279.45	1279.45	1274.25	1274.25	17651.0
2011-03-11 05:00:00	ES	Futures	1274.25	1275.98	1271.28	1275.73	19852.0
2011-03-11 06:00:00	ES	Futures	1275.73	1278.21	1271.78	1277.22	28136.0
2011-03-11 07:00:00	ES	Futures	1276.97	1279.94	1274.99	1279.2	23062.0
2011-03-11 08:00:00	ES	Futures	1279.2	1281.67	1276.72	1277.96	49755.0
2011-03-11 09:00:00	ES	Futures	1277.96	1284.64	1275.73	1282.17	131625.0
2011-03-11 10:00:00	ES	Futures	1282.17	1283.9	1278.46	1282.91	81298.0
2011-03-11 11:00:00	ES	Futures	1282.91	1288.35	1280.68	1287.12	64407.0
2011-03-11 12:00:00	ES	Futures	1287.36	1289.84	1286.62	1288.6	34043.0
2011-03-11 13:00:00	ES	Futures	1288.35	1288.6	1285.14	1286.87	23105.0
2011-03-11 14:00:00	ES	Futures	1287.12	1291.57	1286.62	1291.07	32903.0
2011-03-11 15:00:00	ES	Futures	1290.83	1295.28	1290.33	1290.33	77034.0
2011-03-11 16:00:00	ES	Futures	1290.58	1293.3	1290.08	1293.05	26533.0
2011-03-11 00:00:00	NQ	Futures	2626.92	2628.07	2621.47	2623.19	395.0
2011-03-11 01:00:00	NQ	Futures	2622.33	2623.48	2600.51	2615.44	1911.0
2011-03-11 02:00:00	NQ	Futures	2614.58	2618.6	2605.39	2608.26	1468.0
2011-03-11 03:00:00	NQ	Futures	2608.26	2617.45	2607.4	2616.59	1450.0
2011-03-11 04:00:00	NQ	Futures	2616.01	2616.3	2604.82	2605.39	1141.0
2011-03-11 05:00:00	NQ	Futures	2605.11	2610.85	2600.51	2609.99	1478.0
2011-03-11 06:00:00	NQ	Futures	2610.56	2612.86	2602.24	2610.56	2740.0
2011-03-11 07:00:00	NQ	Futures	2610.27	2616.87	2604.82	2615.44	2335.0
2011-03-11 08:00:00	NQ	Futures	2616.01	2620.61	2611.13	2614.29	3145.0
2011-03-11 09:00:00	NQ	Futures	2613.72	2628.36	2607.98	2620.89	21800.0
2011-03-11 10:00:00	NQ	Futures	2621.18	2623.76	2611.42	2620.03	17169.0
2011-03-11 11:00:00	NQ	Futures	2620.32	2634.67	2615.44	2633.52	12438.0
2011-03-11 12:00:00	NQ	Futures	2633.52	2638.69	2630.37	2637.83	6413.0
2011-03-11 13:00:00	NQ	Futures	2638.12	2638.69	2628.64	2631.8	4126.0
2011-03-11 14:00:00	NQ	Futures	2631.8	2641.27	2630.08	2640.12	3729.0
2011-03-11 15:00:00	NQ	Futures	2639.84	2647.59	2638.98	2639.26	10119.0
2011-03-11 16:00:00	NQ	Futures	2639.26	2647.87	2636.11	2646.44	4507.0
2011-03-11 00:00:00	YM	Futures	11496.6	11504.3	11472.5	11474.5	249.0
2011-03-11 01:00:00	YM	Futures	11475.4	11482.2	11391.6	11431.1	1726.0
2011-03-11 02:00:00	YM	Futures	11429.2	11441.7	11399.3	11414.7	1909.0
2011-03-11 03:00:00	YM	Futures	11414.7	11456.2	11409.0	11452.3	1739.0
2011-03-11 04:00:00	YM	Futures	11450.4	11451.3	11413.8	11413.8	1158.0
2011-03-11 05:00:00	YM	Futures	11414.7	11426.3	11394.5	11423.4	1556.0
2011-03-11 06:00:00	YM	Futures	11423.4	11443.6	11400.3	11435.9	1724.0
2011-03-11 07:00:00	YM	Futures	11435.0	11451.3	11419.6	11444.6	2260.0
2011-03-11 08:00:00	YM	Futures	11446.5	11463.9	11428.2	11437.9	4047.0
2011-03-11 09:00:00	YM	Futures	11436.9	11485.1	11415.7	11469.6	17377.0
2011-03-11 10:00:00	YM	Futures	11466.8	11483.1	11435.0	11465.8	16606.0
2011-03-11 11:00:00	YM	Futures	11464.8	11509.1	11443.6	11499.5	11969.0
2011-03-11 12:00:00	YM	Futures	11499.5	11524.5	11495.6	11514.9	6443.0
2011-03-11 13:00:00	YM	Futures	11513.9	11515.9	11488.9	11500.5	5333.0
2011-03-11 14:00:00	YM	Futures	11500.5	11543.8	11495.6	11539.0	6556.0
2011-03-11 15:00:00	YM	Futures	11539.0	11583.3	11538.0	11540.0	17518.0

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

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