PREVIEW / futures_1hour / 2017-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-25.parquet
  size:    53 KB
  rows:    1,633

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-09-25 00:00:00	ES	Futures	2733.12	2733.67	2732.58	2733.12	4102.0
2017-09-25 01:00:00	ES	Futures	2733.12	2733.67	2731.76	2732.58	5290.0
2017-09-25 02:00:00	ES	Futures	2732.58	2733.12	2731.76	2732.58	9597.0
2017-09-25 03:00:00	ES	Futures	2732.85	2732.85	2730.11	2731.76	24475.0
2017-09-25 04:00:00	ES	Futures	2731.76	2733.67	2730.11	2732.85	17922.0
2017-09-25 05:00:00	ES	Futures	2732.85	2733.4	2730.39	2731.76	13321.0
2017-09-25 06:00:00	ES	Futures	2732.03	2733.94	2731.76	2733.67	9840.0
2017-09-25 07:00:00	ES	Futures	2733.4	2734.49	2732.85	2733.94	10964.0
2017-09-25 08:00:00	ES	Futures	2733.94	2733.94	2730.94	2731.21	12550.0
2017-09-25 09:00:00	ES	Futures	2731.48	2733.4	2729.84	2731.76	151860.0
2017-09-25 10:00:00	ES	Futures	2732.03	2735.59	2724.64	2725.19	268940.0
2017-09-25 11:00:00	ES	Futures	2725.19	2727.65	2719.17	2724.37	314655.0
2017-09-25 12:00:00	ES	Futures	2724.37	2727.11	2720.27	2726.29	154452.0
2017-09-25 13:00:00	ES	Futures	2726.29	2728.2	2724.64	2726.29	83675.0
2017-09-25 14:00:00	ES	Futures	2726.56	2727.65	2722.73	2725.74	102513.0
2017-09-25 15:00:00	ES	Futures	2725.74	2729.57	2724.1	2729.02	172806.0
2017-09-25 16:00:00	ES	Futures	2729.29	2733.67	2729.02	2733.4	121062.0
2017-09-25 18:00:00	ES	Futures	2733.4	2733.67	2732.3	2732.85	5604.0
2017-09-25 19:00:00	ES	Futures	2732.58	2733.12	2730.94	2732.03	5268.0
2017-09-25 20:00:00	ES	Futures	2731.76	2732.3	2727.65	2729.84	13341.0
2017-09-25 21:00:00	ES	Futures	2729.57	2730.66	2729.29	2730.39	6662.0
2017-09-25 22:00:00	ES	Futures	2730.39	2732.85	2729.84	2730.94	9291.0
2017-09-25 23:00:00	ES	Futures	2730.94	2731.48	2730.11	2730.11	4342.0
2017-09-25 00:00:00	NQ	Futures	7059.48	7061.56	7057.69	7060.67	747.0
2017-09-25 01:00:00	NQ	Futures	7060.67	7063.34	7055.91	7059.18	1056.0
2017-09-25 02:00:00	NQ	Futures	7059.77	7060.37	7054.72	7056.21	1674.0
2017-09-25 03:00:00	NQ	Futures	7056.21	7057.1	7044.31	7049.96	4274.0
2017-09-25 04:00:00	NQ	Futures	7049.66	7056.8	7045.5	7055.61	2802.0
2017-09-25 05:00:00	NQ	Futures	7055.91	7057.1	7046.39	7051.45	1896.0
2017-09-25 06:00:00	NQ	Futures	7051.74	7058.58	7051.15	7057.1	2070.0
2017-09-25 07:00:00	NQ	Futures	7057.1	7059.18	7050.85	7051.74	2269.0
2017-09-25 08:00:00	NQ	Futures	7051.45	7051.45	7031.52	7032.41	6745.0
2017-09-25 09:00:00	NQ	Futures	7032.41	7033.6	7002.97	7012.78	63756.0
2017-09-25 10:00:00	NQ	Futures	7012.78	7035.68	6972.33	6975.9	92302.0
2017-09-25 11:00:00	NQ	Futures	6975.9	6990.48	6962.52	6974.12	68111.0
2017-09-25 12:00:00	NQ	Futures	6974.71	6983.04	6954.19	6978.58	51236.0
2017-09-25 13:00:00	NQ	Futures	6978.58	6983.04	6968.17	6975.61	29991.0
2017-09-25 14:00:00	NQ	Futures	6975.61	6980.96	6950.03	6966.68	37710.0
2017-09-25 15:00:00	NQ	Futures	6966.98	6985.72	6959.54	6985.12	48997.0
2017-09-25 16:00:00	NQ	Futures	6984.83	6994.64	6984.83	6993.75	11781.0
2017-09-25 18:00:00	NQ	Futures	6993.75	6995.23	6989.58	6990.77	1221.0
2017-09-25 19:00:00	NQ	Futures	6990.48	6992.56	6985.72	6988.69	1173.0
2017-09-25 20:00:00	NQ	Futures	6988.69	6989.88	6974.71	6983.34	4084.0
2017-09-25 21:00:00	NQ	Futures	6983.04	6988.1	6981.55	6987.8	2317.0
2017-09-25 22:00:00	NQ	Futures	6987.8	6998.21	6986.31	6992.86	2717.0
2017-09-25 23:00:00	NQ	Futures	6992.56	6994.94	6987.5	6990.18	2538.0
2017-09-25 00:00:00	YM	Futures	24247.7	24251.0	24240.1	24249.9	1545.0
2017-09-25 01:00:00	YM	Futures	24249.9	24252.1	24239.0	24246.7	985.0
2017-09-25 02:00:00	YM	Futures	24246.7	24249.9	24236.9	24247.7	2291.0
2017-09-25 03:00:00	YM	Futures	24247.7	24249.9	24228.2	24241.2	3306.0

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

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