PREVIEW / futures_1hour / 2011-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-03.parquet
  size:    12 KB
  rows:    205

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-07-03 18:00:00	ES	Futures	1331.33	1331.58	1330.08	1330.83	5986.0
2011-07-03 19:00:00	ES	Futures	1330.83	1330.83	1330.33	1330.83	2248.0
2011-07-03 20:00:00	ES	Futures	1330.58	1330.83	1329.83	1330.33	5067.0
2011-07-03 21:00:00	ES	Futures	1330.08	1330.33	1329.33	1329.33	4241.0
2011-07-03 22:00:00	ES	Futures	1329.33	1330.83	1329.33	1330.83	1477.0
2011-07-03 23:00:00	ES	Futures	1330.83	1331.08	1330.33	1330.83	1942.0
2011-07-03 18:00:00	NQ	Futures	2710.75	2712.19	2709.31	2711.61	809.0
2011-07-03 19:00:00	NQ	Futures	2711.61	2712.19	2710.17	2710.46	122.0
2011-07-03 20:00:00	NQ	Futures	2710.17	2712.19	2710.17	2711.61	208.0
2011-07-03 21:00:00	NQ	Futures	2711.61	2713.05	2711.32	2712.19	263.0
2011-07-03 22:00:00	NQ	Futures	2712.19	2715.64	2712.19	2715.64	185.0
2011-07-03 23:00:00	NQ	Futures	2715.64	2715.64	2714.49	2714.78	206.0
2011-07-03 18:00:00	YM	Futures	12119.5	12150.5	12106.0	12116.6	502.0
2011-07-03 19:00:00	YM	Futures	12119.5	12122.4	12117.6	12120.5	65.0
2011-07-03 20:00:00	YM	Futures	12119.5	12127.3	12117.6	12121.5	240.0
2011-07-03 21:00:00	YM	Futures	12123.4	12128.2	12116.6	12117.6	476.0
2011-07-03 22:00:00	YM	Futures	12118.6	12135.0	12117.6	12132.1	203.0
2011-07-03 23:00:00	YM	Futures	12132.1	12132.1	12124.4	12130.2	167.0
2011-07-03 18:00:00	CL	Futures	162.72	163.27	162.32	162.96	446.0
2011-07-03 19:00:00	CL	Futures	163.01	163.23	162.94	163.16	329.0
2011-07-03 20:00:00	CL	Futures	163.13	163.25	163.03	163.15	244.0
2011-07-03 21:00:00	CL	Futures	163.09	163.27	162.8	162.87	334.0
2011-07-03 22:00:00	CL	Futures	162.89	163.33	162.87	163.32	363.0
2011-07-03 23:00:00	CL	Futures	163.32	163.33	163.06	163.16	244.0
2011-07-03 18:00:00	GC	Futures	2073.7	2075.7	2072.9	2075.5	464.0
2011-07-03 19:00:00	GC	Futures	2075.5	2078.6	2075.0	2078.6	627.0
2011-07-03 20:00:00	GC	Futures	2078.6	2082.2	2078.2	2081.1	1920.0
2011-07-03 21:00:00	GC	Futures	2081.1	2081.7	2079.0	2079.9	875.0
2011-07-03 22:00:00	GC	Futures	2080.0	2081.9	2079.0	2081.7	810.0
2011-07-03 23:00:00	GC	Futures	2081.5	2083.6	2081.2	2082.8	920.0
2011-07-03 18:00:00	ZN	Futures	105.042278	105.082637	105.015372	105.042278	1948.0
2011-07-03 19:00:00	ZN	Futures	105.042278	105.082637	105.042278	105.055731	1171.0
2011-07-03 20:00:00	ZN	Futures	105.069184	105.082637	105.028825	105.042278	1658.0
2011-07-03 21:00:00	ZN	Futures	105.042278	105.069184	105.028825	105.069184	2249.0
2011-07-03 22:00:00	ZN	Futures	105.069184	105.069184	105.055731	105.055731	560.0
2011-07-03 23:00:00	ZN	Futures	105.055731	105.069184	105.042278	105.069184	762.0

> showing 36 of 205 rows — these rows as CSV

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