PREVIEW / futures_1hour / 2023-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-09.parquet
  size:    67 KB
  rows:    2,044

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-09 00:00:00	ES	Futures	4675.96	4680.58	4675.42	4680.04	4532.0
2023-10-09 01:00:00	ES	Futures	4680.04	4684.11	4679.49	4683.84	7200.0
2023-10-09 02:00:00	ES	Futures	4683.84	4690.08	4680.85	4681.39	12970.0
2023-10-09 03:00:00	ES	Futures	4681.39	4683.84	4670.26	4677.86	30699.0
2023-10-09 04:00:00	ES	Futures	4677.86	4690.63	4676.51	4689.54	22496.0
2023-10-09 05:00:00	ES	Futures	4689.54	4695.24	4687.1	4689.27	16569.0
2023-10-09 06:00:00	ES	Futures	4689.54	4694.7	4687.91	4688.18	11530.0
2023-10-09 07:00:00	ES	Futures	4688.18	4689.81	4682.21	4686.28	19526.0
2023-10-09 08:00:00	ES	Futures	4686.28	4692.53	4680.04	4682.21	44705.0
2023-10-09 09:00:00	ES	Futures	4682.21	4710.99	4681.94	4708.55	190132.0
2023-10-09 10:00:00	ES	Futures	4708.55	4712.08	4688.18	4692.26	179938.0
2023-10-09 11:00:00	ES	Futures	4692.26	4711.27	4691.44	4710.45	123805.0
2023-10-09 12:00:00	ES	Futures	4710.72	4721.04	4705.29	4709.64	104416.0
2023-10-09 13:00:00	ES	Futures	4709.91	4744.67	4708.55	4744.4	155123.0
2023-10-09 14:00:00	ES	Futures	4744.67	4753.09	4739.78	4749.28	170975.0
2023-10-09 15:00:00	ES	Futures	4749.56	4750.64	4738.42	4746.84	204505.0
2023-10-09 16:00:00	ES	Futures	4746.57	4749.01	4744.94	4745.48	38729.0
2023-10-09 18:00:00	ES	Futures	4745.48	4746.03	4743.58	4744.94	3264.0
2023-10-09 19:00:00	ES	Futures	4744.94	4746.57	4744.4	4746.3	3675.0
2023-10-09 20:00:00	ES	Futures	4746.3	4751.19	4744.94	4749.56	9267.0
2023-10-09 21:00:00	ES	Futures	4749.56	4755.26	4749.28	4752.27	11272.0
2023-10-09 22:00:00	ES	Futures	4752.27	4753.9	4749.01	4749.28	5613.0
2023-10-09 23:00:00	ES	Futures	4749.01	4750.91	4748.47	4750.37	4159.0
2023-10-09 00:00:00	NQ	Futures	16459.53	16476.56	16456.78	16473.26	3070.0
2023-10-09 01:00:00	NQ	Futures	16473.26	16497.98	16471.06	16495.78	4907.0
2023-10-09 02:00:00	NQ	Futures	16496.61	16516.38	16483.42	16488.92	7295.0
2023-10-09 03:00:00	NQ	Futures	16488.09	16496.61	16448.81	16479.58	16207.0
2023-10-09 04:00:00	NQ	Futures	16480.13	16505.12	16453.21	16497.7	13775.0
2023-10-09 05:00:00	NQ	Futures	16497.16	16510.89	16474.63	16480.4	8483.0
2023-10-09 06:00:00	NQ	Futures	16480.95	16503.47	16474.36	16476.56	5999.0
2023-10-09 07:00:00	NQ	Futures	16476.83	16485.62	16455.68	16471.61	11473.0
2023-10-09 08:00:00	NQ	Futures	16471.06	16501.55	16448.81	16465.57	22380.0
2023-10-09 09:00:00	NQ	Futures	16465.02	16548.52	16424.37	16539.73	98851.0
2023-10-09 10:00:00	NQ	Futures	16539.18	16553.19	16456.51	16469.96	85146.0
2023-10-09 11:00:00	NQ	Futures	16469.41	16535.61	16441.4	16534.51	52856.0
2023-10-09 12:00:00	NQ	Futures	16534.51	16584.77	16527.37	16549.34	42530.0
2023-10-09 13:00:00	NQ	Futures	16549.62	16690.79	16547.42	16690.24	60312.0
2023-10-09 14:00:00	NQ	Futures	16690.52	16713.59	16663.05	16697.66	54296.0
2023-10-09 15:00:00	NQ	Futures	16697.93	16712.77	16663.33	16689.42	67548.0
2023-10-09 16:00:00	NQ	Futures	16689.69	16701.51	16685.3	16694.09	10827.0
2023-10-09 18:00:00	NQ	Futures	16695.74	16696.29	16686.4	16692.72	1898.0
2023-10-09 19:00:00	NQ	Futures	16692.72	16700.68	16689.97	16699.58	2118.0
2023-10-09 20:00:00	NQ	Futures	16699.03	16723.48	16688.87	16715.79	5873.0
2023-10-09 21:00:00	NQ	Futures	16715.24	16741.06	16714.69	16726.77	6486.0
2023-10-09 22:00:00	NQ	Futures	16726.77	16735.29	16711.94	16712.49	3754.0
2023-10-09 23:00:00	NQ	Futures	16712.22	16719.91	16708.65	16717.16	2592.0
2023-10-09 00:00:00	YM	Futures	36187.6	36222.3	36187.6	36215.8	768.0
2023-10-09 01:00:00	YM	Futures	36216.9	36241.9	36212.6	36240.8	1041.0
2023-10-09 02:00:00	YM	Futures	36240.8	36280.9	36201.7	36206.1	2940.0
2023-10-09 03:00:00	YM	Futures	36206.1	36224.5	36121.5	36183.3	6729.0

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

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