PREVIEW / futures_1hour / 2011-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-23.parquet
  size:    14 KB
  rows:    270

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-10-23 18:00:00	ES	Futures	1233.48	1234.48	1230.47	1232.98	17665.0
2011-10-23 19:00:00	ES	Futures	1232.98	1237.99	1232.48	1237.49	7622.0
2011-10-23 20:00:00	ES	Futures	1237.24	1237.99	1233.73	1234.23	8723.0
2011-10-23 21:00:00	ES	Futures	1234.23	1235.74	1232.98	1235.48	9809.0
2011-10-23 22:00:00	ES	Futures	1235.48	1238.24	1234.98	1237.24	6358.0
2011-10-23 23:00:00	ES	Futures	1237.24	1245.26	1236.99	1244.76	17040.0
2011-10-23 18:00:00	NQ	Futures	2683.42	2683.99	2675.92	2680.82	1155.0
2011-10-23 19:00:00	NQ	Futures	2680.82	2691.78	2680.25	2689.76	351.0
2011-10-23 20:00:00	NQ	Futures	2689.47	2690.91	2682.55	2683.71	408.0
2011-10-23 21:00:00	NQ	Futures	2683.71	2687.17	2681.69	2686.3	734.0
2011-10-23 22:00:00	NQ	Futures	2686.3	2692.07	2685.15	2690.34	695.0
2011-10-23 23:00:00	NQ	Futures	2690.34	2703.89	2688.9	2703.6	1554.0
2011-10-23 18:00:00	YM	Futures	11536.1	11546.9	11506.6	11533.1	739.0
2011-10-23 19:00:00	YM	Futures	11529.2	11578.4	11528.2	11571.5	632.0
2011-10-23 20:00:00	YM	Futures	11572.5	11576.5	11541.0	11543.0	687.0
2011-10-23 21:00:00	YM	Futures	11544.0	11556.8	11534.1	11552.8	816.0
2011-10-23 22:00:00	YM	Futures	11552.8	11576.5	11549.9	11570.6	850.0
2011-10-23 23:00:00	YM	Futures	11571.5	11641.4	11566.6	11639.5	2285.0
2011-10-23 18:00:00	CL	Futures	146.85	147.39	146.76	146.98	1254.0
2011-10-23 19:00:00	CL	Futures	146.97	147.61	146.81	147.51	541.0
2011-10-23 20:00:00	CL	Futures	147.51	148.28	147.41	147.81	1042.0
2011-10-23 21:00:00	CL	Futures	147.81	148.11	147.44	147.89	1036.0
2011-10-23 22:00:00	CL	Futures	147.88	148.57	147.64	148.35	1017.0
2011-10-23 23:00:00	CL	Futures	148.38	148.86	148.2	148.81	959.0
2011-10-23 18:00:00	GC	Futures	2288.0	2288.6	2281.2	2285.5	827.0
2011-10-23 19:00:00	GC	Futures	2285.4	2291.7	2284.3	2289.7	1156.0
2011-10-23 20:00:00	GC	Futures	2289.6	2293.7	2281.6	2285.2	2863.0
2011-10-23 21:00:00	GC	Futures	2285.4	2285.9	2279.1	2284.6	2578.0
2011-10-23 22:00:00	GC	Futures	2284.8	2291.5	2283.3	2290.0	1768.0
2011-10-23 23:00:00	GC	Futures	2290.0	2294.0	2288.6	2292.2	1868.0
2011-10-23 18:00:00	ZN	Futures	111.652213	111.787747	111.598	111.692873	4552.0
2011-10-23 19:00:00	ZN	Futures	111.706427	111.706427	111.584447	111.625107	2992.0
2011-10-23 20:00:00	ZN	Futures	111.611553	111.652213	111.584447	111.625107	3547.0
2011-10-23 21:00:00	ZN	Futures	111.625107	111.625107	111.570893	111.584447	3685.0
2011-10-23 22:00:00	ZN	Futures	111.584447	111.598	111.462467	111.503127	5052.0
2011-10-23 23:00:00	ZN	Futures	111.503127	111.51668	111.421807	111.43536	3729.0

> showing 36 of 270 rows — these rows as CSV

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