PREVIEW / futures_1hour / 2023-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-28.parquet
  size:    68 KB
  rows:    2,061

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-09-28 00:00:00	ES	Futures	4686.01	4687.91	4679.49	4687.64	8977.0
2023-09-28 01:00:00	ES	Futures	4687.91	4696.06	4687.1	4695.52	13582.0
2023-09-28 02:00:00	ES	Futures	4695.52	4695.52	4687.91	4688.46	10818.0
2023-09-28 03:00:00	ES	Futures	4688.46	4694.16	4684.38	4687.37	26388.0
2023-09-28 04:00:00	ES	Futures	4687.1	4688.73	4679.49	4683.84	26238.0
2023-09-28 05:00:00	ES	Futures	4683.57	4690.9	4673.25	4690.08	30513.0
2023-09-28 06:00:00	ES	Futures	4690.08	4694.16	4686.01	4690.36	20882.0
2023-09-28 07:00:00	ES	Futures	4690.08	4690.36	4676.51	4682.75	38378.0
2023-09-28 08:00:00	ES	Futures	4682.75	4701.49	4674.61	4678.68	111885.0
2023-09-28 09:00:00	ES	Futures	4678.41	4692.8	4671.89	4691.99	239190.0
2023-09-28 10:00:00	ES	Futures	4692.26	4701.76	4676.78	4699.32	280803.0
2023-09-28 11:00:00	ES	Futures	4699.32	4724.3	4694.97	4722.13	265748.0
2023-09-28 12:00:00	ES	Futures	4722.4	4731.36	4712.9	4716.7	165252.0
2023-09-28 13:00:00	ES	Futures	4716.7	4720.5	4702.85	4708.01	157905.0
2023-09-28 14:00:00	ES	Futures	4708.28	4718.6	4700.68	4710.72	156322.0
2023-09-28 15:00:00	ES	Futures	4710.72	4726.2	4706.11	4712.35	280878.0
2023-09-28 16:00:00	ES	Futures	4712.62	4718.06	4708.28	4716.7	53958.0
2023-09-28 18:00:00	ES	Futures	4716.43	4721.59	4715.61	4718.06	6666.0
2023-09-28 19:00:00	ES	Futures	4718.33	4718.6	4712.9	4713.44	6746.0
2023-09-28 20:00:00	ES	Futures	4713.44	4713.71	4702.58	4702.85	16451.0
2023-09-28 21:00:00	ES	Futures	4702.58	4705.56	4700.68	4704.48	16763.0
2023-09-28 22:00:00	ES	Futures	4704.75	4713.44	4704.75	4712.62	8936.0
2023-09-28 23:00:00	ES	Futures	4712.62	4716.43	4712.35	4715.61	5386.0
2023-09-28 00:00:00	NQ	Futures	16194.48	16196.95	16164.26	16195.57	6046.0
2023-09-28 01:00:00	NQ	Futures	16196.4	16233.75	16193.65	16228.53	6835.0
2023-09-28 02:00:00	NQ	Futures	16228.81	16231.28	16199.14	16203.54	5830.0
2023-09-28 03:00:00	NQ	Futures	16202.17	16220.57	16181.02	16192.55	10271.0
2023-09-28 04:00:00	NQ	Futures	16192.83	16199.42	16160.14	16170.58	11279.0
2023-09-28 05:00:00	NQ	Futures	16170.58	16193.65	16125.81	16188.43	14291.0
2023-09-28 06:00:00	NQ	Futures	16188.71	16199.69	16167.28	16183.76	8378.0
2023-09-28 07:00:00	NQ	Futures	16183.76	16185.14	16130.48	16152.45	13022.0
2023-09-28 08:00:00	NQ	Futures	16152.18	16235.13	16125.81	16143.66	47000.0
2023-09-28 09:00:00	NQ	Futures	16143.11	16202.72	16104.11	16198.87	92304.0
2023-09-28 10:00:00	NQ	Futures	16198.87	16246.94	16127.73	16238.97	105936.0
2023-09-28 11:00:00	NQ	Futures	16238.15	16381.8	16212.33	16379.05	93139.0
2023-09-28 12:00:00	NQ	Futures	16379.32	16422.17	16346.64	16360.37	68078.0
2023-09-28 13:00:00	NQ	Futures	16360.65	16378.78	16293.9	16315.6	57991.0
2023-09-28 14:00:00	NQ	Futures	16315.6	16352.41	16272.48	16307.91	58963.0
2023-09-28 15:00:00	NQ	Futures	16308.19	16384.82	16302.69	16324.39	79688.0
2023-09-28 16:00:00	NQ	Futures	16324.39	16353.78	16317.25	16344.17	13090.0
2023-09-28 18:00:00	NQ	Futures	16344.17	16363.94	16341.7	16354.06	3328.0
2023-09-28 19:00:00	NQ	Futures	16354.33	16355.43	16330.16	16334.28	2499.0
2023-09-28 20:00:00	NQ	Futures	16334.55	16337.03	16294.45	16296.1	5472.0
2023-09-28 21:00:00	NQ	Futures	16295.83	16316.15	16288.14	16309.56	6028.0
2023-09-28 22:00:00	NQ	Futures	16309.01	16348.29	16309.01	16340.87	5261.0
2023-09-28 23:00:00	NQ	Futures	16341.42	16360.65	16340.87	16354.6	3548.0
2023-09-28 00:00:00	YM	Futures	36645.4	36657.3	36599.8	36656.3	1074.0
2023-09-28 01:00:00	YM	Futures	36657.3	36709.4	36654.1	36702.9	1588.0
2023-09-28 02:00:00	YM	Futures	36704.0	36704.0	36647.6	36649.7	1850.0
2023-09-28 03:00:00	YM	Futures	36650.8	36693.1	36630.2	36642.2	3850.0

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

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