PREVIEW / futures_1hour / 2012-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-29.parquet
  size:    14 KB
  rows:    275

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-07-29 18:00:00	ES	Futures	1402.88	1405.17	1402.88	1403.39	8479.0
2012-07-29 19:00:00	ES	Futures	1403.64	1404.66	1402.37	1402.37	4076.0
2012-07-29 20:00:00	ES	Futures	1402.37	1402.63	1400.59	1401.1	9646.0
2012-07-29 21:00:00	ES	Futures	1401.1	1402.12	1400.85	1401.1	3834.0
2012-07-29 22:00:00	ES	Futures	1401.36	1402.88	1400.34	1402.37	4517.0
2012-07-29 23:00:00	ES	Futures	1402.12	1404.15	1401.86	1403.14	4199.0
2012-07-29 18:00:00	NQ	Futures	3061.19	3063.21	3058.87	3061.76	1016.0
2012-07-29 19:00:00	NQ	Futures	3061.48	3063.21	3058.0	3058.29	274.0
2012-07-29 20:00:00	NQ	Futures	3058.29	3058.87	3055.1	3055.68	721.0
2012-07-29 21:00:00	NQ	Futures	3055.39	3058.0	3055.1	3055.68	466.0
2012-07-29 22:00:00	NQ	Futures	3055.68	3059.16	3053.94	3058.0	518.0
2012-07-29 23:00:00	NQ	Futures	3057.71	3062.63	3057.71	3060.9	658.0
2012-07-29 18:00:00	YM	Futures	12945.1	12953.1	12934.2	12942.2	810.0
2012-07-29 19:00:00	YM	Futures	12941.2	12950.1	12931.2	12931.2	268.0
2012-07-29 20:00:00	YM	Futures	12933.2	12933.2	12918.3	12922.3	690.0
2012-07-29 21:00:00	YM	Futures	12921.3	12931.2	12919.3	12923.3	378.0
2012-07-29 22:00:00	YM	Futures	12921.3	12937.2	12917.3	12933.2	480.0
2012-07-29 23:00:00	YM	Futures	12932.2	12947.1	12928.2	12938.2	427.0
2012-07-29 18:00:00	CL	Futures	148.01	148.17	147.89	148.04	510.0
2012-07-29 19:00:00	CL	Futures	148.03	148.09	147.78	147.81	430.0
2012-07-29 20:00:00	CL	Futures	147.83	147.96	147.57	147.75	872.0
2012-07-29 21:00:00	CL	Futures	147.75	147.96	147.65	147.8	654.0
2012-07-29 22:00:00	CL	Futures	147.78	148.16	147.7	148.01	912.0
2012-07-29 23:00:00	CL	Futures	147.98	149.34	147.98	149.08	2899.0
2012-07-29 18:00:00	GC	Futures	2245.2	2248.6	2240.6	2244.1	1146.0
2012-07-29 19:00:00	GC	Futures	2243.7	2245.9	2243.5	2243.9	292.0
2012-07-29 20:00:00	GC	Futures	2243.9	2244.8	2241.2	2243.4	998.0
2012-07-29 21:00:00	GC	Futures	2243.7	2243.8	2239.7	2240.5	2078.0
2012-07-29 22:00:00	GC	Futures	2240.5	2241.7	2240.4	2241.2	651.0
2012-07-29 23:00:00	GC	Futures	2241.3	2243.3	2240.9	2242.8	912.0
2012-07-29 18:00:00	ZN	Futures	118.144647	118.240923	118.089632	118.130893	7257.0
2012-07-29 19:00:00	ZN	Futures	118.144647	118.172154	118.075878	118.144647	10715.0
2012-07-29 20:00:00	ZN	Futures	118.144647	118.213416	118.144647	118.158401	8561.0
2012-07-29 21:00:00	ZN	Futures	118.158401	118.199662	118.144647	118.185908	5697.0
2012-07-29 22:00:00	ZN	Futures	118.185908	118.268431	118.185908	118.213416	13150.0
2012-07-29 23:00:00	ZN	Futures	118.213416	118.240923	118.103386	118.130893	9309.0

> showing 36 of 275 rows — these rows as CSV

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