PREVIEW / futures_1hour / 2023-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-01.parquet
  size:    55 KB
  rows:    1,626

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-01 00:00:00	ES	Futures	4963.72	4966.19	4963.72	4965.09	3152.0
2023-09-01 01:00:00	ES	Futures	4965.09	4965.91	4962.34	4962.89	3021.0
2023-09-01 02:00:00	ES	Futures	4962.89	4964.26	4956.03	4961.24	9687.0
2023-09-01 03:00:00	ES	Futures	4961.24	4971.95	4958.77	4970.58	29099.0
2023-09-01 04:00:00	ES	Futures	4970.58	4971.4	4967.28	4968.66	9399.0
2023-09-01 05:00:00	ES	Futures	4968.66	4974.97	4968.38	4972.5	11572.0
2023-09-01 06:00:00	ES	Futures	4972.22	4977.17	4969.48	4975.52	14107.0
2023-09-01 07:00:00	ES	Futures	4975.52	4979.09	4973.6	4975.79	15707.0
2023-09-01 08:00:00	ES	Futures	4975.79	4991.99	4966.46	4987.6	95973.0
2023-09-01 09:00:00	ES	Futures	4987.87	4993.64	4965.09	4978.26	234964.0
2023-09-01 10:00:00	ES	Futures	4978.26	4986.5	4959.87	4963.44	277054.0
2023-09-01 11:00:00	ES	Futures	4963.44	4966.73	4949.17	4951.64	154704.0
2023-09-01 12:00:00	ES	Futures	4951.36	4963.99	4949.44	4960.97	119135.0
2023-09-01 13:00:00	ES	Futures	4960.97	4962.89	4954.66	4959.87	65281.0
2023-09-01 14:00:00	ES	Futures	4959.87	4961.52	4951.36	4958.77	74252.0
2023-09-01 15:00:00	ES	Futures	4958.77	4967.28	4956.85	4966.19	160826.0
2023-09-01 16:00:00	ES	Futures	4966.46	4966.73	4961.24	4962.07	46601.0
2023-09-01 00:00:00	NQ	Futures	17296.98	17303.37	17295.86	17298.64	1587.0
2023-09-01 01:00:00	NQ	Futures	17298.64	17298.64	17285.57	17288.63	1837.0
2023-09-01 02:00:00	NQ	Futures	17289.19	17295.03	17246.36	17267.22	6527.0
2023-09-01 03:00:00	NQ	Futures	17267.22	17316.44	17256.92	17310.05	10343.0
2023-09-01 04:00:00	NQ	Futures	17309.77	17312.55	17289.47	17293.36	5795.0
2023-09-01 05:00:00	NQ	Futures	17293.64	17320.34	17290.58	17307.54	5138.0
2023-09-01 06:00:00	NQ	Futures	17308.38	17320.06	17296.98	17314.22	5449.0
2023-09-01 07:00:00	NQ	Futures	17314.5	17334.8	17308.94	17321.73	6930.0
2023-09-01 08:00:00	NQ	Futures	17321.45	17415.18	17306.71	17397.1	41013.0
2023-09-01 09:00:00	NQ	Futures	17397.66	17423.53	17242.74	17310.33	112792.0
2023-09-01 10:00:00	NQ	Futures	17306.15	17347.32	17224.11	17238.57	112722.0
2023-09-01 11:00:00	NQ	Futures	17238.85	17275.0	17195.18	17202.97	64863.0
2023-09-01 12:00:00	NQ	Futures	17202.69	17270.0	17192.95	17261.65	50194.0
2023-09-01 13:00:00	NQ	Futures	17261.65	17268.61	17218.82	17248.02	32045.0
2023-09-01 14:00:00	NQ	Futures	17247.75	17254.42	17199.07	17234.67	33423.0
2023-09-01 15:00:00	NQ	Futures	17234.12	17274.45	17228.28	17266.38	50639.0
2023-09-01 16:00:00	NQ	Futures	17266.1	17270.0	17254.42	17256.65	10988.0
2023-09-01 00:00:00	YM	Futures	38165.5	38180.8	38164.4	38178.7	632.0
2023-09-01 01:00:00	YM	Futures	38178.7	38179.8	38158.9	38161.1	569.0
2023-09-01 02:00:00	YM	Futures	38162.2	38168.8	38132.6	38167.7	2252.0
2023-09-01 03:00:00	YM	Futures	38167.7	38219.2	38153.5	38214.8	4685.0
2023-09-01 04:00:00	YM	Futures	38214.8	38223.6	38199.5	38213.7	1802.0
2023-09-01 05:00:00	YM	Futures	38214.8	38257.5	38213.7	38242.2	2312.0
2023-09-01 06:00:00	YM	Futures	38242.2	38269.6	38219.2	38251.0	2449.0
2023-09-01 07:00:00	YM	Futures	38252.1	38270.7	38242.2	38252.1	3179.0
2023-09-01 08:00:00	YM	Futures	38252.1	38322.2	38218.1	38289.3	10529.0
2023-09-01 09:00:00	YM	Futures	38290.4	38373.7	38221.4	38321.1	30964.0
2023-09-01 10:00:00	YM	Futures	38314.5	38351.8	38183.0	38210.4	30050.0
2023-09-01 11:00:00	YM	Futures	38210.4	38228.0	38082.2	38104.2	15424.0
2023-09-01 12:00:00	YM	Futures	38103.1	38174.3	38087.7	38153.5	9509.0
2023-09-01 13:00:00	YM	Futures	38152.4	38176.5	38133.7	38166.6	5034.0
2023-09-01 14:00:00	YM	Futures	38166.6	38178.7	38123.9	38174.3	6075.0
2023-09-01 15:00:00	YM	Futures	38174.3	38236.7	38163.3	38221.4	11985.0

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

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