PREVIEW / futures_1hour / 2019-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-22.parquet
  size:    41 KB
  rows:    1,350

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-04-22 00:00:00	ES	Futures	3149.4	3150.75	3148.58	3149.12	3484.0
2019-04-22 01:00:00	ES	Futures	3149.4	3150.48	3148.58	3149.12	3360.0
2019-04-22 02:00:00	ES	Futures	3149.4	3150.48	3148.31	3149.4	3476.0
2019-04-22 03:00:00	ES	Futures	3149.67	3149.94	3147.23	3147.77	4777.0
2019-04-22 04:00:00	ES	Futures	3148.04	3148.04	3146.14	3147.23	4023.0
2019-04-22 05:00:00	ES	Futures	3146.96	3147.23	3145.87	3146.96	2420.0
2019-04-22 06:00:00	ES	Futures	3146.96	3149.12	3146.96	3147.77	4232.0
2019-04-22 07:00:00	ES	Futures	3147.77	3148.31	3146.68	3147.77	6270.0
2019-04-22 08:00:00	ES	Futures	3148.04	3148.31	3143.7	3144.24	19163.0
2019-04-22 09:00:00	ES	Futures	3144.24	3152.65	3143.7	3152.38	117861.0
2019-04-22 10:00:00	ES	Futures	3152.11	3154.55	3148.85	3153.46	120512.0
2019-04-22 11:00:00	ES	Futures	3153.73	3156.44	3150.21	3154.82	72595.0
2019-04-22 12:00:00	ES	Futures	3154.55	3155.36	3152.92	3154.82	49929.0
2019-04-22 13:00:00	ES	Futures	3154.82	3155.9	3152.92	3155.09	38302.0
2019-04-22 14:00:00	ES	Futures	3155.36	3155.9	3153.19	3154.27	44260.0
2019-04-22 15:00:00	ES	Futures	3154.55	3158.61	3152.92	3157.26	89208.0
2019-04-22 16:00:00	ES	Futures	3157.53	3161.05	3155.63	3158.88	43710.0
2019-04-22 18:00:00	ES	Futures	3157.53	3159.43	3157.53	3159.15	4557.0
2019-04-22 19:00:00	ES	Futures	3159.15	3159.97	3157.8	3158.61	2894.0
2019-04-22 20:00:00	ES	Futures	3158.88	3159.97	3154.82	3155.09	10035.0
2019-04-22 21:00:00	ES	Futures	3155.36	3156.71	3153.46	3156.71	12543.0
2019-04-22 22:00:00	ES	Futures	3156.71	3157.8	3155.9	3156.71	7006.0
2019-04-22 23:00:00	ES	Futures	3156.71	3158.07	3156.17	3157.26	3218.0
2019-04-22 00:00:00	NQ	Futures	8960.91	8965.57	8959.16	8960.91	2345.0
2019-04-22 01:00:00	NQ	Futures	8960.91	8966.44	8957.71	8959.16	2324.0
2019-04-22 02:00:00	NQ	Futures	8959.16	8962.66	8956.25	8960.62	2219.0
2019-04-22 03:00:00	NQ	Futures	8960.62	8962.07	8949.55	8953.34	4855.0
2019-04-22 04:00:00	NQ	Futures	8953.05	8955.09	8948.68	8952.18	2138.0
2019-04-22 05:00:00	NQ	Futures	8952.47	8954.21	8947.52	8954.21	1208.0
2019-04-22 06:00:00	NQ	Futures	8953.92	8961.2	8953.34	8956.83	2161.0
2019-04-22 07:00:00	NQ	Futures	8956.83	8959.45	8948.97	8950.14	2909.0
2019-04-22 08:00:00	NQ	Futures	8950.14	8950.72	8932.38	8934.71	9719.0
2019-04-22 09:00:00	NQ	Futures	8934.71	8964.4	8933.54	8964.4	43095.0
2019-04-22 10:00:00	NQ	Futures	8963.82	8986.24	8960.91	8985.37	44355.0
2019-04-22 11:00:00	NQ	Futures	8985.37	8994.98	8974.01	8987.7	25658.0
2019-04-22 12:00:00	NQ	Futures	8987.7	8993.81	8983.91	8987.4	17728.0
2019-04-22 13:00:00	NQ	Futures	8987.4	8998.47	8983.04	8995.85	14917.0
2019-04-22 14:00:00	NQ	Futures	8996.14	9001.67	8992.06	8997.01	15941.0
2019-04-22 15:00:00	NQ	Futures	8997.01	9007.49	8993.23	9006.04	25008.0
2019-04-22 16:00:00	NQ	Futures	9005.75	9022.05	9001.96	9013.61	10418.0
2019-04-22 18:00:00	NQ	Futures	9011.86	9015.36	9008.08	9015.06	1660.0
2019-04-22 19:00:00	NQ	Futures	9015.06	9017.98	9011.86	9013.9	1517.0
2019-04-22 20:00:00	NQ	Futures	9014.19	9017.69	9001.67	9004.29	4081.0
2019-04-22 21:00:00	NQ	Futures	9003.71	9008.95	8997.6	9008.95	4713.0
2019-04-22 22:00:00	NQ	Futures	9008.95	9011.86	9005.46	9008.08	2789.0
2019-04-22 23:00:00	NQ	Futures	9007.79	9012.15	9006.91	9010.41	1541.0
2019-04-22 00:00:00	YM	Futures	28856.9	28871.0	28852.5	28856.9	1340.0
2019-04-22 01:00:00	YM	Futures	28858.0	28865.6	28848.2	28854.7	890.0
2019-04-22 02:00:00	YM	Futures	28854.7	28867.8	28847.1	28854.7	1096.0
2019-04-22 03:00:00	YM	Futures	28855.8	28856.9	28833.0	28843.8	1595.0

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

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