PREVIEW / futures_1hour / 2017-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-03.parquet
  size:    13 KB
  rows:    253

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
2017-09-03 18:00:00	ES	Futures	2691.02	2696.22	2689.93	2695.4	31896.0
2017-09-03 19:00:00	ES	Futures	2695.4	2696.76	2694.3	2694.85	5718.0
2017-09-03 20:00:00	ES	Futures	2695.12	2695.94	2693.21	2693.21	12723.0
2017-09-03 21:00:00	ES	Futures	2693.21	2697.04	2692.94	2696.49	16481.0
2017-09-03 22:00:00	ES	Futures	2696.76	2697.04	2695.4	2696.22	3558.0
2017-09-03 23:00:00	ES	Futures	2696.22	2697.04	2695.12	2695.67	5144.0
2017-09-03 18:00:00	NQ	Futures	7094.22	7107.32	7086.48	7103.45	6096.0
2017-09-03 19:00:00	NQ	Futures	7103.15	7104.34	7098.69	7099.28	1192.0
2017-09-03 20:00:00	NQ	Futures	7099.58	7101.37	7088.86	7088.86	3291.0
2017-09-03 21:00:00	NQ	Futures	7088.86	7103.75	7082.31	7101.96	4552.0
2017-09-03 22:00:00	NQ	Futures	7102.26	7103.75	7096.31	7100.18	933.0
2017-09-03 23:00:00	NQ	Futures	7099.88	7105.54	7098.09	7099.58	4112.0
2017-09-03 18:00:00	YM	Futures	23821.4	23867.1	23812.7	23860.6	3022.0
2017-09-03 19:00:00	YM	Futures	23861.7	23872.6	23851.9	23857.3	894.0
2017-09-03 20:00:00	YM	Futures	23858.4	23862.8	23843.2	23844.3	1446.0
2017-09-03 21:00:00	YM	Futures	23845.4	23872.6	23842.1	23869.3	2088.0
2017-09-03 22:00:00	YM	Futures	23870.4	23873.7	23863.9	23870.4	522.0
2017-09-03 23:00:00	YM	Futures	23871.5	23876.9	23863.9	23867.1	748.0
2017-09-03 18:00:00	CL	Futures	42.76	42.91	42.76	42.86	3679.0
2017-09-03 19:00:00	CL	Futures	42.87	42.87	42.78	42.79	1929.0
2017-09-03 20:00:00	CL	Futures	42.79	42.91	42.71	42.85	5933.0
2017-09-03 21:00:00	CL	Futures	42.85	42.97	42.83	42.9	5677.0
2017-09-03 22:00:00	CL	Futures	42.91	42.91	42.87	42.88	2271.0
2017-09-03 23:00:00	CL	Futures	42.88	42.92	42.87	42.9	2328.0
2017-09-03 18:00:00	GC	Futures	1784.7	1789.7	1782.8	1785.2	13121.0
2017-09-03 19:00:00	GC	Futures	1785.3	1787.3	1785.2	1786.8	5087.0
2017-09-03 20:00:00	GC	Futures	1786.7	1787.6	1785.5	1786.1	9778.0
2017-09-03 21:00:00	GC	Futures	1786.0	1786.3	1781.2	1782.9	17927.0
2017-09-03 22:00:00	GC	Futures	1782.9	1783.3	1781.6	1782.8	5404.0
2017-09-03 23:00:00	GC	Futures	1782.7	1784.1	1782.3	1783.6	3173.0
2017-09-03 18:00:00	ZN	Futures	126.400599	126.447189	126.322947	126.385068	1398.0
2017-09-03 19:00:00	ZN	Futures	126.385068	126.400599	126.338478	126.338478	265.0
2017-09-03 20:00:00	ZN	Futures	126.338478	126.338478	126.291887	126.338478	474.0
2017-09-03 21:00:00	ZN	Futures	126.338478	126.369538	126.307417	126.354008	587.0
2017-09-03 22:00:00	ZN	Futures	126.338478	126.338478	126.338478	126.338478	13.0

> showing 35 of 253 rows — these rows as CSV

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