PREVIEW / futures_1hour / 2023-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-25.parquet
  size:    67 KB
  rows:    2,062

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-25 00:00:00	ES	Futures	4490.2	4491.88	4489.08	4490.48	2661.0
2023-01-25 01:00:00	ES	Futures	4490.48	4495.79	4490.2	4493.84	5069.0
2023-01-25 02:00:00	ES	Futures	4493.84	4498.31	4492.44	4497.19	7930.0
2023-01-25 03:00:00	ES	Futures	4497.19	4499.71	4490.76	4491.88	16259.0
2023-01-25 04:00:00	ES	Futures	4491.88	4492.44	4478.18	4478.74	18032.0
2023-01-25 05:00:00	ES	Futures	4478.74	4481.25	4469.79	4477.34	22463.0
2023-01-25 06:00:00	ES	Futures	4477.62	4481.25	4470.63	4474.54	16186.0
2023-01-25 07:00:00	ES	Futures	4474.26	4479.02	4472.03	4475.38	22495.0
2023-01-25 08:00:00	ES	Futures	4475.38	4476.22	4459.72	4461.68	36009.0
2023-01-25 09:00:00	ES	Futures	4461.4	4467.55	4440.99	4442.11	221870.0
2023-01-25 10:00:00	ES	Futures	4441.83	4458.61	4432.6	4448.26	333186.0
2023-01-25 11:00:00	ES	Futures	4448.54	4480.14	4445.46	4473.98	239638.0
2023-01-25 12:00:00	ES	Futures	4473.98	4477.06	4466.44	4474.26	102599.0
2023-01-25 13:00:00	ES	Futures	4474.26	4498.59	4472.87	4494.68	139021.0
2023-01-25 14:00:00	ES	Futures	4494.68	4508.1	4490.76	4503.06	161345.0
2023-01-25 15:00:00	ES	Futures	4503.34	4513.69	4497.19	4510.05	223702.0
2023-01-25 16:00:00	ES	Futures	4510.05	4517.88	4502.78	4506.7	66954.0
2023-01-25 18:00:00	ES	Futures	4508.38	4517.32	4505.3	4515.65	11031.0
2023-01-25 19:00:00	ES	Futures	4515.93	4518.44	4512.57	4513.13	6594.0
2023-01-25 20:00:00	ES	Futures	4513.41	4513.69	4508.66	4512.57	7409.0
2023-01-25 21:00:00	ES	Futures	4512.29	4515.09	4511.73	4513.97	4025.0
2023-01-25 22:00:00	ES	Futures	4513.69	4514.81	4512.29	4513.97	2488.0
2023-01-25 23:00:00	ES	Futures	4513.97	4516.76	4513.41	4514.81	3694.0
2023-01-25 00:00:00	NQ	Futures	13449.46	13453.72	13442.06	13452.02	2412.0
2023-01-25 01:00:00	NQ	Futures	13452.3	13472.22	13451.73	13465.67	3292.0
2023-01-25 02:00:00	NQ	Futures	13466.24	13487.29	13458.28	13484.45	3592.0
2023-01-25 03:00:00	NQ	Futures	13485.02	13494.12	13456.28	13463.11	6911.0
2023-01-25 04:00:00	NQ	Futures	13463.11	13467.95	13407.92	13409.91	9648.0
2023-01-25 05:00:00	NQ	Futures	13409.91	13415.6	13374.35	13390.85	12204.0
2023-01-25 06:00:00	NQ	Futures	13391.14	13403.94	13351.59	13365.25	10982.0
2023-01-25 07:00:00	NQ	Futures	13365.82	13392.56	13361.55	13385.16	10388.0
2023-01-25 08:00:00	NQ	Futures	13385.16	13387.15	13317.74	13325.99	17304.0
2023-01-25 09:00:00	NQ	Futures	13325.13	13341.92	13225.56	13228.12	89270.0
2023-01-25 10:00:00	NQ	Futures	13228.4	13282.46	13205.65	13276.2	98990.0
2023-01-25 11:00:00	NQ	Futures	13276.77	13415.32	13266.53	13388.58	89152.0
2023-01-25 12:00:00	NQ	Futures	13388.86	13398.25	13351.31	13375.49	40943.0
2023-01-25 13:00:00	NQ	Futures	13376.06	13469.37	13373.5	13448.32	48742.0
2023-01-25 14:00:00	NQ	Futures	13448.32	13513.47	13435.8	13495.54	51401.0
2023-01-25 15:00:00	NQ	Futures	13495.26	13545.9	13468.8	13514.89	65960.0
2023-01-25 16:00:00	NQ	Futures	13514.61	13561.26	13480.47	13511.76	23945.0
2023-01-25 18:00:00	NQ	Futures	13513.18	13559.84	13504.65	13550.17	7580.0
2023-01-25 19:00:00	NQ	Futures	13550.45	13567.81	13538.79	13541.06	4119.0
2023-01-25 20:00:00	NQ	Futures	13541.06	13548.18	13518.3	13543.06	5134.0
2023-01-25 21:00:00	NQ	Futures	13543.06	13556.14	13540.49	13551.02	3181.0
2023-01-25 22:00:00	NQ	Futures	13551.59	13557.28	13544.48	13553.3	2302.0
2023-01-25 23:00:00	NQ	Futures	13554.15	13567.24	13553.3	13560.41	2603.0
2023-01-25 00:00:00	YM	Futures	37591.4	37600.3	37579.1	37588.0	549.0
2023-01-25 01:00:00	YM	Futures	37589.2	37617.0	37583.6	37605.9	858.0
2023-01-25 02:00:00	YM	Futures	37605.9	37643.7	37597.0	37629.3	1556.0
2023-01-25 03:00:00	YM	Futures	37628.1	37646.0	37586.9	37591.4	2713.0

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

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