PREVIEW / futures_1hour / 2017-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-24.parquet
  size:    49 KB
  rows:    1,586

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-24 00:00:00	ES	Futures	2668.88	2669.16	2667.52	2667.79	2594.0
2017-08-24 01:00:00	ES	Futures	2668.06	2668.88	2665.88	2665.88	4853.0
2017-08-24 02:00:00	ES	Futures	2666.15	2671.07	2665.06	2670.52	11710.0
2017-08-24 03:00:00	ES	Futures	2670.52	2671.07	2668.06	2668.34	18700.0
2017-08-24 04:00:00	ES	Futures	2668.06	2672.71	2667.79	2670.8	18143.0
2017-08-24 05:00:00	ES	Futures	2670.8	2672.71	2670.8	2672.44	9042.0
2017-08-24 06:00:00	ES	Futures	2672.71	2673.53	2671.34	2671.89	12154.0
2017-08-24 07:00:00	ES	Futures	2671.89	2675.17	2671.34	2674.35	17832.0
2017-08-24 08:00:00	ES	Futures	2674.62	2677.08	2673.8	2676.54	27914.0
2017-08-24 09:00:00	ES	Futures	2676.54	2677.63	2665.88	2666.97	175149.0
2017-08-24 10:00:00	ES	Futures	2666.7	2674.9	2664.51	2672.16	206081.0
2017-08-24 11:00:00	ES	Futures	2672.16	2673.26	2661.78	2667.24	239138.0
2017-08-24 12:00:00	ES	Futures	2667.24	2668.88	2665.6	2667.52	98868.0
2017-08-24 13:00:00	ES	Futures	2667.52	2672.44	2666.7	2668.61	82939.0
2017-08-24 14:00:00	ES	Futures	2668.61	2669.7	2665.06	2668.34	97495.0
2017-08-24 15:00:00	ES	Futures	2668.34	2669.43	2663.96	2665.06	227665.0
2017-08-24 16:00:00	ES	Futures	2665.06	2671.07	2664.78	2670.8	84916.0
2017-08-24 18:00:00	ES	Futures	2670.52	2672.44	2669.98	2670.8	4926.0
2017-08-24 19:00:00	ES	Futures	2670.8	2671.07	2669.43	2669.98	2391.0
2017-08-24 20:00:00	ES	Futures	2669.98	2669.98	2668.06	2668.88	6198.0
2017-08-24 21:00:00	ES	Futures	2668.61	2668.88	2666.42	2668.61	6426.0
2017-08-24 22:00:00	ES	Futures	2668.88	2671.62	2667.79	2671.07	7012.0
2017-08-24 23:00:00	ES	Futures	2671.07	2671.62	2669.43	2669.98	3463.0
2017-08-24 00:00:00	NQ	Futures	6965.89	6967.08	6960.53	6962.32	755.0
2017-08-24 01:00:00	NQ	Futures	6962.32	6965.89	6958.15	6958.15	1153.0
2017-08-24 02:00:00	NQ	Futures	6958.15	6973.63	6954.58	6972.14	2155.0
2017-08-24 03:00:00	NQ	Futures	6971.85	6973.93	6963.81	6964.4	2332.0
2017-08-24 04:00:00	NQ	Futures	6964.4	6978.69	6962.02	6974.53	3066.0
2017-08-24 05:00:00	NQ	Futures	6974.53	6981.97	6971.85	6981.08	1762.0
2017-08-24 06:00:00	NQ	Futures	6980.78	6984.95	6977.8	6980.78	3736.0
2017-08-24 07:00:00	NQ	Futures	6980.78	6987.03	6977.5	6984.65	3459.0
2017-08-24 08:00:00	NQ	Futures	6984.95	6992.69	6981.97	6991.2	6076.0
2017-08-24 09:00:00	NQ	Futures	6991.2	6996.26	6947.43	6951.3	52650.0
2017-08-24 10:00:00	NQ	Futures	6951.9	6970.36	6934.63	6959.94	69512.0
2017-08-24 11:00:00	NQ	Futures	6959.64	6962.91	6911.7	6931.65	75770.0
2017-08-24 12:00:00	NQ	Futures	6931.65	6945.35	6924.5	6940.58	33091.0
2017-08-24 13:00:00	NQ	Futures	6940.28	6960.53	6937.9	6952.49	25269.0
2017-08-24 14:00:00	NQ	Futures	6952.19	6959.04	6937.31	6957.85	26061.0
2017-08-24 15:00:00	NQ	Futures	6957.85	6964.4	6945.94	6951.9	37393.0
2017-08-24 16:00:00	NQ	Futures	6951.6	6963.81	6950.11	6962.62	6692.0
2017-08-24 18:00:00	NQ	Futures	6961.72	6970.36	6960.23	6963.21	1231.0
2017-08-24 19:00:00	NQ	Futures	6963.81	6964.7	6958.15	6959.34	686.0
2017-08-24 20:00:00	NQ	Futures	6959.64	6961.72	6953.38	6957.26	1276.0
2017-08-24 21:00:00	NQ	Futures	6956.96	6957.55	6947.43	6955.77	1606.0
2017-08-24 22:00:00	NQ	Futures	6956.06	6966.78	6950.71	6962.62	2301.0
2017-08-24 23:00:00	NQ	Futures	6962.32	6967.68	6959.34	6960.83	974.0
2017-08-24 00:00:00	YM	Futures	23727.8	23728.9	23716.9	23720.2	409.0
2017-08-24 01:00:00	YM	Futures	23720.2	23726.7	23709.3	23709.3	826.0
2017-08-24 02:00:00	YM	Futures	23709.3	23745.2	23702.8	23742.0	2013.0
2017-08-24 03:00:00	YM	Futures	23742.0	23746.3	23724.6	23727.8	2133.0

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

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