PREVIEW / futures_1hour / 2019-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-13.parquet
  size:    59 KB
  rows:    1,877

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-11-13 00:00:00	ES	Futures	3350.02	3351.65	3348.4	3350.84	7797.0
2019-11-13 01:00:00	ES	Futures	3350.84	3352.47	3348.94	3352.47	6439.0
2019-11-13 02:00:00	ES	Futures	3352.47	3353.56	3351.11	3353.01	6935.0
2019-11-13 03:00:00	ES	Futures	3353.01	3355.19	3351.11	3351.11	15428.0
2019-11-13 04:00:00	ES	Futures	3351.11	3351.38	3341.88	3343.51	38852.0
2019-11-13 05:00:00	ES	Futures	3343.51	3347.31	3343.23	3346.77	14960.0
2019-11-13 06:00:00	ES	Futures	3346.77	3347.31	3345.14	3346.77	11058.0
2019-11-13 07:00:00	ES	Futures	3346.49	3349.48	3344.59	3348.12	16987.0
2019-11-13 08:00:00	ES	Futures	3348.12	3350.57	3347.85	3350.02	19769.0
2019-11-13 09:00:00	ES	Futures	3350.02	3353.28	3344.32	3352.2	144852.0
2019-11-13 10:00:00	ES	Futures	3352.2	3359.26	3350.57	3358.99	169974.0
2019-11-13 11:00:00	ES	Futures	3358.99	3361.43	3355.19	3360.35	114992.0
2019-11-13 12:00:00	ES	Futures	3360.08	3363.61	3358.72	3362.79	95189.0
2019-11-13 13:00:00	ES	Futures	3362.52	3364.96	3353.56	3357.09	127536.0
2019-11-13 14:00:00	ES	Futures	3357.36	3361.16	3352.47	3360.35	140667.0
2019-11-13 15:00:00	ES	Futures	3360.62	3363.06	3357.36	3360.08	162786.0
2019-11-13 16:00:00	ES	Futures	3360.08	3364.42	3358.99	3364.15	61281.0
2019-11-13 18:00:00	ES	Futures	3364.15	3364.42	3361.16	3362.25	6094.0
2019-11-13 19:00:00	ES	Futures	3362.25	3363.06	3358.99	3359.8	8337.0
2019-11-13 20:00:00	ES	Futures	3359.53	3367.95	3359.53	3365.51	17494.0
2019-11-13 21:00:00	ES	Futures	3365.51	3365.51	3355.46	3358.45	21473.0
2019-11-13 22:00:00	ES	Futures	3358.45	3360.08	3357.63	3357.9	7606.0
2019-11-13 23:00:00	ES	Futures	3357.9	3360.08	3356.0	3359.8	6858.0
2019-11-13 00:00:00	NQ	Futures	9583.05	9588.86	9578.4	9585.37	2440.0
2019-11-13 01:00:00	NQ	Futures	9585.37	9590.89	9579.27	9590.02	2279.0
2019-11-13 02:00:00	NQ	Futures	9590.02	9594.96	9587.7	9594.09	3336.0
2019-11-13 03:00:00	NQ	Futures	9594.38	9601.06	9586.54	9586.83	5047.0
2019-11-13 04:00:00	NQ	Futures	9586.83	9586.83	9551.39	9557.2	13217.0
2019-11-13 05:00:00	NQ	Futures	9557.2	9570.56	9556.91	9568.53	5440.0
2019-11-13 06:00:00	NQ	Futures	9568.53	9569.98	9563.01	9569.11	2996.0
2019-11-13 07:00:00	NQ	Futures	9569.69	9580.44	9564.17	9574.63	5458.0
2019-11-13 08:00:00	NQ	Futures	9574.34	9587.7	9572.59	9586.83	7238.0
2019-11-13 09:00:00	NQ	Futures	9587.12	9602.51	9570.85	9591.77	50476.0
2019-11-13 10:00:00	NQ	Futures	9591.77	9614.71	9585.96	9611.81	59737.0
2019-11-13 11:00:00	NQ	Futures	9611.81	9621.4	9596.7	9617.04	41220.0
2019-11-13 12:00:00	NQ	Futures	9616.75	9622.85	9610.07	9617.91	31242.0
2019-11-13 13:00:00	NQ	Futures	9618.2	9622.56	9582.18	9595.54	36179.0
2019-11-13 14:00:00	NQ	Futures	9595.54	9605.42	9574.05	9603.09	45849.0
2019-11-13 15:00:00	NQ	Futures	9603.39	9615.0	9594.09	9603.68	35775.0
2019-11-13 16:00:00	NQ	Futures	9603.97	9611.52	9589.73	9609.78	11292.0
2019-11-13 18:00:00	NQ	Futures	9608.32	9609.49	9599.32	9602.8	1825.0
2019-11-13 19:00:00	NQ	Futures	9602.8	9604.55	9592.06	9596.12	2731.0
2019-11-13 20:00:00	NQ	Futures	9596.41	9627.5	9596.41	9617.91	8387.0
2019-11-13 21:00:00	NQ	Futures	9617.62	9617.62	9579.27	9592.35	9860.0
2019-11-13 22:00:00	NQ	Futures	9592.06	9596.99	9588.28	9589.15	3818.0
2019-11-13 23:00:00	NQ	Futures	9588.86	9596.12	9582.47	9595.54	2926.0
2019-11-13 00:00:00	YM	Futures	30025.5	30042.9	30013.5	30036.3	1140.0
2019-11-13 01:00:00	YM	Futures	30036.3	30048.3	30018.9	30048.3	1440.0
2019-11-13 02:00:00	YM	Futures	30047.2	30058.1	30039.6	30057.0	1649.0
2019-11-13 03:00:00	YM	Futures	30057.0	30073.4	30035.3	30037.4	2946.0

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

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