PREVIEW / futures_1hour / 2023-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-23.parquet
  size:    66 KB
  rows:    2,036

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-23 00:00:00	ES	Futures	4457.21	4460.0	4455.53	4457.49	4361.0
2023-01-23 01:00:00	ES	Futures	4457.49	4461.96	4455.53	4460.0	5270.0
2023-01-23 02:00:00	ES	Futures	4460.0	4465.6	4455.81	4461.12	11163.0
2023-01-23 03:00:00	ES	Futures	4461.12	4468.11	4454.69	4456.93	19903.0
2023-01-23 04:00:00	ES	Futures	4456.93	4460.84	4454.13	4459.17	10263.0
2023-01-23 05:00:00	ES	Futures	4459.17	4460.84	4452.18	4457.21	8647.0
2023-01-23 06:00:00	ES	Futures	4456.93	4458.05	4451.62	4454.13	9571.0
2023-01-23 07:00:00	ES	Futures	4454.41	4465.88	4454.41	4460.0	16888.0
2023-01-23 08:00:00	ES	Futures	4460.0	4473.7	4460.0	4467.83	43362.0
2023-01-23 09:00:00	ES	Futures	4467.83	4487.69	4458.33	4482.93	182787.0
2023-01-23 10:00:00	ES	Futures	4482.93	4510.33	4479.86	4505.58	243355.0
2023-01-23 11:00:00	ES	Futures	4505.86	4530.74	4505.58	4524.31	233962.0
2023-01-23 12:00:00	ES	Futures	4524.59	4525.71	4511.17	4524.03	115357.0
2023-01-23 13:00:00	ES	Futures	4524.03	4537.18	4522.92	4529.91	112328.0
2023-01-23 14:00:00	ES	Futures	4529.91	4529.91	4492.44	4501.67	188998.0
2023-01-23 15:00:00	ES	Futures	4501.95	4518.16	4496.35	4513.41	241195.0
2023-01-23 16:00:00	ES	Futures	4513.69	4515.37	4508.1	4515.09	47707.0
2023-01-23 18:00:00	ES	Futures	4514.53	4515.37	4508.38	4510.05	4762.0
2023-01-23 19:00:00	ES	Futures	4510.05	4512.29	4508.94	4511.45	4020.0
2023-01-23 20:00:00	ES	Futures	4511.45	4515.65	4509.49	4513.97	4808.0
2023-01-23 21:00:00	ES	Futures	4513.97	4517.04	4512.57	4513.69	3557.0
2023-01-23 22:00:00	ES	Futures	4513.69	4514.53	4512.29	4512.85	1990.0
2023-01-23 23:00:00	ES	Futures	4512.85	4515.09	4512.01	4515.09	2597.0
2023-01-23 00:00:00	NQ	Futures	13276.77	13290.14	13269.94	13278.48	2172.0
2023-01-23 01:00:00	NQ	Futures	13277.62	13294.69	13273.07	13290.71	2333.0
2023-01-23 02:00:00	NQ	Futures	13290.99	13307.78	13277.34	13292.42	5046.0
2023-01-23 03:00:00	NQ	Futures	13291.85	13321.43	13263.4	13272.5	10746.0
2023-01-23 04:00:00	NQ	Futures	13272.5	13294.98	13261.12	13290.14	5575.0
2023-01-23 05:00:00	NQ	Futures	13290.14	13298.96	13261.69	13278.19	5272.0
2023-01-23 06:00:00	NQ	Futures	13278.76	13284.17	13259.7	13268.23	4447.0
2023-01-23 07:00:00	NQ	Futures	13268.52	13317.74	13268.52	13296.97	8181.0
2023-01-23 08:00:00	NQ	Futures	13297.25	13340.78	13296.68	13310.62	16551.0
2023-01-23 09:00:00	NQ	Futures	13311.19	13452.59	13282.17	13429.26	85545.0
2023-01-23 10:00:00	NQ	Futures	13429.26	13523.14	13418.73	13507.21	94972.0
2023-01-23 11:00:00	NQ	Futures	13507.21	13606.78	13507.21	13593.98	81460.0
2023-01-23 12:00:00	NQ	Futures	13594.26	13595.69	13550.74	13590.0	41013.0
2023-01-23 13:00:00	NQ	Futures	13590.28	13636.37	13585.73	13608.2	51403.0
2023-01-23 14:00:00	NQ	Futures	13608.49	13610.2	13497.82	13531.96	67288.0
2023-01-23 15:00:00	NQ	Futures	13532.24	13588.86	13505.22	13577.76	76753.0
2023-01-23 16:00:00	NQ	Futures	13578.05	13583.74	13557.85	13582.32	13183.0
2023-01-23 18:00:00	NQ	Futures	13579.47	13582.88	13560.12	13562.69	2920.0
2023-01-23 19:00:00	NQ	Futures	13562.97	13570.37	13558.7	13565.53	2145.0
2023-01-23 20:00:00	NQ	Futures	13566.95	13577.19	13555.86	13571.22	2995.0
2023-01-23 21:00:00	NQ	Futures	13572.07	13584.59	13570.65	13575.2	2174.0
2023-01-23 22:00:00	NQ	Futures	13574.63	13577.48	13569.51	13571.5	1131.0
2023-01-23 23:00:00	NQ	Futures	13570.94	13576.06	13565.81	13576.06	1412.0
2023-01-23 00:00:00	YM	Futures	37281.6	37300.6	37269.4	37280.5	1115.0
2023-01-23 01:00:00	YM	Futures	37280.5	37307.3	37266.0	37296.1	1110.0
2023-01-23 02:00:00	YM	Futures	37295.0	37332.9	37267.2	37310.6	2548.0
2023-01-23 03:00:00	YM	Futures	37310.6	37363.0	37277.2	37293.9	3608.0

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

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