PREVIEW / futures_1hour / 2023-09-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	4740.32	4741.68	4739.24	4741.41	3942.0
2023-09-26 01:00:00	ES	Futures	4741.14	4742.22	4736.52	4738.15	6587.0
2023-09-26 02:00:00	ES	Futures	4737.88	4738.69	4727.56	4728.65	14170.0
2023-09-26 03:00:00	ES	Futures	4728.92	4731.09	4718.6	4730.0	35118.0
2023-09-26 04:00:00	ES	Futures	4730.28	4740.87	4730.0	4735.16	28370.0
2023-09-26 05:00:00	ES	Futures	4734.89	4737.61	4728.65	4729.46	18252.0
2023-09-26 06:00:00	ES	Futures	4729.46	4738.15	4729.19	4737.34	17336.0
2023-09-26 07:00:00	ES	Futures	4737.34	4741.68	4729.73	4737.88	24151.0
2023-09-26 08:00:00	ES	Futures	4737.88	4743.31	4726.74	4728.37	45200.0
2023-09-26 09:00:00	ES	Futures	4728.37	4729.46	4715.34	4716.97	197826.0
2023-09-26 10:00:00	ES	Futures	4716.97	4719.96	4698.23	4709.64	284092.0
2023-09-26 11:00:00	ES	Futures	4709.64	4712.35	4694.43	4699.59	178360.0
2023-09-26 12:00:00	ES	Futures	4699.59	4709.37	4696.87	4705.02	107595.0
2023-09-26 13:00:00	ES	Futures	4705.02	4709.37	4687.37	4695.24	178848.0
2023-09-26 14:00:00	ES	Futures	4695.52	4695.79	4681.67	4685.74	134085.0
2023-09-26 15:00:00	ES	Futures	4685.47	4688.46	4676.78	4686.01	277935.0
2023-09-26 16:00:00	ES	Futures	4686.01	4695.52	4685.47	4691.99	71556.0
2023-09-26 18:00:00	ES	Futures	4692.8	4694.16	4689.27	4690.08	5495.0
2023-09-26 19:00:00	ES	Futures	4690.36	4694.43	4690.08	4693.89	10708.0
2023-09-26 20:00:00	ES	Futures	4693.89	4696.33	4689.27	4691.44	13417.0
2023-09-26 21:00:00	ES	Futures	4691.17	4698.77	4690.9	4698.23	12360.0
2023-09-26 22:00:00	ES	Futures	4698.23	4698.23	4695.52	4696.06	7073.0
2023-09-26 23:00:00	ES	Futures	4696.06	4697.15	4693.89	4695.52	6752.0
2023-09-26 00:00:00	NQ	Futures	16342.24	16347.19	16337.3	16345.82	2402.0
2023-09-26 01:00:00	NQ	Futures	16345.54	16351.31	16323.57	16331.53	4164.0
2023-09-26 02:00:00	NQ	Futures	16329.88	16335.1	16284.84	16293.63	8161.0
2023-09-26 03:00:00	NQ	Futures	16294.18	16317.25	16254.63	16315.05	15422.0
2023-09-26 04:00:00	NQ	Futures	16315.05	16356.25	16307.91	16323.84	14536.0
2023-09-26 05:00:00	NQ	Futures	16324.12	16334.28	16299.4	16302.69	8733.0
2023-09-26 06:00:00	NQ	Futures	16302.42	16338.95	16302.42	16335.93	7714.0
2023-09-26 07:00:00	NQ	Futures	16335.93	16357.63	16305.44	16341.42	11567.0
2023-09-26 08:00:00	NQ	Futures	16341.15	16362.3	16302.14	16309.01	18486.0
2023-09-26 09:00:00	NQ	Futures	16309.56	16311.21	16220.57	16229.91	88801.0
2023-09-26 10:00:00	NQ	Futures	16227.16	16266.44	16177.17	16225.51	112577.0
2023-09-26 11:00:00	NQ	Futures	16225.51	16235.4	16177.72	16192.0	71901.0
2023-09-26 12:00:00	NQ	Futures	16192.28	16240.34	16174.7	16219.47	47409.0
2023-09-26 13:00:00	NQ	Futures	16219.74	16242.54	16154.92	16192.0	69239.0
2023-09-26 14:00:00	NQ	Futures	16192.28	16192.55	16140.37	16158.77	50514.0
2023-09-26 15:00:00	NQ	Futures	16158.49	16172.23	16113.17	16159.87	83819.0
2023-09-26 16:00:00	NQ	Futures	16159.87	16189.81	16158.22	16178.0	17224.0
2023-09-26 18:00:00	NQ	Futures	16178.0	16181.57	16165.09	16172.23	3716.0
2023-09-26 19:00:00	NQ	Futures	16172.23	16195.57	16169.21	16193.1	4154.0
2023-09-26 20:00:00	NQ	Futures	16192.55	16205.19	16175.52	16184.31	5488.0
2023-09-26 21:00:00	NQ	Futures	16184.86	16207.38	16181.02	16205.46	6131.0
2023-09-26 22:00:00	NQ	Futures	16205.74	16206.84	16190.08	16193.65	3317.0
2023-09-26 23:00:00	NQ	Futures	16193.1	16199.14	16183.76	16192.28	3524.0
2023-09-26 00:00:00	YM	Futures	37069.6	37080.4	37064.1	37077.2	408.0
2023-09-26 01:00:00	YM	Futures	37077.2	37083.7	37047.9	37058.7	664.0
2023-09-26 02:00:00	YM	Futures	37057.6	37065.2	36994.7	36996.9	2837.0
2023-09-26 03:00:00	YM	Futures	36998.0	37007.7	36924.2	36996.9	6231.0

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

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