PREVIEW / futures_1hour / 2018-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-04.parquet
  size:    38 KB
  rows:    1,195

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-07-04 00:00:00	ES	Futures	2961.98	2963.34	2961.16	2962.53	1785.0
2018-07-04 01:00:00	ES	Futures	2962.8	2964.43	2962.53	2963.62	3974.0
2018-07-04 02:00:00	ES	Futures	2963.62	2964.16	2960.35	2962.53	6296.0
2018-07-04 03:00:00	ES	Futures	2962.53	2964.98	2962.25	2963.34	7485.0
2018-07-04 04:00:00	ES	Futures	2963.34	2968.25	2962.53	2966.89	7182.0
2018-07-04 05:00:00	ES	Futures	2966.89	2968.79	2964.43	2964.43	6589.0
2018-07-04 06:00:00	ES	Futures	2964.71	2967.43	2964.16	2967.16	4725.0
2018-07-04 07:00:00	ES	Futures	2967.16	2967.7	2964.43	2964.71	3065.0
2018-07-04 08:00:00	ES	Futures	2964.98	2966.07	2963.34	2965.8	4665.0
2018-07-04 09:00:00	ES	Futures	2965.8	2966.61	2962.25	2963.34	8876.0
2018-07-04 10:00:00	ES	Futures	2963.34	2964.71	2962.25	2963.62	6599.0
2018-07-04 11:00:00	ES	Futures	2963.89	2966.34	2962.8	2965.25	5807.0
2018-07-04 12:00:00	ES	Futures	2965.25	2967.43	2964.43	2966.34	3811.0
2018-07-04 18:00:00	ES	Futures	2966.61	2967.43	2964.16	2964.16	1505.0
2018-07-04 19:00:00	ES	Futures	2964.16	2964.71	2962.8	2964.43	1995.0
2018-07-04 20:00:00	ES	Futures	2964.43	2967.16	2959.26	2959.53	7418.0
2018-07-04 21:00:00	ES	Futures	2959.53	2966.34	2956.26	2964.16	13529.0
2018-07-04 22:00:00	ES	Futures	2964.16	2967.43	2963.07	2965.8	6202.0
2018-07-04 23:00:00	ES	Futures	2965.52	2966.61	2957.89	2959.8	7655.0
2018-07-04 00:00:00	NQ	Futures	8288.75	8292.88	8286.69	8289.93	631.0
2018-07-04 01:00:00	NQ	Futures	8290.23	8299.35	8287.87	8289.34	1428.0
2018-07-04 02:00:00	NQ	Futures	8289.05	8293.46	8283.16	8287.87	2263.0
2018-07-04 03:00:00	NQ	Futures	8287.87	8296.41	8285.81	8290.52	2998.0
2018-07-04 04:00:00	NQ	Futures	8291.4	8301.41	8287.58	8297.29	2370.0
2018-07-04 05:00:00	NQ	Futures	8298.18	8304.65	8292.58	8293.76	2071.0
2018-07-04 06:00:00	NQ	Futures	8293.76	8305.83	8293.76	8304.06	1688.0
2018-07-04 07:00:00	NQ	Futures	8304.36	8304.95	8292.88	8294.64	1494.0
2018-07-04 08:00:00	NQ	Futures	8295.23	8298.47	8285.52	8295.23	2075.0
2018-07-04 09:00:00	NQ	Futures	8294.94	8299.35	8279.63	8283.75	4556.0
2018-07-04 10:00:00	NQ	Futures	8283.45	8286.1	8272.27	8279.04	4462.0
2018-07-04 11:00:00	NQ	Futures	8279.63	8284.34	8275.21	8280.22	3085.0
2018-07-04 12:00:00	NQ	Futures	8280.22	8296.7	8277.86	8293.76	1803.0
2018-07-04 18:00:00	NQ	Futures	8295.23	8299.94	8290.23	8291.4	790.0
2018-07-04 19:00:00	NQ	Futures	8291.4	8292.58	8286.4	8289.34	1044.0
2018-07-04 20:00:00	NQ	Futures	8289.64	8299.65	8274.33	8274.62	3373.0
2018-07-04 21:00:00	NQ	Futures	8274.33	8293.46	8264.02	8285.22	5244.0
2018-07-04 22:00:00	NQ	Futures	8284.04	8291.99	8280.51	8287.87	1975.0
2018-07-04 23:00:00	NQ	Futures	8287.87	8290.52	8265.79	8273.44	2763.0
2018-07-04 00:00:00	YM	Futures	26302.2	26316.4	26295.7	26313.1	721.0
2018-07-04 01:00:00	YM	Futures	26313.1	26332.7	26293.6	26306.6	1209.0
2018-07-04 02:00:00	YM	Futures	26308.8	26308.8	26266.4	26282.7	2446.0
2018-07-04 03:00:00	YM	Futures	26282.7	26307.7	26276.2	26282.7	2169.0
2018-07-04 04:00:00	YM	Futures	26283.8	26333.8	26277.2	26319.6	1888.0
2018-07-04 05:00:00	YM	Futures	26319.6	26365.3	26317.5	26318.6	2544.0
2018-07-04 06:00:00	YM	Futures	26318.6	26349.0	26318.6	26343.6	1095.0
2018-07-04 07:00:00	YM	Futures	26344.6	26353.3	26320.7	26326.2	1111.0
2018-07-04 08:00:00	YM	Futures	26327.3	26337.0	26301.2	26330.5	1599.0
2018-07-04 09:00:00	YM	Futures	26331.6	26338.1	26271.8	26285.9	3722.0
2018-07-04 10:00:00	YM	Futures	26285.9	26308.8	26272.9	26293.6	2862.0
2018-07-04 11:00:00	YM	Futures	26294.6	26324.0	26282.7	26314.2	2480.0

> showing 50 of 1,195 rows — these rows as CSV

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