PREVIEW / futures_1hour / 2013-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-31.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
2013-03-31 18:00:00	ES	Futures	1610.42	1611.19	1609.13	1610.16	3634.0
2013-03-31 19:00:00	ES	Futures	1610.16	1611.45	1610.16	1610.42	3189.0
2013-03-31 20:00:00	ES	Futures	1610.67	1610.67	1607.33	1607.84	6220.0
2013-03-31 21:00:00	ES	Futures	1607.84	1608.61	1606.55	1608.1	7805.0
2013-03-31 22:00:00	ES	Futures	1608.1	1608.61	1607.84	1608.36	1462.0
2013-03-31 23:00:00	ES	Futures	1608.1	1608.87	1607.33	1608.61	1793.0
2013-03-31 18:00:00	NQ	Futures	3279.51	3282.72	3279.51	3282.14	418.0
2013-03-31 19:00:00	NQ	Futures	3282.43	3284.18	3282.14	3282.43	186.0
2013-03-31 20:00:00	NQ	Futures	3282.14	3282.72	3277.47	3277.47	689.0
2013-03-31 21:00:00	NQ	Futures	3278.06	3278.93	3275.43	3278.64	630.0
2013-03-31 22:00:00	NQ	Futures	3278.06	3278.93	3277.76	3278.35	136.0
2013-03-31 23:00:00	NQ	Futures	3278.35	3280.39	3276.89	3280.1	201.0
2013-03-31 18:00:00	YM	Futures	14666.8	14666.8	14650.6	14657.7	277.0
2013-03-31 19:00:00	YM	Futures	14658.7	14666.8	14658.7	14661.7	168.0
2013-03-31 20:00:00	YM	Futures	14661.7	14662.7	14639.5	14641.5	408.0
2013-03-31 21:00:00	YM	Futures	14640.5	14649.6	14631.4	14649.6	1130.0
2013-03-31 22:00:00	YM	Futures	14649.6	14651.6	14647.6	14648.6	321.0
2013-03-31 23:00:00	YM	Futures	14648.6	14653.6	14642.5	14652.6	268.0
2013-03-31 18:00:00	CL	Futures	154.07	154.77	153.68	153.96	2648.0
2013-03-31 19:00:00	CL	Futures	153.94	153.94	153.79	153.85	579.0
2013-03-31 20:00:00	CL	Futures	153.85	153.87	153.45	153.61	1290.0
2013-03-31 21:00:00	CL	Futures	153.61	153.66	153.38	153.58	888.0
2013-03-31 22:00:00	CL	Futures	153.58	153.63	153.06	153.06	1296.0
2013-03-31 23:00:00	CL	Futures	153.06	153.3	153.01	153.3	614.0
2013-03-31 18:00:00	GC	Futures	2194.9	2199.7	2192.5	2194.9	1878.0
2013-03-31 19:00:00	GC	Futures	2194.8	2195.5	2192.2	2193.4	680.0
2013-03-31 20:00:00	GC	Futures	2193.6	2197.5	2191.2	2195.6	2275.0
2013-03-31 21:00:00	GC	Futures	2195.6	2199.7	2194.8	2197.1	2258.0
2013-03-31 22:00:00	GC	Futures	2197.1	2198.0	2195.1	2196.4	888.0
2013-03-31 23:00:00	GC	Futures	2195.9	2196.4	2195.6	2195.6	373.0
2013-03-31 18:00:00	ZN	Futures	118.389245	118.501582	118.389245	118.473497	8312.0
2013-03-31 19:00:00	ZN	Futures	118.473497	118.515624	118.473497	118.501582	5022.0
2013-03-31 20:00:00	ZN	Futures	118.501582	118.55775	118.473497	118.515624	6809.0
2013-03-31 21:00:00	ZN	Futures	118.515624	118.571792	118.501582	118.543708	4711.0
2013-03-31 22:00:00	ZN	Futures	118.543708	118.571792	118.543708	118.55775	4889.0
2013-03-31 23:00:00	ZN	Futures	118.55775	118.571792	118.529666	118.543708	2895.0

> showing 36 of 275 rows — these rows as CSV

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