PREVIEW / futures_1hour / 2019-05-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	3059.93	3061.02	3058.58	3059.93	5536.0
2019-05-14 01:00:00	ES	Futures	3060.2	3061.56	3058.85	3060.47	9938.0
2019-05-14 02:00:00	ES	Futures	3060.47	3061.29	3055.05	3057.22	22292.0
2019-05-14 03:00:00	ES	Futures	3056.95	3062.64	3055.86	3059.66	26929.0
2019-05-14 04:00:00	ES	Futures	3059.66	3059.93	3053.97	3059.12	28218.0
2019-05-14 05:00:00	ES	Futures	3059.12	3065.62	3057.76	3063.73	33073.0
2019-05-14 06:00:00	ES	Futures	3063.73	3069.42	3061.83	3064.27	29783.0
2019-05-14 07:00:00	ES	Futures	3064.0	3070.5	3063.73	3067.52	32729.0
2019-05-14 08:00:00	ES	Futures	3067.52	3069.15	3059.39	3064.0	70817.0
2019-05-14 09:00:00	ES	Futures	3064.0	3071.86	3058.58	3064.81	260396.0
2019-05-14 10:00:00	ES	Futures	3064.54	3078.91	3064.54	3075.93	276994.0
2019-05-14 11:00:00	ES	Futures	3075.66	3090.57	3072.13	3088.67	205614.0
2019-05-14 12:00:00	ES	Futures	3088.67	3091.11	3082.98	3085.96	113508.0
2019-05-14 13:00:00	ES	Futures	3086.23	3094.63	3085.96	3091.92	105517.0
2019-05-14 14:00:00	ES	Futures	3091.92	3094.36	3082.7	3085.96	134939.0
2019-05-14 15:00:00	ES	Futures	3085.69	3091.11	3073.22	3075.11	224723.0
2019-05-14 16:00:00	ES	Futures	3075.38	3080.81	3074.57	3079.99	69744.0
2019-05-14 18:00:00	ES	Futures	3080.54	3082.7	3078.91	3080.81	8738.0
2019-05-14 19:00:00	ES	Futures	3080.81	3082.16	3079.45	3081.89	8112.0
2019-05-14 20:00:00	ES	Futures	3081.89	3081.89	3072.67	3077.55	20791.0
2019-05-14 21:00:00	ES	Futures	3077.28	3086.5	3075.11	3084.33	18009.0
2019-05-14 22:00:00	ES	Futures	3084.06	3084.87	3078.91	3083.79	18368.0
2019-05-14 23:00:00	ES	Futures	3083.79	3085.96	3082.7	3084.06	9368.0
2019-05-14 00:00:00	NQ	Futures	8576.29	8582.99	8570.18	8577.75	2737.0
2019-05-14 01:00:00	NQ	Futures	8578.04	8586.19	8570.76	8575.71	3520.0
2019-05-14 02:00:00	NQ	Futures	8575.71	8578.04	8555.04	8563.48	8167.0
2019-05-14 03:00:00	NQ	Futures	8563.77	8592.89	8558.53	8582.41	9059.0
2019-05-14 04:00:00	NQ	Futures	8582.41	8584.15	8562.9	8580.08	8237.0
2019-05-14 05:00:00	NQ	Futures	8579.79	8599.59	8577.46	8596.38	7916.0
2019-05-14 06:00:00	NQ	Futures	8595.8	8613.27	8588.81	8596.67	10219.0
2019-05-14 07:00:00	NQ	Futures	8596.96	8617.93	8594.93	8605.12	10956.0
2019-05-14 08:00:00	NQ	Futures	8605.41	8611.23	8573.38	8596.38	21882.0
2019-05-14 09:00:00	NQ	Futures	8596.09	8612.4	8555.04	8574.55	81640.0
2019-05-14 10:00:00	NQ	Futures	8574.25	8635.4	8573.38	8621.71	91315.0
2019-05-14 11:00:00	NQ	Futures	8621.71	8672.96	8604.83	8663.64	69056.0
2019-05-14 12:00:00	NQ	Futures	8663.93	8679.65	8648.5	8661.02	38483.0
2019-05-14 13:00:00	NQ	Futures	8661.02	8687.51	8660.73	8680.53	27254.0
2019-05-14 14:00:00	NQ	Futures	8680.24	8684.02	8649.66	8661.02	38610.0
2019-05-14 15:00:00	NQ	Futures	8660.73	8676.16	8628.12	8633.07	58137.0
2019-05-14 16:00:00	NQ	Futures	8632.78	8649.66	8627.54	8648.21	12463.0
2019-05-14 18:00:00	NQ	Futures	8652.28	8657.82	8643.84	8652.58	2458.0
2019-05-14 19:00:00	NQ	Futures	8652.58	8656.94	8648.21	8656.36	1713.0
2019-05-14 20:00:00	NQ	Futures	8656.36	8656.36	8628.7	8642.39	7239.0
2019-05-14 21:00:00	NQ	Futures	8642.68	8674.12	8634.81	8667.42	7822.0
2019-05-14 22:00:00	NQ	Futures	8667.13	8668.59	8649.66	8665.39	7697.0
2019-05-14 23:00:00	NQ	Futures	8665.1	8674.7	8661.89	8667.13	3546.0
2019-05-14 00:00:00	YM	Futures	27613.7	27633.3	27599.6	27623.5	1630.0
2019-05-14 01:00:00	YM	Futures	27624.6	27639.8	27606.1	27623.5	2370.0
2019-05-14 02:00:00	YM	Futures	27623.5	27630.0	27573.5	27586.5	5424.0
2019-05-14 03:00:00	YM	Futures	27586.5	27635.4	27577.8	27609.3	4681.0

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

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