PREVIEW / futures_1hour / 2016-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-20.parquet
  size:    15 KB
  rows:    293

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
2016-03-20 18:00:00	ES	Futures	2199.26	2200.34	2197.64	2198.99	6243.0
2016-03-20 19:00:00	ES	Futures	2198.72	2200.07	2198.45	2199.26	2329.0
2016-03-20 20:00:00	ES	Futures	2199.26	2199.8	2197.64	2198.18	5094.0
2016-03-20 21:00:00	ES	Futures	2197.91	2198.18	2193.32	2195.48	10323.0
2016-03-20 22:00:00	ES	Futures	2195.48	2197.1	2194.94	2197.1	3045.0
2016-03-20 23:00:00	ES	Futures	2196.83	2197.37	2195.48	2196.56	2169.0
2016-03-20 18:00:00	NQ	Futures	5230.27	5230.27	5219.56	5223.73	818.0
2016-03-20 19:00:00	NQ	Futures	5223.43	5227.6	5222.84	5224.32	275.0
2016-03-20 20:00:00	NQ	Futures	5225.81	5226.11	5220.75	5221.94	426.0
2016-03-20 21:00:00	NQ	Futures	5221.94	5222.24	5211.53	5217.18	1236.0
2016-03-20 22:00:00	NQ	Futures	5217.48	5222.54	5214.8	5222.24	408.0
2016-03-20 23:00:00	NQ	Futures	5222.54	5222.54	5215.1	5217.48	466.0
2016-03-20 18:00:00	YM	Futures	18721.1	18722.2	18699.7	18710.4	913.0
2016-03-20 19:00:00	YM	Futures	18710.4	18720.0	18707.2	18713.6	377.0
2016-03-20 20:00:00	YM	Futures	18713.6	18717.9	18702.9	18705.1	539.0
2016-03-20 21:00:00	YM	Futures	18706.1	18707.2	18670.8	18686.9	1813.0
2016-03-20 22:00:00	YM	Futures	18684.7	18701.9	18679.4	18698.6	669.0
2016-03-20 23:00:00	YM	Futures	18699.7	18701.9	18684.7	18694.4	310.0
2016-03-20 18:00:00	CL	Futures	45.59	45.66	45.35	45.53	2886.0
2016-03-20 19:00:00	CL	Futures	45.53	45.54	45.31	45.31	2474.0
2016-03-20 20:00:00	CL	Futures	45.31	45.42	45.21	45.3	2694.0
2016-03-20 21:00:00	CL	Futures	45.3	45.41	45.14	45.23	3707.0
2016-03-20 22:00:00	CL	Futures	45.23	45.39	45.21	45.36	1917.0
2016-03-20 23:00:00	CL	Futures	45.35	45.36	45.2	45.22	1489.0
2016-03-20 18:00:00	GC	Futures	1713.5	1715.5	1712.4	1714.7	860.0
2016-03-20 19:00:00	GC	Futures	1714.6	1715.1	1710.7	1711.7	1363.0
2016-03-20 20:00:00	GC	Futures	1711.6	1714.8	1710.7	1712.8	1380.0
2016-03-20 21:00:00	GC	Futures	1712.8	1714.4	1708.4	1710.3	4878.0
2016-03-20 22:00:00	GC	Futures	1710.3	1712.2	1709.8	1711.4	2665.0
2016-03-20 23:00:00	GC	Futures	1711.6	1713.5	1709.4	1709.6	3467.0
2016-03-20 18:00:00	ZN	Futures	125.997337	126.027767	125.951691	125.982121	3517.0
2016-03-20 19:00:00	ZN	Futures	125.997337	125.997337	125.936476	125.951691	3470.0
2016-03-20 20:00:00	ZN	Futures	125.951691	125.966906	125.936476	125.951691	2691.0
2016-03-20 21:00:00	ZN	Futures	125.951691	126.042982	125.936476	126.027767	6664.0
2016-03-20 22:00:00	ZN	Futures	126.027767	126.073413	126.027767	126.058197	2637.0
2016-03-20 23:00:00	ZN	Futures	126.058197	126.058197	126.027767	126.058197	1950.0

> showing 36 of 293 rows — these rows as CSV

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