PREVIEW / futures_1hour / 2012-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-09.parquet
  size:    13 KB
  rows:    254

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-09 18:00:00	ES	Futures	1461.37	1461.88	1460.86	1461.37	4826.0
2012-09-09 19:00:00	ES	Futures	1461.37	1461.88	1460.1	1460.86	2877.0
2012-09-09 20:00:00	ES	Futures	1460.6	1460.86	1459.08	1459.08	6783.0
2012-09-09 21:00:00	ES	Futures	1459.08	1459.59	1458.82	1459.08	6305.0
2012-09-09 22:00:00	ES	Futures	1459.33	1459.59	1458.57	1458.82	3862.0
2012-09-09 23:00:00	ES	Futures	1459.08	1459.08	1457.55	1457.81	6921.0
2012-09-09 18:00:00	NQ	Futures	3272.51	3273.09	3270.77	3271.93	350.0
2012-09-09 19:00:00	NQ	Futures	3271.93	3272.8	3269.03	3270.19	190.0
2012-09-09 20:00:00	NQ	Futures	3270.48	3271.06	3267.58	3267.87	396.0
2012-09-09 21:00:00	NQ	Futures	3267.87	3269.32	3267.29	3268.16	324.0
2012-09-09 22:00:00	NQ	Futures	3268.45	3269.32	3267.87	3268.45	407.0
2012-09-09 23:00:00	NQ	Futures	3268.45	3268.45	3265.26	3265.55	627.0
2012-09-09 18:00:00	YM	Futures	13210.6	13216.6	13207.7	13212.6	467.0
2012-09-09 19:00:00	YM	Futures	13211.6	13216.6	13203.7	13207.7	152.0
2012-09-09 20:00:00	YM	Futures	13205.7	13205.7	13194.7	13195.7	358.0
2012-09-09 21:00:00	YM	Futures	13196.7	13200.7	13193.7	13195.7	384.0
2012-09-09 22:00:00	YM	Futures	13196.7	13199.7	13191.7	13193.7	252.0
2012-09-09 23:00:00	YM	Futures	13194.7	13194.7	13182.8	13184.8	561.0
2012-09-09 18:00:00	CL	Futures	157.53	157.71	157.4	157.57	369.0
2012-09-09 19:00:00	CL	Futures	157.57	157.68	157.53	157.61	192.0
2012-09-09 20:00:00	CL	Futures	157.63	157.65	157.29	157.43	528.0
2012-09-09 21:00:00	CL	Futures	157.4	157.81	157.34	157.73	906.0
2012-09-09 22:00:00	CL	Futures	157.76	157.79	157.61	157.68	177.0
2012-09-09 23:00:00	CL	Futures	157.66	157.7	157.42	157.58	277.0
2012-09-09 18:00:00	GC	Futures	2397.6	2398.7	2395.1	2395.8	1496.0
2012-09-09 19:00:00	GC	Futures	2395.8	2398.5	2394.9	2398.5	764.0
2012-09-09 20:00:00	GC	Futures	2398.5	2399.0	2394.9	2397.4	2616.0
2012-09-09 21:00:00	GC	Futures	2397.4	2403.6	2397.1	2401.2	4753.0
2012-09-09 22:00:00	GC	Futures	2400.8	2402.0	2399.7	2401.5	1824.0
2012-09-09 23:00:00	GC	Futures	2401.6	2402.2	2400.1	2401.6	1692.0
2012-09-09 18:00:00	ZN	Futures	118.007109	118.131881	118.007109	118.09029	5862.0
2012-09-09 19:00:00	ZN	Futures	118.09029	118.118017	118.076427	118.09029	3684.0
2012-09-09 20:00:00	ZN	Futures	118.09029	118.104154	118.076427	118.104154	4012.0
2012-09-09 21:00:00	ZN	Futures	118.09029	118.131881	118.09029	118.131881	4355.0
2012-09-09 22:00:00	ZN	Futures	118.118017	118.145745	118.118017	118.131881	3122.0
2012-09-09 23:00:00	ZN	Futures	118.131881	118.173472	118.131881	118.159608	4197.0

> showing 36 of 254 rows — these rows as CSV

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