PREVIEW / futures_1hour / 2023-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-30.parquet
  size:    67 KB
  rows:    2,086

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-10-30 00:00:00	ES	Futures	4510.58	4510.86	4506.78	4508.96	3570.0
2023-10-30 01:00:00	ES	Futures	4508.96	4511.13	4507.05	4510.58	4249.0
2023-10-30 02:00:00	ES	Futures	4510.58	4515.47	4510.58	4514.93	7333.0
2023-10-30 03:00:00	ES	Futures	4514.93	4521.72	4513.03	4519.27	14385.0
2023-10-30 04:00:00	ES	Futures	4519.55	4523.35	4514.66	4518.73	25637.0
2023-10-30 05:00:00	ES	Futures	4518.73	4526.33	4518.19	4523.89	18688.0
2023-10-30 06:00:00	ES	Futures	4523.89	4524.98	4519.0	4521.72	15113.0
2023-10-30 07:00:00	ES	Futures	4521.45	4528.51	4520.36	4525.25	21244.0
2023-10-30 08:00:00	ES	Futures	4525.52	4526.06	4517.1	4520.63	33917.0
2023-10-30 09:00:00	ES	Futures	4520.63	4544.8	4519.82	4539.91	220588.0
2023-10-30 10:00:00	ES	Futures	4539.91	4541.27	4510.04	4519.0	359744.0
2023-10-30 11:00:00	ES	Futures	4519.27	4530.41	4512.49	4529.59	202227.0
2023-10-30 12:00:00	ES	Futures	4529.59	4532.85	4514.66	4521.18	156464.0
2023-10-30 13:00:00	ES	Futures	4521.45	4548.87	4518.46	4548.33	182706.0
2023-10-30 14:00:00	ES	Futures	4548.33	4555.39	4541.0	4550.23	146482.0
2023-10-30 15:00:00	ES	Futures	4550.23	4559.46	4545.62	4546.97	286529.0
2023-10-30 16:00:00	ES	Futures	4547.24	4548.6	4542.09	4545.89	71581.0
2023-10-30 18:00:00	ES	Futures	4545.07	4545.62	4542.09	4544.53	4512.0
2023-10-30 19:00:00	ES	Futures	4544.53	4545.62	4542.36	4542.63	5747.0
2023-10-30 20:00:00	ES	Futures	4542.63	4542.9	4535.84	4539.91	14496.0
2023-10-30 21:00:00	ES	Futures	4539.91	4541.0	4532.85	4536.38	13691.0
2023-10-30 22:00:00	ES	Futures	4536.38	4539.1	4534.21	4534.48	4812.0
2023-10-30 23:00:00	ES	Futures	4534.75	4536.11	4527.42	4531.49	18468.0
2023-10-30 00:00:00	NQ	Futures	15755.84	15756.39	15741.83	15748.7	2009.0
2023-10-30 01:00:00	NQ	Futures	15749.24	15755.56	15739.08	15753.91	2509.0
2023-10-30 02:00:00	NQ	Futures	15754.19	15775.89	15751.44	15774.79	4196.0
2023-10-30 03:00:00	NQ	Futures	15774.24	15799.78	15767.37	15789.9	6676.0
2023-10-30 04:00:00	NQ	Futures	15790.17	15803.63	15767.1	15776.99	11070.0
2023-10-30 05:00:00	NQ	Futures	15776.71	15811.59	15774.79	15796.49	7643.0
2023-10-30 06:00:00	NQ	Futures	15796.49	15799.51	15778.08	15785.5	5853.0
2023-10-30 07:00:00	NQ	Futures	15785.23	15811.32	15780.83	15797.04	7001.0
2023-10-30 08:00:00	NQ	Futures	15797.31	15799.78	15760.23	15776.71	13783.0
2023-10-30 09:00:00	NQ	Futures	15776.99	15904.7	15748.97	15876.41	99122.0
2023-10-30 10:00:00	NQ	Futures	15876.69	15884.93	15717.66	15759.13	136569.0
2023-10-30 11:00:00	NQ	Futures	15759.13	15817.91	15734.41	15814.07	90938.0
2023-10-30 12:00:00	NQ	Futures	15814.61	15819.28	15722.33	15744.03	70600.0
2023-10-30 13:00:00	NQ	Futures	15744.3	15852.79	15734.14	15849.22	66634.0
2023-10-30 14:00:00	NQ	Futures	15848.95	15877.24	15819.83	15860.76	53634.0
2023-10-30 15:00:00	NQ	Futures	15861.31	15899.76	15834.12	15841.26	79511.0
2023-10-30 16:00:00	NQ	Futures	15841.53	15845.38	15823.68	15834.67	15517.0
2023-10-30 18:00:00	NQ	Futures	15832.19	15838.79	15824.78	15828.9	2293.0
2023-10-30 19:00:00	NQ	Futures	15828.62	15833.29	15817.09	15819.01	2286.0
2023-10-30 20:00:00	NQ	Futures	15818.46	15820.38	15786.87	15801.98	6661.0
2023-10-30 21:00:00	NQ	Futures	15801.98	15807.2	15775.34	15791.82	6646.0
2023-10-30 22:00:00	NQ	Futures	15791.82	15800.88	15778.91	15780.01	2927.0
2023-10-30 23:00:00	NQ	Futures	15780.01	15783.58	15741.0	15759.13	10340.0
2023-10-30 00:00:00	YM	Futures	35340.4	35340.4	35314.4	35327.4	684.0
2023-10-30 01:00:00	YM	Futures	35328.5	35348.0	35324.1	35346.9	451.0
2023-10-30 02:00:00	YM	Futures	35346.9	35384.9	35346.9	35381.6	1416.0
2023-10-30 03:00:00	YM	Futures	35381.6	35420.7	35366.4	35400.1	3410.0

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

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