PREVIEW / futures_1hour / 2022-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-11-23.parquet
  size:    67 KB
  rows:    2,001

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-11-23 00:00:00	ES	Futures	4519.04	4522.98	4518.47	4522.14	4201.0
2022-11-23 01:00:00	ES	Futures	4522.14	4524.11	4517.06	4521.86	4989.0
2022-11-23 02:00:00	ES	Futures	4521.86	4528.62	4517.91	4526.93	11773.0
2022-11-23 03:00:00	ES	Futures	4526.93	4527.77	4519.32	4522.42	26690.0
2022-11-23 04:00:00	ES	Futures	4522.7	4534.82	4519.88	4531.44	23109.0
2022-11-23 05:00:00	ES	Futures	4531.44	4531.72	4523.83	4526.08	9160.0
2022-11-23 06:00:00	ES	Futures	4526.37	4528.9	4522.42	4528.9	11294.0
2022-11-23 07:00:00	ES	Futures	4528.9	4531.16	4524.11	4528.62	12540.0
2022-11-23 08:00:00	ES	Futures	4528.34	4528.9	4512.55	4518.19	45571.0
2022-11-23 09:00:00	ES	Futures	4518.47	4543.0	4515.37	4537.64	140697.0
2022-11-23 10:00:00	ES	Futures	4537.92	4553.15	4529.47	4546.1	155865.0
2022-11-23 11:00:00	ES	Futures	4545.82	4550.61	4519.6	4525.8	132851.0
2022-11-23 12:00:00	ES	Futures	4525.8	4533.69	4513.96	4519.88	111718.0
2022-11-23 13:00:00	ES	Futures	4519.6	4535.39	4516.5	4532.85	75514.0
2022-11-23 14:00:00	ES	Futures	4532.85	4554.55	4524.11	4546.94	213849.0
2022-11-23 15:00:00	ES	Futures	4546.94	4554.84	4540.74	4549.2	173717.0
2022-11-23 16:00:00	ES	Futures	4549.2	4554.84	4546.94	4554.55	44328.0
2022-11-23 18:00:00	ES	Futures	4553.99	4556.53	4552.3	4556.25	4671.0
2022-11-23 19:00:00	ES	Futures	4556.53	4559.07	4554.84	4557.09	5355.0
2022-11-23 20:00:00	ES	Futures	4556.81	4559.35	4556.53	4557.94	4664.0
2022-11-23 21:00:00	ES	Futures	4557.66	4559.63	4555.4	4558.22	2811.0
2022-11-23 22:00:00	ES	Futures	4558.78	4559.07	4556.53	4557.09	2316.0
2022-11-23 23:00:00	ES	Futures	4557.09	4557.66	4555.12	4557.37	2399.0
2022-11-23 00:00:00	NQ	Futures	13479.32	13495.98	13475.87	13494.26	2154.0
2022-11-23 01:00:00	NQ	Futures	13494.83	13502.59	13479.32	13495.12	2647.0
2022-11-23 02:00:00	NQ	Futures	13494.55	13527.3	13479.61	13517.82	5360.0
2022-11-23 03:00:00	NQ	Futures	13517.82	13522.99	13491.96	13500.01	7412.0
2022-11-23 04:00:00	NQ	Futures	13500.29	13540.23	13493.4	13530.18	6024.0
2022-11-23 05:00:00	NQ	Futures	13530.18	13530.46	13502.88	13513.51	4768.0
2022-11-23 06:00:00	NQ	Futures	13514.09	13535.92	13499.43	13535.35	5164.0
2022-11-23 07:00:00	NQ	Futures	13535.35	13554.31	13516.67	13542.82	6646.0
2022-11-23 08:00:00	NQ	Futures	13541.38	13542.53	13490.53	13514.37	18626.0
2022-11-23 09:00:00	NQ	Futures	13514.37	13621.55	13498.86	13599.13	64900.0
2022-11-23 10:00:00	NQ	Futures	13599.42	13665.79	13563.79	13649.7	64421.0
2022-11-23 11:00:00	NQ	Futures	13649.99	13660.33	13522.99	13545.4	51765.0
2022-11-23 12:00:00	NQ	Futures	13545.12	13581.32	13494.83	13516.67	41161.0
2022-11-23 13:00:00	NQ	Futures	13516.38	13589.37	13506.9	13576.15	33669.0
2022-11-23 14:00:00	NQ	Futures	13576.44	13659.19	13540.23	13637.06	74106.0
2022-11-23 15:00:00	NQ	Futures	13636.49	13668.38	13606.32	13640.8	53996.0
2022-11-23 16:00:00	NQ	Futures	13640.51	13654.3	13635.91	13651.14	11065.0
2022-11-23 18:00:00	NQ	Futures	13651.43	13664.93	13645.97	13663.5	2147.0
2022-11-23 19:00:00	NQ	Futures	13663.78	13676.14	13662.92	13671.54	2754.0
2022-11-23 20:00:00	NQ	Futures	13671.54	13682.17	13668.67	13673.84	2479.0
2022-11-23 21:00:00	NQ	Futures	13674.13	13677.86	13664.36	13675.28	1381.0
2022-11-23 22:00:00	NQ	Futures	13676.14	13678.72	13667.81	13670.1	987.0
2022-11-23 23:00:00	NQ	Futures	13669.53	13671.83	13662.92	13671.25	945.0
2022-11-23 00:00:00	YM	Futures	38297.3	38323.2	38292.9	38315.3	779.0
2022-11-23 01:00:00	YM	Futures	38314.2	38327.6	38278.3	38307.4	863.0
2022-11-23 02:00:00	YM	Futures	38305.2	38347.8	38281.6	38333.3	1827.0
2022-11-23 03:00:00	YM	Futures	38332.1	38338.9	38274.9	38308.6	3625.0

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

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