PREVIEW / futures_1hour / 2023-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-28.parquet
  size:    61 KB
  rows:    1,929

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-28 00:00:00	ES	Futures	4848.69	4850.89	4848.69	4850.89	2607.0
2023-08-28 01:00:00	ES	Futures	4850.62	4856.66	4848.97	4856.38	6712.0
2023-08-28 02:00:00	ES	Futures	4856.11	4857.48	4853.91	4854.73	6100.0
2023-08-28 03:00:00	ES	Futures	4854.73	4857.48	4848.42	4851.17	12919.0
2023-08-28 04:00:00	ES	Futures	4851.17	4858.03	4850.62	4855.01	9199.0
2023-08-28 05:00:00	ES	Futures	4855.01	4856.66	4849.52	4854.46	7852.0
2023-08-28 06:00:00	ES	Futures	4854.46	4855.28	4849.24	4853.64	6204.0
2023-08-28 07:00:00	ES	Futures	4853.64	4858.3	4852.26	4858.03	11378.0
2023-08-28 08:00:00	ES	Futures	4858.03	4871.75	4857.2	4870.93	32156.0
2023-08-28 09:00:00	ES	Futures	4870.93	4883.28	4867.36	4876.42	181701.0
2023-08-28 10:00:00	ES	Futures	4876.42	4883.28	4862.69	4870.11	185316.0
2023-08-28 11:00:00	ES	Futures	4870.38	4870.66	4857.48	4864.07	140386.0
2023-08-28 12:00:00	ES	Futures	4863.79	4876.7	4858.03	4876.15	89360.0
2023-08-28 13:00:00	ES	Futures	4876.15	4883.83	4856.93	4860.22	139508.0
2023-08-28 14:00:00	ES	Futures	4860.22	4869.01	4857.2	4867.91	100707.0
2023-08-28 15:00:00	ES	Futures	4868.19	4885.75	4862.69	4877.24	216123.0
2023-08-28 16:00:00	ES	Futures	4877.24	4880.54	4875.87	4879.99	35823.0
2023-08-28 18:00:00	ES	Futures	4879.71	4883.01	4879.44	4881.36	4164.0
2023-08-28 19:00:00	ES	Futures	4881.64	4881.64	4878.07	4878.62	3478.0
2023-08-28 20:00:00	ES	Futures	4878.62	4879.99	4874.77	4879.17	6044.0
2023-08-28 21:00:00	ES	Futures	4879.44	4882.19	4875.32	4875.6	6160.0
2023-08-28 22:00:00	ES	Futures	4875.87	4879.71	4875.6	4879.71	3607.0
2023-08-28 23:00:00	ES	Futures	4879.71	4881.64	4878.62	4880.81	2702.0
2023-08-28 00:00:00	NQ	Futures	16666.17	16676.19	16662.56	16676.19	1704.0
2023-08-28 01:00:00	NQ	Futures	16676.47	16696.77	16660.89	16693.43	3453.0
2023-08-28 02:00:00	NQ	Futures	16693.15	16704.0	16683.97	16687.87	3866.0
2023-08-28 03:00:00	NQ	Futures	16688.7	16707.62	16662.0	16681.75	7746.0
2023-08-28 04:00:00	NQ	Futures	16682.58	16723.75	16679.8	16710.95	8401.0
2023-08-28 05:00:00	NQ	Futures	16710.68	16713.18	16680.92	16700.66	4906.0
2023-08-28 06:00:00	NQ	Futures	16700.66	16710.95	16681.19	16700.66	4524.0
2023-08-28 07:00:00	NQ	Futures	16700.66	16728.48	16697.88	16722.36	7576.0
2023-08-28 08:00:00	NQ	Futures	16723.19	16790.78	16719.3	16788.27	16555.0
2023-08-28 09:00:00	NQ	Futures	16788.0	16828.6	16692.87	16745.72	103663.0
2023-08-28 10:00:00	NQ	Futures	16746.0	16795.51	16686.48	16724.03	92628.0
2023-08-28 11:00:00	NQ	Futures	16724.58	16732.37	16669.51	16706.23	66933.0
2023-08-28 12:00:00	NQ	Futures	16706.5	16771.03	16680.08	16768.25	47429.0
2023-08-28 13:00:00	NQ	Futures	16768.53	16804.68	16686.48	16698.16	63055.0
2023-08-28 14:00:00	NQ	Futures	16698.99	16749.61	16693.71	16743.77	44563.0
2023-08-28 15:00:00	NQ	Futures	16743.77	16810.52	16720.97	16788.27	68286.0
2023-08-28 16:00:00	NQ	Futures	16789.39	16799.68	16782.99	16796.9	11086.0
2023-08-28 18:00:00	NQ	Futures	16797.73	16813.31	16797.73	16804.41	2962.0
2023-08-28 19:00:00	NQ	Futures	16806.07	16806.07	16791.89	16795.51	1873.0
2023-08-28 20:00:00	NQ	Futures	16795.23	16800.79	16775.48	16798.56	3182.0
2023-08-28 21:00:00	NQ	Futures	16798.29	16818.03	16784.38	16786.05	4194.0
2023-08-28 22:00:00	NQ	Futures	16785.49	16805.24	16785.21	16804.41	3158.0
2023-08-28 23:00:00	NQ	Futures	16804.68	16816.64	16802.18	16812.47	2587.0
2023-08-28 00:00:00	YM	Futures	37703.2	37719.6	37703.2	37715.2	390.0
2023-08-28 01:00:00	YM	Futures	37715.2	37759.1	37705.4	37756.9	1380.0
2023-08-28 02:00:00	YM	Futures	37755.8	37773.3	37743.7	37761.3	1471.0
2023-08-28 03:00:00	YM	Futures	37759.1	37778.8	37721.8	37731.7	2266.0

> showing 50 of 1,929 rows — these rows as CSV

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