PREVIEW / futures_1hour / 2023-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-05.parquet
  size:    68 KB
  rows:    2,051

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-04-05 00:00:00	ES	Futures	4582.99	4582.99	4580.21	4581.32	4076.0
2023-04-05 01:00:00	ES	Futures	4581.6	4582.16	4578.83	4579.94	4918.0
2023-04-05 02:00:00	ES	Futures	4580.21	4583.54	4575.5	4582.71	9438.0
2023-04-05 03:00:00	ES	Futures	4582.71	4584.1	4571.34	4575.22	22146.0
2023-04-05 04:00:00	ES	Futures	4575.5	4575.5	4568.29	4570.78	18455.0
2023-04-05 05:00:00	ES	Futures	4570.51	4575.22	4568.29	4569.95	15360.0
2023-04-05 06:00:00	ES	Futures	4569.95	4575.78	4568.57	4575.5	11523.0
2023-04-05 07:00:00	ES	Futures	4575.22	4579.38	4573.28	4574.67	15175.0
2023-04-05 08:00:00	ES	Futures	4574.67	4579.94	4567.46	4571.06	43387.0
2023-04-05 09:00:00	ES	Futures	4571.06	4578.83	4569.12	4575.5	148888.0
2023-04-05 10:00:00	ES	Futures	4575.78	4579.38	4551.37	4552.76	307928.0
2023-04-05 11:00:00	ES	Futures	4552.76	4564.96	4550.54	4561.08	176246.0
2023-04-05 12:00:00	ES	Futures	4561.08	4561.63	4547.49	4550.54	138211.0
2023-04-05 13:00:00	ES	Futures	4550.81	4562.74	4548.6	4561.91	124790.0
2023-04-05 14:00:00	ES	Futures	4561.91	4568.84	4560.52	4566.07	140766.0
2023-04-05 15:00:00	ES	Futures	4566.07	4570.23	4558.58	4567.73	171096.0
2023-04-05 16:00:00	ES	Futures	4567.46	4568.57	4564.68	4564.68	44255.0
2023-04-05 18:00:00	ES	Futures	4563.85	4565.79	4560.8	4564.96	5061.0
2023-04-05 19:00:00	ES	Futures	4564.68	4565.24	4562.74	4563.57	2662.0
2023-04-05 20:00:00	ES	Futures	4563.3	4564.96	4558.58	4560.52	7218.0
2023-04-05 21:00:00	ES	Futures	4560.52	4560.8	4555.53	4558.58	9550.0
2023-04-05 22:00:00	ES	Futures	4558.58	4560.24	4557.19	4557.75	4453.0
2023-04-05 23:00:00	ES	Futures	4557.75	4559.14	4555.53	4556.08	3992.0
2023-04-05 00:00:00	NQ	Futures	14895.28	14896.13	14880.36	14887.12	3523.0
2023-04-05 01:00:00	NQ	Futures	14886.83	14889.93	14879.8	14887.4	2973.0
2023-04-05 02:00:00	NQ	Futures	14887.68	14901.19	14868.53	14897.25	5467.0
2023-04-05 03:00:00	NQ	Futures	14896.97	14899.79	14858.68	14866.0	9307.0
2023-04-05 04:00:00	NQ	Futures	14866.84	14867.97	14839.53	14850.23	8941.0
2023-04-05 05:00:00	NQ	Futures	14850.51	14866.28	14847.7	14855.02	5525.0
2023-04-05 06:00:00	NQ	Futures	14854.74	14873.32	14851.08	14870.5	4710.0
2023-04-05 07:00:00	NQ	Futures	14870.22	14890.21	14865.15	14875.85	8228.0
2023-04-05 08:00:00	NQ	Futures	14875.85	14906.54	14855.02	14866.28	22199.0
2023-04-05 09:00:00	NQ	Futures	14866.56	14875.01	14775.9	14795.61	76650.0
2023-04-05 10:00:00	NQ	Futures	14795.61	14826.58	14671.45	14672.57	118158.0
2023-04-05 11:00:00	NQ	Futures	14672.85	14713.4	14662.72	14695.94	75120.0
2023-04-05 12:00:00	NQ	Futures	14696.5	14699.04	14647.51	14664.97	53040.0
2023-04-05 13:00:00	NQ	Futures	14665.53	14709.17	14656.24	14705.51	48106.0
2023-04-05 14:00:00	NQ	Futures	14705.51	14742.12	14698.19	14726.63	51975.0
2023-04-05 15:00:00	NQ	Futures	14726.63	14745.21	14687.78	14730.29	62200.0
2023-04-05 16:00:00	NQ	Futures	14730.29	14734.23	14714.24	14722.41	11955.0
2023-04-05 18:00:00	NQ	Futures	14722.69	14722.69	14704.11	14713.12	2738.0
2023-04-05 19:00:00	NQ	Futures	14712.27	14714.24	14700.45	14705.23	1936.0
2023-04-05 20:00:00	NQ	Futures	14704.67	14710.86	14680.74	14688.9	5242.0
2023-04-05 21:00:00	NQ	Futures	14689.18	14689.47	14660.75	14675.39	6389.0
2023-04-05 22:00:00	NQ	Futures	14675.11	14682.15	14669.19	14674.26	3241.0
2023-04-05 23:00:00	NQ	Futures	14673.98	14681.3	14666.1	14670.04	2781.0
2023-04-05 00:00:00	YM	Futures	37135.0	37137.3	37119.6	37125.1	889.0
2023-04-05 01:00:00	YM	Futures	37126.2	37128.4	37107.4	37114.0	1081.0
2023-04-05 02:00:00	YM	Futures	37115.2	37136.2	37077.6	37126.2	2077.0
2023-04-05 03:00:00	YM	Futures	37127.3	37149.4	37046.6	37080.9	3385.0

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

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