PREVIEW / futures_1hour / 2019-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-20.parquet
  size:    56 KB
  rows:    1,806

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
2019-05-20 00:00:00	ES	Futures	3113.07	3115.24	3111.71	3114.42	4157.0
2019-05-20 01:00:00	ES	Futures	3114.42	3115.78	3110.9	3113.07	5925.0
2019-05-20 02:00:00	ES	Futures	3113.07	3114.42	3109.0	3109.27	9159.0
2019-05-20 03:00:00	ES	Futures	3109.27	3111.98	3107.65	3109.81	14624.0
2019-05-20 04:00:00	ES	Futures	3110.09	3114.69	3096.8	3098.97	30978.0
2019-05-20 05:00:00	ES	Futures	3098.97	3102.49	3095.99	3101.68	25391.0
2019-05-20 06:00:00	ES	Futures	3101.68	3101.68	3083.25	3084.06	48963.0
2019-05-20 07:00:00	ES	Futures	3084.33	3088.13	3082.16	3085.69	32593.0
2019-05-20 08:00:00	ES	Futures	3085.69	3085.96	3075.38	3079.18	85993.0
2019-05-20 09:00:00	ES	Futures	3079.18	3088.94	3072.13	3086.5	275575.0
2019-05-20 10:00:00	ES	Futures	3086.77	3096.8	3081.89	3093.82	252504.0
2019-05-20 11:00:00	ES	Futures	3093.55	3095.99	3083.52	3087.85	169885.0
2019-05-20 12:00:00	ES	Futures	3088.13	3094.63	3083.79	3084.33	122542.0
2019-05-20 13:00:00	ES	Futures	3084.33	3088.94	3082.16	3086.5	93627.0
2019-05-20 14:00:00	ES	Futures	3086.77	3087.31	3075.38	3077.55	109069.0
2019-05-20 15:00:00	ES	Futures	3077.82	3084.06	3071.59	3081.08	208093.0
2019-05-20 16:00:00	ES	Futures	3081.08	3088.4	3079.45	3088.13	57306.0
2019-05-20 18:00:00	ES	Futures	3088.4	3090.57	3088.4	3089.75	6143.0
2019-05-20 19:00:00	ES	Futures	3089.75	3091.65	3088.94	3090.29	9300.0
2019-05-20 20:00:00	ES	Futures	3090.57	3093.82	3087.31	3093.01	18167.0
2019-05-20 21:00:00	ES	Futures	3093.28	3098.43	3092.46	3096.8	19980.0
2019-05-20 22:00:00	ES	Futures	3096.53	3098.16	3093.01	3097.89	10927.0
2019-05-20 23:00:00	ES	Futures	3097.61	3099.51	3096.8	3097.89	9453.0
2019-05-20 00:00:00	NQ	Futures	8780.1	8785.34	8772.53	8783.3	2632.0
2019-05-20 01:00:00	NQ	Futures	8783.3	8788.84	8769.04	8778.06	3473.0
2019-05-20 02:00:00	NQ	Futures	8778.06	8783.3	8757.68	8760.59	5910.0
2019-05-20 03:00:00	NQ	Futures	8760.89	8768.46	8752.15	8760.3	6065.0
2019-05-20 04:00:00	NQ	Futures	8760.01	8780.1	8707.31	8716.34	13839.0
2019-05-20 05:00:00	NQ	Futures	8716.63	8720.71	8697.41	8712.84	12242.0
2019-05-20 06:00:00	NQ	Futures	8712.55	8712.55	8638.89	8645.01	18711.0
2019-05-20 07:00:00	NQ	Futures	8645.59	8654.9	8629.28	8642.68	12573.0
2019-05-20 08:00:00	NQ	Futures	8642.97	8650.54	8593.18	8610.65	34707.0
2019-05-20 09:00:00	NQ	Futures	8610.36	8637.73	8573.38	8618.8	97351.0
2019-05-20 10:00:00	NQ	Futures	8618.8	8662.18	8592.31	8649.96	100939.0
2019-05-20 11:00:00	NQ	Futures	8650.25	8657.82	8609.48	8628.7	78556.0
2019-05-20 12:00:00	NQ	Futures	8629.28	8658.69	8614.43	8617.05	49458.0
2019-05-20 13:00:00	NQ	Futures	8616.47	8631.9	8606.57	8621.42	35208.0
2019-05-20 14:00:00	NQ	Futures	8621.71	8624.04	8587.36	8595.8	43887.0
2019-05-20 15:00:00	NQ	Futures	8595.8	8619.97	8575.13	8604.53	64282.0
2019-05-20 16:00:00	NQ	Futures	8604.24	8626.37	8601.04	8626.08	14150.0
2019-05-20 18:00:00	NQ	Futures	8627.83	8634.23	8625.79	8631.9	1991.0
2019-05-20 19:00:00	NQ	Futures	8632.19	8640.06	8628.7	8636.27	2618.0
2019-05-20 20:00:00	NQ	Futures	8636.85	8649.37	8624.92	8648.5	7761.0
2019-05-20 21:00:00	NQ	Futures	8648.79	8660.44	8642.97	8656.07	9233.0
2019-05-20 22:00:00	NQ	Futures	8655.49	8659.56	8644.13	8659.27	4963.0
2019-05-20 23:00:00	NQ	Futures	8659.27	8671.5	8658.11	8667.42	6221.0
2019-05-20 00:00:00	YM	Futures	28123.8	28143.4	28107.5	28135.8	1595.0
2019-05-20 01:00:00	YM	Futures	28136.9	28152.1	28109.7	28130.3	1626.0
2019-05-20 02:00:00	YM	Futures	28129.2	28139.0	28093.4	28095.5	4011.0
2019-05-20 03:00:00	YM	Futures	28096.6	28118.4	28083.6	28105.3	3536.0

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

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