PREVIEW / futures_1hour / 2023-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-26.parquet
  size:    68 KB
  rows:    2,097

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-26 00:00:00	ES	Futures	4543.71	4544.53	4539.64	4541.81	6806.0
2023-10-26 01:00:00	ES	Futures	4541.54	4545.62	4539.91	4540.73	9623.0
2023-10-26 02:00:00	ES	Futures	4540.46	4545.34	4537.74	4541.27	14449.0
2023-10-26 03:00:00	ES	Futures	4541.27	4544.53	4530.68	4540.73	43928.0
2023-10-26 04:00:00	ES	Futures	4540.46	4547.24	4538.83	4543.17	22909.0
2023-10-26 05:00:00	ES	Futures	4543.17	4550.5	4539.1	4545.34	20253.0
2023-10-26 06:00:00	ES	Futures	4545.07	4550.78	4540.18	4541.0	16193.0
2023-10-26 07:00:00	ES	Futures	4541.0	4541.27	4531.22	4539.64	35439.0
2023-10-26 08:00:00	ES	Futures	4539.64	4561.64	4535.84	4559.74	103785.0
2023-10-26 09:00:00	ES	Futures	4560.01	4567.61	4545.07	4546.7	290704.0
2023-10-26 10:00:00	ES	Futures	4546.43	4562.72	4534.75	4557.02	332917.0
2023-10-26 11:00:00	ES	Futures	4557.02	4559.74	4529.87	4536.65	238223.0
2023-10-26 12:00:00	ES	Futures	4536.65	4536.65	4510.86	4511.13	246377.0
2023-10-26 13:00:00	ES	Futures	4511.13	4527.96	4503.8	4526.88	210105.0
2023-10-26 14:00:00	ES	Futures	4526.88	4548.33	4523.89	4548.06	206739.0
2023-10-26 15:00:00	ES	Futures	4548.06	4552.68	4512.49	4515.2	333809.0
2023-10-26 16:00:00	ES	Futures	4515.2	4527.42	4507.6	4519.27	116943.0
2023-10-26 18:00:00	ES	Futures	4526.33	4536.11	4526.06	4534.75	14562.0
2023-10-26 19:00:00	ES	Futures	4534.48	4541.27	4534.48	4540.46	10898.0
2023-10-26 20:00:00	ES	Futures	4540.18	4540.18	4529.87	4532.58	11889.0
2023-10-26 21:00:00	ES	Futures	4532.31	4540.46	4531.49	4538.55	9311.0
2023-10-26 22:00:00	ES	Futures	4538.55	4542.9	4538.55	4539.1	9572.0
2023-10-26 23:00:00	ES	Futures	4539.1	4540.18	4535.3	4539.64	5293.0
2023-10-26 00:00:00	NQ	Futures	15734.14	15739.63	15720.13	15728.37	3595.0
2023-10-26 01:00:00	NQ	Futures	15727.82	15743.75	15720.95	15724.8	5313.0
2023-10-26 02:00:00	NQ	Futures	15724.52	15739.63	15711.07	15720.68	8194.0
2023-10-26 03:00:00	NQ	Futures	15719.86	15722.33	15663.55	15712.99	23042.0
2023-10-26 04:00:00	NQ	Futures	15712.71	15756.94	15706.12	15745.4	14503.0
2023-10-26 05:00:00	NQ	Futures	15745.12	15773.42	15723.43	15752.27	12147.0
2023-10-26 06:00:00	NQ	Futures	15752.54	15784.4	15739.08	15750.07	10160.0
2023-10-26 07:00:00	NQ	Futures	15750.34	15751.44	15713.54	15745.12	16350.0
2023-10-26 08:00:00	NQ	Futures	15745.95	15835.76	15736.06	15825.33	39715.0
2023-10-26 09:00:00	NQ	Futures	15825.88	15885.48	15725.62	15744.3	136604.0
2023-10-26 10:00:00	NQ	Futures	15744.3	15804.18	15674.54	15769.3	144440.0
2023-10-26 11:00:00	NQ	Futures	15769.02	15774.51	15631.14	15674.54	105167.0
2023-10-26 12:00:00	NQ	Futures	15674.26	15681.68	15539.4	15547.37	95730.0
2023-10-26 13:00:00	NQ	Futures	15547.92	15633.06	15535.28	15627.02	83680.0
2023-10-26 14:00:00	NQ	Futures	15627.57	15731.94	15614.11	15730.57	76131.0
2023-10-26 15:00:00	NQ	Futures	15730.57	15746.5	15577.03	15594.88	107332.0
2023-10-26 16:00:00	NQ	Futures	15595.16	15664.37	15578.13	15611.36	39373.0
2023-10-26 18:00:00	NQ	Futures	15653.94	15713.54	15652.01	15699.26	8046.0
2023-10-26 19:00:00	NQ	Futures	15698.98	15730.57	15697.88	15727.55	5376.0
2023-10-26 20:00:00	NQ	Futures	15727.0	15727.0	15677.01	15689.92	6514.0
2023-10-26 21:00:00	NQ	Futures	15689.37	15718.48	15686.07	15709.69	5035.0
2023-10-26 22:00:00	NQ	Futures	15709.97	15731.12	15709.69	15714.91	4083.0
2023-10-26 23:00:00	NQ	Futures	15714.91	15719.31	15698.98	15717.93	2869.0
2023-10-26 00:00:00	YM	Futures	35887.1	35889.3	35860.0	35873.0	1081.0
2023-10-26 01:00:00	YM	Futures	35874.1	35899.1	35862.2	35866.5	1355.0
2023-10-26 02:00:00	YM	Futures	35866.5	35895.8	35841.6	35864.4	2104.0
2023-10-26 03:00:00	YM	Futures	35862.2	35888.2	35801.4	35861.1	6043.0

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

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