PREVIEW / futures_1hour / 2019-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-25.parquet
  size:    59 KB
  rows:    1,845

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-09-25 00:00:00	ES	Futures	3234.31	3235.12	3232.68	3233.22	4929.0
2019-09-25 01:00:00	ES	Futures	3233.5	3235.12	3232.14	3232.68	6031.0
2019-09-25 02:00:00	ES	Futures	3232.95	3233.22	3226.43	3227.79	14908.0
2019-09-25 03:00:00	ES	Futures	3227.52	3230.24	3220.46	3221.0	31793.0
2019-09-25 04:00:00	ES	Futures	3220.73	3223.72	3216.11	3217.47	31853.0
2019-09-25 05:00:00	ES	Futures	3217.47	3220.73	3212.31	3220.19	40125.0
2019-09-25 06:00:00	ES	Futures	3220.19	3222.36	3219.1	3221.82	18968.0
2019-09-25 07:00:00	ES	Futures	3221.82	3222.36	3218.83	3220.19	17537.0
2019-09-25 08:00:00	ES	Futures	3220.19	3228.88	3220.19	3228.06	34149.0
2019-09-25 09:00:00	ES	Futures	3228.06	3231.32	3217.74	3218.56	154915.0
2019-09-25 10:00:00	ES	Futures	3218.56	3234.31	3209.32	3229.96	364298.0
2019-09-25 11:00:00	ES	Futures	3230.24	3235.12	3228.88	3232.41	151090.0
2019-09-25 12:00:00	ES	Futures	3232.14	3237.57	3230.78	3232.41	111438.0
2019-09-25 13:00:00	ES	Futures	3232.68	3238.11	3231.59	3237.3	58617.0
2019-09-25 14:00:00	ES	Futures	3237.3	3244.63	3237.03	3244.09	95726.0
2019-09-25 15:00:00	ES	Futures	3243.82	3250.61	3242.73	3244.9	183785.0
2019-09-25 16:00:00	ES	Futures	3244.9	3246.26	3243.0	3244.36	73245.0
2019-09-25 18:00:00	ES	Futures	3244.09	3247.35	3243.55	3244.9	5918.0
2019-09-25 19:00:00	ES	Futures	3244.9	3244.9	3240.83	3243.55	8198.0
2019-09-25 20:00:00	ES	Futures	3243.55	3244.36	3239.47	3241.92	11482.0
2019-09-25 21:00:00	ES	Futures	3241.64	3244.09	3240.29	3242.46	9363.0
2019-09-25 22:00:00	ES	Futures	3242.46	3243.0	3239.74	3242.46	6284.0
2019-09-25 23:00:00	ES	Futures	3242.46	3242.46	3240.83	3241.64	4841.0
2019-09-25 00:00:00	NQ	Futures	9010.2	9013.1	9001.19	9005.26	5323.0
2019-09-25 01:00:00	NQ	Futures	9005.55	9010.78	8999.45	9004.39	3577.0
2019-09-25 02:00:00	NQ	Futures	9004.68	9004.97	8979.12	8983.77	6354.0
2019-09-25 03:00:00	NQ	Futures	8984.06	8993.06	8957.62	8958.49	12817.0
2019-09-25 04:00:00	NQ	Futures	8958.49	8968.95	8940.77	8945.42	16181.0
2019-09-25 05:00:00	NQ	Futures	8945.13	8958.2	8927.7	8956.46	13632.0
2019-09-25 06:00:00	NQ	Futures	8956.17	8963.43	8951.23	8961.11	6142.0
2019-09-25 07:00:00	NQ	Futures	8961.11	8962.56	8949.49	8955.01	5772.0
2019-09-25 08:00:00	NQ	Futures	8955.3	8989.87	8955.01	8987.25	14033.0
2019-09-25 09:00:00	NQ	Futures	8987.54	8996.55	8935.54	8944.84	68557.0
2019-09-25 10:00:00	NQ	Futures	8944.55	9004.97	8904.17	8994.22	113063.0
2019-09-25 11:00:00	NQ	Futures	8994.51	9024.43	8992.19	9006.13	60004.0
2019-09-25 12:00:00	NQ	Futures	9006.42	9033.73	9003.81	9020.08	44032.0
2019-09-25 13:00:00	NQ	Futures	9020.37	9045.35	9016.01	9040.99	29459.0
2019-09-25 14:00:00	NQ	Futures	9040.99	9081.66	9039.25	9078.76	36940.0
2019-09-25 15:00:00	NQ	Futures	9078.76	9114.78	9075.27	9090.38	54103.0
2019-09-25 16:00:00	NQ	Futures	9089.79	9092.99	9082.53	9090.09	10009.0
2019-09-25 18:00:00	NQ	Futures	9089.5	9096.77	9082.24	9085.44	2896.0
2019-09-25 19:00:00	NQ	Futures	9085.73	9086.6	9072.37	9082.53	3800.0
2019-09-25 20:00:00	NQ	Futures	9083.11	9086.02	9067.72	9075.85	5721.0
2019-09-25 21:00:00	NQ	Futures	9075.85	9085.15	9070.04	9078.47	4533.0
2019-09-25 22:00:00	NQ	Futures	9078.76	9080.79	9070.33	9078.47	3831.0
2019-09-25 23:00:00	NQ	Futures	9078.76	9079.05	9069.17	9070.33	3144.0
2019-09-25 00:00:00	YM	Futures	29256.0	29262.5	29241.9	29245.1	847.0
2019-09-25 01:00:00	YM	Futures	29247.3	29257.1	29235.3	29240.8	1285.0
2019-09-25 02:00:00	YM	Futures	29241.9	29242.9	29190.7	29202.7	3081.0
2019-09-25 03:00:00	YM	Futures	29201.6	29227.7	29139.5	29143.9	7964.0

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

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