PREVIEW / futures_1hour / 2018-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-17.parquet
  size:    53 KB
  rows:    1,658

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-04-17 00:00:00	ES	Futures	2935.94	2939.22	2935.13	2939.22	5051.0
2018-04-17 01:00:00	ES	Futures	2939.22	2940.04	2936.76	2939.77	6497.0
2018-04-17 02:00:00	ES	Futures	2939.77	2943.04	2938.95	2940.31	12937.0
2018-04-17 03:00:00	ES	Futures	2940.04	2940.86	2935.67	2939.49	15085.0
2018-04-17 04:00:00	ES	Futures	2939.49	2940.86	2934.58	2940.31	14695.0
2018-04-17 05:00:00	ES	Futures	2940.58	2940.86	2937.31	2940.04	10093.0
2018-04-17 06:00:00	ES	Futures	2940.04	2943.31	2939.77	2942.49	16416.0
2018-04-17 07:00:00	ES	Futures	2942.49	2942.77	2940.31	2942.49	20873.0
2018-04-17 08:00:00	ES	Futures	2942.49	2945.77	2941.95	2944.13	33084.0
2018-04-17 09:00:00	ES	Futures	2944.13	2946.86	2939.22	2945.77	137601.0
2018-04-17 10:00:00	ES	Futures	2945.77	2953.41	2944.4	2952.32	177938.0
2018-04-17 11:00:00	ES	Futures	2952.59	2956.69	2951.77	2953.14	131037.0
2018-04-17 12:00:00	ES	Futures	2953.41	2956.41	2951.23	2953.14	92955.0
2018-04-17 13:00:00	ES	Futures	2953.14	2955.32	2948.77	2954.23	91775.0
2018-04-17 14:00:00	ES	Futures	2954.23	2957.5	2949.32	2954.23	112397.0
2018-04-17 15:00:00	ES	Futures	2954.23	2962.42	2953.14	2954.5	234922.0
2018-04-17 16:00:00	ES	Futures	2954.5	2956.14	2952.87	2953.41	62365.0
2018-04-17 18:00:00	ES	Futures	2952.32	2955.32	2951.5	2955.05	5371.0
2018-04-17 19:00:00	ES	Futures	2954.78	2956.69	2954.5	2955.05	2975.0
2018-04-17 20:00:00	ES	Futures	2955.32	2961.6	2955.05	2960.23	9011.0
2018-04-17 21:00:00	ES	Futures	2960.23	2961.33	2957.78	2958.87	5849.0
2018-04-17 22:00:00	ES	Futures	2958.87	2959.69	2957.5	2958.87	4305.0
2018-04-17 23:00:00	ES	Futures	2958.6	2960.78	2958.05	2960.51	2846.0
2018-04-17 00:00:00	NQ	Futures	7952.47	7964.0	7949.22	7962.82	1563.0
2018-04-17 01:00:00	NQ	Futures	7962.82	7966.36	7956.32	7964.89	2642.0
2018-04-17 02:00:00	NQ	Futures	7964.89	7975.82	7963.7	7973.75	4404.0
2018-04-17 03:00:00	NQ	Futures	7973.75	7974.64	7956.02	7966.07	4139.0
2018-04-17 04:00:00	NQ	Futures	7965.77	7969.02	7948.93	7967.25	4329.0
2018-04-17 05:00:00	NQ	Futures	7967.55	7971.09	7957.79	7969.91	2544.0
2018-04-17 06:00:00	NQ	Futures	7969.32	7979.37	7966.36	7972.57	4313.0
2018-04-17 07:00:00	NQ	Futures	7972.28	7978.19	7965.48	7978.19	5715.0
2018-04-17 08:00:00	NQ	Futures	7978.19	7992.37	7976.71	7983.51	7582.0
2018-04-17 09:00:00	NQ	Futures	7983.8	8002.42	7967.55	7996.21	46772.0
2018-04-17 10:00:00	NQ	Futures	7997.1	8030.79	7996.51	8029.31	46741.0
2018-04-17 11:00:00	NQ	Futures	8029.61	8057.09	8029.61	8047.64	42673.0
2018-04-17 12:00:00	NQ	Futures	8048.23	8069.21	8047.93	8058.87	24904.0
2018-04-17 13:00:00	NQ	Futures	8059.16	8073.64	8049.11	8066.85	30119.0
2018-04-17 14:00:00	NQ	Futures	8066.85	8081.92	8055.32	8075.12	35467.0
2018-04-17 15:00:00	NQ	Futures	8075.12	8091.37	8064.78	8069.51	38307.0
2018-04-17 16:00:00	NQ	Futures	8069.51	8077.48	8066.55	8068.62	7630.0
2018-04-17 18:00:00	NQ	Futures	8061.53	8073.94	8057.98	8070.39	1963.0
2018-04-17 19:00:00	NQ	Futures	8070.39	8080.44	8069.51	8076.01	1233.0
2018-04-17 20:00:00	NQ	Futures	8076.01	8094.92	8074.82	8090.49	3225.0
2018-04-17 21:00:00	NQ	Futures	8090.78	8094.03	8086.35	8089.31	1948.0
2018-04-17 22:00:00	NQ	Futures	8089.9	8092.56	8082.21	8085.17	1705.0
2018-04-17 23:00:00	NQ	Futures	8085.46	8087.83	8078.08	8085.17	1452.0
2018-04-17 00:00:00	YM	Futures	26756.4	26784.6	26749.8	26783.5	1370.0
2018-04-17 01:00:00	YM	Futures	26783.5	26790.0	26758.5	26785.7	1889.0
2018-04-17 02:00:00	YM	Futures	26786.8	26854.1	26780.2	26826.9	3885.0
2018-04-17 03:00:00	YM	Futures	26828.0	26831.3	26767.2	26807.4	3962.0

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

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