PREVIEW / futures_1hour / 2023-09-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	4749.56	4750.91	4747.93	4749.56	3040.0
2023-09-25 01:00:00	ES	Futures	4749.28	4751.73	4746.57	4747.11	4319.0
2023-09-25 02:00:00	ES	Futures	4747.11	4750.91	4746.03	4748.74	8757.0
2023-09-25 03:00:00	ES	Futures	4748.74	4757.16	4748.47	4752.81	20755.0
2023-09-25 04:00:00	ES	Futures	4753.09	4754.44	4722.13	4729.46	39853.0
2023-09-25 05:00:00	ES	Futures	4729.46	4736.25	4727.56	4735.71	22835.0
2023-09-25 06:00:00	ES	Futures	4735.71	4738.69	4730.0	4734.08	17913.0
2023-09-25 07:00:00	ES	Futures	4734.08	4737.61	4722.67	4724.03	23568.0
2023-09-25 08:00:00	ES	Futures	4724.03	4728.1	4718.06	4722.13	42166.0
2023-09-25 09:00:00	ES	Futures	4721.86	4740.59	4712.35	4738.42	210723.0
2023-09-25 10:00:00	ES	Futures	4738.69	4740.32	4723.49	4723.49	205451.0
2023-09-25 11:00:00	ES	Futures	4723.49	4750.91	4722.67	4746.3	198630.0
2023-09-25 12:00:00	ES	Futures	4746.3	4754.99	4738.97	4744.4	107566.0
2023-09-25 13:00:00	ES	Futures	4744.12	4752.54	4738.97	4748.74	103590.0
2023-09-25 14:00:00	ES	Futures	4748.74	4751.46	4740.87	4741.68	116381.0
2023-09-25 15:00:00	ES	Futures	4741.68	4757.97	4732.18	4757.16	268349.0
2023-09-25 16:00:00	ES	Futures	4757.16	4761.5	4756.07	4760.69	59477.0
2023-09-25 18:00:00	ES	Futures	4759.88	4759.88	4757.16	4757.7	3902.0
2023-09-25 19:00:00	ES	Futures	4757.43	4757.43	4755.26	4755.53	2512.0
2023-09-25 20:00:00	ES	Futures	4755.53	4755.8	4740.59	4741.95	13982.0
2023-09-25 21:00:00	ES	Futures	4742.22	4743.58	4735.43	4737.06	14729.0
2023-09-25 22:00:00	ES	Futures	4737.06	4738.15	4733.81	4735.98	9758.0
2023-09-25 23:00:00	ES	Futures	4736.25	4740.59	4735.71	4740.05	5482.0
2023-09-25 00:00:00	NQ	Futures	16393.61	16399.1	16387.84	16393.88	1857.0
2023-09-25 01:00:00	NQ	Futures	16393.33	16406.52	16381.8	16383.17	3231.0
2023-09-25 02:00:00	NQ	Futures	16382.9	16398.55	16376.3	16387.29	3942.0
2023-09-25 03:00:00	NQ	Futures	16386.47	16420.52	16385.37	16396.08	7299.0
2023-09-25 04:00:00	NQ	Futures	16396.08	16404.32	16256.82	16302.69	20682.0
2023-09-25 05:00:00	NQ	Futures	16302.69	16332.08	16294.45	16321.92	11961.0
2023-09-25 06:00:00	NQ	Futures	16321.1	16341.97	16300.22	16323.02	8072.0
2023-09-25 07:00:00	NQ	Futures	16323.57	16337.85	16274.68	16284.02	10876.0
2023-09-25 08:00:00	NQ	Futures	16283.47	16310.66	16259.02	16283.19	17610.0
2023-09-25 09:00:00	NQ	Futures	16282.37	16366.14	16240.62	16343.62	84045.0
2023-09-25 10:00:00	NQ	Futures	16343.34	16353.51	16276.87	16279.9	85235.0
2023-09-25 11:00:00	NQ	Futures	16279.9	16395.25	16278.8	16369.99	64833.0
2023-09-25 12:00:00	NQ	Futures	16370.26	16409.81	16330.98	16350.76	42040.0
2023-09-25 13:00:00	NQ	Futures	16351.58	16393.33	16337.03	16373.01	42716.0
2023-09-25 14:00:00	NQ	Futures	16373.83	16388.66	16336.2	16342.52	43072.0
2023-09-25 15:00:00	NQ	Futures	16342.24	16413.11	16306.81	16410.36	75591.0
2023-09-25 16:00:00	NQ	Futures	16410.36	16431.24	16407.07	16426.02	16375.0
2023-09-25 18:00:00	NQ	Futures	16423.82	16423.82	16414.76	16416.68	2175.0
2023-09-25 19:00:00	NQ	Futures	16417.23	16418.05	16404.04	16404.87	2109.0
2023-09-25 20:00:00	NQ	Futures	16404.87	16406.52	16334.83	16345.82	8320.0
2023-09-25 21:00:00	NQ	Futures	16346.36	16353.78	16320.27	16330.16	6687.0
2023-09-25 22:00:00	NQ	Futures	16329.61	16335.1	16317.52	16326.04	5082.0
2023-09-25 23:00:00	NQ	Futures	16326.31	16343.07	16324.12	16342.24	2855.0
2023-09-25 00:00:00	YM	Futures	37213.8	37222.5	37200.8	37211.7	487.0
2023-09-25 01:00:00	YM	Futures	37211.7	37222.5	37195.4	37198.7	538.0
2023-09-25 02:00:00	YM	Futures	37197.6	37224.7	37193.2	37205.2	1513.0
2023-09-25 03:00:00	YM	Futures	37205.2	37271.3	37201.9	37254.0	2989.0

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

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