PREVIEW / futures_1hour / 2019-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-18.parquet
  size:    52 KB
  rows:    1,729

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-18 00:00:00	ES	Futures	3069.69	3070.78	3069.42	3070.5	2817.0
2019-03-18 01:00:00	ES	Futures	3070.5	3071.86	3069.42	3071.59	3916.0
2019-03-18 02:00:00	ES	Futures	3071.86	3072.94	3071.59	3072.4	3339.0
2019-03-18 03:00:00	ES	Futures	3072.4	3072.94	3070.23	3071.05	5408.0
2019-03-18 04:00:00	ES	Futures	3070.78	3071.86	3069.42	3070.5	11222.0
2019-03-18 05:00:00	ES	Futures	3070.5	3070.78	3067.52	3068.88	9755.0
2019-03-18 06:00:00	ES	Futures	3069.15	3070.5	3067.25	3069.69	9850.0
2019-03-18 07:00:00	ES	Futures	3069.69	3074.03	3069.42	3072.94	13858.0
2019-03-18 08:00:00	ES	Futures	3072.94	3072.94	3069.69	3069.69	13746.0
2019-03-18 09:00:00	ES	Futures	3069.96	3078.37	3068.34	3078.37	177353.0
2019-03-18 10:00:00	ES	Futures	3078.1	3080.81	3074.57	3079.18	158830.0
2019-03-18 11:00:00	ES	Futures	3079.18	3079.72	3066.17	3069.42	166672.0
2019-03-18 12:00:00	ES	Futures	3069.69	3074.3	3067.79	3073.22	91648.0
2019-03-18 13:00:00	ES	Futures	3072.94	3075.93	3071.86	3075.38	54170.0
2019-03-18 14:00:00	ES	Futures	3075.11	3077.28	3073.22	3075.66	55283.0
2019-03-18 15:00:00	ES	Futures	3075.93	3079.99	3072.13	3078.1	136437.0
2019-03-18 16:00:00	ES	Futures	3077.82	3081.89	3077.82	3081.62	49513.0
2019-03-18 18:00:00	ES	Futures	3081.35	3083.52	3081.08	3081.62	6041.0
2019-03-18 19:00:00	ES	Futures	3081.62	3082.98	3080.54	3081.62	4808.0
2019-03-18 20:00:00	ES	Futures	3081.35	3081.62	3078.91	3080.54	10903.0
2019-03-18 21:00:00	ES	Futures	3080.54	3084.87	3079.99	3082.43	9610.0
2019-03-18 22:00:00	ES	Futures	3082.43	3083.79	3081.35	3083.52	5643.0
2019-03-18 23:00:00	ES	Futures	3083.52	3084.33	3081.89	3081.89	3267.0
2019-03-18 00:00:00	NQ	Futures	8555.91	8560.28	8555.91	8558.53	1372.0
2019-03-18 01:00:00	NQ	Futures	8558.53	8562.61	8554.75	8562.03	1599.0
2019-03-18 02:00:00	NQ	Futures	8562.03	8569.3	8561.44	8566.98	2119.0
2019-03-18 03:00:00	NQ	Futures	8566.98	8568.43	8560.28	8562.32	2398.0
2019-03-18 04:00:00	NQ	Futures	8562.03	8567.56	8560.57	8563.48	4240.0
2019-03-18 05:00:00	NQ	Futures	8563.48	8566.1	8556.2	8558.53	4197.0
2019-03-18 06:00:00	NQ	Futures	8559.11	8560.86	8552.71	8556.2	4340.0
2019-03-18 07:00:00	NQ	Futures	8556.2	8567.85	8555.62	8562.32	5544.0
2019-03-18 08:00:00	NQ	Futures	8562.03	8562.03	8549.22	8549.8	5025.0
2019-03-18 09:00:00	NQ	Futures	8549.8	8582.41	8539.61	8581.53	57518.0
2019-03-18 10:00:00	NQ	Futures	8581.53	8594.34	8569.3	8587.36	60239.0
2019-03-18 11:00:00	NQ	Futures	8587.36	8589.1	8533.2	8542.52	64209.0
2019-03-18 12:00:00	NQ	Futures	8543.1	8552.13	8527.09	8547.18	41145.0
2019-03-18 13:00:00	NQ	Futures	8547.18	8559.99	8544.56	8558.82	23213.0
2019-03-18 14:00:00	NQ	Futures	8558.82	8570.47	8556.49	8568.72	24361.0
2019-03-18 15:00:00	NQ	Futures	8569.01	8572.51	8556.49	8565.81	39490.0
2019-03-18 16:00:00	NQ	Futures	8565.81	8577.17	8565.23	8576.87	7816.0
2019-03-18 18:00:00	NQ	Futures	8574.25	8581.24	8573.09	8574.84	1978.0
2019-03-18 19:00:00	NQ	Futures	8574.84	8579.5	8571.63	8575.13	1784.0
2019-03-18 20:00:00	NQ	Futures	8575.13	8575.13	8567.56	8571.05	3325.0
2019-03-18 21:00:00	NQ	Futures	8570.76	8586.48	8569.6	8578.33	4190.0
2019-03-18 22:00:00	NQ	Futures	8578.62	8582.7	8574.84	8580.66	2484.0
2019-03-18 23:00:00	NQ	Futures	8580.95	8584.15	8575.71	8576.58	1490.0
2019-03-18 00:00:00	YM	Futures	28176.0	28190.2	28172.8	28178.2	788.0
2019-03-18 01:00:00	YM	Futures	28178.2	28186.9	28167.3	28185.8	989.0
2019-03-18 02:00:00	YM	Futures	28185.8	28202.1	28181.5	28186.9	1381.0
2019-03-18 03:00:00	YM	Futures	28188.0	28189.1	28160.8	28169.5	1785.0

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

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