PREVIEW / futures_1hour / 2018-02-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-22.parquet
  size:    54 KB
  rows:    1,665

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-02-22 00:00:00	ES	Futures	2939.64	2942.92	2938.28	2942.1	6835.0
2018-02-22 01:00:00	ES	Futures	2942.1	2943.74	2940.46	2942.38	4712.0
2018-02-22 02:00:00	ES	Futures	2942.1	2944.84	2938.0	2943.74	13589.0
2018-02-22 03:00:00	ES	Futures	2943.74	2948.39	2939.1	2942.65	23858.0
2018-02-22 04:00:00	ES	Futures	2942.65	2947.57	2939.1	2946.75	20005.0
2018-02-22 05:00:00	ES	Futures	2946.48	2956.59	2946.2	2952.76	23512.0
2018-02-22 06:00:00	ES	Futures	2953.04	2958.5	2950.85	2954.13	18536.0
2018-02-22 07:00:00	ES	Futures	2954.13	2962.33	2954.13	2957.68	26944.0
2018-02-22 08:00:00	ES	Futures	2957.68	2963.97	2954.4	2962.33	33810.0
2018-02-22 09:00:00	ES	Futures	2962.33	2977.09	2960.42	2965.61	198297.0
2018-02-22 10:00:00	ES	Futures	2965.88	2977.91	2960.96	2971.35	207278.0
2018-02-22 11:00:00	ES	Futures	2971.35	2985.02	2970.53	2982.83	135877.0
2018-02-22 12:00:00	ES	Futures	2982.83	2985.84	2968.62	2971.62	129563.0
2018-02-22 13:00:00	ES	Futures	2971.35	2976.27	2958.5	2965.34	164656.0
2018-02-22 14:00:00	ES	Futures	2965.61	2973.54	2954.68	2955.77	140082.0
2018-02-22 15:00:00	ES	Futures	2955.77	2963.97	2948.12	2955.5	279166.0
2018-02-22 16:00:00	ES	Futures	2955.5	2968.07	2953.58	2966.7	69142.0
2018-02-22 18:00:00	ES	Futures	2965.88	2967.25	2963.15	2966.16	7108.0
2018-02-22 19:00:00	ES	Futures	2965.88	2973.54	2962.88	2971.35	11294.0
2018-02-22 20:00:00	ES	Futures	2971.35	2972.99	2968.34	2971.35	6062.0
2018-02-22 21:00:00	ES	Futures	2971.62	2976.0	2970.8	2973.26	4807.0
2018-02-22 22:00:00	ES	Futures	2973.26	2973.26	2969.44	2971.9	3544.0
2018-02-22 23:00:00	ES	Futures	2971.62	2972.72	2968.34	2971.35	3383.0
2018-02-22 00:00:00	NQ	Futures	7976.9	7988.17	7973.34	7982.24	2622.0
2018-02-22 01:00:00	NQ	Futures	7982.24	7985.21	7975.42	7978.39	1272.0
2018-02-22 02:00:00	NQ	Futures	7978.68	7988.47	7966.82	7984.61	2850.0
2018-02-22 03:00:00	NQ	Futures	7984.61	7993.22	7972.75	7976.31	4117.0
2018-02-22 04:00:00	NQ	Futures	7975.72	7989.95	7963.26	7989.95	4180.0
2018-02-22 05:00:00	NQ	Futures	7989.66	8020.21	7986.69	8010.42	5451.0
2018-02-22 06:00:00	NQ	Futures	8010.42	8030.59	8005.08	8017.83	4572.0
2018-02-22 07:00:00	NQ	Futures	8018.43	8047.2	8017.83	8038.0	9039.0
2018-02-22 08:00:00	NQ	Futures	8038.3	8060.54	8029.4	8058.17	10781.0
2018-02-22 09:00:00	NQ	Futures	8057.87	8091.68	8046.01	8059.36	51961.0
2018-02-22 10:00:00	NQ	Futures	8059.06	8100.88	8044.23	8078.34	70766.0
2018-02-22 11:00:00	NQ	Futures	8078.63	8104.73	8073.89	8094.65	41787.0
2018-02-22 12:00:00	NQ	Futures	8094.65	8102.96	8042.75	8054.02	38756.0
2018-02-22 13:00:00	NQ	Futures	8054.02	8067.96	8011.6	8038.59	48602.0
2018-02-22 14:00:00	NQ	Futures	8039.19	8067.07	8017.54	8021.1	36079.0
2018-02-22 15:00:00	NQ	Futures	8021.39	8045.42	8004.49	8028.51	56367.0
2018-02-22 16:00:00	NQ	Futures	8028.51	8063.8	8024.65	8062.62	10571.0
2018-02-22 18:00:00	NQ	Futures	8058.47	8061.73	8050.16	8056.69	1670.0
2018-02-22 19:00:00	NQ	Futures	8057.28	8073.0	8046.9	8067.66	5896.0
2018-02-22 20:00:00	NQ	Futures	8067.96	8073.0	8050.75	8063.51	4067.0
2018-02-22 21:00:00	NQ	Futures	8063.21	8074.48	8061.14	8070.33	2409.0
2018-02-22 22:00:00	NQ	Futures	8070.03	8070.92	8059.65	8065.88	1686.0
2018-02-22 23:00:00	NQ	Futures	8065.88	8070.63	8055.5	8066.18	1688.0
2018-02-22 00:00:00	YM	Futures	26779.6	26824.2	26766.6	26811.2	3968.0
2018-02-22 01:00:00	YM	Futures	26810.1	26818.8	26780.7	26794.9	2216.0
2018-02-22 02:00:00	YM	Futures	26797.0	26832.9	26763.3	26810.1	4995.0
2018-02-22 03:00:00	YM	Futures	26810.1	26864.4	26773.1	26812.2	6176.0

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

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