PREVIEW / futures_1hour / 2011-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-23.parquet
  size:    49 KB
  rows:    1,476

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-02-23 00:00:00	ES	Futures	1304.93	1305.67	1304.19	1305.43	6113.0
2011-02-23 01:00:00	ES	Futures	1305.18	1305.43	1303.94	1304.19	7099.0
2011-02-23 02:00:00	ES	Futures	1304.44	1305.43	1303.94	1304.93	10876.0
2011-02-23 03:00:00	ES	Futures	1304.93	1305.92	1303.94	1305.18	28982.0
2011-02-23 04:00:00	ES	Futures	1304.93	1305.43	1303.45	1304.93	21142.0
2011-02-23 05:00:00	ES	Futures	1304.68	1305.92	1304.19	1304.93	14083.0
2011-02-23 06:00:00	ES	Futures	1304.93	1306.91	1304.44	1306.66	25502.0
2011-02-23 07:00:00	ES	Futures	1306.41	1306.91	1305.18	1305.18	25669.0
2011-02-23 08:00:00	ES	Futures	1305.18	1305.43	1302.21	1302.46	60822.0
2011-02-23 09:00:00	ES	Futures	1302.7	1302.95	1297.01	1297.76	391236.0
2011-02-23 10:00:00	ES	Futures	1297.76	1300.72	1294.29	1298.99	432006.0
2011-02-23 11:00:00	ES	Futures	1298.74	1299.98	1291.82	1292.31	383791.0
2011-02-23 12:00:00	ES	Futures	1292.31	1292.56	1286.87	1289.59	432409.0
2011-02-23 13:00:00	ES	Futures	1289.59	1292.31	1284.15	1290.83	334804.0
2011-02-23 14:00:00	ES	Futures	1290.83	1295.53	1290.33	1295.53	286834.0
2011-02-23 15:00:00	ES	Futures	1295.53	1298.0	1291.82	1292.81	428669.0
2011-02-23 16:00:00	ES	Futures	1292.81	1293.8	1291.07	1293.05	119892.0
2011-02-23 17:00:00	ES	Futures	1293.05	1293.8	1292.81	1293.3	1909.0
2011-02-23 18:00:00	ES	Futures	1293.55	1295.28	1293.55	1294.79	8648.0
2011-02-23 19:00:00	ES	Futures	1294.79	1295.03	1293.55	1293.8	15474.0
2011-02-23 20:00:00	ES	Futures	1294.04	1295.78	1293.8	1295.78	9184.0
2011-02-23 21:00:00	ES	Futures	1295.78	1296.27	1295.28	1295.78	7890.0
2011-02-23 22:00:00	ES	Futures	1296.02	1297.26	1295.53	1297.01	8095.0
2011-02-23 23:00:00	ES	Futures	1296.77	1297.01	1295.78	1296.02	7883.0
2011-02-23 00:00:00	NQ	Futures	2671.41	2671.99	2670.55	2671.99	217.0
2011-02-23 01:00:00	NQ	Futures	2671.7	2671.7	2667.97	2668.83	494.0
2011-02-23 02:00:00	NQ	Futures	2668.25	2673.13	2668.25	2672.85	1071.0
2011-02-23 03:00:00	NQ	Futures	2672.56	2674.57	2669.69	2673.42	2595.0
2011-02-23 04:00:00	NQ	Futures	2673.42	2673.99	2670.84	2673.13	1138.0
2011-02-23 05:00:00	NQ	Futures	2673.13	2676.0	2673.13	2673.99	1124.0
2011-02-23 06:00:00	NQ	Futures	2673.99	2680.31	2673.13	2679.45	3286.0
2011-02-23 07:00:00	NQ	Futures	2679.45	2680.6	2677.73	2677.73	2284.0
2011-02-23 08:00:00	NQ	Futures	2678.01	2678.59	2673.13	2673.71	10619.0
2011-02-23 09:00:00	NQ	Futures	2673.99	2674.28	2660.5	2662.8	59870.0
2011-02-23 10:00:00	NQ	Futures	2662.23	2664.52	2648.16	2657.63	70407.0
2011-02-23 11:00:00	NQ	Futures	2657.63	2659.36	2639.84	2640.7	49776.0
2011-02-23 12:00:00	NQ	Futures	2640.41	2640.7	2625.2	2633.81	52685.0
2011-02-23 13:00:00	NQ	Futures	2634.1	2640.7	2623.48	2637.54	40217.0
2011-02-23 14:00:00	NQ	Futures	2637.83	2649.88	2637.54	2649.6	41862.0
2011-02-23 15:00:00	NQ	Futures	2649.88	2655.34	2642.42	2643.86	55577.0
2011-02-23 16:00:00	NQ	Futures	2643.86	2647.3	2639.26	2646.44	11192.0
2011-02-23 17:00:00	NQ	Futures	2646.15	2646.15	2644.43	2645.29	169.0
2011-02-23 18:00:00	NQ	Futures	2646.44	2648.74	2646.15	2647.3	287.0
2011-02-23 19:00:00	NQ	Futures	2647.59	2648.16	2645.29	2645.58	466.0
2011-02-23 20:00:00	NQ	Futures	2646.15	2648.74	2644.72	2648.45	261.0
2011-02-23 21:00:00	NQ	Futures	2648.74	2650.74	2647.87	2649.88	377.0
2011-02-23 22:00:00	NQ	Futures	2649.88	2651.89	2649.88	2651.32	192.0
2011-02-23 23:00:00	NQ	Futures	2651.32	2651.61	2649.88	2649.88	160.0
2011-02-23 00:00:00	YM	Futures	11692.6	11712.7	11691.6	11711.8	451.0
2011-02-23 01:00:00	YM	Futures	11710.8	11710.8	11694.5	11695.5	295.0

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

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