PREVIEW / futures_1hour / 2019-08-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	3075.21	3086.85	3066.01	3067.36	53736.0
2019-08-06 01:00:00	ES	Futures	3067.36	3075.48	3067.09	3072.23	27660.0
2019-08-06 02:00:00	ES	Futures	3072.23	3077.1	3068.44	3076.83	47867.0
2019-08-06 03:00:00	ES	Futures	3076.83	3085.23	3073.04	3075.21	65234.0
2019-08-06 04:00:00	ES	Futures	3075.21	3091.99	3068.98	3090.37	63641.0
2019-08-06 05:00:00	ES	Futures	3090.64	3097.41	3087.93	3091.99	42297.0
2019-08-06 06:00:00	ES	Futures	3091.99	3094.7	3088.47	3091.18	33771.0
2019-08-06 07:00:00	ES	Futures	3090.91	3102.55	3088.2	3094.43	69861.0
2019-08-06 08:00:00	ES	Futures	3094.7	3098.49	3087.66	3090.64	70412.0
2019-08-06 09:00:00	ES	Futures	3090.91	3110.67	3089.29	3102.28	311107.0
2019-08-06 10:00:00	ES	Futures	3102.28	3108.78	3086.58	3097.41	305576.0
2019-08-06 11:00:00	ES	Futures	3097.41	3097.95	3081.71	3095.51	253114.0
2019-08-06 12:00:00	ES	Futures	3095.51	3100.39	3087.39	3090.64	153752.0
2019-08-06 13:00:00	ES	Futures	3090.64	3108.24	3090.64	3106.88	140183.0
2019-08-06 14:00:00	ES	Futures	3106.88	3122.31	3100.39	3111.21	195608.0
2019-08-06 15:00:00	ES	Futures	3111.48	3122.58	3108.51	3120.15	267894.0
2019-08-06 16:00:00	ES	Futures	3120.15	3122.31	3113.11	3113.65	82956.0
2019-08-06 18:00:00	ES	Futures	3111.75	3113.92	3110.67	3110.67	7486.0
2019-08-06 19:00:00	ES	Futures	3110.67	3110.94	3102.28	3106.61	13986.0
2019-08-06 20:00:00	ES	Futures	3106.61	3109.05	3101.2	3107.69	24854.0
2019-08-06 21:00:00	ES	Futures	3107.69	3112.03	3099.03	3102.28	41254.0
2019-08-06 22:00:00	ES	Futures	3102.28	3102.55	3091.72	3095.78	25790.0
2019-08-06 23:00:00	ES	Futures	3095.78	3099.3	3090.91	3098.76	14054.0
2019-08-06 00:00:00	NQ	Futures	8612.01	8651.76	8580.96	8587.93	24923.0
2019-08-06 01:00:00	NQ	Futures	8587.35	8621.58	8587.35	8606.79	13053.0
2019-08-06 02:00:00	NQ	Futures	8606.5	8626.81	8593.15	8624.77	15030.0
2019-08-06 03:00:00	NQ	Futures	8624.48	8649.44	8607.95	8615.78	18706.0
2019-08-06 04:00:00	NQ	Futures	8615.78	8675.84	8595.18	8670.33	20807.0
2019-08-06 05:00:00	NQ	Futures	8670.33	8688.32	8661.62	8665.1	12997.0
2019-08-06 06:00:00	NQ	Futures	8665.39	8672.65	8646.53	8657.27	11742.0
2019-08-06 07:00:00	NQ	Futures	8656.98	8697.02	8646.53	8671.49	20878.0
2019-08-06 08:00:00	NQ	Futures	8672.07	8683.38	8650.6	8662.78	25031.0
2019-08-06 09:00:00	NQ	Futures	8663.07	8737.35	8659.01	8722.84	103093.0
2019-08-06 10:00:00	NQ	Futures	8722.55	8744.31	8661.33	8695.57	108037.0
2019-08-06 11:00:00	NQ	Futures	8695.57	8698.47	8631.16	8678.74	87314.0
2019-08-06 12:00:00	NQ	Futures	8678.74	8695.28	8650.31	8659.3	54492.0
2019-08-06 13:00:00	NQ	Futures	8659.3	8720.52	8659.3	8713.56	41089.0
2019-08-06 14:00:00	NQ	Futures	8713.56	8761.14	8692.09	8729.52	57253.0
2019-08-06 15:00:00	NQ	Futures	8729.81	8750.7	8715.88	8735.61	65215.0
2019-08-06 16:00:00	NQ	Futures	8735.9	8746.05	8719.07	8724.87	13021.0
2019-08-06 18:00:00	NQ	Futures	8719.07	8731.26	8717.04	8717.33	3227.0
2019-08-06 19:00:00	NQ	Futures	8717.33	8719.94	8687.74	8706.59	6338.0
2019-08-06 20:00:00	NQ	Futures	8706.3	8711.53	8683.67	8707.17	10290.0
2019-08-06 21:00:00	NQ	Futures	8707.46	8721.39	8677.87	8690.06	15599.0
2019-08-06 22:00:00	NQ	Futures	8689.19	8689.19	8648.28	8660.75	10988.0
2019-08-06 23:00:00	NQ	Futures	8660.46	8678.45	8647.41	8674.68	5667.0
2019-08-06 00:00:00	YM	Futures	27860.7	27970.5	27760.6	27773.7	10842.0
2019-08-06 01:00:00	YM	Futures	27775.8	27874.8	27775.8	27846.5	6886.0
2019-08-06 02:00:00	YM	Futures	27844.4	27895.5	27813.9	27885.7	7717.0
2019-08-06 03:00:00	YM	Futures	27883.5	27967.2	27850.9	27883.5	10319.0

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

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