PREVIEW / futures_1hour / 2018-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-04.parquet
  size:    15 KB
  rows:    311

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
2018-11-04 18:00:00	ES	Futures	2962.06	2962.6	2953.36	2954.44	10590.0
2018-11-04 19:00:00	ES	Futures	2954.72	2958.52	2952.27	2956.08	8550.0
2018-11-04 20:00:00	ES	Futures	2956.08	2958.8	2951.45	2953.08	11939.0
2018-11-04 21:00:00	ES	Futures	2953.08	2958.52	2952.54	2955.26	10472.0
2018-11-04 22:00:00	ES	Futures	2955.26	2956.62	2954.17	2955.53	3391.0
2018-11-04 23:00:00	ES	Futures	2955.53	2955.8	2954.44	2954.44	1886.0
2018-11-04 18:00:00	NQ	Futures	8180.82	8184.34	8157.07	8162.93	4794.0
2018-11-04 19:00:00	NQ	Futures	8163.52	8174.37	8154.13	8164.99	3863.0
2018-11-04 20:00:00	NQ	Futures	8165.28	8174.08	8147.97	8161.47	6171.0
2018-11-04 21:00:00	NQ	Futures	8160.88	8183.46	8157.65	8176.43	5587.0
2018-11-04 22:00:00	NQ	Futures	8175.84	8182.58	8170.56	8178.19	1775.0
2018-11-04 23:00:00	NQ	Futures	8178.19	8179.94	8173.49	8174.67	980.0
2018-11-04 18:00:00	YM	Futures	27401.8	27407.3	27326.9	27334.5	1903.0
2018-11-04 19:00:00	YM	Futures	27336.7	27364.9	27310.6	27346.4	2176.0
2018-11-04 20:00:00	YM	Futures	27346.4	27375.8	27305.1	27324.7	3249.0
2018-11-04 21:00:00	YM	Futures	27323.6	27375.8	27318.2	27341.0	2919.0
2018-11-04 22:00:00	YM	Futures	27342.1	27355.1	27328.0	27341.0	1234.0
2018-11-04 23:00:00	YM	Futures	27342.1	27347.5	27331.2	27338.8	739.0
2018-11-04 18:00:00	CL	Futures	57.9	57.98	57.8	57.89	3646.0
2018-11-04 19:00:00	CL	Futures	57.89	57.89	57.71	57.78	4570.0
2018-11-04 20:00:00	CL	Futures	57.79	57.83	57.47	57.6	12738.0
2018-11-04 21:00:00	CL	Futures	57.59	57.66	57.55	57.61	4879.0
2018-11-04 22:00:00	CL	Futures	57.61	57.69	57.55	57.63	4260.0
2018-11-04 23:00:00	CL	Futures	57.63	57.66	57.59	57.62	1926.0
2018-11-04 18:00:00	GC	Futures	1608.4	1610.2	1608.0	1609.9	1855.0
2018-11-04 19:00:00	GC	Futures	1609.9	1611.4	1609.3	1609.9	3608.0
2018-11-04 20:00:00	GC	Futures	1609.9	1609.9	1607.5	1608.8	4556.0
2018-11-04 21:00:00	GC	Futures	1608.6	1609.2	1606.8	1606.8	3672.0
2018-11-04 22:00:00	GC	Futures	1606.8	1607.7	1606.5	1607.2	1962.0
2018-11-04 23:00:00	GC	Futures	1607.3	1608.0	1606.8	1607.6	1431.0
2018-11-04 18:00:00	ZN	Futures	118.905618	118.952834	118.889879	118.952834	16997.0
2018-11-04 19:00:00	ZN	Futures	118.952834	118.984311	118.921356	118.952834	16863.0
2018-11-04 20:00:00	ZN	Futures	118.968572	119.015788	118.952834	118.984311	16884.0
2018-11-04 21:00:00	ZN	Futures	118.984311	119.00005	118.937095	118.968572	13636.0
2018-11-04 22:00:00	ZN	Futures	118.952834	119.00005	118.952834	118.968572	10106.0
2018-11-04 23:00:00	ZN	Futures	118.968572	118.984311	118.952834	118.952834	6546.0

> showing 36 of 311 rows — these rows as CSV

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