PREVIEW / futures_1hour / 2019-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-15.parquet
  size:    62 KB
  rows:    1,867

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-08-15 00:00:00	ES	Futures	3083.87	3087.93	3080.08	3087.12	12366.0
2019-08-15 01:00:00	ES	Futures	3087.39	3093.08	3086.58	3091.18	14747.0
2019-08-15 02:00:00	ES	Futures	3091.45	3102.28	3091.18	3100.93	31327.0
2019-08-15 03:00:00	ES	Futures	3100.66	3102.01	3086.85	3094.7	53016.0
2019-08-15 04:00:00	ES	Futures	3094.43	3101.2	3090.64	3094.97	41484.0
2019-08-15 05:00:00	ES	Futures	3095.24	3096.87	3067.36	3074.67	114902.0
2019-08-15 06:00:00	ES	Futures	3074.67	3074.94	3051.12	3063.57	96368.0
2019-08-15 07:00:00	ES	Futures	3063.57	3103.09	3062.76	3094.7	153405.0
2019-08-15 08:00:00	ES	Futures	3094.7	3109.59	3084.14	3094.7	162176.0
2019-08-15 09:00:00	ES	Futures	3094.43	3097.68	3069.25	3089.29	373823.0
2019-08-15 10:00:00	ES	Futures	3089.02	3094.43	3077.65	3083.33	254484.0
2019-08-15 11:00:00	ES	Futures	3083.33	3087.12	3069.25	3086.58	196165.0
2019-08-15 12:00:00	ES	Futures	3086.31	3092.53	3079.27	3082.25	138565.0
2019-08-15 13:00:00	ES	Futures	3082.52	3087.93	3058.97	3062.49	189396.0
2019-08-15 14:00:00	ES	Futures	3062.49	3080.35	3059.24	3078.19	197851.0
2019-08-15 15:00:00	ES	Futures	3078.46	3091.99	3078.46	3083.87	249021.0
2019-08-15 16:00:00	ES	Futures	3083.6	3088.74	3082.79	3087.93	56391.0
2019-08-15 18:00:00	ES	Futures	3087.12	3094.7	3085.77	3092.26	11315.0
2019-08-15 19:00:00	ES	Futures	3092.53	3093.89	3089.29	3090.64	7694.0
2019-08-15 20:00:00	ES	Futures	3090.37	3098.76	3085.5	3097.41	24996.0
2019-08-15 21:00:00	ES	Futures	3097.41	3101.74	3096.05	3098.22	19471.0
2019-08-15 22:00:00	ES	Futures	3098.49	3103.09	3097.41	3101.74	15527.0
2019-08-15 23:00:00	ES	Futures	3101.74	3105.8	3100.66	3104.72	13545.0
2019-08-15 00:00:00	NQ	Futures	8708.04	8718.2	8696.15	8716.46	5550.0
2019-08-15 01:00:00	NQ	Futures	8716.75	8736.19	8715.01	8730.39	5207.0
2019-08-15 02:00:00	NQ	Futures	8730.97	8767.23	8730.1	8761.14	11581.0
2019-08-15 03:00:00	NQ	Futures	8760.85	8765.49	8712.4	8739.96	17521.0
2019-08-15 04:00:00	NQ	Futures	8739.96	8766.94	8725.74	8744.6	18548.0
2019-08-15 05:00:00	NQ	Futures	8744.6	8749.25	8636.96	8659.3	38036.0
2019-08-15 06:00:00	NQ	Futures	8659.3	8662.78	8574.58	8623.03	37313.0
2019-08-15 07:00:00	NQ	Futures	8623.03	8757.08	8617.23	8736.77	42708.0
2019-08-15 08:00:00	NQ	Futures	8736.19	8788.7	8703.11	8748.66	41268.0
2019-08-15 09:00:00	NQ	Futures	8748.08	8762.01	8659.01	8723.71	102427.0
2019-08-15 10:00:00	NQ	Futures	8723.42	8737.93	8687.15	8698.47	68084.0
2019-08-15 11:00:00	NQ	Futures	8698.76	8715.01	8651.76	8712.69	62885.0
2019-08-15 12:00:00	NQ	Futures	8712.98	8734.45	8685.99	8698.47	41918.0
2019-08-15 13:00:00	NQ	Futures	8698.76	8717.62	8629.42	8640.44	47873.0
2019-08-15 14:00:00	NQ	Futures	8640.73	8691.51	8630.29	8681.93	50007.0
2019-08-15 15:00:00	NQ	Futures	8682.51	8724.29	8682.51	8697.02	51874.0
2019-08-15 16:00:00	NQ	Futures	8696.73	8715.59	8692.38	8715.3	7456.0
2019-08-15 18:00:00	NQ	Futures	8715.01	8733.29	8707.75	8726.32	3768.0
2019-08-15 19:00:00	NQ	Futures	8726.32	8732.13	8717.91	8722.26	2242.0
2019-08-15 20:00:00	NQ	Futures	8721.68	8748.37	8707.17	8742.57	7778.0
2019-08-15 21:00:00	NQ	Futures	8742.86	8758.53	8738.22	8744.89	6870.0
2019-08-15 22:00:00	NQ	Futures	8744.6	8761.72	8741.41	8758.53	4646.0
2019-08-15 23:00:00	NQ	Futures	8758.53	8767.81	8752.73	8766.36	4842.0
2019-08-15 00:00:00	YM	Futures	27729.1	27763.9	27694.3	27755.2	3781.0
2019-08-15 01:00:00	YM	Futures	27756.3	27809.6	27748.7	27792.2	4294.0
2019-08-15 02:00:00	YM	Futures	27794.3	27895.5	27791.1	27879.2	6802.0
2019-08-15 03:00:00	YM	Futures	27877.0	27886.8	27762.8	27829.1	8428.0

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

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