PREVIEW / futures_1hour / 2017-12-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-18.parquet
  size:    51 KB
  rows:    1,631

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-12-18 00:00:00	ES	Futures	2938.82	2939.1	2938.28	2938.55	2677.0
2017-12-18 01:00:00	ES	Futures	2938.82	2939.37	2938.28	2939.1	2702.0
2017-12-18 02:00:00	ES	Futures	2939.1	2940.46	2938.82	2939.64	8438.0
2017-12-18 03:00:00	ES	Futures	2939.64	2942.38	2939.37	2939.92	20972.0
2017-12-18 04:00:00	ES	Futures	2939.92	2942.92	2939.1	2942.65	13592.0
2017-12-18 05:00:00	ES	Futures	2942.38	2943.2	2941.56	2942.1	9415.0
2017-12-18 06:00:00	ES	Futures	2942.38	2943.47	2941.56	2941.56	11382.0
2017-12-18 07:00:00	ES	Futures	2941.56	2944.02	2941.56	2942.65	12516.0
2017-12-18 08:00:00	ES	Futures	2942.92	2944.84	2942.65	2943.2	24207.0
2017-12-18 09:00:00	ES	Futures	2943.2	2949.76	2942.38	2947.84	183956.0
2017-12-18 10:00:00	ES	Futures	2948.12	2948.94	2944.84	2946.48	142958.0
2017-12-18 11:00:00	ES	Futures	2946.48	2949.21	2944.56	2948.66	111610.0
2017-12-18 12:00:00	ES	Futures	2948.39	2949.48	2947.3	2948.12	60682.0
2017-12-18 13:00:00	ES	Futures	2948.12	2948.12	2945.66	2946.2	64673.0
2017-12-18 14:00:00	ES	Futures	2946.2	2947.84	2945.11	2947.84	50434.0
2017-12-18 15:00:00	ES	Futures	2947.84	2948.39	2943.47	2946.2	168068.0
2017-12-18 16:00:00	ES	Futures	2946.2	2947.3	2944.29	2947.3	75433.0
2017-12-18 18:00:00	ES	Futures	2946.48	2947.57	2946.2	2946.75	4540.0
2017-12-18 19:00:00	ES	Futures	2947.02	2947.02	2945.93	2946.2	3410.0
2017-12-18 20:00:00	ES	Futures	2946.2	2947.02	2945.93	2946.75	2886.0
2017-12-18 21:00:00	ES	Futures	2947.02	2947.02	2945.93	2946.75	2899.0
2017-12-18 22:00:00	ES	Futures	2946.48	2947.3	2946.48	2946.75	1332.0
2017-12-18 23:00:00	ES	Futures	2947.02	2947.57	2946.75	2947.3	1338.0
2017-12-18 00:00:00	NQ	Futures	7736.36	7737.25	7735.47	7736.07	668.0
2017-12-18 01:00:00	NQ	Futures	7736.36	7738.44	7734.29	7736.36	824.0
2017-12-18 02:00:00	NQ	Futures	7736.66	7744.67	7736.07	7740.81	2080.0
2017-12-18 03:00:00	NQ	Futures	7741.11	7750.6	7741.11	7745.56	3563.0
2017-12-18 04:00:00	NQ	Futures	7745.56	7755.05	7745.26	7754.46	2419.0
2017-12-18 05:00:00	NQ	Futures	7754.46	7754.75	7749.71	7752.38	1541.0
2017-12-18 06:00:00	NQ	Futures	7752.38	7758.31	7752.08	7752.68	2265.0
2017-12-18 07:00:00	NQ	Futures	7752.68	7755.35	7747.34	7748.23	3069.0
2017-12-18 08:00:00	NQ	Futures	7748.23	7750.6	7736.66	7741.11	6779.0
2017-12-18 09:00:00	NQ	Futures	7740.81	7748.23	7726.87	7743.78	51225.0
2017-12-18 10:00:00	NQ	Futures	7743.48	7752.38	7740.52	7742.3	37509.0
2017-12-18 11:00:00	NQ	Futures	7742.3	7755.35	7734.29	7750.6	23132.0
2017-12-18 12:00:00	NQ	Futures	7750.6	7761.28	7750.01	7758.91	18138.0
2017-12-18 13:00:00	NQ	Futures	7758.61	7759.5	7751.79	7757.42	13296.0
2017-12-18 14:00:00	NQ	Futures	7757.13	7759.2	7752.68	7758.31	10756.0
2017-12-18 15:00:00	NQ	Futures	7758.31	7759.5	7744.67	7752.97	23568.0
2017-12-18 16:00:00	NQ	Futures	7752.97	7755.35	7749.71	7753.57	7117.0
2017-12-18 18:00:00	NQ	Futures	7752.97	7756.53	7752.08	7755.35	924.0
2017-12-18 19:00:00	NQ	Futures	7755.05	7756.24	7751.19	7753.27	847.0
2017-12-18 20:00:00	NQ	Futures	7752.97	7758.61	7752.38	7758.61	970.0
2017-12-18 21:00:00	NQ	Futures	7758.61	7759.2	7755.05	7755.64	846.0
2017-12-18 22:00:00	NQ	Futures	7755.64	7757.42	7755.64	7757.13	426.0
2017-12-18 23:00:00	NQ	Futures	7757.13	7758.31	7756.83	7757.72	417.0
2017-12-18 00:00:00	YM	Futures	26925.3	26932.9	26919.8	26931.8	795.0
2017-12-18 01:00:00	YM	Futures	26931.8	26942.7	26922.0	26938.3	1040.0
2017-12-18 02:00:00	YM	Futures	26938.3	26955.7	26926.4	26927.5	2286.0
2017-12-18 03:00:00	YM	Futures	26928.5	26965.5	26928.5	26938.3	3177.0

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

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