PREVIEW / futures_1hour / 2017-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-18.parquet
  size:    52 KB
  rows:    1,611

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-07-18 00:00:00	ES	Futures	2685.28	2685.83	2685.01	2685.56	1727.0
2017-07-18 01:00:00	ES	Futures	2685.56	2686.38	2685.28	2686.1	2919.0
2017-07-18 02:00:00	ES	Futures	2686.1	2686.65	2685.56	2685.83	5930.0
2017-07-18 03:00:00	ES	Futures	2686.1	2686.65	2684.46	2685.28	16208.0
2017-07-18 04:00:00	ES	Futures	2685.56	2690.2	2684.74	2688.56	21036.0
2017-07-18 05:00:00	ES	Futures	2688.84	2689.66	2687.47	2688.56	10957.0
2017-07-18 06:00:00	ES	Futures	2688.84	2689.38	2686.38	2687.2	14141.0
2017-07-18 07:00:00	ES	Futures	2687.2	2688.02	2685.28	2685.83	22139.0
2017-07-18 08:00:00	ES	Futures	2685.83	2686.92	2680.91	2681.18	40980.0
2017-07-18 09:00:00	ES	Futures	2680.91	2682.82	2678.72	2681.46	159310.0
2017-07-18 10:00:00	ES	Futures	2681.73	2683.92	2676.54	2682.82	197321.0
2017-07-18 11:00:00	ES	Futures	2682.82	2685.28	2680.91	2684.19	113019.0
2017-07-18 12:00:00	ES	Futures	2684.19	2685.28	2682.55	2682.82	79963.0
2017-07-18 13:00:00	ES	Futures	2682.82	2685.56	2681.18	2684.74	79989.0
2017-07-18 14:00:00	ES	Futures	2685.01	2686.1	2683.92	2685.01	65471.0
2017-07-18 15:00:00	ES	Futures	2685.01	2688.02	2684.74	2687.47	141110.0
2017-07-18 16:00:00	ES	Futures	2687.47	2690.75	2685.83	2689.93	69623.0
2017-07-18 18:00:00	ES	Futures	2689.38	2689.66	2687.2	2688.02	6463.0
2017-07-18 19:00:00	ES	Futures	2688.02	2688.56	2687.74	2688.02	1573.0
2017-07-18 20:00:00	ES	Futures	2688.02	2689.66	2687.74	2689.38	3653.0
2017-07-18 21:00:00	ES	Futures	2689.66	2690.2	2688.84	2689.66	3966.0
2017-07-18 22:00:00	ES	Futures	2689.93	2690.75	2689.66	2689.93	2975.0
2017-07-18 23:00:00	ES	Futures	2690.2	2690.2	2689.38	2689.66	1320.0
2017-07-18 00:00:00	NQ	Futures	6968.57	6971.25	6968.57	6970.65	266.0
2017-07-18 01:00:00	NQ	Futures	6970.65	6973.04	6968.87	6972.14	641.0
2017-07-18 02:00:00	NQ	Futures	6971.85	6972.14	6969.17	6970.65	567.0
2017-07-18 03:00:00	NQ	Futures	6970.95	6971.85	6964.1	6967.68	2008.0
2017-07-18 04:00:00	NQ	Futures	6967.97	6982.27	6964.7	6978.4	2988.0
2017-07-18 05:00:00	NQ	Futures	6978.4	6980.78	6975.72	6977.8	1550.0
2017-07-18 06:00:00	NQ	Futures	6978.1	6979.88	6970.36	6972.44	3854.0
2017-07-18 07:00:00	NQ	Futures	6972.74	6975.12	6962.32	6964.7	3980.0
2017-07-18 08:00:00	NQ	Futures	6964.7	6969.17	6946.24	6947.13	8429.0
2017-07-18 09:00:00	NQ	Futures	6946.83	6961.13	6931.95	6956.66	45288.0
2017-07-18 10:00:00	NQ	Futures	6956.96	6975.72	6948.92	6974.82	49595.0
2017-07-18 11:00:00	NQ	Futures	6975.12	6988.22	6967.97	6983.76	30487.0
2017-07-18 12:00:00	NQ	Futures	6983.46	6987.92	6976.01	6981.08	17571.0
2017-07-18 13:00:00	NQ	Futures	6981.08	6995.37	6974.53	6994.18	20065.0
2017-07-18 14:00:00	NQ	Futures	6993.88	7001.62	6991.2	6995.67	18763.0
2017-07-18 15:00:00	NQ	Futures	6995.96	7006.09	6994.47	7004.6	24203.0
2017-07-18 16:00:00	NQ	Futures	7004.3	7025.14	7003.41	7022.76	9462.0
2017-07-18 18:00:00	NQ	Futures	7021.57	7022.76	7013.83	7016.51	1693.0
2017-07-18 19:00:00	NQ	Futures	7015.32	7019.19	7014.42	7018.0	552.0
2017-07-18 20:00:00	NQ	Futures	7017.7	7024.55	7017.4	7024.25	1411.0
2017-07-18 21:00:00	NQ	Futures	7023.95	7031.69	7022.17	7029.31	2510.0
2017-07-18 22:00:00	NQ	Futures	7029.61	7032.88	7028.12	7029.61	1347.0
2017-07-18 23:00:00	NQ	Futures	7029.91	7032.88	7028.42	7029.01	875.0
2017-07-18 00:00:00	YM	Futures	23481.8	23490.5	23481.8	23486.2	427.0
2017-07-18 01:00:00	YM	Futures	23486.2	23494.9	23484.0	23491.6	617.0
2017-07-18 02:00:00	YM	Futures	23490.5	23493.8	23487.3	23489.4	740.0
2017-07-18 03:00:00	YM	Futures	23489.4	23492.7	23474.2	23481.8	2280.0

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

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