PREVIEW / futures_1hour / 2023-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-03.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-07-03 00:00:00	ES	Futures	4928.85	4929.95	4927.48	4928.85	2453.0
2023-07-03 01:00:00	ES	Futures	4928.85	4930.22	4927.48	4927.48	3974.0
2023-07-03 02:00:00	ES	Futures	4927.75	4928.03	4924.73	4926.38	9460.0
2023-07-03 03:00:00	ES	Futures	4926.38	4929.13	4926.11	4928.85	16322.0
2023-07-03 04:00:00	ES	Futures	4928.85	4932.7	4928.3	4931.32	15020.0
2023-07-03 05:00:00	ES	Futures	4931.05	4931.32	4928.58	4929.4	8488.0
2023-07-03 06:00:00	ES	Futures	4929.4	4933.79	4926.11	4929.68	13367.0
2023-07-03 07:00:00	ES	Futures	4929.68	4930.5	4923.91	4924.46	13958.0
2023-07-03 08:00:00	ES	Futures	4924.73	4926.11	4922.26	4924.19	24703.0
2023-07-03 09:00:00	ES	Futures	4924.46	4928.58	4918.7	4927.48	126059.0
2023-07-03 10:00:00	ES	Futures	4927.75	4930.22	4922.26	4924.46	126342.0
2023-07-03 11:00:00	ES	Futures	4924.73	4930.22	4924.19	4929.13	75406.0
2023-07-03 12:00:00	ES	Futures	4929.13	4934.62	4928.3	4932.7	99070.0
2023-07-03 13:00:00	ES	Futures	4932.97	4933.24	4929.13	4932.42	23001.0
2023-07-03 18:00:00	ES	Futures	4932.42	4932.42	4926.93	4929.4	2284.0
2023-07-03 19:00:00	ES	Futures	4929.4	4930.5	4927.21	4928.03	1690.0
2023-07-03 20:00:00	ES	Futures	4928.03	4931.6	4926.93	4930.5	3282.0
2023-07-03 21:00:00	ES	Futures	4930.5	4931.87	4928.3	4931.6	2457.0
2023-07-03 22:00:00	ES	Futures	4931.6	4931.87	4929.4	4930.22	1583.0
2023-07-03 23:00:00	ES	Futures	4930.5	4932.7	4930.22	4931.6	1723.0
2023-07-03 00:00:00	NQ	Futures	17079.48	17085.32	17076.42	17081.15	1943.0
2023-07-03 01:00:00	NQ	Futures	17080.87	17092.83	17075.03	17080.87	2699.0
2023-07-03 02:00:00	NQ	Futures	17080.87	17083.37	17067.24	17078.36	3865.0
2023-07-03 03:00:00	NQ	Futures	17078.36	17095.33	17075.03	17089.77	5800.0
2023-07-03 04:00:00	NQ	Futures	17090.32	17123.98	17088.93	17112.02	7986.0
2023-07-03 05:00:00	NQ	Futures	17112.02	17112.02	17099.78	17103.4	3809.0
2023-07-03 06:00:00	NQ	Futures	17103.12	17106.18	17071.97	17093.38	7590.0
2023-07-03 07:00:00	NQ	Futures	17093.11	17097.28	17061.95	17063.9	7606.0
2023-07-03 08:00:00	NQ	Futures	17064.18	17085.32	17056.67	17078.64	11791.0
2023-07-03 09:00:00	NQ	Futures	17078.36	17121.75	17063.07	17100.89	56984.0
2023-07-03 10:00:00	NQ	Futures	17103.4	17118.69	17033.31	17038.31	59069.0
2023-07-03 11:00:00	NQ	Futures	17038.87	17058.9	17030.53	17044.99	34630.0
2023-07-03 12:00:00	NQ	Futures	17045.27	17096.16	17039.43	17093.66	32221.0
2023-07-03 13:00:00	NQ	Futures	17093.66	17095.05	17077.81	17085.04	5445.0
2023-07-03 18:00:00	NQ	Futures	17085.04	17087.54	17061.12	17067.52	1481.0
2023-07-03 19:00:00	NQ	Futures	17066.96	17072.25	17059.73	17063.07	1210.0
2023-07-03 20:00:00	NQ	Futures	17063.35	17079.2	17059.73	17070.02	1862.0
2023-07-03 21:00:00	NQ	Futures	17069.46	17075.31	17059.73	17073.08	2270.0
2023-07-03 22:00:00	NQ	Futures	17072.25	17073.64	17065.01	17071.13	1163.0
2023-07-03 23:00:00	NQ	Futures	17071.13	17080.03	17070.58	17077.25	1147.0
2023-07-03 00:00:00	YM	Futures	37948.6	37949.7	37938.7	37946.4	519.0
2023-07-03 01:00:00	YM	Futures	37946.4	37948.6	37937.6	37939.8	524.0
2023-07-03 02:00:00	YM	Futures	37938.7	37938.7	37916.8	37925.6	1741.0
2023-07-03 03:00:00	YM	Futures	37926.7	37943.1	37920.1	37935.4	2183.0
2023-07-03 04:00:00	YM	Futures	37933.3	37933.3	37899.3	37911.3	2926.0
2023-07-03 05:00:00	YM	Futures	37911.3	37917.9	37882.9	37889.4	1407.0
2023-07-03 06:00:00	YM	Futures	37886.1	37927.8	37881.8	37899.3	2010.0
2023-07-03 07:00:00	YM	Futures	37900.4	37910.2	37870.8	37879.6	1844.0
2023-07-03 08:00:00	YM	Futures	37879.6	37888.3	37862.0	37875.2	3079.0
2023-07-03 09:00:00	YM	Futures	37874.1	37903.7	37807.3	37885.0	17942.0

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

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