PREVIEW / futures_1hour / 2011-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-06.parquet
  size:    14 KB
  rows:    272

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-06 18:00:00	ES	Futures	1306.66	1309.88	1305.67	1307.65	26252.0
2011-03-06 19:00:00	ES	Futures	1307.65	1308.15	1304.93	1305.18	11312.0
2011-03-06 20:00:00	ES	Futures	1305.18	1305.18	1301.71	1302.95	14210.0
2011-03-06 21:00:00	ES	Futures	1303.2	1304.44	1301.22	1301.47	7258.0
2011-03-06 22:00:00	ES	Futures	1301.22	1302.21	1300.48	1300.97	11836.0
2011-03-06 23:00:00	ES	Futures	1301.22	1302.21	1300.48	1300.97	3424.0
2011-03-06 18:00:00	NQ	Futures	2709.87	2716.19	2707.29	2709.01	876.0
2011-03-06 19:00:00	NQ	Futures	2709.3	2711.02	2703.85	2704.42	955.0
2011-03-06 20:00:00	NQ	Futures	2704.42	2704.42	2697.24	2699.83	1077.0
2011-03-06 21:00:00	NQ	Futures	2699.83	2702.98	2695.81	2696.1	648.0
2011-03-06 22:00:00	NQ	Futures	2696.1	2699.25	2694.95	2696.67	590.0
2011-03-06 23:00:00	NQ	Futures	2696.38	2698.39	2696.1	2696.67	240.0
2011-03-06 18:00:00	YM	Futures	11650.5	11663.9	11635.1	11645.7	746.0
2011-03-06 19:00:00	YM	Futures	11645.7	11651.4	11627.5	11629.4	474.0
2011-03-06 20:00:00	YM	Futures	11627.5	11628.4	11599.7	11610.2	414.0
2011-03-06 21:00:00	YM	Futures	11615.0	11621.7	11599.7	11600.7	398.0
2011-03-06 22:00:00	YM	Futures	11600.7	11606.4	11592.0	11599.7	356.0
2011-03-06 23:00:00	YM	Futures	11597.8	11608.3	11594.9	11596.8	269.0
2011-03-06 18:00:00	CL	Futures	184.85	185.84	184.15	185.79	8192.0
2011-03-06 19:00:00	CL	Futures	185.81	186.25	185.17	185.63	3699.0
2011-03-06 20:00:00	CL	Futures	185.65	187.1	185.59	186.74	4368.0
2011-03-06 21:00:00	CL	Futures	186.78	187.24	186.58	187.06	1944.0
2011-03-06 22:00:00	CL	Futures	187.04	187.8	187.04	187.45	3911.0
2011-03-06 23:00:00	CL	Futures	187.47	187.93	187.11	187.43	2377.0
2011-03-06 18:00:00	GC	Futures	2003.0	2008.2	2000.4	2004.2	4200.0
2011-03-06 19:00:00	GC	Futures	2004.2	2005.4	2001.1	2002.4	2540.0
2011-03-06 20:00:00	GC	Futures	2002.6	2004.4	2002.4	2003.3	1419.0
2011-03-06 21:00:00	GC	Futures	2003.6	2007.5	2003.0	2006.5	2166.0
2011-03-06 22:00:00	GC	Futures	2006.7	2008.2	2006.4	2007.7	1530.0
2011-03-06 23:00:00	GC	Futures	2007.8	2007.8	2003.9	2005.3	2391.0
2011-03-06 18:00:00	ZN	Futures	100.799378	100.799378	100.786237	100.786237	2.0
2011-03-06 19:00:00	ZN	Futures	100.812518	100.812518	100.812518	100.812518	3.0
2011-03-06 20:00:00	ZN	Futures	100.851939	100.87822	100.851939	100.87822	130.0
2011-03-06 21:00:00	ZN	Futures	100.865079	100.865079	100.865079	100.865079	1.0
2011-03-06 22:00:00	ZN	Futures	100.943921	100.970202	100.943921	100.970202	5.0
2011-03-06 23:00:00	ZN	Futures	100.943921	100.943921	100.9045	100.9045	4.0

> showing 36 of 272 rows — these rows as CSV

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