PREVIEW / futures_1hour / 2011-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-23.parquet
  size:    14 KB
  rows:    274

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-01-23 18:00:00	ES	Futures	1266.33	1267.07	1264.6	1266.08	6951.0
2011-01-23 19:00:00	ES	Futures	1266.08	1267.57	1264.85	1267.07	6626.0
2011-01-23 20:00:00	ES	Futures	1266.83	1268.31	1266.33	1268.06	5152.0
2011-01-23 21:00:00	ES	Futures	1268.06	1269.8	1267.57	1268.81	4320.0
2011-01-23 22:00:00	ES	Futures	1268.81	1269.05	1268.06	1268.81	3091.0
2011-01-23 23:00:00	ES	Futures	1268.81	1270.29	1268.56	1270.04	2493.0
2011-01-23 18:00:00	NQ	Futures	2604.82	2605.68	2599.94	2602.81	854.0
2011-01-23 19:00:00	NQ	Futures	2603.38	2606.83	2600.51	2605.68	797.0
2011-01-23 20:00:00	NQ	Futures	2605.68	2608.26	2603.96	2607.98	405.0
2011-01-23 21:00:00	NQ	Futures	2607.69	2610.27	2606.83	2608.26	443.0
2011-01-23 22:00:00	NQ	Futures	2608.26	2609.12	2607.4	2608.55	93.0
2011-01-23 23:00:00	NQ	Futures	2608.26	2611.13	2607.69	2610.27	188.0
2011-01-23 18:00:00	YM	Futures	11315.2	11325.8	11307.6	11316.2	355.0
2011-01-23 19:00:00	YM	Futures	11318.1	11331.5	11312.4	11326.7	253.0
2011-01-23 20:00:00	YM	Futures	11327.7	11334.4	11321.9	11333.4	179.0
2011-01-23 21:00:00	YM	Futures	11333.4	11346.8	11330.6	11337.3	346.0
2011-01-23 22:00:00	YM	Futures	11338.2	11342.1	11335.4	11338.2	121.0
2011-01-23 23:00:00	YM	Futures	11339.2	11348.8	11338.2	11345.9	122.0
2011-01-23 18:00:00	CL	Futures	163.7	163.77	163.15	163.51	975.0
2011-01-23 19:00:00	CL	Futures	163.51	163.73	163.2	163.72	1001.0
2011-01-23 20:00:00	CL	Futures	163.7	164.03	163.66	163.9	926.0
2011-01-23 21:00:00	CL	Futures	163.92	164.06	163.66	163.72	1391.0
2011-01-23 22:00:00	CL	Futures	163.73	163.84	163.51	163.83	800.0
2011-01-23 23:00:00	CL	Futures	163.81	164.21	163.81	164.14	747.0
2011-01-23 18:00:00	GC	Futures	1875.9	1882.0	1875.9	1878.4	2523.0
2011-01-23 19:00:00	GC	Futures	1878.4	1884.1	1878.1	1884.1	1913.0
2011-01-23 20:00:00	GC	Futures	1884.1	1884.7	1882.3	1882.3	1556.0
2011-01-23 21:00:00	GC	Futures	1882.5	1886.2	1881.5	1886.0	1716.0
2011-01-23 22:00:00	GC	Futures	1886.0	1889.0	1885.5	1887.1	2637.0
2011-01-23 23:00:00	GC	Futures	1887.2	1888.5	1886.1	1888.0	1156.0
2011-01-23 18:00:00	ZN	Futures	101.049044	101.062184	100.970202	101.062184	3371.0
2011-01-23 19:00:00	ZN	Futures	101.049044	101.049044	100.943921	100.970202	4942.0
2011-01-23 20:00:00	ZN	Futures	100.970202	100.970202	100.917641	100.943921	3608.0
2011-01-23 21:00:00	ZN	Futures	100.943921	100.983342	100.943921	100.957062	2794.0
2011-01-23 22:00:00	ZN	Futures	100.957062	100.957062	100.851939	100.9045	5858.0
2011-01-23 23:00:00	ZN	Futures	100.9045	100.9045	100.87822	100.89136	2878.0

> showing 36 of 274 rows — these rows as CSV

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