PREVIEW / futures_1hour / 2023-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-04.parquet
  size:    69 KB
  rows:    2,078

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-10-04 00:00:00	ES	Futures	4615.13	4624.91	4613.51	4623.28	9680.0
2023-10-04 01:00:00	ES	Futures	4623.28	4624.37	4611.33	4614.32	13878.0
2023-10-04 02:00:00	ES	Futures	4614.32	4615.68	4601.28	4601.56	27361.0
2023-10-04 03:00:00	ES	Futures	4601.28	4620.29	4600.74	4619.75	49008.0
2023-10-04 04:00:00	ES	Futures	4619.75	4629.8	4615.41	4625.45	40169.0
2023-10-04 05:00:00	ES	Futures	4625.45	4634.69	4623.55	4633.6	29081.0
2023-10-04 06:00:00	ES	Futures	4633.6	4636.59	4625.73	4630.88	26601.0
2023-10-04 07:00:00	ES	Futures	4630.61	4643.1	4629.26	4640.93	50484.0
2023-10-04 08:00:00	ES	Futures	4640.66	4651.25	4638.76	4643.65	92573.0
2023-10-04 09:00:00	ES	Futures	4643.92	4652.34	4635.77	4643.38	199939.0
2023-10-04 10:00:00	ES	Futures	4642.83	4647.45	4621.11	4626.54	390144.0
2023-10-04 11:00:00	ES	Futures	4626.54	4658.86	4622.74	4658.58	255038.0
2023-10-04 12:00:00	ES	Futures	4658.31	4663.2	4650.98	4655.05	180732.0
2023-10-04 13:00:00	ES	Futures	4655.33	4656.14	4637.67	4639.3	145050.0
2023-10-04 14:00:00	ES	Futures	4639.3	4651.79	4633.06	4650.17	150664.0
2023-10-04 15:00:00	ES	Futures	4650.44	4675.15	4648.54	4666.73	296085.0
2023-10-04 16:00:00	ES	Futures	4666.46	4667.27	4660.48	4660.76	57156.0
2023-10-04 18:00:00	ES	Futures	4661.57	4662.93	4659.13	4660.76	4968.0
2023-10-04 19:00:00	ES	Futures	4661.03	4662.39	4659.94	4661.84	3405.0
2023-10-04 20:00:00	ES	Futures	4661.84	4664.01	4655.6	4663.47	11866.0
2023-10-04 21:00:00	ES	Futures	4663.47	4669.17	4662.11	4669.17	9850.0
2023-10-04 22:00:00	ES	Futures	4668.9	4669.17	4665.37	4667.0	6279.0
2023-10-04 23:00:00	ES	Futures	4667.0	4672.7	4667.0	4671.35	7088.0
2023-10-04 00:00:00	NQ	Futures	16103.29	16140.09	16096.42	16132.4	5564.0
2023-10-04 01:00:00	NQ	Futures	16132.13	16134.87	16079.94	16092.3	6938.0
2023-10-04 02:00:00	NQ	Futures	16092.03	16097.24	16029.68	16031.87	14478.0
2023-10-04 03:00:00	NQ	Futures	16031.05	16100.54	16028.3	16092.85	20811.0
2023-10-04 04:00:00	NQ	Futures	16093.12	16135.7	16075.27	16121.14	17636.0
2023-10-04 05:00:00	NQ	Futures	16121.41	16156.85	16114.27	16149.71	12405.0
2023-10-04 06:00:00	NQ	Futures	16149.16	16171.13	16121.41	16148.33	13104.0
2023-10-04 07:00:00	NQ	Futures	16148.33	16209.31	16142.56	16198.6	22651.0
2023-10-04 08:00:00	NQ	Futures	16197.77	16259.85	16190.36	16233.48	39876.0
2023-10-04 09:00:00	NQ	Futures	16234.03	16298.02	16204.09	16262.04	85753.0
2023-10-04 10:00:00	NQ	Futures	16263.42	16315.05	16188.16	16233.48	150899.0
2023-10-04 11:00:00	NQ	Futures	16233.48	16367.24	16216.17	16364.77	95197.0
2023-10-04 12:00:00	NQ	Futures	16364.49	16368.89	16323.02	16343.89	56981.0
2023-10-04 13:00:00	NQ	Futures	16344.17	16347.19	16277.15	16282.37	50843.0
2023-10-04 14:00:00	NQ	Futures	16282.37	16343.34	16264.51	16337.3	57555.0
2023-10-04 15:00:00	NQ	Futures	16337.85	16431.51	16332.36	16391.68	83305.0
2023-10-04 16:00:00	NQ	Futures	16391.68	16391.96	16371.91	16372.73	15943.0
2023-10-04 18:00:00	NQ	Futures	16373.28	16385.09	16363.94	16378.78	3579.0
2023-10-04 19:00:00	NQ	Futures	16379.05	16388.66	16375.2	16385.64	2812.0
2023-10-04 20:00:00	NQ	Futures	16385.64	16391.68	16357.08	16388.39	7523.0
2023-10-04 21:00:00	NQ	Futures	16388.11	16409.54	16377.68	16407.34	5986.0
2023-10-04 22:00:00	NQ	Futures	16407.89	16408.16	16388.11	16399.1	3699.0
2023-10-04 23:00:00	NQ	Futures	16399.1	16419.97	16393.33	16410.64	4359.0
2023-10-04 00:00:00	YM	Futures	35899.1	35971.8	35887.1	35963.1	1429.0
2023-10-04 01:00:00	YM	Futures	35963.1	35968.5	35888.2	35909.9	1970.0
2023-10-04 02:00:00	YM	Futures	35911.0	35920.8	35827.5	35829.6	4583.0
2023-10-04 03:00:00	YM	Futures	35828.6	35960.9	35821.0	35956.6	8142.0

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

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