PREVIEW / futures_1hour / 2023-10-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	4629.26	4630.34	4628.17	4630.07	3340.0
2023-10-25 01:00:00	ES	Futures	4630.07	4631.16	4622.47	4624.64	8769.0
2023-10-25 02:00:00	ES	Futures	4624.91	4628.17	4620.84	4621.11	10813.0
2023-10-25 03:00:00	ES	Futures	4621.11	4622.47	4611.88	4619.48	30318.0
2023-10-25 04:00:00	ES	Futures	4619.75	4626.27	4615.95	4623.82	23433.0
2023-10-25 05:00:00	ES	Futures	4623.82	4625.73	4617.04	4620.29	15241.0
2023-10-25 06:00:00	ES	Futures	4620.29	4626.0	4614.59	4625.73	13707.0
2023-10-25 07:00:00	ES	Futures	4625.73	4629.53	4624.1	4625.73	20359.0
2023-10-25 08:00:00	ES	Futures	4625.45	4631.97	4620.02	4620.29	39224.0
2023-10-25 09:00:00	ES	Futures	4620.29	4624.1	4593.68	4601.01	248782.0
2023-10-25 10:00:00	ES	Futures	4601.28	4611.6	4588.52	4600.74	306174.0
2023-10-25 11:00:00	ES	Futures	4600.74	4615.13	4593.68	4593.95	246464.0
2023-10-25 12:00:00	ES	Futures	4593.95	4596.67	4580.92	4583.63	176755.0
2023-10-25 13:00:00	ES	Futures	4583.63	4586.62	4566.25	4573.86	230120.0
2023-10-25 14:00:00	ES	Futures	4573.86	4580.65	4567.34	4573.59	145320.0
2023-10-25 15:00:00	ES	Futures	4573.59	4582.28	4568.43	4573.31	265253.0
2023-10-25 16:00:00	ES	Futures	4573.04	4587.44	4572.5	4574.13	87931.0
2023-10-25 18:00:00	ES	Futures	4564.35	4567.07	4552.13	4556.48	24926.0
2023-10-25 19:00:00	ES	Futures	4556.48	4557.56	4547.52	4552.95	15577.0
2023-10-25 20:00:00	ES	Futures	4552.95	4558.38	4544.8	4546.7	16549.0
2023-10-25 21:00:00	ES	Futures	4546.7	4549.96	4542.9	4545.34	13773.0
2023-10-25 22:00:00	ES	Futures	4545.34	4546.43	4538.28	4541.27	13783.0
2023-10-25 23:00:00	ES	Futures	4541.0	4545.89	4541.0	4543.44	6489.0
2023-10-25 00:00:00	NQ	Futures	16244.74	16248.31	16238.7	16247.21	2884.0
2023-10-25 01:00:00	NQ	Futures	16247.21	16251.33	16216.45	16226.61	5624.0
2023-10-25 02:00:00	NQ	Futures	16226.34	16237.32	16208.21	16210.13	6473.0
2023-10-25 03:00:00	NQ	Futures	16210.41	16220.29	16164.54	16197.77	14604.0
2023-10-25 04:00:00	NQ	Futures	16198.6	16228.26	16188.71	16214.8	12912.0
2023-10-25 05:00:00	NQ	Futures	16214.25	16226.61	16191.45	16207.11	8847.0
2023-10-25 06:00:00	NQ	Futures	16206.56	16229.63	16185.14	16227.44	8676.0
2023-10-25 07:00:00	NQ	Futures	16226.89	16242.27	16218.65	16224.14	10341.0
2023-10-25 08:00:00	NQ	Futures	16224.14	16249.41	16200.79	16202.44	19258.0
2023-10-25 09:00:00	NQ	Futures	16202.17	16214.25	16046.16	16096.97	119170.0
2023-10-25 10:00:00	NQ	Futures	16097.24	16126.63	16036.82	16064.56	122184.0
2023-10-25 11:00:00	NQ	Futures	16065.11	16133.5	16013.2	16017.32	99184.0
2023-10-25 12:00:00	NQ	Futures	16017.32	16034.9	15973.1	15988.48	66950.0
2023-10-25 13:00:00	NQ	Futures	15988.2	15997.27	15878.89	15911.85	93057.0
2023-10-25 14:00:00	NQ	Futures	15911.57	15938.49	15876.96	15905.25	61927.0
2023-10-25 15:00:00	NQ	Futures	15905.25	15935.19	15878.06	15904.7	84358.0
2023-10-25 16:00:00	NQ	Futures	15904.98	15968.15	15869.0	15895.09	37999.0
2023-10-25 18:00:00	NQ	Futures	15848.12	15853.62	15769.57	15789.35	19650.0
2023-10-25 19:00:00	NQ	Futures	15789.35	15792.37	15745.95	15766.0	7852.0
2023-10-25 20:00:00	NQ	Futures	15765.72	15800.06	15742.65	15752.27	9855.0
2023-10-25 21:00:00	NQ	Futures	15751.99	15764.63	15727.27	15737.43	9094.0
2023-10-25 22:00:00	NQ	Futures	15737.98	15742.93	15713.26	15719.58	7754.0
2023-10-25 23:00:00	NQ	Futures	15719.31	15741.55	15719.03	15734.14	3862.0
2023-10-25 00:00:00	YM	Futures	36132.3	36139.9	36126.9	36137.7	527.0
2023-10-25 01:00:00	YM	Futures	36138.8	36144.2	36091.1	36110.6	1679.0
2023-10-25 02:00:00	YM	Futures	36109.5	36149.7	36091.1	36092.2	4194.0
2023-10-25 03:00:00	YM	Futures	36093.2	36106.3	36047.7	36093.2	6260.0

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

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