PREVIEW / futures_1hour / 2023-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-08-31.parquet
  size:    64 KB
  rows:    1,982

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-31 00:00:00	ES	Futures	4971.68	4973.6	4971.4	4971.68	3524.0
2023-08-31 01:00:00	ES	Futures	4971.4	4972.22	4967.83	4971.68	7562.0
2023-08-31 02:00:00	ES	Futures	4971.95	4972.5	4968.38	4968.93	9064.0
2023-08-31 03:00:00	ES	Futures	4968.93	4976.07	4967.83	4975.52	21746.0
2023-08-31 04:00:00	ES	Futures	4975.52	4975.52	4971.68	4974.7	12978.0
2023-08-31 05:00:00	ES	Futures	4974.7	4975.52	4966.46	4968.93	18159.0
2023-08-31 06:00:00	ES	Futures	4968.66	4973.32	4968.66	4971.13	9340.0
2023-08-31 07:00:00	ES	Futures	4970.85	4982.11	4968.38	4980.19	21398.0
2023-08-31 08:00:00	ES	Futures	4980.19	4986.5	4975.79	4978.54	49735.0
2023-08-31 09:00:00	ES	Futures	4978.26	4981.83	4968.66	4980.46	161103.0
2023-08-31 10:00:00	ES	Futures	4980.46	4984.85	4973.6	4979.64	152009.0
2023-08-31 11:00:00	ES	Futures	4979.36	4979.64	4969.48	4974.7	125183.0
2023-08-31 12:00:00	ES	Futures	4974.7	4978.54	4957.68	4964.26	124569.0
2023-08-31 13:00:00	ES	Futures	4964.26	4974.42	4962.07	4970.03	93928.0
2023-08-31 14:00:00	ES	Futures	4970.03	4977.99	4962.34	4963.17	108040.0
2023-08-31 15:00:00	ES	Futures	4963.17	4972.22	4955.21	4956.85	296606.0
2023-08-31 16:00:00	ES	Futures	4956.85	4962.34	4956.03	4960.15	90454.0
2023-08-31 18:00:00	ES	Futures	4959.6	4960.7	4956.58	4959.6	4564.0
2023-08-31 19:00:00	ES	Futures	4959.32	4962.07	4959.05	4961.52	3157.0
2023-08-31 20:00:00	ES	Futures	4961.52	4964.26	4960.15	4962.62	7317.0
2023-08-31 21:00:00	ES	Futures	4962.62	4966.19	4961.24	4963.99	8431.0
2023-08-31 22:00:00	ES	Futures	4963.99	4965.09	4962.34	4962.89	3766.0
2023-08-31 23:00:00	ES	Futures	4962.62	4963.72	4962.07	4963.72	3161.0
2023-08-31 00:00:00	NQ	Futures	17256.92	17264.71	17251.36	17252.47	2987.0
2023-08-31 01:00:00	NQ	Futures	17252.2	17253.31	17229.11	17251.36	6855.0
2023-08-31 02:00:00	NQ	Futures	17251.08	17254.7	17232.45	17233.28	6126.0
2023-08-31 03:00:00	NQ	Futures	17232.73	17262.77	17226.05	17259.15	13606.0
2023-08-31 04:00:00	NQ	Futures	17259.43	17263.88	17242.46	17251.08	8186.0
2023-08-31 05:00:00	NQ	Futures	17251.64	17254.7	17199.63	17207.14	13952.0
2023-08-31 06:00:00	NQ	Futures	17206.86	17234.67	17206.58	17223.27	6180.0
2023-08-31 07:00:00	NQ	Futures	17222.71	17277.23	17213.26	17267.49	11456.0
2023-08-31 08:00:00	NQ	Futures	17267.49	17293.36	17236.06	17253.59	21656.0
2023-08-31 09:00:00	NQ	Futures	17254.14	17319.78	17223.27	17318.11	93428.0
2023-08-31 10:00:00	NQ	Futures	17318.39	17362.89	17285.02	17335.91	87909.0
2023-08-31 11:00:00	NQ	Futures	17335.64	17345.37	17287.8	17316.17	58501.0
2023-08-31 12:00:00	NQ	Futures	17316.44	17336.19	17236.34	17275.0	59858.0
2023-08-31 13:00:00	NQ	Futures	17275.84	17328.68	17265.55	17307.82	42797.0
2023-08-31 14:00:00	NQ	Futures	17307.82	17350.93	17298.37	17303.65	44168.0
2023-08-31 15:00:00	NQ	Futures	17303.93	17348.15	17278.34	17280.01	65535.0
2023-08-31 16:00:00	NQ	Futures	17280.01	17299.48	17278.06	17284.74	16254.0
2023-08-31 18:00:00	NQ	Futures	17281.96	17284.18	17269.16	17278.06	2566.0
2023-08-31 19:00:00	NQ	Futures	17277.78	17288.08	17275.0	17284.74	1709.0
2023-08-31 20:00:00	NQ	Futures	17285.29	17295.86	17279.18	17291.69	2587.0
2023-08-31 21:00:00	NQ	Futures	17291.97	17310.33	17288.91	17300.31	4341.0
2023-08-31 22:00:00	NQ	Futures	17299.76	17305.04	17293.08	17294.75	1972.0
2023-08-31 23:00:00	NQ	Futures	17293.92	17298.09	17289.47	17296.42	1539.0
2023-08-31 00:00:00	YM	Futures	38371.5	38384.6	38367.1	38373.7	1054.0
2023-08-31 01:00:00	YM	Futures	38372.6	38386.8	38358.3	38376.9	2461.0
2023-08-31 02:00:00	YM	Futures	38378.0	38383.5	38359.4	38372.6	2395.0
2023-08-31 03:00:00	YM	Futures	38371.5	38433.9	38367.1	38428.4	4959.0

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

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