PREVIEW / futures_1hour / 2023-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-31.parquet
  size:    66 KB
  rows:    2,046

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-07-31 00:00:00	ES	Futures	5048.81	5049.91	5045.79	5048.81	5177.0
2023-07-31 01:00:00	ES	Futures	5048.81	5054.3	5047.17	5052.66	7404.0
2023-07-31 02:00:00	ES	Futures	5052.93	5058.97	5051.01	5054.3	10475.0
2023-07-31 03:00:00	ES	Futures	5054.03	5060.34	5051.83	5054.85	18812.0
2023-07-31 04:00:00	ES	Futures	5055.13	5063.09	5055.13	5062.81	13556.0
2023-07-31 05:00:00	ES	Futures	5062.54	5064.19	5058.42	5060.07	10443.0
2023-07-31 06:00:00	ES	Futures	5060.07	5063.64	5058.7	5063.64	8913.0
2023-07-31 07:00:00	ES	Futures	5063.36	5066.66	5062.81	5066.66	13951.0
2023-07-31 08:00:00	ES	Futures	5066.66	5071.6	5064.46	5070.23	24310.0
2023-07-31 09:00:00	ES	Futures	5070.23	5072.15	5052.93	5058.97	185685.0
2023-07-31 10:00:00	ES	Futures	5058.7	5068.3	5055.13	5064.74	145169.0
2023-07-31 11:00:00	ES	Futures	5065.01	5068.58	5055.4	5058.15	117290.0
2023-07-31 12:00:00	ES	Futures	5058.42	5061.72	5053.48	5054.85	67935.0
2023-07-31 13:00:00	ES	Futures	5054.85	5061.17	5050.46	5057.87	80800.0
2023-07-31 14:00:00	ES	Futures	5057.87	5061.17	5053.48	5059.79	69350.0
2023-07-31 15:00:00	ES	Futures	5059.79	5069.13	5048.54	5068.58	278757.0
2023-07-31 16:00:00	ES	Futures	5068.58	5071.32	5066.66	5069.95	114370.0
2023-07-31 18:00:00	ES	Futures	5070.5	5071.87	5067.48	5068.03	4367.0
2023-07-31 19:00:00	ES	Futures	5068.03	5068.85	5066.93	5068.03	2709.0
2023-07-31 20:00:00	ES	Futures	5068.3	5071.87	5067.48	5071.87	6521.0
2023-07-31 21:00:00	ES	Futures	5071.87	5074.89	5069.95	5073.52	9677.0
2023-07-31 22:00:00	ES	Futures	5073.52	5073.52	5070.23	5070.77	5419.0
2023-07-31 23:00:00	ES	Futures	5070.77	5071.6	5069.4	5069.95	3652.0
2023-07-31 00:00:00	NQ	Futures	17585.4	17591.24	17568.15	17582.89	3903.0
2023-07-31 01:00:00	NQ	Futures	17582.89	17610.43	17574.55	17602.36	4627.0
2023-07-31 02:00:00	NQ	Futures	17602.36	17626.84	17594.58	17605.42	4999.0
2023-07-31 03:00:00	NQ	Futures	17604.87	17619.33	17585.68	17601.53	6603.0
2023-07-31 04:00:00	NQ	Futures	17602.09	17643.81	17601.25	17640.19	6817.0
2023-07-31 05:00:00	NQ	Futures	17640.47	17648.26	17614.88	17621.28	5147.0
2023-07-31 06:00:00	NQ	Futures	17621.83	17635.74	17614.88	17634.35	3925.0
2023-07-31 07:00:00	NQ	Futures	17633.79	17659.94	17632.12	17659.38	6692.0
2023-07-31 08:00:00	NQ	Futures	17659.1	17683.86	17647.98	17673.29	12076.0
2023-07-31 09:00:00	NQ	Futures	17673.57	17694.7	17583.73	17609.04	98295.0
2023-07-31 10:00:00	NQ	Futures	17608.76	17660.21	17585.95	17645.2	75854.0
2023-07-31 11:00:00	NQ	Futures	17645.47	17666.61	17601.53	17627.95	53842.0
2023-07-31 12:00:00	NQ	Futures	17628.79	17647.98	17604.87	17607.93	34114.0
2023-07-31 13:00:00	NQ	Futures	17607.93	17641.02	17588.18	17621.55	38771.0
2023-07-31 14:00:00	NQ	Futures	17621.0	17642.97	17600.69	17634.9	35489.0
2023-07-31 15:00:00	NQ	Futures	17634.35	17648.81	17578.17	17648.26	66882.0
2023-07-31 16:00:00	NQ	Futures	17647.98	17662.72	17640.47	17654.65	14536.0
2023-07-31 18:00:00	NQ	Futures	17654.93	17664.11	17641.86	17645.75	2518.0
2023-07-31 19:00:00	NQ	Futures	17646.03	17647.42	17635.74	17644.92	1935.0
2023-07-31 20:00:00	NQ	Futures	17644.92	17661.05	17638.52	17660.77	3810.0
2023-07-31 21:00:00	NQ	Futures	17660.77	17677.18	17654.93	17669.12	4216.0
2023-07-31 22:00:00	NQ	Futures	17669.67	17671.9	17654.65	17656.6	2688.0
2023-07-31 23:00:00	NQ	Futures	17656.04	17659.66	17646.86	17652.15	2059.0
2023-07-31 00:00:00	YM	Futures	38923.6	38934.6	38903.9	38929.1	999.0
2023-07-31 01:00:00	YM	Futures	38930.2	38956.5	38920.3	38946.6	1210.0
2023-07-31 02:00:00	YM	Futures	38946.6	38986.1	38936.8	38972.9	2032.0
2023-07-31 03:00:00	YM	Futures	38974.0	39023.3	38962.0	38990.5	2846.0

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

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