PREVIEW / futures_1hour / 2018-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-15.parquet
  size:    58 KB
  rows:    1,766

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-15 00:00:00	ES	Futures	2931.05	2938.67	2929.96	2938.4	9234.0
2018-11-15 01:00:00	ES	Futures	2938.12	2944.92	2937.04	2942.75	7762.0
2018-11-15 02:00:00	ES	Futures	2942.48	2950.64	2942.2	2949.55	15432.0
2018-11-15 03:00:00	ES	Futures	2949.28	2955.8	2942.48	2944.11	34326.0
2018-11-15 04:00:00	ES	Futures	2943.84	2945.47	2935.13	2936.22	26904.0
2018-11-15 05:00:00	ES	Futures	2936.22	2944.65	2930.78	2944.11	31631.0
2018-11-15 06:00:00	ES	Futures	2944.11	2948.73	2941.39	2944.92	18082.0
2018-11-15 07:00:00	ES	Futures	2945.2	2947.92	2939.48	2939.76	19634.0
2018-11-15 08:00:00	ES	Futures	2939.48	2941.39	2929.69	2933.23	51372.0
2018-11-15 09:00:00	ES	Futures	2932.96	2935.95	2913.37	2923.71	344594.0
2018-11-15 10:00:00	ES	Futures	2923.98	2930.78	2906.3	2922.89	318841.0
2018-11-15 11:00:00	ES	Futures	2922.62	2947.37	2920.44	2943.56	300032.0
2018-11-15 12:00:00	ES	Futures	2943.56	2949.28	2932.96	2935.4	170342.0
2018-11-15 13:00:00	ES	Futures	2935.4	2968.86	2928.33	2965.87	290151.0
2018-11-15 14:00:00	ES	Futures	2965.87	2977.56	2960.16	2967.77	193973.0
2018-11-15 15:00:00	ES	Futures	2967.77	2972.94	2950.09	2972.12	343495.0
2018-11-15 16:00:00	ES	Futures	2971.85	2977.02	2967.77	2974.57	82842.0
2018-11-15 18:00:00	ES	Futures	2972.12	2972.67	2965.32	2966.14	8603.0
2018-11-15 19:00:00	ES	Futures	2966.41	2971.31	2965.32	2969.4	9893.0
2018-11-15 20:00:00	ES	Futures	2969.13	2969.95	2962.06	2965.6	9998.0
2018-11-15 21:00:00	ES	Futures	2965.87	2966.41	2962.6	2964.24	5948.0
2018-11-15 22:00:00	ES	Futures	2964.24	2971.04	2963.42	2970.49	6847.0
2018-11-15 23:00:00	ES	Futures	2970.49	2972.12	2968.32	2970.49	4252.0
2018-11-15 00:00:00	NQ	Futures	7940.6	7964.65	7937.08	7964.07	5177.0
2018-11-15 01:00:00	NQ	Futures	7962.6	7993.98	7959.37	7986.06	5715.0
2018-11-15 02:00:00	NQ	Futures	7985.77	8018.33	7982.54	8014.52	8385.0
2018-11-15 03:00:00	NQ	Futures	8015.1	8028.89	7977.26	7984.01	12863.0
2018-11-15 04:00:00	NQ	Futures	7983.72	7996.33	7958.49	7962.31	11363.0
2018-11-15 05:00:00	NQ	Futures	7962.31	7993.1	7945.59	7990.76	11300.0
2018-11-15 06:00:00	NQ	Futures	7991.05	8007.48	7977.26	7988.12	9198.0
2018-11-15 07:00:00	NQ	Futures	7988.41	8003.66	7970.81	7971.69	13752.0
2018-11-15 08:00:00	NQ	Futures	7971.4	7979.9	7937.08	7950.57	21711.0
2018-11-15 09:00:00	NQ	Futures	7950.28	7991.34	7902.18	7931.8	105163.0
2018-11-15 10:00:00	NQ	Futures	7932.09	7954.39	7875.19	7937.08	119305.0
2018-11-15 11:00:00	NQ	Futures	7937.37	8008.36	7924.76	7992.22	83963.0
2018-11-15 12:00:00	NQ	Futures	7992.52	8015.69	7963.77	7974.33	58756.0
2018-11-15 13:00:00	NQ	Futures	7973.75	8083.15	7954.68	8074.94	91565.0
2018-11-15 14:00:00	NQ	Futures	8074.94	8119.52	8062.62	8094.3	60701.0
2018-11-15 15:00:00	NQ	Futures	8093.71	8106.03	8034.17	8099.58	101653.0
2018-11-15 16:00:00	NQ	Futures	8099.28	8116.3	8065.55	8081.68	19573.0
2018-11-15 18:00:00	NQ	Futures	8065.55	8070.54	8052.65	8061.45	3913.0
2018-11-15 19:00:00	NQ	Futures	8061.74	8079.63	8055.87	8063.5	5365.0
2018-11-15 20:00:00	NQ	Futures	8062.91	8065.26	8039.15	8050.3	9501.0
2018-11-15 21:00:00	NQ	Futures	8050.59	8058.81	8043.55	8052.06	4249.0
2018-11-15 22:00:00	NQ	Futures	8052.06	8077.87	8049.42	8074.35	4245.0
2018-11-15 23:00:00	NQ	Futures	8074.06	8079.92	8065.26	8071.13	2517.0
2018-11-15 00:00:00	YM	Futures	27185.6	27236.7	27175.8	27234.5	4154.0
2018-11-15 01:00:00	YM	Futures	27235.6	27293.2	27224.7	27266.0	3350.0
2018-11-15 02:00:00	YM	Futures	27266.0	27339.9	27255.2	27326.9	5245.0
2018-11-15 03:00:00	YM	Futures	27326.9	27383.4	27260.6	27276.9	7520.0

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

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