PREVIEW / futures_1hour / 2023-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-30.parquet
  size:    64 KB
  rows:    2,017

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
2023-08-30 00:00:00	ES	Futures	4956.58	4957.68	4954.11	4954.11	4052.0
2023-08-30 01:00:00	ES	Futures	4954.11	4956.58	4949.72	4951.64	7867.0
2023-08-30 02:00:00	ES	Futures	4951.91	4951.91	4946.15	4947.52	9978.0
2023-08-30 03:00:00	ES	Futures	4947.52	4950.26	4940.38	4949.17	23056.0
2023-08-30 04:00:00	ES	Futures	4949.17	4949.99	4940.11	4940.66	17190.0
2023-08-30 05:00:00	ES	Futures	4940.66	4942.3	4937.09	4939.83	15956.0
2023-08-30 06:00:00	ES	Futures	4939.83	4946.97	4939.56	4945.32	12892.0
2023-08-30 07:00:00	ES	Futures	4945.05	4945.87	4942.03	4943.13	14926.0
2023-08-30 08:00:00	ES	Futures	4943.13	4956.58	4941.48	4952.19	54396.0
2023-08-30 09:00:00	ES	Futures	4951.91	4971.13	4947.79	4970.03	171748.0
2023-08-30 10:00:00	ES	Futures	4970.03	4974.15	4942.3	4962.89	286654.0
2023-08-30 11:00:00	ES	Futures	4962.89	4969.21	4953.56	4968.38	132937.0
2023-08-30 12:00:00	ES	Futures	4968.11	4974.97	4964.81	4972.22	98493.0
2023-08-30 13:00:00	ES	Futures	4972.22	4972.5	4960.15	4964.81	84345.0
2023-08-30 14:00:00	ES	Futures	4964.81	4970.3	4956.3	4969.21	121394.0
2023-08-30 15:00:00	ES	Futures	4969.21	4971.95	4962.62	4967.56	187720.0
2023-08-30 16:00:00	ES	Futures	4967.83	4971.4	4966.46	4970.85	64779.0
2023-08-30 18:00:00	ES	Futures	4970.85	4971.4	4968.38	4968.93	2652.0
2023-08-30 19:00:00	ES	Futures	4968.93	4969.21	4967.56	4968.11	2383.0
2023-08-30 20:00:00	ES	Futures	4968.38	4971.95	4968.38	4969.21	5665.0
2023-08-30 21:00:00	ES	Futures	4969.21	4972.22	4968.66	4970.58	6421.0
2023-08-30 22:00:00	ES	Futures	4970.58	4975.79	4970.3	4970.58	6775.0
2023-08-30 23:00:00	ES	Futures	4970.85	4972.77	4969.48	4971.68	4467.0
2023-08-30 00:00:00	NQ	Futures	17194.9	17196.85	17177.66	17177.94	2751.0
2023-08-30 01:00:00	NQ	Futures	17177.94	17186.56	17152.07	17160.69	4723.0
2023-08-30 02:00:00	NQ	Futures	17160.69	17165.42	17140.94	17146.78	5449.0
2023-08-30 03:00:00	NQ	Futures	17146.51	17160.69	17115.08	17144.84	11894.0
2023-08-30 04:00:00	NQ	Futures	17145.39	17148.73	17107.85	17109.79	9357.0
2023-08-30 05:00:00	NQ	Futures	17109.52	17113.41	17090.05	17103.67	8204.0
2023-08-30 06:00:00	NQ	Futures	17103.4	17131.21	17102.01	17125.37	6366.0
2023-08-30 07:00:00	NQ	Futures	17125.09	17140.39	17112.02	17126.48	8880.0
2023-08-30 08:00:00	NQ	Futures	17125.92	17190.45	17115.08	17164.03	25997.0
2023-08-30 09:00:00	NQ	Futures	17163.19	17218.54	17117.86	17205.19	101551.0
2023-08-30 10:00:00	NQ	Futures	17205.19	17252.2	17105.07	17214.09	126152.0
2023-08-30 11:00:00	NQ	Futures	17214.37	17241.91	17169.59	17239.4	57998.0
2023-08-30 12:00:00	NQ	Futures	17239.12	17269.44	17229.11	17254.7	43642.0
2023-08-30 13:00:00	NQ	Futures	17254.42	17261.93	17205.47	17225.5	36781.0
2023-08-30 14:00:00	NQ	Futures	17225.77	17256.65	17188.5	17251.92	48529.0
2023-08-30 15:00:00	NQ	Futures	17251.92	17266.66	17220.21	17246.08	54377.0
2023-08-30 16:00:00	NQ	Futures	17245.8	17260.54	17235.79	17258.59	11122.0
2023-08-30 18:00:00	NQ	Futures	17259.43	17259.71	17250.53	17251.92	1612.0
2023-08-30 19:00:00	NQ	Futures	17251.92	17255.53	17245.52	17247.19	1748.0
2023-08-30 20:00:00	NQ	Futures	17247.47	17263.88	17247.19	17248.3	4143.0
2023-08-30 21:00:00	NQ	Futures	17248.58	17261.37	17245.52	17251.08	4787.0
2023-08-30 22:00:00	NQ	Futures	17251.08	17279.73	17249.42	17255.81	4914.0
2023-08-30 23:00:00	NQ	Futures	17256.09	17263.32	17250.53	17257.2	2922.0
2023-08-30 00:00:00	YM	Futures	38270.7	38278.4	38260.8	38261.9	461.0
2023-08-30 01:00:00	YM	Futures	38261.9	38274.0	38232.3	38245.5	1177.0
2023-08-30 02:00:00	YM	Futures	38245.5	38245.5	38208.2	38218.1	1412.0
2023-08-30 03:00:00	YM	Futures	38218.1	38255.3	38178.7	38249.9	6089.0

> showing 50 of 2,017 rows — these rows as CSV

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