PREVIEW / futures_1hour / 2023-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-27.parquet
  size:    57 KB
  rows:    1,677

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-27 00:00:00	ES	Futures	4539.37	4543.44	4538.83	4542.9	5496.0
2023-10-27 01:00:00	ES	Futures	4542.9	4543.71	4539.91	4543.44	8955.0
2023-10-27 02:00:00	ES	Futures	4543.17	4543.71	4537.74	4537.74	9977.0
2023-10-27 03:00:00	ES	Futures	4537.74	4538.55	4531.22	4536.65	23585.0
2023-10-27 04:00:00	ES	Futures	4536.38	4545.34	4535.3	4544.8	22029.0
2023-10-27 05:00:00	ES	Futures	4544.8	4545.89	4535.57	4538.28	20112.0
2023-10-27 06:00:00	ES	Futures	4538.28	4541.27	4532.58	4533.12	15231.0
2023-10-27 07:00:00	ES	Futures	4532.85	4535.02	4520.36	4521.45	34576.0
2023-10-27 08:00:00	ES	Futures	4521.72	4538.83	4519.55	4533.12	73088.0
2023-10-27 09:00:00	ES	Futures	4533.4	4538.83	4514.93	4522.53	263749.0
2023-10-27 10:00:00	ES	Futures	4522.53	4532.31	4506.78	4524.98	362982.0
2023-10-27 11:00:00	ES	Futures	4524.98	4536.93	4516.83	4524.16	212621.0
2023-10-27 12:00:00	ES	Futures	4524.43	4525.79	4504.61	4505.97	165343.0
2023-10-27 13:00:00	ES	Futures	4506.24	4508.68	4487.5	4490.49	224088.0
2023-10-27 14:00:00	ES	Futures	4490.49	4499.72	4478.27	4481.53	212329.0
2023-10-27 15:00:00	ES	Futures	4481.53	4497.01	4477.73	4494.83	334190.0
2023-10-27 16:00:00	ES	Futures	4494.83	4498.64	4492.66	4493.2	73732.0
2023-10-27 00:00:00	NQ	Futures	15717.93	15736.06	15713.54	15732.49	2951.0
2023-10-27 01:00:00	NQ	Futures	15732.22	15738.81	15719.31	15738.26	4529.0
2023-10-27 02:00:00	NQ	Futures	15737.43	15738.81	15712.99	15713.54	4952.0
2023-10-27 03:00:00	NQ	Futures	15712.99	15726.45	15684.42	15719.58	11245.0
2023-10-27 04:00:00	NQ	Futures	15718.76	15757.48	15709.42	15754.19	11988.0
2023-10-27 05:00:00	NQ	Futures	15754.19	15758.58	15726.45	15742.1	9043.0
2023-10-27 06:00:00	NQ	Futures	15742.38	15754.74	15722.05	15724.52	8162.0
2023-10-27 07:00:00	NQ	Futures	15724.25	15733.86	15684.97	15689.92	14209.0
2023-10-27 08:00:00	NQ	Futures	15689.64	15748.7	15677.83	15725.62	32167.0
2023-10-27 09:00:00	NQ	Futures	15726.17	15773.42	15700.9	15740.73	105279.0
2023-10-27 10:00:00	NQ	Futures	15741.0	15787.15	15682.23	15751.17	136685.0
2023-10-27 11:00:00	NQ	Futures	15750.89	15829.17	15738.53	15791.27	91742.0
2023-10-27 12:00:00	NQ	Futures	15790.99	15804.18	15705.02	15715.19	60327.0
2023-10-27 13:00:00	NQ	Futures	15715.74	15724.25	15632.51	15648.17	76716.0
2023-10-27 14:00:00	NQ	Futures	15648.44	15694.04	15614.38	15629.49	72158.0
2023-10-27 15:00:00	NQ	Futures	15629.77	15680.85	15611.64	15673.16	83707.0
2023-10-27 16:00:00	NQ	Futures	15673.16	15692.66	15669.87	15677.83	16938.0
2023-10-27 00:00:00	YM	Futures	35771.1	35798.2	35764.6	35794.9	727.0
2023-10-27 01:00:00	YM	Futures	35794.9	35797.1	35775.4	35787.3	1095.0
2023-10-27 02:00:00	YM	Futures	35786.3	35787.3	35746.1	35746.1	2127.0
2023-10-27 03:00:00	YM	Futures	35745.0	35751.5	35690.8	35729.8	4919.0
2023-10-27 04:00:00	YM	Futures	35727.7	35797.1	35721.2	35791.7	4207.0
2023-10-27 05:00:00	YM	Futures	35790.6	35806.9	35726.6	35734.2	3464.0
2023-10-27 06:00:00	YM	Futures	35736.4	35757.0	35676.7	35676.7	2504.0
2023-10-27 07:00:00	YM	Futures	35674.5	35690.8	35562.8	35575.8	6445.0
2023-10-27 08:00:00	YM	Futures	35576.9	35709.2	35571.5	35669.1	8997.0
2023-10-27 09:00:00	YM	Futures	35669.1	35716.8	35541.1	35597.5	33010.0
2023-10-27 10:00:00	YM	Futures	35592.1	35649.6	35457.6	35573.6	35008.0
2023-10-27 11:00:00	YM	Futures	35573.6	35630.0	35473.8	35522.6	20633.0
2023-10-27 12:00:00	YM	Futures	35520.5	35525.9	35407.7	35417.4	16143.0
2023-10-27 13:00:00	YM	Futures	35418.5	35442.4	35285.1	35300.3	24159.0
2023-10-27 14:00:00	YM	Futures	35297.0	35332.8	35162.5	35184.2	24292.0
2023-10-27 15:00:00	YM	Futures	35186.4	35277.5	35157.1	35264.5	31277.0

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

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