PREVIEW / futures_1hour / 2017-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-23.parquet
  size:    52 KB
  rows:    1,609

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-08-23 00:00:00	ES	Futures	2675.99	2677.63	2675.99	2677.08	3575.0
2017-08-23 01:00:00	ES	Futures	2677.08	2678.45	2676.81	2678.18	3553.0
2017-08-23 02:00:00	ES	Futures	2678.18	2678.45	2676.81	2676.81	6528.0
2017-08-23 03:00:00	ES	Futures	2677.08	2679.82	2675.99	2677.9	26365.0
2017-08-23 04:00:00	ES	Futures	2677.9	2678.18	2675.44	2676.26	22066.0
2017-08-23 05:00:00	ES	Futures	2675.99	2676.81	2675.17	2675.44	11396.0
2017-08-23 06:00:00	ES	Futures	2675.44	2675.99	2673.53	2675.99	14567.0
2017-08-23 07:00:00	ES	Futures	2675.99	2676.26	2670.8	2672.44	37343.0
2017-08-23 08:00:00	ES	Futures	2672.44	2673.53	2670.25	2670.52	38157.0
2017-08-23 09:00:00	ES	Futures	2670.52	2674.08	2666.42	2673.53	220162.0
2017-08-23 10:00:00	ES	Futures	2673.26	2675.17	2669.16	2672.16	185718.0
2017-08-23 11:00:00	ES	Futures	2672.16	2676.26	2670.52	2674.9	112333.0
2017-08-23 12:00:00	ES	Futures	2674.9	2676.26	2671.89	2672.98	65166.0
2017-08-23 13:00:00	ES	Futures	2672.98	2673.8	2669.43	2671.07	65526.0
2017-08-23 14:00:00	ES	Futures	2671.07	2674.35	2670.25	2673.26	99244.0
2017-08-23 15:00:00	ES	Futures	2673.26	2676.26	2670.25	2670.8	166096.0
2017-08-23 16:00:00	ES	Futures	2670.52	2671.62	2666.97	2667.79	99037.0
2017-08-23 18:00:00	ES	Futures	2668.06	2668.61	2662.6	2665.33	16039.0
2017-08-23 19:00:00	ES	Futures	2665.33	2665.6	2663.42	2663.69	6904.0
2017-08-23 20:00:00	ES	Futures	2663.69	2667.24	2663.42	2666.42	8316.0
2017-08-23 21:00:00	ES	Futures	2666.7	2668.34	2666.15	2667.52	7340.0
2017-08-23 22:00:00	ES	Futures	2667.24	2668.61	2665.88	2668.06	5238.0
2017-08-23 23:00:00	ES	Futures	2668.06	2669.43	2667.79	2669.16	5153.0
2017-08-23 00:00:00	NQ	Futures	6988.22	6993.28	6987.92	6990.31	864.0
2017-08-23 01:00:00	NQ	Futures	6990.6	6993.28	6988.82	6992.69	680.0
2017-08-23 02:00:00	NQ	Futures	6992.69	6995.37	6989.71	6991.2	1101.0
2017-08-23 03:00:00	NQ	Futures	6990.9	6999.54	6988.22	6994.47	2976.0
2017-08-23 04:00:00	NQ	Futures	6994.47	6995.07	6987.03	6989.71	2005.0
2017-08-23 05:00:00	NQ	Futures	6990.01	6991.79	6986.73	6987.33	1052.0
2017-08-23 06:00:00	NQ	Futures	6987.03	6987.92	6979.88	6986.44	3192.0
2017-08-23 07:00:00	NQ	Futures	6986.73	6990.01	6973.93	6977.5	6790.0
2017-08-23 08:00:00	NQ	Futures	6976.91	6980.18	6967.97	6970.95	8942.0
2017-08-23 09:00:00	NQ	Futures	6970.95	6981.67	6957.26	6979.59	58504.0
2017-08-23 10:00:00	NQ	Futures	6979.29	6979.29	6959.34	6964.7	57631.0
2017-08-23 11:00:00	NQ	Futures	6964.7	6985.84	6963.21	6979.88	36912.0
2017-08-23 12:00:00	NQ	Futures	6979.88	6984.05	6965.29	6972.74	26858.0
2017-08-23 13:00:00	NQ	Futures	6972.74	6974.53	6958.15	6964.4	22017.0
2017-08-23 14:00:00	NQ	Futures	6964.4	6981.37	6963.21	6978.1	23180.0
2017-08-23 15:00:00	NQ	Futures	6978.4	6988.22	6971.85	6972.74	27592.0
2017-08-23 16:00:00	NQ	Futures	6973.04	6975.12	6957.26	6959.64	9471.0
2017-08-23 18:00:00	NQ	Futures	6962.32	6963.51	6942.37	6947.73	3691.0
2017-08-23 19:00:00	NQ	Futures	6948.03	6952.19	6945.05	6946.54	1892.0
2017-08-23 20:00:00	NQ	Futures	6946.83	6958.15	6945.94	6955.17	2419.0
2017-08-23 21:00:00	NQ	Futures	6954.87	6961.13	6953.09	6958.74	1488.0
2017-08-23 22:00:00	NQ	Futures	6958.74	6962.32	6953.98	6959.94	1487.0
2017-08-23 23:00:00	NQ	Futures	6960.23	6967.97	6960.23	6966.19	1462.0
2017-08-23 00:00:00	YM	Futures	23783.3	23798.6	23783.3	23792.0	715.0
2017-08-23 01:00:00	YM	Futures	23793.1	23804.0	23788.8	23804.0	884.0
2017-08-23 02:00:00	YM	Futures	23804.0	23806.2	23794.2	23798.6	1037.0
2017-08-23 03:00:00	YM	Futures	23798.6	23812.7	23787.7	23798.6	3129.0

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

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