PREVIEW / futures_1hour / 2023-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-23.parquet
  size:    67 KB
  rows:    2,031

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-08-23 00:00:00	ES	Futures	4843.75	4844.58	4841.28	4843.75	2253.0
2023-08-23 01:00:00	ES	Futures	4843.75	4848.69	4842.66	4847.87	6011.0
2023-08-23 02:00:00	ES	Futures	4847.87	4849.52	4845.13	4846.5	7380.0
2023-08-23 03:00:00	ES	Futures	4846.77	4856.11	4846.5	4849.52	23293.0
2023-08-23 04:00:00	ES	Futures	4849.52	4859.13	4849.24	4856.38	16090.0
2023-08-23 05:00:00	ES	Futures	4856.38	4858.58	4851.17	4855.56	11124.0
2023-08-23 06:00:00	ES	Futures	4855.28	4856.93	4841.56	4844.3	14652.0
2023-08-23 07:00:00	ES	Futures	4844.3	4845.13	4834.42	4840.73	26827.0
2023-08-23 08:00:00	ES	Futures	4840.73	4841.83	4830.85	4835.52	42741.0
2023-08-23 09:00:00	ES	Futures	4835.52	4858.03	4834.42	4855.56	150806.0
2023-08-23 10:00:00	ES	Futures	4855.01	4873.68	4853.36	4872.58	190965.0
2023-08-23 11:00:00	ES	Futures	4872.85	4877.79	4868.19	4876.7	127901.0
2023-08-23 12:00:00	ES	Futures	4876.7	4880.81	4872.3	4875.87	73804.0
2023-08-23 13:00:00	ES	Futures	4875.6	4892.07	4874.77	4890.7	89152.0
2023-08-23 14:00:00	ES	Futures	4890.7	4891.24	4878.34	4881.36	98756.0
2023-08-23 15:00:00	ES	Futures	4881.09	4889.32	4877.79	4884.11	214839.0
2023-08-23 16:00:00	ES	Futures	4884.11	4915.13	4880.81	4914.3	117846.0
2023-08-23 18:00:00	ES	Futures	4908.81	4911.28	4902.5	4907.71	13228.0
2023-08-23 19:00:00	ES	Futures	4907.71	4909.36	4905.79	4907.71	5567.0
2023-08-23 20:00:00	ES	Futures	4907.71	4910.19	4906.07	4909.09	7447.0
2023-08-23 21:00:00	ES	Futures	4908.81	4911.56	4905.79	4909.91	8416.0
2023-08-23 22:00:00	ES	Futures	4909.91	4917.87	4909.36	4917.6	10547.0
2023-08-23 23:00:00	ES	Futures	4917.87	4919.79	4915.68	4916.22	7500.0
2023-08-23 00:00:00	NQ	Futures	16700.38	16706.5	16692.32	16701.5	1609.0
2023-08-23 01:00:00	NQ	Futures	16701.22	16726.25	16696.77	16720.97	3701.0
2023-08-23 02:00:00	NQ	Futures	16721.24	16732.37	16708.17	16719.58	5413.0
2023-08-23 03:00:00	NQ	Futures	16719.58	16765.19	16717.63	16745.44	13066.0
2023-08-23 04:00:00	NQ	Futures	16745.44	16780.21	16742.1	16760.18	9129.0
2023-08-23 05:00:00	NQ	Futures	16760.46	16772.14	16738.77	16748.78	6143.0
2023-08-23 06:00:00	NQ	Futures	16749.06	16755.45	16699.27	16709.28	8431.0
2023-08-23 07:00:00	NQ	Futures	16709.56	16712.62	16640.31	16672.57	17674.0
2023-08-23 08:00:00	NQ	Futures	16672.01	16691.21	16642.53	16670.07	22603.0
2023-08-23 09:00:00	NQ	Futures	16669.51	16804.96	16665.9	16792.45	91221.0
2023-08-23 10:00:00	NQ	Futures	16791.89	16893.13	16779.37	16885.62	102217.0
2023-08-23 11:00:00	NQ	Futures	16885.9	16918.16	16872.83	16910.93	60656.0
2023-08-23 12:00:00	NQ	Futures	16910.65	16912.6	16874.49	16885.62	35818.0
2023-08-23 13:00:00	NQ	Futures	16885.62	16957.66	16879.5	16951.26	40381.0
2023-08-23 14:00:00	NQ	Futures	16951.26	16951.81	16894.52	16915.94	44060.0
2023-08-23 15:00:00	NQ	Futures	16916.49	16947.36	16892.57	16908.15	63881.0
2023-08-23 16:00:00	NQ	Futures	16908.15	17084.76	16902.31	17083.65	46433.0
2023-08-23 18:00:00	NQ	Futures	17058.34	17070.86	17014.95	17045.27	11590.0
2023-08-23 19:00:00	NQ	Futures	17044.43	17067.24	17042.21	17060.29	5091.0
2023-08-23 20:00:00	NQ	Futures	17060.29	17073.36	17042.21	17065.57	6059.0
2023-08-23 21:00:00	NQ	Futures	17065.85	17096.72	17051.39	17091.99	6837.0
2023-08-23 22:00:00	NQ	Futures	17091.99	17125.65	17088.38	17123.42	6848.0
2023-08-23 23:00:00	NQ	Futures	17123.42	17131.49	17112.02	17114.8	4702.0
2023-08-23 00:00:00	YM	Futures	37712.0	37715.2	37699.9	37714.1	433.0
2023-08-23 01:00:00	YM	Futures	37714.1	37740.4	37705.4	37737.2	842.0
2023-08-23 02:00:00	YM	Futures	37737.2	37740.4	37713.0	37716.3	1543.0
2023-08-23 03:00:00	YM	Futures	37715.2	37781.0	37707.6	37726.2	4956.0

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

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