PREVIEW / futures_1hour / 2023-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-31.parquet
  size:    69 KB
  rows:    2,102

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-01-31 00:00:00	ES	Futures	4507.82	4510.33	4504.18	4504.46	6754.0
2023-01-31 01:00:00	ES	Futures	4504.74	4509.77	4504.74	4508.94	6555.0
2023-01-31 02:00:00	ES	Futures	4508.66	4520.12	4506.14	4518.72	16626.0
2023-01-31 03:00:00	ES	Futures	4518.72	4520.12	4496.63	4499.99	26552.0
2023-01-31 04:00:00	ES	Futures	4499.99	4501.39	4493.56	4496.63	17225.0
2023-01-31 05:00:00	ES	Futures	4496.63	4496.91	4487.69	4487.96	17274.0
2023-01-31 06:00:00	ES	Futures	4487.96	4495.51	4482.09	4494.4	26240.0
2023-01-31 07:00:00	ES	Futures	4494.12	4504.18	4493.84	4501.39	26449.0
2023-01-31 08:00:00	ES	Futures	4501.67	4527.95	4501.11	4522.08	95195.0
2023-01-31 09:00:00	ES	Futures	4522.36	4529.07	4512.57	4516.21	193985.0
2023-01-31 10:00:00	ES	Futures	4516.21	4540.25	4510.89	4535.78	284511.0
2023-01-31 11:00:00	ES	Futures	4535.78	4542.49	4533.26	4537.18	137300.0
2023-01-31 12:00:00	ES	Futures	4537.18	4546.4	4530.74	4544.17	120966.0
2023-01-31 13:00:00	ES	Futures	4544.45	4551.16	4539.69	4550.32	86903.0
2023-01-31 14:00:00	ES	Futures	4550.32	4556.19	4548.92	4553.39	103086.0
2023-01-31 15:00:00	ES	Futures	4553.67	4575.76	4543.61	4574.64	384787.0
2023-01-31 16:00:00	ES	Futures	4574.92	4575.2	4566.53	4569.61	106377.0
2023-01-31 18:00:00	ES	Futures	4569.61	4569.89	4561.78	4564.3	8709.0
2023-01-31 19:00:00	ES	Futures	4564.3	4569.61	4558.15	4558.71	11088.0
2023-01-31 20:00:00	ES	Futures	4558.98	4562.9	4557.87	4560.94	8159.0
2023-01-31 21:00:00	ES	Futures	4560.94	4561.22	4558.43	4558.71	4288.0
2023-01-31 22:00:00	ES	Futures	4558.71	4564.3	4558.71	4562.34	5163.0
2023-01-31 23:00:00	ES	Futures	4562.34	4565.98	4561.78	4562.9	4972.0
2023-01-31 00:00:00	NQ	Futures	13585.16	13599.39	13572.36	13574.63	3747.0
2023-01-31 01:00:00	NQ	Futures	13575.49	13595.4	13571.5	13589.43	3216.0
2023-01-31 02:00:00	NQ	Futures	13588.86	13635.52	13577.76	13630.11	7070.0
2023-01-31 03:00:00	NQ	Futures	13630.4	13634.38	13549.88	13566.67	13058.0
2023-01-31 04:00:00	NQ	Futures	13567.52	13578.05	13549.88	13561.26	9050.0
2023-01-31 05:00:00	NQ	Futures	13560.69	13562.69	13523.71	13526.27	9905.0
2023-01-31 06:00:00	NQ	Futures	13525.42	13557.85	13508.92	13556.14	12125.0
2023-01-31 07:00:00	NQ	Futures	13555.29	13586.3	13547.89	13576.63	11023.0
2023-01-31 08:00:00	NQ	Futures	13577.19	13675.35	13566.1	13657.14	37367.0
2023-01-31 09:00:00	NQ	Futures	13657.42	13718.59	13620.44	13650.03	81285.0
2023-01-31 10:00:00	NQ	Futures	13651.73	13751.02	13629.54	13739.93	86465.0
2023-01-31 11:00:00	NQ	Futures	13740.21	13765.25	13724.28	13732.53	49288.0
2023-01-31 12:00:00	NQ	Futures	13732.81	13763.82	13703.23	13753.87	41315.0
2023-01-31 13:00:00	NQ	Futures	13754.15	13770.94	13723.71	13764.11	33399.0
2023-01-31 14:00:00	NQ	Futures	13764.11	13791.13	13756.14	13782.31	38868.0
2023-01-31 15:00:00	NQ	Futures	13782.6	13833.24	13737.93	13830.39	89502.0
2023-01-31 16:00:00	NQ	Futures	13830.39	13831.82	13779.75	13791.42	24998.0
2023-01-31 18:00:00	NQ	Futures	13787.72	13791.42	13764.39	13773.21	4120.0
2023-01-31 19:00:00	NQ	Futures	13772.93	13795.4	13754.43	13756.43	4915.0
2023-01-31 20:00:00	NQ	Futures	13755.86	13773.21	13752.16	13762.97	2933.0
2023-01-31 21:00:00	NQ	Futures	13762.97	13763.82	13752.73	13755.57	1882.0
2023-01-31 22:00:00	NQ	Futures	13755.86	13779.19	13754.72	13774.63	2641.0
2023-01-31 23:00:00	NQ	Futures	13774.06	13791.13	13771.79	13777.48	2822.0
2023-01-31 00:00:00	YM	Futures	37624.8	37643.7	37598.1	37598.1	728.0
2023-01-31 01:00:00	YM	Futures	37601.4	37637.1	37601.4	37630.4	669.0
2023-01-31 02:00:00	YM	Futures	37630.4	37712.8	37621.5	37698.3	2075.0
2023-01-31 03:00:00	YM	Futures	37699.5	37708.4	37530.1	37546.8	3544.0

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

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