PREVIEW / futures_1hour / 2021-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-03.parquet
  size:    63 KB
  rows:    1,955

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
2021-08-03 00:00:00	ES	Futures	4941.2	4943.46	4940.08	4942.89	2839.0
2021-08-03 01:00:00	ES	Futures	4942.89	4947.12	4942.89	4945.71	5957.0
2021-08-03 02:00:00	ES	Futures	4945.99	4948.81	4944.58	4946.84	6637.0
2021-08-03 03:00:00	ES	Futures	4947.12	4952.75	4941.77	4949.09	25135.0
2021-08-03 04:00:00	ES	Futures	4949.09	4950.5	4947.12	4950.22	8637.0
2021-08-03 05:00:00	ES	Futures	4950.5	4952.19	4945.71	4950.22	9926.0
2021-08-03 06:00:00	ES	Futures	4950.22	4952.75	4949.65	4951.9	9171.0
2021-08-03 07:00:00	ES	Futures	4951.9	4952.19	4948.53	4951.06	11159.0
2021-08-03 08:00:00	ES	Futures	4951.06	4951.34	4939.8	4945.99	25602.0
2021-08-03 09:00:00	ES	Futures	4946.27	4946.27	4918.96	4920.09	179991.0
2021-08-03 10:00:00	ES	Futures	4919.8	4939.8	4916.71	4931.91	237378.0
2021-08-03 11:00:00	ES	Futures	4931.63	4958.94	4927.13	4957.82	214424.0
2021-08-03 12:00:00	ES	Futures	4957.54	4958.94	4950.22	4958.38	92607.0
2021-08-03 13:00:00	ES	Futures	4958.38	4964.01	4958.38	4962.89	70797.0
2021-08-03 14:00:00	ES	Futures	4963.17	4967.96	4959.23	4965.98	91120.0
2021-08-03 15:00:00	ES	Futures	4965.98	4974.99	4965.7	4973.31	186316.0
2021-08-03 16:00:00	ES	Futures	4973.02	4974.15	4965.42	4965.7	52965.0
2021-08-03 18:00:00	ES	Futures	4966.83	4969.64	4966.27	4967.11	4706.0
2021-08-03 19:00:00	ES	Futures	4967.39	4967.39	4964.29	4965.14	3784.0
2021-08-03 20:00:00	ES	Futures	4965.14	4966.27	4962.04	4965.14	8328.0
2021-08-03 21:00:00	ES	Futures	4965.14	4969.36	4963.45	4968.8	8631.0
2021-08-03 22:00:00	ES	Futures	4968.8	4969.08	4967.39	4967.39	4569.0
2021-08-03 23:00:00	ES	Futures	4967.67	4969.64	4967.11	4967.67	3312.0
2021-08-03 00:00:00	NQ	Futures	17341.19	17349.88	17338.29	17347.56	1718.0
2021-08-03 01:00:00	NQ	Futures	17348.14	17366.1	17346.69	17362.63	3229.0
2021-08-03 02:00:00	NQ	Futures	17363.2	17373.34	17356.54	17366.1	3158.0
2021-08-03 03:00:00	NQ	Futures	17366.68	17371.61	17351.04	17362.05	5956.0
2021-08-03 04:00:00	NQ	Futures	17362.05	17366.68	17356.54	17366.39	2594.0
2021-08-03 05:00:00	NQ	Futures	17366.1	17368.13	17331.92	17345.82	5357.0
2021-08-03 06:00:00	NQ	Futures	17344.96	17359.44	17341.48	17349.3	3488.0
2021-08-03 07:00:00	NQ	Futures	17348.72	17358.28	17335.11	17353.94	3972.0
2021-08-03 08:00:00	NQ	Futures	17353.65	17367.26	17337.71	17366.68	7883.0
2021-08-03 09:00:00	NQ	Futures	17366.39	17391.01	17268.77	17270.51	85038.0
2021-08-03 10:00:00	NQ	Futures	17270.51	17310.77	17221.55	17274.85	104930.0
2021-08-03 11:00:00	NQ	Futures	17275.14	17401.44	17205.91	17393.33	97177.0
2021-08-03 12:00:00	NQ	Futures	17393.33	17406.66	17357.41	17404.92	48085.0
2021-08-03 13:00:00	NQ	Futures	17404.92	17423.46	17393.62	17403.76	31289.0
2021-08-03 14:00:00	NQ	Futures	17403.76	17425.2	17374.5	17409.84	31960.0
2021-08-03 15:00:00	NQ	Futures	17410.13	17438.81	17402.31	17431.86	47986.0
2021-08-03 16:00:00	NQ	Futures	17431.57	17438.81	17416.8	17421.43	9828.0
2021-08-03 18:00:00	NQ	Futures	17424.91	17432.73	17421.43	17426.07	1986.0
2021-08-03 19:00:00	NQ	Futures	17426.07	17426.07	17412.74	17417.09	2059.0
2021-08-03 20:00:00	NQ	Futures	17415.93	17423.75	17405.5	17422.01	2769.0
2021-08-03 21:00:00	NQ	Futures	17422.01	17429.83	17409.55	17426.36	3445.0
2021-08-03 22:00:00	NQ	Futures	17426.93	17437.07	17421.72	17426.07	3375.0
2021-08-03 23:00:00	NQ	Futures	17426.36	17435.91	17426.07	17429.83	1682.0
2021-08-03 00:00:00	YM	Futures	38879.3	38894.9	38867.0	38891.5	684.0
2021-08-03 01:00:00	YM	Futures	38890.4	38919.5	38889.3	38908.3	1419.0
2021-08-03 02:00:00	YM	Futures	38910.5	38935.1	38899.4	38917.2	1516.0
2021-08-03 03:00:00	YM	Futures	38918.4	38983.2	38881.5	38954.1	5263.0

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

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