PREVIEW / futures_1hour / 2023-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-11-13.parquet
  size:    65 KB
  rows:    2,075

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-11-13 00:00:00	ES	Futures	4789.75	4794.09	4788.66	4791.1	6966.0
2023-11-13 01:00:00	ES	Futures	4791.1	4796.54	4790.56	4795.99	8562.0
2023-11-13 02:00:00	ES	Futures	4795.99	4798.16	4794.09	4797.08	9431.0
2023-11-13 03:00:00	ES	Futures	4797.08	4800.61	4793.55	4800.07	17745.0
2023-11-13 04:00:00	ES	Futures	4800.34	4804.14	4798.71	4803.05	17869.0
2023-11-13 05:00:00	ES	Futures	4802.78	4806.85	4799.52	4806.04	11763.0
2023-11-13 06:00:00	ES	Futures	4806.31	4806.85	4800.88	4805.23	11517.0
2023-11-13 07:00:00	ES	Futures	4805.23	4805.77	4800.34	4803.32	16771.0
2023-11-13 08:00:00	ES	Futures	4803.32	4807.4	4794.91	4796.81	42382.0
2023-11-13 09:00:00	ES	Futures	4796.81	4800.34	4787.3	4792.46	169920.0
2023-11-13 10:00:00	ES	Futures	4792.19	4804.14	4788.66	4801.7	196717.0
2023-11-13 11:00:00	ES	Futures	4801.42	4819.35	4799.52	4815.54	161520.0
2023-11-13 12:00:00	ES	Futures	4815.82	4817.17	4806.58	4810.66	110529.0
2023-11-13 13:00:00	ES	Futures	4810.66	4815.82	4803.6	4810.66	103414.0
2023-11-13 14:00:00	ES	Futures	4810.38	4816.9	4808.48	4810.93	79207.0
2023-11-13 15:00:00	ES	Futures	4811.2	4815.0	4805.5	4807.13	166839.0
2023-11-13 16:00:00	ES	Futures	4806.85	4810.11	4806.31	4809.84	40265.0
2023-11-13 18:00:00	ES	Futures	4809.03	4810.11	4807.94	4809.57	3711.0
2023-11-13 19:00:00	ES	Futures	4809.3	4809.84	4807.13	4808.48	6064.0
2023-11-13 20:00:00	ES	Futures	4808.76	4809.84	4807.4	4808.48	6552.0
2023-11-13 21:00:00	ES	Futures	4808.76	4810.93	4807.67	4808.21	5247.0
2023-11-13 22:00:00	ES	Futures	4808.21	4810.66	4806.58	4810.11	5194.0
2023-11-13 23:00:00	ES	Futures	4810.11	4811.47	4809.03	4809.57	3171.0
2023-11-13 00:00:00	NQ	Futures	17044.29	17061.04	17039.89	17049.78	3775.0
2023-11-13 01:00:00	NQ	Futures	17050.05	17073.95	17044.29	17070.38	4998.0
2023-11-13 02:00:00	NQ	Futures	17070.1	17076.42	17060.77	17070.38	4418.0
2023-11-13 03:00:00	NQ	Futures	17071.2	17076.42	17057.47	17074.22	7272.0
2023-11-13 04:00:00	NQ	Futures	17074.77	17091.25	17067.36	17085.21	9163.0
2023-11-13 05:00:00	NQ	Futures	17084.94	17104.99	17073.95	17101.69	5482.0
2023-11-13 06:00:00	NQ	Futures	17102.52	17103.89	17081.37	17098.12	6101.0
2023-11-13 07:00:00	NQ	Futures	17098.12	17102.79	17085.49	17098.12	7652.0
2023-11-13 08:00:00	NQ	Futures	17098.12	17110.76	17058.84	17068.73	22372.0
2023-11-13 09:00:00	NQ	Futures	17068.73	17074.22	16991.0	17018.74	86283.0
2023-11-13 10:00:00	NQ	Futures	17018.74	17082.19	17005.56	17068.46	94819.0
2023-11-13 11:00:00	NQ	Futures	17068.73	17127.51	17063.24	17106.64	66366.0
2023-11-13 12:00:00	NQ	Futures	17106.91	17113.78	17072.3	17092.63	48293.0
2023-11-13 13:00:00	NQ	Futures	17092.35	17119.0	17069.28	17093.73	39059.0
2023-11-13 14:00:00	NQ	Futures	17093.73	17126.41	17081.64	17106.64	31205.0
2023-11-13 15:00:00	NQ	Futures	17106.64	17120.37	17074.77	17081.64	47907.0
2023-11-13 16:00:00	NQ	Futures	17081.37	17093.73	17078.34	17092.08	7837.0
2023-11-13 18:00:00	NQ	Futures	17092.9	17098.12	17086.31	17093.18	2102.0
2023-11-13 19:00:00	NQ	Futures	17093.18	17099.49	17086.58	17098.12	3090.0
2023-11-13 20:00:00	NQ	Futures	17098.4	17105.54	17091.53	17101.69	3555.0
2023-11-13 21:00:00	NQ	Futures	17101.14	17109.38	17098.12	17102.52	2904.0
2023-11-13 22:00:00	NQ	Futures	17102.79	17112.4	17096.47	17111.85	3113.0
2023-11-13 23:00:00	NQ	Futures	17111.58	17114.88	17107.73	17108.83	2267.0
2023-11-13 00:00:00	YM	Futures	37113.0	37131.4	37103.2	37119.5	739.0
2023-11-13 01:00:00	YM	Futures	37119.5	37154.2	37116.2	37154.2	1168.0
2023-11-13 02:00:00	YM	Futures	37152.0	37172.6	37145.5	37160.7	1723.0
2023-11-13 03:00:00	YM	Futures	37161.8	37192.1	37137.9	37188.9	2172.0

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

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