PREVIEW / futures_1hour / 2012-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-02.parquet
  size:    12 KB
  rows:    210

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
2012-09-02 18:00:00	ES	Futures	1430.34	1430.34	1425.77	1429.07	7515.0
2012-09-02 19:00:00	ES	Futures	1429.07	1429.07	1424.5	1424.5	4016.0
2012-09-02 20:00:00	ES	Futures	1424.75	1424.75	1420.68	1421.19	11579.0
2012-09-02 21:00:00	ES	Futures	1421.19	1424.5	1420.68	1424.24	8003.0
2012-09-02 22:00:00	ES	Futures	1424.24	1427.04	1423.73	1426.53	5884.0
2012-09-02 23:00:00	ES	Futures	1426.53	1427.55	1426.28	1427.04	3880.0
2012-09-02 18:00:00	NQ	Futures	3215.4	3217.43	3209.32	3215.69	929.0
2012-09-02 19:00:00	NQ	Futures	3215.4	3215.69	3208.16	3208.16	391.0
2012-09-02 20:00:00	NQ	Futures	3208.74	3208.74	3200.04	3200.33	1124.0
2012-09-02 21:00:00	NQ	Futures	3200.91	3207.58	3200.33	3207.58	809.0
2012-09-02 22:00:00	NQ	Futures	3207.29	3212.22	3205.55	3211.06	837.0
2012-09-02 23:00:00	NQ	Futures	3211.35	3213.95	3210.77	3212.51	761.0
2012-09-02 18:00:00	YM	Futures	12988.9	13015.7	12979.9	13012.8	1709.0
2012-09-02 19:00:00	YM	Futures	13012.8	13012.8	12976.0	12976.0	389.0
2012-09-02 20:00:00	YM	Futures	12975.0	12976.0	12943.1	12945.1	1462.0
2012-09-02 21:00:00	YM	Futures	12945.1	12972.0	12944.1	12968.0	1006.0
2012-09-02 22:00:00	YM	Futures	12968.0	12987.9	12961.0	12984.9	855.0
2012-09-02 23:00:00	YM	Futures	12983.9	12990.9	12980.9	12985.9	435.0
2012-09-02 18:00:00	CL	Futures	157.76	158.02	157.65	157.84	301.0
2012-09-02 19:00:00	CL	Futures	157.84	157.97	157.42	157.47	516.0
2012-09-02 20:00:00	CL	Futures	157.47	157.5	157.16	157.24	687.0
2012-09-02 21:00:00	CL	Futures	157.22	157.6	157.21	157.57	772.0
2012-09-02 22:00:00	CL	Futures	157.57	157.73	157.48	157.61	642.0
2012-09-02 23:00:00	CL	Futures	157.61	157.71	157.48	157.57	426.0
2012-09-02 18:00:00	GC	Futures	2336.1	2338.7	2333.8	2336.0	1119.0
2012-09-02 19:00:00	GC	Futures	2336.1	2336.1	2331.0	2332.5	960.0
2012-09-02 20:00:00	GC	Futures	2332.5	2333.2	2328.7	2329.9	2417.0
2012-09-02 21:00:00	GC	Futures	2330.2	2335.0	2329.9	2333.8	2890.0
2012-09-02 22:00:00	GC	Futures	2333.5	2335.0	2332.8	2334.4	1453.0
2012-09-02 23:00:00	GC	Futures	2334.6	2335.7	2333.5	2335.3	1347.0
2012-09-02 18:00:00	ZN	Futures	118.653535	118.694797	118.639782	118.653535	346.0
2012-09-02 19:00:00	ZN	Futures	118.639782	118.70855	118.639782	118.694797	488.0
2012-09-02 20:00:00	ZN	Futures	118.694797	118.70855	118.667289	118.681043	259.0
2012-09-02 21:00:00	ZN	Futures	118.667289	118.694797	118.667289	118.681043	572.0
2012-09-02 22:00:00	ZN	Futures	118.694797	118.70855	118.667289	118.667289	475.0
2012-09-02 23:00:00	ZN	Futures	118.667289	118.694797	118.653535	118.667289	187.0

> showing 36 of 210 rows — these rows as CSV

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