PREVIEW / futures_1hour / 2012-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-01.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
2012-04-01 18:00:00	ES	Futures	1424.05	1427.08	1423.54	1427.08	19033.0
2012-04-01 19:00:00	ES	Futures	1427.08	1427.08	1425.31	1425.31	5072.0
2012-04-01 20:00:00	ES	Futures	1425.31	1426.33	1425.06	1425.31	6283.0
2012-04-01 21:00:00	ES	Futures	1425.31	1426.07	1424.55	1424.81	6321.0
2012-04-01 22:00:00	ES	Futures	1424.81	1425.31	1423.29	1423.8	6079.0
2012-04-01 23:00:00	ES	Futures	1423.8	1425.57	1423.29	1424.81	5260.0
2012-04-01 18:00:00	NQ	Futures	3190.46	3198.27	3190.46	3197.4	2108.0
2012-04-01 19:00:00	NQ	Futures	3197.69	3197.69	3194.51	3194.8	634.0
2012-04-01 20:00:00	NQ	Futures	3194.8	3196.24	3194.22	3195.09	535.0
2012-04-01 21:00:00	NQ	Futures	3195.09	3196.24	3193.93	3194.22	418.0
2012-04-01 22:00:00	NQ	Futures	3194.22	3195.09	3192.77	3193.35	839.0
2012-04-01 23:00:00	NQ	Futures	3193.06	3196.24	3191.62	3195.09	560.0
2012-04-01 18:00:00	YM	Futures	13122.3	13148.2	13122.3	13147.2	862.0
2012-04-01 19:00:00	YM	Futures	13147.2	13148.2	13134.2	13134.2	308.0
2012-04-01 20:00:00	YM	Futures	13134.2	13141.2	13131.2	13134.2	613.0
2012-04-01 21:00:00	YM	Futures	13134.2	13138.2	13127.2	13131.2	441.0
2012-04-01 22:00:00	YM	Futures	13130.2	13131.2	13117.3	13120.3	560.0
2012-04-01 23:00:00	YM	Futures	13120.3	13133.2	13118.3	13128.2	381.0
2012-04-01 18:00:00	CL	Futures	172.46	172.98	172.44	172.95	1592.0
2012-04-01 19:00:00	CL	Futures	172.95	172.96	172.73	172.73	306.0
2012-04-01 20:00:00	CL	Futures	172.73	172.88	172.58	172.6	761.0
2012-04-01 21:00:00	CL	Futures	172.61	172.63	172.48	172.49	391.0
2012-04-01 22:00:00	CL	Futures	172.48	172.61	172.21	172.29	675.0
2012-04-01 23:00:00	CL	Futures	172.29	172.48	172.18	172.34	419.0
2012-04-01 18:00:00	GC	Futures	2316.5	2323.1	2316.2	2322.6	1612.0
2012-04-01 19:00:00	GC	Futures	2322.6	2322.6	2319.9	2320.4	566.0
2012-04-01 20:00:00	GC	Futures	2320.1	2321.7	2317.4	2317.4	1720.0
2012-04-01 21:00:00	GC	Futures	2317.7	2318.3	2314.8	2316.1	1329.0
2012-04-01 22:00:00	GC	Futures	2316.3	2318.3	2315.1	2315.8	949.0
2012-04-01 23:00:00	GC	Futures	2315.8	2316.2	2313.6	2314.9	1352.0
2012-04-01 18:00:00	ZN	Futures	113.247885	113.247885	113.056496	113.124849	11113.0
2012-04-01 19:00:00	ZN	Futures	113.13852	113.165861	113.097508	113.152191	6216.0
2012-04-01 20:00:00	ZN	Futures	113.152191	113.179532	113.015484	113.056496	16955.0
2012-04-01 21:00:00	ZN	Futures	113.042825	113.097508	113.042825	113.097508	4782.0
2012-04-01 22:00:00	ZN	Futures	113.097508	113.13852	113.097508	113.111178	3728.0
2012-04-01 23:00:00	ZN	Futures	113.111178	113.193203	113.097508	113.124849	7308.0

> showing 36 of 274 rows — these rows as CSV

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