PREVIEW / futures_1hour / 2023-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-30.parquet
  size:    67 KB
  rows:    2,095

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-01-30 00:00:00	ES	Futures	4554.51	4554.51	4548.92	4551.72	8610.0
2023-01-30 01:00:00	ES	Futures	4551.44	4554.23	4548.08	4550.04	6853.0
2023-01-30 02:00:00	ES	Futures	4550.32	4550.88	4541.37	4543.89	13838.0
2023-01-30 03:00:00	ES	Futures	4543.89	4543.89	4527.39	4532.7	34188.0
2023-01-30 04:00:00	ES	Futures	4532.7	4538.85	4522.92	4528.51	28044.0
2023-01-30 05:00:00	ES	Futures	4528.79	4531.86	4525.43	4530.74	14836.0
2023-01-30 06:00:00	ES	Futures	4530.46	4531.3	4518.44	4523.47	25083.0
2023-01-30 07:00:00	ES	Futures	4523.2	4530.46	4523.2	4528.51	28090.0
2023-01-30 08:00:00	ES	Futures	4528.79	4534.1	4525.71	4532.42	34208.0
2023-01-30 09:00:00	ES	Futures	4532.42	4554.79	4530.19	4551.99	194335.0
2023-01-30 10:00:00	ES	Futures	4551.99	4560.94	4524.59	4536.62	264218.0
2023-01-30 11:00:00	ES	Futures	4536.9	4546.68	4525.43	4538.85	193552.0
2023-01-30 12:00:00	ES	Futures	4538.85	4541.65	4524.59	4526.27	126041.0
2023-01-30 13:00:00	ES	Futures	4526.55	4538.01	4522.08	4528.23	151979.0
2023-01-30 14:00:00	ES	Futures	4528.23	4530.19	4513.41	4517.88	160569.0
2023-01-30 15:00:00	ES	Futures	4517.88	4523.47	4506.7	4510.89	332939.0
2023-01-30 16:00:00	ES	Futures	4510.89	4520.12	4510.89	4518.16	63324.0
2023-01-30 18:00:00	ES	Futures	4517.6	4522.64	4515.37	4522.36	5930.0
2023-01-30 19:00:00	ES	Futures	4522.36	4522.92	4516.48	4519.84	7243.0
2023-01-30 20:00:00	ES	Futures	4519.84	4521.52	4513.41	4518.72	8974.0
2023-01-30 21:00:00	ES	Futures	4518.44	4520.68	4514.81	4515.37	5666.0
2023-01-30 22:00:00	ES	Futures	4515.65	4516.48	4503.62	4504.46	13506.0
2023-01-30 23:00:00	ES	Futures	4504.74	4507.82	4503.62	4507.26	5612.0
2023-01-30 00:00:00	NQ	Futures	13859.7	13859.7	13830.11	13849.17	4556.0
2023-01-30 01:00:00	NQ	Futures	13848.89	13859.7	13834.38	13843.48	3578.0
2023-01-30 02:00:00	NQ	Futures	13844.05	13848.03	13802.51	13810.2	7793.0
2023-01-30 03:00:00	NQ	Futures	13810.2	13810.2	13751.31	13760.69	14899.0
2023-01-30 04:00:00	NQ	Futures	13761.26	13791.13	13718.87	13739.36	16241.0
2023-01-30 05:00:00	NQ	Futures	13739.64	13750.17	13725.7	13744.76	7875.0
2023-01-30 06:00:00	NQ	Futures	13744.76	13747.61	13700.1	13725.13	11644.0
2023-01-30 07:00:00	NQ	Futures	13724.56	13758.7	13724.56	13751.02	11007.0
2023-01-30 08:00:00	NQ	Futures	13751.31	13767.52	13729.11	13753.3	16658.0
2023-01-30 09:00:00	NQ	Futures	13753.01	13805.36	13723.42	13791.99	79822.0
2023-01-30 10:00:00	NQ	Futures	13791.7	13818.73	13635.8	13686.44	108988.0
2023-01-30 11:00:00	NQ	Futures	13686.72	13736.8	13667.38	13724.28	70562.0
2023-01-30 12:00:00	NQ	Futures	13724.85	13733.67	13661.97	13679.04	41971.0
2023-01-30 13:00:00	NQ	Futures	13679.33	13721.15	13652.87	13679.9	45371.0
2023-01-30 14:00:00	NQ	Futures	13680.18	13694.12	13636.37	13656.0	49493.0
2023-01-30 15:00:00	NQ	Futures	13656.0	13677.91	13610.2	13624.14	89474.0
2023-01-30 16:00:00	NQ	Futures	13624.14	13652.3	13622.43	13642.91	15415.0
2023-01-30 18:00:00	NQ	Futures	13637.51	13659.98	13633.24	13658.56	3280.0
2023-01-30 19:00:00	NQ	Futures	13658.56	13660.84	13638.36	13650.31	3929.0
2023-01-30 20:00:00	NQ	Futures	13650.31	13660.27	13629.83	13645.76	4480.0
2023-01-30 21:00:00	NQ	Futures	13645.19	13652.02	13632.39	13633.81	2871.0
2023-01-30 22:00:00	NQ	Futures	13634.09	13637.22	13568.38	13578.33	9122.0
2023-01-30 23:00:00	NQ	Futures	13578.33	13585.73	13566.67	13585.16	3765.0
2023-01-30 00:00:00	YM	Futures	37838.7	37838.7	37807.5	37818.7	1011.0
2023-01-30 01:00:00	YM	Futures	37817.6	37834.3	37799.7	37812.0	659.0
2023-01-30 02:00:00	YM	Futures	37810.9	37815.3	37760.7	37780.8	1448.0
2023-01-30 03:00:00	YM	Futures	37779.7	37779.7	37666.0	37728.4	4076.0

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

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