PREVIEW / futures_1hour / 2022-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-09.parquet
  size:    72 KB
  rows:    2,113

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
2022-05-09 00:00:00	ES	Futures	4626.03	4626.59	4619.51	4620.64	4559.0
2022-05-09 01:00:00	ES	Futures	4620.93	4626.88	4614.69	4614.97	9479.0
2022-05-09 02:00:00	ES	Futures	4614.97	4633.4	4614.69	4629.15	13507.0
2022-05-09 03:00:00	ES	Futures	4628.86	4641.05	4612.99	4615.26	27906.0
2022-05-09 04:00:00	ES	Futures	4615.26	4617.81	4593.15	4607.32	28369.0
2022-05-09 05:00:00	ES	Futures	4607.04	4613.84	4591.73	4598.25	30106.0
2022-05-09 06:00:00	ES	Futures	4598.53	4600.52	4573.31	4578.41	43112.0
2022-05-09 07:00:00	ES	Futures	4578.69	4595.13	4570.19	4592.3	38440.0
2022-05-09 08:00:00	ES	Futures	4592.01	4605.05	4583.23	4597.97	56426.0
2022-05-09 09:00:00	ES	Futures	4597.97	4613.27	4577.28	4599.38	252652.0
2022-05-09 10:00:00	ES	Futures	4599.38	4601.94	4547.8	4551.2	304749.0
2022-05-09 11:00:00	ES	Futures	4550.92	4568.49	4532.21	4561.69	240624.0
2022-05-09 12:00:00	ES	Futures	4561.97	4586.06	4547.51	4548.65	183328.0
2022-05-09 13:00:00	ES	Futures	4548.36	4562.54	4533.06	4546.38	147601.0
2022-05-09 14:00:00	ES	Futures	4546.1	4558.85	4529.94	4555.17	161515.0
2022-05-09 15:00:00	ES	Futures	4555.17	4569.62	4501.03	4520.59	358622.0
2022-05-09 16:00:00	ES	Futures	4520.87	4536.18	4518.6	4523.14	73975.0
2022-05-09 18:00:00	ES	Futures	4527.39	4537.31	4526.26	4535.61	9924.0
2022-05-09 19:00:00	ES	Futures	4535.33	4536.18	4524.84	4534.19	7170.0
2022-05-09 20:00:00	ES	Futures	4534.19	4535.61	4491.68	4504.72	31352.0
2022-05-09 21:00:00	ES	Futures	4504.72	4532.21	4499.33	4528.81	25290.0
2022-05-09 22:00:00	ES	Futures	4529.09	4545.53	4525.12	4540.15	19195.0
2022-05-09 23:00:00	ES	Futures	4540.43	4546.38	4534.19	4546.1	11862.0
2022-05-09 00:00:00	NQ	Futures	14609.81	14609.81	14576.18	14584.29	2554.0
2022-05-09 01:00:00	NQ	Futures	14584.0	14602.85	14557.91	14561.97	4864.0
2022-05-09 02:00:00	NQ	Futures	14561.39	14619.38	14559.07	14604.3	6587.0
2022-05-09 03:00:00	NQ	Futures	14603.14	14642.58	14529.49	14539.64	14454.0
2022-05-09 04:00:00	NQ	Futures	14541.09	14549.21	14451.2	14494.11	17146.0
2022-05-09 05:00:00	NQ	Futures	14491.21	14521.66	14419.3	14447.43	15809.0
2022-05-09 06:00:00	NQ	Futures	14448.59	14459.61	14345.65	14368.55	18651.0
2022-05-09 07:00:00	NQ	Futures	14368.84	14411.76	14317.52	14397.84	21801.0
2022-05-09 08:00:00	NQ	Futures	14397.26	14467.72	14367.1	14433.51	24642.0
2022-05-09 09:00:00	NQ	Futures	14432.93	14563.42	14405.38	14443.08	100415.0
2022-05-09 10:00:00	NQ	Futures	14442.79	14458.16	14257.78	14270.54	116645.0
2022-05-09 11:00:00	NQ	Futures	14269.96	14334.92	14195.15	14296.93	86414.0
2022-05-09 12:00:00	NQ	Futures	14295.77	14405.38	14234.3	14252.27	70218.0
2022-05-09 13:00:00	NQ	Futures	14251.4	14305.05	14180.07	14216.32	59236.0
2022-05-09 14:00:00	NQ	Futures	14216.32	14268.51	14162.96	14260.39	64983.0
2022-05-09 15:00:00	NQ	Futures	14260.68	14312.01	14075.68	14147.01	111558.0
2022-05-09 16:00:00	NQ	Futures	14146.72	14207.04	14144.11	14157.16	22331.0
2022-05-09 18:00:00	NQ	Futures	14157.74	14211.68	14157.74	14199.5	4836.0
2022-05-09 19:00:00	NQ	Futures	14199.79	14203.85	14162.09	14191.96	3033.0
2022-05-09 20:00:00	NQ	Futures	14191.38	14198.92	14037.4	14099.46	11697.0
2022-05-09 21:00:00	NQ	Futures	14100.04	14199.5	14087.86	14188.77	8818.0
2022-05-09 22:00:00	NQ	Futures	14189.93	14273.73	14181.81	14250.82	8480.0
2022-05-09 23:00:00	NQ	Futures	14252.85	14280.69	14220.09	14276.05	5805.0
2022-05-09 00:00:00	YM	Futures	36631.5	36642.8	36597.7	36606.7	850.0
2022-05-09 01:00:00	YM	Futures	36608.9	36647.3	36567.2	36572.9	1429.0
2022-05-09 02:00:00	YM	Futures	36568.4	36709.3	36566.1	36677.7	2294.0
2022-05-09 03:00:00	YM	Futures	36674.3	36779.2	36593.2	36608.9	4259.0

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

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