PREVIEW / futures_1hour / 2018-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-02.parquet
  size:    16 KB
  rows:    322

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-12-02 18:00:00	ES	Futures	3039.31	3056.99	3038.76	3049.92	52930.0
2018-12-02 19:00:00	ES	Futures	3049.92	3051.0	3044.48	3045.29	18892.0
2018-12-02 20:00:00	ES	Futures	3045.29	3049.92	3044.2	3046.92	16198.0
2018-12-02 21:00:00	ES	Futures	3046.92	3053.18	3046.38	3053.18	9951.0
2018-12-02 22:00:00	ES	Futures	3053.18	3056.44	3053.18	3054.0	10818.0
2018-12-02 23:00:00	ES	Futures	3054.0	3055.9	3051.82	3053.18	7506.0
2018-12-02 18:00:00	NQ	Futures	8260.9	8333.93	8260.9	8311.35	15870.0
2018-12-02 19:00:00	NQ	Futures	8311.64	8323.96	8297.27	8300.79	6845.0
2018-12-02 20:00:00	NQ	Futures	8300.5	8316.04	8295.22	8304.31	6623.0
2018-12-02 21:00:00	NQ	Futures	8304.6	8325.43	8302.84	8323.38	4734.0
2018-12-02 22:00:00	NQ	Futures	8323.96	8347.72	8323.96	8335.11	7594.0
2018-12-02 23:00:00	NQ	Futures	8334.81	8343.32	8330.71	8333.05	3249.0
2018-12-02 18:00:00	YM	Futures	28046.1	28288.4	28042.9	28239.5	7170.0
2018-12-02 19:00:00	YM	Futures	28238.5	28253.7	28189.6	28196.1	3901.0
2018-12-02 20:00:00	YM	Futures	28196.1	28255.8	28196.1	28220.0	4240.0
2018-12-02 21:00:00	YM	Futures	28221.1	28272.1	28215.6	28270.0	2321.0
2018-12-02 22:00:00	YM	Futures	28271.1	28306.9	28268.9	28273.2	3034.0
2018-12-02 23:00:00	YM	Futures	28272.1	28296.0	28252.6	28265.6	1642.0
2018-12-02 18:00:00	CL	Futures	48.08	48.18	47.7	47.96	14283.0
2018-12-02 19:00:00	CL	Futures	47.96	48.45	47.86	48.2	15759.0
2018-12-02 20:00:00	CL	Futures	48.21	48.69	48.19	48.61	20708.0
2018-12-02 21:00:00	CL	Futures	48.6	49.37	48.57	49.29	29027.0
2018-12-02 22:00:00	CL	Futures	49.29	49.31	49.02	49.13	10157.0
2018-12-02 23:00:00	CL	Futures	49.13	49.29	49.1	49.29	7803.0
2018-12-02 18:00:00	GC	Futures	1590.5	1597.9	1589.5	1590.0	4896.0
2018-12-02 19:00:00	GC	Futures	1590.0	1591.1	1589.0	1590.9	4052.0
2018-12-02 20:00:00	GC	Futures	1590.9	1592.2	1590.2	1591.7	6240.0
2018-12-02 21:00:00	GC	Futures	1591.6	1593.4	1591.6	1592.6	5313.0
2018-12-02 22:00:00	GC	Futures	1592.5	1593.5	1592.0	1593.5	3818.0
2018-12-02 23:00:00	GC	Futures	1593.5	1595.1	1593.4	1594.0	4417.0
2018-12-02 18:00:00	ZN	Futures	120.243404	120.29062	120.196188	120.227665	3489.0
2018-12-02 19:00:00	ZN	Futures	120.227665	120.29062	120.227665	120.274881	1686.0
2018-12-02 20:00:00	ZN	Futures	120.259143	120.259143	120.196188	120.243404	1024.0
2018-12-02 21:00:00	ZN	Futures	120.227665	120.227665	120.196188	120.196188	538.0
2018-12-02 22:00:00	ZN	Futures	120.196188	120.196188	120.133233	120.148972	1527.0
2018-12-02 23:00:00	ZN	Futures	120.148972	120.148972	120.148972	120.148972	419.0

> showing 36 of 322 rows — these rows as CSV

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