PREVIEW / futures_1hour / 2017-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-17.parquet
  size:    51 KB
  rows:    1,587

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-17 00:00:00	ES	Futures	2686.38	2686.38	2685.83	2686.1	957.0
2017-07-17 01:00:00	ES	Futures	2686.1	2686.92	2685.56	2686.38	1571.0
2017-07-17 02:00:00	ES	Futures	2686.38	2686.65	2685.56	2685.83	5031.0
2017-07-17 03:00:00	ES	Futures	2686.1	2688.29	2685.83	2686.65	17518.0
2017-07-17 04:00:00	ES	Futures	2686.92	2686.92	2685.28	2685.56	10735.0
2017-07-17 05:00:00	ES	Futures	2685.83	2685.83	2683.1	2685.01	17794.0
2017-07-17 06:00:00	ES	Futures	2685.28	2688.29	2684.19	2686.92	15677.0
2017-07-17 07:00:00	ES	Futures	2686.92	2688.29	2686.65	2687.2	11074.0
2017-07-17 08:00:00	ES	Futures	2687.2	2688.02	2684.74	2685.01	17754.0
2017-07-17 09:00:00	ES	Futures	2685.01	2687.47	2683.37	2687.2	99338.0
2017-07-17 10:00:00	ES	Futures	2687.2	2688.84	2685.28	2688.56	140137.0
2017-07-17 11:00:00	ES	Futures	2688.56	2689.66	2685.56	2686.65	108529.0
2017-07-17 12:00:00	ES	Futures	2686.65	2689.38	2686.38	2688.84	65380.0
2017-07-17 13:00:00	ES	Futures	2688.84	2690.2	2687.2	2687.74	64696.0
2017-07-17 14:00:00	ES	Futures	2687.74	2688.02	2685.56	2686.1	79349.0
2017-07-17 15:00:00	ES	Futures	2686.38	2686.92	2684.46	2685.83	115321.0
2017-07-17 16:00:00	ES	Futures	2685.83	2689.38	2685.56	2689.38	54252.0
2017-07-17 18:00:00	ES	Futures	2688.84	2689.11	2687.74	2688.29	2603.0
2017-07-17 19:00:00	ES	Futures	2688.02	2688.56	2688.02	2688.02	1443.0
2017-07-17 20:00:00	ES	Futures	2688.02	2688.56	2685.83	2686.38	6379.0
2017-07-17 21:00:00	ES	Futures	2686.1	2686.65	2683.37	2684.74	12329.0
2017-07-17 22:00:00	ES	Futures	2685.01	2685.83	2684.19	2684.46	4529.0
2017-07-17 23:00:00	ES	Futures	2684.46	2685.56	2684.19	2685.28	2854.0
2017-07-17 00:00:00	NQ	Futures	6968.57	6968.57	6965.89	6967.38	253.0
2017-07-17 01:00:00	NQ	Futures	6967.68	6970.36	6965.0	6969.46	548.0
2017-07-17 02:00:00	NQ	Futures	6969.17	6970.36	6965.29	6966.19	780.0
2017-07-17 03:00:00	NQ	Futures	6966.19	6973.63	6965.89	6966.78	1954.0
2017-07-17 04:00:00	NQ	Futures	6966.49	6968.57	6962.62	6964.1	1194.0
2017-07-17 05:00:00	NQ	Futures	6964.1	6965.0	6956.36	6962.91	2327.0
2017-07-17 06:00:00	NQ	Futures	6962.91	6972.74	6960.83	6972.14	3906.0
2017-07-17 07:00:00	NQ	Futures	6972.14	6976.61	6970.06	6971.25	1980.0
2017-07-17 08:00:00	NQ	Futures	6971.25	6972.14	6961.13	6963.81	3683.0
2017-07-17 09:00:00	NQ	Futures	6963.81	6976.01	6955.77	6975.42	35042.0
2017-07-17 10:00:00	NQ	Futures	6975.42	6983.76	6956.36	6957.85	45069.0
2017-07-17 11:00:00	NQ	Futures	6958.15	6962.62	6950.41	6955.47	32552.0
2017-07-17 12:00:00	NQ	Futures	6955.17	6967.08	6953.09	6965.29	16288.0
2017-07-17 13:00:00	NQ	Futures	6965.29	6967.97	6953.09	6955.17	14508.0
2017-07-17 14:00:00	NQ	Futures	6955.47	6957.26	6945.05	6952.49	18166.0
2017-07-17 15:00:00	NQ	Futures	6952.79	6962.02	6950.41	6957.85	22272.0
2017-07-17 16:00:00	NQ	Futures	6957.85	6978.99	6957.85	6978.1	9824.0
2017-07-17 18:00:00	NQ	Futures	6977.2	6977.5	6972.44	6974.53	829.0
2017-07-17 19:00:00	NQ	Futures	6974.23	6976.91	6973.93	6975.72	331.0
2017-07-17 20:00:00	NQ	Futures	6975.72	6975.72	6967.97	6969.46	1113.0
2017-07-17 21:00:00	NQ	Futures	6969.17	6970.36	6962.91	6967.08	1985.0
2017-07-17 22:00:00	NQ	Futures	6966.78	6971.85	6965.59	6965.89	859.0
2017-07-17 23:00:00	NQ	Futures	6965.89	6969.46	6965.89	6968.87	510.0
2017-07-17 00:00:00	YM	Futures	23510.1	23512.3	23507.9	23510.1	181.0
2017-07-17 01:00:00	YM	Futures	23511.2	23515.6	23506.9	23513.4	293.0
2017-07-17 02:00:00	YM	Futures	23512.3	23524.3	23507.9	23513.4	1577.0
2017-07-17 03:00:00	YM	Futures	23513.4	23530.8	23513.4	23521.0	1798.0

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

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