PREVIEW / futures_1hour / 2018-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-14.parquet
  size:    57 KB
  rows:    1,725

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
2018-11-14 00:00:00	ES	Futures	2965.6	2970.22	2964.51	2967.77	5471.0
2018-11-14 01:00:00	ES	Futures	2967.5	2968.86	2966.14	2968.59	3905.0
2018-11-14 02:00:00	ES	Futures	2968.59	2969.13	2959.61	2963.42	15431.0
2018-11-14 03:00:00	ES	Futures	2963.42	2964.24	2949.55	2950.09	40170.0
2018-11-14 04:00:00	ES	Futures	2949.82	2959.07	2949.55	2957.98	19717.0
2018-11-14 05:00:00	ES	Futures	2958.25	2969.13	2956.08	2968.04	30780.0
2018-11-14 06:00:00	ES	Futures	2968.32	2968.59	2959.88	2961.52	18982.0
2018-11-14 07:00:00	ES	Futures	2961.52	2972.4	2961.24	2967.5	26202.0
2018-11-14 08:00:00	ES	Futures	2967.23	2984.91	2966.68	2981.64	65941.0
2018-11-14 09:00:00	ES	Futures	2981.64	2990.08	2979.2	2984.09	228776.0
2018-11-14 10:00:00	ES	Futures	2984.09	2984.64	2962.06	2965.05	271077.0
2018-11-14 11:00:00	ES	Futures	2965.05	2965.6	2943.56	2954.72	257735.0
2018-11-14 12:00:00	ES	Futures	2954.72	2958.25	2940.03	2942.2	241286.0
2018-11-14 13:00:00	ES	Futures	2942.2	2948.19	2928.88	2934.04	238038.0
2018-11-14 14:00:00	ES	Futures	2934.32	2956.08	2922.62	2954.44	297220.0
2018-11-14 15:00:00	ES	Futures	2954.72	2963.15	2934.59	2941.39	312621.0
2018-11-14 16:00:00	ES	Futures	2941.39	2943.29	2932.96	2939.76	90372.0
2018-11-14 18:00:00	ES	Futures	2939.76	2946.56	2932.41	2934.59	19536.0
2018-11-14 19:00:00	ES	Futures	2934.59	2942.48	2929.15	2941.39	18147.0
2018-11-14 20:00:00	ES	Futures	2941.12	2942.48	2925.61	2928.06	14661.0
2018-11-14 21:00:00	ES	Futures	2928.33	2939.21	2927.52	2930.78	11598.0
2018-11-14 22:00:00	ES	Futures	2930.51	2933.77	2927.52	2931.05	7533.0
2018-11-14 23:00:00	ES	Futures	2931.05	2931.6	2926.97	2931.05	5835.0
2018-11-14 00:00:00	NQ	Futures	8031.53	8047.95	8030.94	8040.91	2694.0
2018-11-14 01:00:00	NQ	Futures	8040.62	8046.49	8030.94	8038.27	2484.0
2018-11-14 02:00:00	NQ	Futures	8038.57	8040.91	7998.09	8014.81	8734.0
2018-11-14 03:00:00	NQ	Futures	8014.22	8018.62	7951.16	7954.39	16513.0
2018-11-14 04:00:00	NQ	Futures	7953.8	7986.36	7953.21	7981.66	8582.0
2018-11-14 05:00:00	NQ	Futures	7982.25	8026.25	7977.56	8022.44	12072.0
2018-11-14 06:00:00	NQ	Futures	8022.73	8027.13	7994.86	8000.73	10306.0
2018-11-14 07:00:00	NQ	Futures	8001.32	8046.78	8001.02	8022.44	12104.0
2018-11-14 08:00:00	NQ	Futures	8022.73	8095.18	8020.09	8080.8	28818.0
2018-11-14 09:00:00	NQ	Futures	8081.1	8130.08	8067.31	8084.62	91200.0
2018-11-14 10:00:00	NQ	Futures	8084.62	8088.43	8003.96	8023.32	98163.0
2018-11-14 11:00:00	NQ	Futures	8023.32	8023.9	7963.48	8003.96	83789.0
2018-11-14 12:00:00	NQ	Futures	8004.25	8012.46	7949.99	7958.79	88411.0
2018-11-14 13:00:00	NQ	Futures	7959.08	7993.69	7935.32	7953.51	67926.0
2018-11-14 14:00:00	NQ	Futures	7953.51	8017.74	7914.79	8013.05	80055.0
2018-11-14 15:00:00	NQ	Futures	8013.34	8040.03	7939.43	7957.32	68618.0
2018-11-14 16:00:00	NQ	Futures	7957.61	7963.77	7926.52	7957.32	17002.0
2018-11-14 18:00:00	NQ	Futures	7954.68	7985.48	7940.6	7948.23	7538.0
2018-11-14 19:00:00	NQ	Futures	7948.52	7976.38	7933.56	7973.45	8512.0
2018-11-14 20:00:00	NQ	Futures	7973.16	7979.02	7921.24	7931.51	11591.0
2018-11-14 21:00:00	NQ	Futures	7932.09	7971.4	7930.04	7942.07	6488.0
2018-11-14 22:00:00	NQ	Futures	7942.36	7950.28	7932.68	7941.48	4631.0
2018-11-14 23:00:00	NQ	Futures	7940.89	7944.41	7928.57	7940.89	4908.0
2018-11-14 00:00:00	YM	Futures	27499.6	27542.0	27493.1	27519.2	1980.0
2018-11-14 01:00:00	YM	Futures	27518.1	27542.0	27505.1	27539.8	1319.0
2018-11-14 02:00:00	YM	Futures	27538.7	27542.0	27456.2	27494.2	4850.0
2018-11-14 03:00:00	YM	Futures	27493.1	27498.5	27385.5	27389.9	7947.0

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

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