PREVIEW / futures_1hour / 2011-06-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	1289.18	1289.43	1288.43	1288.68	3032.0
2011-06-29 01:00:00	ES	Futures	1288.93	1289.93	1288.43	1288.68	4452.0
2011-06-29 02:00:00	ES	Futures	1288.93	1291.17	1288.68	1291.17	12735.0
2011-06-29 03:00:00	ES	Futures	1291.17	1293.42	1290.67	1293.17	39550.0
2011-06-29 04:00:00	ES	Futures	1293.17	1295.91	1291.67	1293.42	39858.0
2011-06-29 05:00:00	ES	Futures	1293.42	1296.91	1293.17	1295.91	24120.0
2011-06-29 06:00:00	ES	Futures	1295.91	1299.9	1293.92	1298.65	56505.0
2011-06-29 07:00:00	ES	Futures	1298.9	1301.15	1297.16	1297.66	63025.0
2011-06-29 08:00:00	ES	Futures	1297.66	1300.4	1293.42	1298.41	105981.0
2011-06-29 09:00:00	ES	Futures	1298.41	1301.15	1291.42	1293.92	393130.0
2011-06-29 10:00:00	ES	Futures	1293.92	1298.65	1289.68	1298.41	382177.0
2011-06-29 11:00:00	ES	Futures	1298.41	1300.15	1297.41	1299.4	266088.0
2011-06-29 12:00:00	ES	Futures	1299.4	1300.9	1298.65	1299.4	114549.0
2011-06-29 13:00:00	ES	Futures	1299.15	1301.9	1298.16	1298.65	143735.0
2011-06-29 14:00:00	ES	Futures	1298.65	1299.4	1293.92	1297.16	295054.0
2011-06-29 15:00:00	ES	Futures	1297.16	1301.4	1296.41	1300.15	376676.0
2011-06-29 16:00:00	ES	Futures	1300.15	1302.4	1299.9	1300.9	128372.0
2011-06-29 17:00:00	ES	Futures	1300.9	1301.15	1300.4	1300.9	1152.0
2011-06-29 18:00:00	ES	Futures	1300.9	1301.9	1300.65	1301.4	4999.0
2011-06-29 19:00:00	ES	Futures	1301.15	1302.15	1301.15	1301.4	2745.0
2011-06-29 20:00:00	ES	Futures	1301.15	1301.65	1299.9	1300.4	4088.0
2011-06-29 21:00:00	ES	Futures	1300.65	1300.9	1299.15	1299.4	6055.0
2011-06-29 22:00:00	ES	Futures	1299.65	1303.89	1299.4	1303.39	12290.0
2011-06-29 23:00:00	ES	Futures	1303.39	1304.14	1303.14	1303.64	5374.0
2011-06-29 00:00:00	NQ	Futures	2625.57	2626.15	2624.42	2624.42	127.0
2011-06-29 01:00:00	NQ	Futures	2624.71	2627.01	2623.56	2623.84	194.0
2011-06-29 02:00:00	NQ	Futures	2624.42	2629.6	2624.42	2629.02	604.0
2011-06-29 03:00:00	NQ	Futures	2629.31	2634.49	2629.02	2633.63	3753.0
2011-06-29 04:00:00	NQ	Futures	2633.92	2639.1	2631.33	2634.2	3039.0
2011-06-29 05:00:00	NQ	Futures	2634.49	2640.53	2634.49	2639.38	2677.0
2011-06-29 06:00:00	NQ	Futures	2638.81	2646.0	2635.07	2643.41	5861.0
2011-06-29 07:00:00	NQ	Futures	2643.41	2648.02	2639.67	2640.25	6271.0
2011-06-29 08:00:00	NQ	Futures	2640.25	2643.7	2631.04	2640.53	11445.0
2011-06-29 09:00:00	NQ	Futures	2640.82	2645.14	2620.1	2626.15	55162.0
2011-06-29 10:00:00	NQ	Futures	2625.86	2641.11	2618.38	2639.1	43473.0
2011-06-29 11:00:00	NQ	Futures	2639.1	2641.97	2632.19	2636.79	25285.0
2011-06-29 12:00:00	NQ	Futures	2636.79	2639.96	2635.35	2637.08	12657.0
2011-06-29 13:00:00	NQ	Futures	2637.08	2642.26	2636.22	2637.37	13485.0
2011-06-29 14:00:00	NQ	Futures	2637.37	2638.52	2623.56	2631.04	28274.0
2011-06-29 15:00:00	NQ	Futures	2631.33	2639.96	2629.31	2637.66	31053.0
2011-06-29 16:00:00	NQ	Futures	2637.66	2641.69	2637.37	2639.1	7361.0
2011-06-29 17:00:00	NQ	Futures	2638.81	2639.38	2638.23	2638.52	74.0
2011-06-29 18:00:00	NQ	Futures	2638.81	2641.11	2637.37	2639.96	233.0
2011-06-29 19:00:00	NQ	Futures	2640.25	2640.82	2638.81	2639.38	370.0
2011-06-29 20:00:00	NQ	Futures	2639.1	2640.53	2637.37	2637.94	318.0
2011-06-29 21:00:00	NQ	Futures	2637.94	2638.52	2633.05	2635.07	706.0
2011-06-29 22:00:00	NQ	Futures	2635.35	2644.56	2635.35	2643.41	1384.0
2011-06-29 23:00:00	NQ	Futures	2643.99	2644.85	2643.12	2644.28	254.0
2011-06-29 00:00:00	YM	Futures	11738.9	11741.8	11736.0	11737.0	129.0
2011-06-29 01:00:00	YM	Futures	11738.9	11743.8	11735.1	11738.9	169.0

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

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