PREVIEW / futures_1hour / 2023-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-05.parquet
  size:    65 KB
  rows:    2,011

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-05 00:00:00	ES	Futures	4956.3	4959.05	4956.03	4958.22	2093.0
2023-09-05 01:00:00	ES	Futures	4958.5	4959.87	4955.21	4956.3	5119.0
2023-09-05 02:00:00	ES	Futures	4956.3	4957.4	4951.36	4953.83	9997.0
2023-09-05 03:00:00	ES	Futures	4953.83	4954.93	4945.6	4947.79	27953.0
2023-09-05 04:00:00	ES	Futures	4947.52	4953.28	4941.21	4951.64	24545.0
2023-09-05 05:00:00	ES	Futures	4951.91	4958.77	4951.09	4956.03	16385.0
2023-09-05 06:00:00	ES	Futures	4956.03	4960.7	4954.93	4957.4	12403.0
2023-09-05 07:00:00	ES	Futures	4957.4	4960.15	4952.19	4958.22	15612.0
2023-09-05 08:00:00	ES	Futures	4958.22	4963.44	4949.17	4962.34	45317.0
2023-09-05 09:00:00	ES	Futures	4962.34	4963.17	4945.32	4947.79	174784.0
2023-09-05 10:00:00	ES	Futures	4947.79	4957.13	4943.13	4953.56	201390.0
2023-09-05 11:00:00	ES	Futures	4953.56	4963.99	4950.81	4954.66	144818.0
2023-09-05 12:00:00	ES	Futures	4954.66	4960.15	4954.11	4955.75	75198.0
2023-09-05 13:00:00	ES	Futures	4955.48	4956.03	4946.42	4952.46	89984.0
2023-09-05 14:00:00	ES	Futures	4952.46	4959.32	4948.62	4959.05	81869.0
2023-09-05 15:00:00	ES	Futures	4958.77	4959.32	4942.85	4943.68	203338.0
2023-09-05 16:00:00	ES	Futures	4943.68	4946.15	4940.38	4941.75	51432.0
2023-09-05 18:00:00	ES	Futures	4941.21	4943.68	4940.11	4943.4	3262.0
2023-09-05 19:00:00	ES	Futures	4943.4	4943.68	4941.48	4942.85	2549.0
2023-09-05 20:00:00	ES	Futures	4942.85	4945.32	4941.48	4943.68	5484.0
2023-09-05 21:00:00	ES	Futures	4943.68	4944.22	4937.09	4937.91	7731.0
2023-09-05 22:00:00	ES	Futures	4937.64	4943.4	4937.64	4940.93	6285.0
2023-09-05 23:00:00	ES	Futures	4940.93	4940.93	4937.36	4938.46	4778.0
2023-09-05 00:00:00	NQ	Futures	17243.85	17254.42	17242.46	17252.75	1582.0
2023-09-05 01:00:00	NQ	Futures	17252.75	17259.15	17239.68	17243.85	3216.0
2023-09-05 02:00:00	NQ	Futures	17244.13	17248.86	17218.26	17228.83	5076.0
2023-09-05 03:00:00	NQ	Futures	17228.28	17241.63	17190.17	17201.85	11924.0
2023-09-05 04:00:00	NQ	Futures	17201.3	17206.58	17153.18	17189.34	13215.0
2023-09-05 05:00:00	NQ	Futures	17189.9	17217.99	17183.5	17208.53	7109.0
2023-09-05 06:00:00	NQ	Futures	17208.25	17232.17	17200.74	17215.21	6646.0
2023-09-05 07:00:00	NQ	Futures	17215.48	17221.88	17182.11	17212.98	9405.0
2023-09-05 08:00:00	NQ	Futures	17212.98	17243.3	17173.76	17233.84	18689.0
2023-09-05 09:00:00	NQ	Futures	17234.12	17251.92	17183.22	17202.41	84200.0
2023-09-05 10:00:00	NQ	Futures	17202.69	17288.91	17180.44	17265.27	93894.0
2023-09-05 11:00:00	NQ	Futures	17265.27	17329.8	17247.47	17266.1	66629.0
2023-09-05 12:00:00	NQ	Futures	17266.1	17314.78	17263.04	17301.98	37502.0
2023-09-05 13:00:00	NQ	Futures	17301.98	17307.54	17270.28	17301.43	34810.0
2023-09-05 14:00:00	NQ	Futures	17301.7	17340.64	17292.25	17338.97	34374.0
2023-09-05 15:00:00	NQ	Futures	17338.97	17339.81	17277.78	17282.23	58010.0
2023-09-05 16:00:00	NQ	Futures	17281.96	17287.8	17258.87	17263.6	12988.0
2023-09-05 18:00:00	NQ	Futures	17256.65	17272.22	17255.26	17271.11	1783.0
2023-09-05 19:00:00	NQ	Futures	17271.11	17273.89	17262.77	17268.33	1662.0
2023-09-05 20:00:00	NQ	Futures	17268.61	17280.84	17264.43	17272.5	2862.0
2023-09-05 21:00:00	NQ	Futures	17272.78	17275.28	17237.46	17239.4	4989.0
2023-09-05 22:00:00	NQ	Futures	17239.68	17264.43	17237.46	17256.65	3507.0
2023-09-05 23:00:00	NQ	Futures	17256.65	17256.65	17243.02	17246.08	2406.0
2023-09-05 00:00:00	YM	Futures	38143.6	38162.2	38141.4	38162.2	287.0
2023-09-05 01:00:00	YM	Futures	38161.1	38167.7	38139.2	38146.9	667.0
2023-09-05 02:00:00	YM	Futures	38146.9	38153.5	38110.7	38132.6	1813.0
2023-09-05 03:00:00	YM	Futures	38133.7	38133.7	38079.0	38095.4	3764.0

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

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