PREVIEW / futures_1hour / 2018-10-31

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-31.parquet
  size:    56 KB
  rows:    1,726

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-10-31 00:00:00	ES	Futures	2926.43	2928.06	2923.71	2927.52	5111.0
2018-10-31 01:00:00	ES	Futures	2927.24	2933.5	2927.24	2932.96	9613.0
2018-10-31 02:00:00	ES	Futures	2932.96	2933.77	2930.24	2933.23	6869.0
2018-10-31 03:00:00	ES	Futures	2933.5	2937.31	2931.6	2935.4	15091.0
2018-10-31 04:00:00	ES	Futures	2935.13	2942.2	2933.5	2941.66	32551.0
2018-10-31 05:00:00	ES	Futures	2941.39	2942.2	2933.5	2934.86	22460.0
2018-10-31 06:00:00	ES	Futures	2934.59	2943.02	2934.32	2940.57	27018.0
2018-10-31 07:00:00	ES	Futures	2940.84	2945.74	2939.21	2944.11	32186.0
2018-10-31 08:00:00	ES	Futures	2944.38	2952.81	2943.02	2951.72	62679.0
2018-10-31 09:00:00	ES	Futures	2951.72	2960.7	2944.38	2959.34	262291.0
2018-10-31 10:00:00	ES	Futures	2959.07	2969.4	2954.17	2958.52	293756.0
2018-10-31 11:00:00	ES	Futures	2958.52	2964.51	2951.45	2956.08	242454.0
2018-10-31 12:00:00	ES	Futures	2956.08	2966.96	2946.56	2964.78	202447.0
2018-10-31 13:00:00	ES	Futures	2964.51	2972.94	2962.06	2968.86	156988.0
2018-10-31 14:00:00	ES	Futures	2969.13	2977.84	2965.32	2974.03	185067.0
2018-10-31 15:00:00	ES	Futures	2974.3	2978.11	2948.19	2950.09	562734.0
2018-10-31 16:00:00	ES	Futures	2950.09	2953.9	2941.93	2944.11	151682.0
2018-10-31 18:00:00	ES	Futures	2944.11	2951.45	2943.56	2949.28	10513.0
2018-10-31 19:00:00	ES	Futures	2949.28	2952.27	2947.64	2951.72	7773.0
2018-10-31 20:00:00	ES	Futures	2952.0	2956.62	2951.18	2956.08	13577.0
2018-10-31 21:00:00	ES	Futures	2956.08	2961.79	2953.9	2960.97	14798.0
2018-10-31 22:00:00	ES	Futures	2961.24	2961.52	2955.8	2957.71	16934.0
2018-10-31 23:00:00	ES	Futures	2957.98	2960.97	2956.62	2959.88	4833.0
2018-10-31 00:00:00	NQ	Futures	8030.35	8030.35	8015.69	8026.54	4130.0
2018-10-31 01:00:00	NQ	Futures	8026.83	8054.41	8025.37	8052.65	6093.0
2018-10-31 02:00:00	NQ	Futures	8052.65	8057.63	8040.91	8055.87	3992.0
2018-10-31 03:00:00	NQ	Futures	8056.46	8073.77	8048.83	8065.55	8991.0
2018-10-31 04:00:00	NQ	Futures	8065.55	8091.66	8058.51	8088.43	11177.0
2018-10-31 05:00:00	NQ	Futures	8088.43	8092.83	8060.27	8063.79	8128.0
2018-10-31 06:00:00	NQ	Futures	8062.91	8091.66	8054.99	8079.92	11461.0
2018-10-31 07:00:00	NQ	Futures	8079.92	8100.16	8070.25	8092.54	15584.0
2018-10-31 08:00:00	NQ	Futures	8092.83	8130.67	8089.9	8121.87	20795.0
2018-10-31 09:00:00	NQ	Futures	8122.16	8196.66	8114.54	8192.85	95581.0
2018-10-31 10:00:00	NQ	Futures	8192.56	8241.25	8183.46	8189.04	97993.0
2018-10-31 11:00:00	NQ	Futures	8189.04	8216.9	8144.16	8167.92	95860.0
2018-10-31 12:00:00	NQ	Futures	8167.63	8220.72	8134.19	8209.57	72268.0
2018-10-31 13:00:00	NQ	Futures	8209.86	8252.39	8205.46	8224.24	62473.0
2018-10-31 14:00:00	NQ	Futures	8223.94	8258.85	8210.74	8237.73	62844.0
2018-10-31 15:00:00	NQ	Futures	8238.02	8253.57	8180.24	8181.7	100887.0
2018-10-31 16:00:00	NQ	Futures	8181.7	8189.92	8158.83	8164.69	24620.0
2018-10-31 18:00:00	NQ	Futures	8165.87	8185.22	8162.35	8181.41	2169.0
2018-10-31 19:00:00	NQ	Futures	8182.0	8184.64	8171.44	8182.88	2208.0
2018-10-31 20:00:00	NQ	Futures	8182.29	8198.13	8177.89	8193.14	5311.0
2018-10-31 21:00:00	NQ	Futures	8193.14	8222.18	8184.05	8220.42	9428.0
2018-10-31 22:00:00	NQ	Futures	8220.42	8221.89	8203.7	8209.28	11388.0
2018-10-31 23:00:00	NQ	Futures	8208.98	8220.72	8204.58	8216.02	3531.0
2018-10-31 00:00:00	YM	Futures	27053.1	27067.2	27028.1	27059.6	1441.0
2018-10-31 01:00:00	YM	Futures	27061.8	27116.1	27057.4	27104.1	2357.0
2018-10-31 02:00:00	YM	Futures	27106.3	27107.4	27080.2	27102.0	1696.0
2018-10-31 03:00:00	YM	Futures	27103.1	27136.7	27090.0	27113.9	2859.0

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

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