PREVIEW / futures_1hour / 2019-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-19.parquet
  size:    53 KB
  rows:    1,731

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-03-19 00:00:00	ES	Futures	3081.89	3082.98	3081.62	3082.43	2620.0
2019-03-19 01:00:00	ES	Futures	3082.43	3082.7	3081.08	3081.62	2999.0
2019-03-19 02:00:00	ES	Futures	3081.62	3083.52	3081.08	3083.25	3117.0
2019-03-19 03:00:00	ES	Futures	3083.52	3083.52	3082.16	3082.16	4537.0
2019-03-19 04:00:00	ES	Futures	3082.16	3088.13	3081.89	3087.85	18135.0
2019-03-19 05:00:00	ES	Futures	3087.85	3090.29	3087.31	3088.67	14807.0
2019-03-19 06:00:00	ES	Futures	3088.67	3093.82	3087.85	3093.01	14450.0
2019-03-19 07:00:00	ES	Futures	3093.28	3093.28	3089.75	3090.29	11841.0
2019-03-19 08:00:00	ES	Futures	3090.57	3092.46	3089.21	3091.65	24474.0
2019-03-19 09:00:00	ES	Futures	3091.65	3093.01	3086.5	3086.77	179018.0
2019-03-19 10:00:00	ES	Futures	3087.04	3093.55	3084.6	3085.14	154255.0
2019-03-19 11:00:00	ES	Futures	3085.14	3098.16	3085.14	3097.61	126295.0
2019-03-19 12:00:00	ES	Futures	3097.89	3100.05	3081.08	3091.11	226982.0
2019-03-19 13:00:00	ES	Futures	3091.38	3092.46	3086.23	3086.5	151049.0
2019-03-19 14:00:00	ES	Futures	3086.77	3089.21	3081.89	3083.79	111378.0
2019-03-19 15:00:00	ES	Futures	3083.79	3085.14	3067.79	3079.72	308158.0
2019-03-19 16:00:00	ES	Futures	3079.72	3079.99	3074.57	3077.28	63284.0
2019-03-19 18:00:00	ES	Futures	3076.74	3077.82	3073.22	3073.22	6614.0
2019-03-19 19:00:00	ES	Futures	3073.49	3074.84	3071.86	3074.03	4761.0
2019-03-19 20:00:00	ES	Futures	3074.03	3075.66	3069.96	3070.78	10764.0
2019-03-19 21:00:00	ES	Futures	3070.5	3071.59	3066.71	3068.88	15664.0
2019-03-19 22:00:00	ES	Futures	3068.88	3074.57	3068.88	3073.76	7640.0
2019-03-19 23:00:00	ES	Futures	3073.76	3074.84	3071.86	3073.76	5482.0
2019-03-19 00:00:00	NQ	Futures	8576.29	8580.37	8573.38	8577.75	1238.0
2019-03-19 01:00:00	NQ	Futures	8577.75	8580.37	8574.55	8575.42	1271.0
2019-03-19 02:00:00	NQ	Futures	8575.42	8579.5	8572.22	8578.62	1388.0
2019-03-19 03:00:00	NQ	Futures	8578.62	8579.79	8575.42	8575.42	1624.0
2019-03-19 04:00:00	NQ	Futures	8575.42	8592.6	8575.13	8592.31	5610.0
2019-03-19 05:00:00	NQ	Futures	8592.02	8599.29	8589.39	8597.26	4995.0
2019-03-19 06:00:00	NQ	Futures	8597.26	8608.61	8594.93	8606.86	4864.0
2019-03-19 07:00:00	NQ	Futures	8606.86	8608.03	8599.88	8602.79	4434.0
2019-03-19 08:00:00	NQ	Futures	8602.79	8612.4	8601.91	8606.57	9141.0
2019-03-19 09:00:00	NQ	Futures	8606.57	8617.05	8589.69	8597.55	57776.0
2019-03-19 10:00:00	NQ	Futures	8597.84	8617.05	8587.36	8589.1	51796.0
2019-03-19 11:00:00	NQ	Futures	8589.39	8631.32	8589.39	8631.03	49819.0
2019-03-19 12:00:00	NQ	Futures	8631.03	8642.97	8589.39	8617.93	63714.0
2019-03-19 13:00:00	NQ	Futures	8618.22	8626.66	8610.07	8614.43	40133.0
2019-03-19 14:00:00	NQ	Futures	8614.43	8625.21	8604.83	8610.94	30742.0
2019-03-19 15:00:00	NQ	Futures	8611.23	8614.73	8561.44	8597.55	68914.0
2019-03-19 16:00:00	NQ	Futures	8597.55	8598.13	8583.28	8594.05	10946.0
2019-03-19 18:00:00	NQ	Futures	8592.6	8595.51	8582.7	8582.99	2103.0
2019-03-19 19:00:00	NQ	Futures	8582.99	8589.69	8578.04	8585.9	1985.0
2019-03-19 20:00:00	NQ	Futures	8586.19	8591.14	8573.38	8575.13	3976.0
2019-03-19 21:00:00	NQ	Futures	8574.55	8577.46	8563.48	8569.3	5859.0
2019-03-19 22:00:00	NQ	Futures	8569.6	8585.61	8569.3	8583.57	3570.0
2019-03-19 23:00:00	NQ	Futures	8583.57	8586.48	8576.29	8581.82	2635.0
2019-03-19 00:00:00	YM	Futures	28261.9	28276.1	28258.7	28272.8	703.0
2019-03-19 01:00:00	YM	Futures	28272.8	28276.1	28259.8	28260.9	759.0
2019-03-19 02:00:00	YM	Futures	28261.9	28279.3	28247.8	28278.3	1152.0
2019-03-19 03:00:00	YM	Futures	28278.3	28279.3	28259.8	28260.9	1636.0

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

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