PREVIEW / futures_1hour / 2016-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-07.parquet
  size:    15 KB
  rows:    290

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-08-07 18:00:00	ES	Futures	2360.41	2363.39	2360.41	2362.85	5369.0
2016-08-07 19:00:00	ES	Futures	2362.85	2363.12	2361.76	2361.76	2318.0
2016-08-07 20:00:00	ES	Futures	2361.76	2362.58	2361.49	2362.03	3649.0
2016-08-07 21:00:00	ES	Futures	2362.03	2362.58	2360.68	2362.03	3438.0
2016-08-07 22:00:00	ES	Futures	2362.3	2363.39	2361.76	2362.85	2999.0
2016-08-07 23:00:00	ES	Futures	2362.85	2363.12	2362.03	2362.3	2099.0
2016-08-07 18:00:00	NQ	Futures	5704.41	5709.18	5701.13	5708.88	842.0
2016-08-07 19:00:00	NQ	Futures	5708.58	5709.18	5706.5	5706.5	395.0
2016-08-07 20:00:00	NQ	Futures	5706.79	5708.28	5705.3	5707.99	463.0
2016-08-07 21:00:00	NQ	Futures	5707.69	5709.18	5704.41	5708.28	492.0
2016-08-07 22:00:00	NQ	Futures	5708.28	5711.56	5707.09	5710.97	528.0
2016-08-07 23:00:00	NQ	Futures	5710.67	5710.97	5708.88	5709.18	303.0
2016-08-07 18:00:00	YM	Futures	19864.6	19889.3	19860.3	19888.3	1458.0
2016-08-07 19:00:00	YM	Futures	19886.1	19887.2	19878.6	19879.7	501.0
2016-08-07 20:00:00	YM	Futures	19879.7	19882.9	19872.1	19881.8	575.0
2016-08-07 21:00:00	YM	Futures	19880.7	19882.9	19865.7	19880.7	788.0
2016-08-07 22:00:00	YM	Futures	19879.7	19889.3	19877.5	19886.1	478.0
2016-08-07 23:00:00	YM	Futures	19886.1	19887.2	19877.5	19879.7	277.0
2016-08-07 18:00:00	CL	Futures	43.3	43.31	43.14	43.21	2387.0
2016-08-07 19:00:00	CL	Futures	43.22	43.29	43.19	43.27	949.0
2016-08-07 20:00:00	CL	Futures	43.27	43.39	43.26	43.29	2339.0
2016-08-07 21:00:00	CL	Futures	43.29	43.3	43.15	43.23	3647.0
2016-08-07 22:00:00	CL	Futures	43.22	43.24	43.12	43.19	2233.0
2016-08-07 23:00:00	CL	Futures	43.19	43.23	43.14	43.2	1754.0
2016-08-07 18:00:00	GC	Futures	1814.6	1814.7	1809.3	1810.8	3335.0
2016-08-07 19:00:00	GC	Futures	1811.1	1812.3	1808.9	1812.0	2628.0
2016-08-07 20:00:00	GC	Futures	1812.1	1814.2	1810.9	1813.0	6204.0
2016-08-07 21:00:00	GC	Futures	1812.8	1817.6	1812.6	1814.6	6703.0
2016-08-07 22:00:00	GC	Futures	1814.6	1817.8	1814.0	1815.8	3359.0
2016-08-07 23:00:00	GC	Futures	1815.8	1817.8	1811.6	1816.5	7209.0
2016-08-07 18:00:00	ZN	Futures	128.583926	128.599141	128.477419	128.50785	8913.0
2016-08-07 19:00:00	ZN	Futures	128.50785	128.583926	128.50785	128.568711	5306.0
2016-08-07 20:00:00	ZN	Futures	128.568711	128.583926	128.431774	128.50785	20208.0
2016-08-07 21:00:00	ZN	Futures	128.50785	128.568711	128.477419	128.553495	10825.0
2016-08-07 22:00:00	ZN	Futures	128.553495	128.629572	128.553495	128.599141	9950.0
2016-08-07 23:00:00	ZN	Futures	128.583926	128.629572	128.583926	128.614356	3722.0

> showing 36 of 290 rows — these rows as CSV

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