PREVIEW / futures_1hour / 2022-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-15.parquet
  size:    66 KB
  rows:    2,027

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-09-15 00:00:00	ES	Futures	4475.06	4476.19	4471.4	4473.65	3908.0
2022-09-15 01:00:00	ES	Futures	4473.65	4474.5	4468.3	4471.4	6105.0
2022-09-15 02:00:00	ES	Futures	4471.4	4475.91	4467.73	4471.96	7704.0
2022-09-15 03:00:00	ES	Futures	4471.96	4482.95	4469.7	4480.98	12932.0
2022-09-15 04:00:00	ES	Futures	4480.98	4484.36	4468.86	4474.5	14113.0
2022-09-15 05:00:00	ES	Futures	4474.5	4480.98	4470.55	4477.88	14315.0
2022-09-15 06:00:00	ES	Futures	4477.88	4479.85	4455.61	4462.66	23729.0
2022-09-15 07:00:00	ES	Futures	4462.38	4473.65	4460.68	4463.5	21782.0
2022-09-15 08:00:00	ES	Futures	4463.22	4471.4	4452.23	4464.35	75874.0
2022-09-15 09:00:00	ES	Futures	4464.35	4477.88	4443.21	4475.62	271661.0
2022-09-15 10:00:00	ES	Futures	4475.91	4484.93	4429.68	4432.21	367589.0
2022-09-15 11:00:00	ES	Futures	4432.21	4446.59	4421.22	4427.98	290071.0
2022-09-15 12:00:00	ES	Futures	4427.98	4441.52	4419.53	4441.23	207276.0
2022-09-15 13:00:00	ES	Futures	4441.23	4469.14	4441.23	4449.97	254090.0
2022-09-15 14:00:00	ES	Futures	4449.97	4450.54	4425.45	4428.83	227287.0
2022-09-15 15:00:00	ES	Futures	4428.83	4430.24	4403.18	4418.68	385630.0
2022-09-15 16:00:00	ES	Futures	4418.68	4429.39	4403.74	4408.82	76320.0
2022-09-15 18:00:00	ES	Futures	4402.05	4403.18	4383.45	4394.44	19250.0
2022-09-15 19:00:00	ES	Futures	4394.72	4395.0	4385.7	4390.77	8751.0
2022-09-15 20:00:00	ES	Futures	4391.06	4396.98	4389.65	4390.77	11960.0
2022-09-15 21:00:00	ES	Futures	4391.06	4395.0	4389.93	4390.77	9015.0
2022-09-15 22:00:00	ES	Futures	4390.49	4394.72	4388.8	4391.9	7650.0
2022-09-15 23:00:00	ES	Futures	4391.9	4392.47	4387.39	4387.67	6652.0
2022-09-15 00:00:00	NQ	Futures	14054.83	14059.43	14037.31	14047.94	2809.0
2022-09-15 01:00:00	NQ	Futures	14048.8	14052.82	14026.68	14037.31	3506.0
2022-09-15 02:00:00	NQ	Futures	14037.02	14053.11	14025.81	14038.74	3533.0
2022-09-15 03:00:00	NQ	Futures	14038.74	14077.53	14033.57	14072.36	6867.0
2022-09-15 04:00:00	NQ	Futures	14071.5	14082.13	14024.09	14042.19	7996.0
2022-09-15 05:00:00	NQ	Futures	14042.77	14063.74	14026.68	14054.83	5703.0
2022-09-15 06:00:00	NQ	Futures	14054.83	14065.18	13971.51	13996.51	9169.0
2022-09-15 07:00:00	NQ	Futures	13995.93	14040.18	13985.59	13997.37	9138.0
2022-09-15 08:00:00	NQ	Futures	13996.79	14025.53	13953.41	14000.24	28722.0
2022-09-15 09:00:00	NQ	Futures	14000.24	14044.49	13918.35	14025.53	86099.0
2022-09-15 10:00:00	NQ	Futures	14025.81	14060.58	13804.0	13806.01	121222.0
2022-09-15 11:00:00	NQ	Futures	13806.3	13873.82	13777.85	13818.94	91260.0
2022-09-15 12:00:00	NQ	Futures	13819.23	13873.82	13789.06	13872.38	59513.0
2022-09-15 13:00:00	NQ	Futures	13872.67	13964.9	13872.38	13896.52	74308.0
2022-09-15 14:00:00	NQ	Futures	13896.8	13898.24	13805.15	13818.08	58649.0
2022-09-15 15:00:00	NQ	Futures	13818.36	13826.98	13719.81	13796.53	101076.0
2022-09-15 16:00:00	NQ	Futures	13796.53	13833.88	13740.21	13760.61	22634.0
2022-09-15 18:00:00	NQ	Futures	13735.9	13741.07	13666.08	13712.92	9164.0
2022-09-15 19:00:00	NQ	Futures	13712.34	13714.06	13682.46	13694.81	3676.0
2022-09-15 20:00:00	NQ	Futures	13695.1	13716.94	13682.46	13684.76	7144.0
2022-09-15 21:00:00	NQ	Futures	13685.04	13705.16	13680.45	13689.07	4166.0
2022-09-15 22:00:00	NQ	Futures	13689.35	13701.42	13683.9	13692.23	3143.0
2022-09-15 23:00:00	NQ	Futures	13693.09	13694.53	13677.86	13680.16	3214.0
2022-09-15 00:00:00	YM	Futures	35096.7	35103.5	35072.0	35085.5	522.0
2022-09-15 01:00:00	YM	Futures	35088.9	35090.0	35053.0	35073.2	759.0
2022-09-15 02:00:00	YM	Futures	35070.9	35102.3	35049.6	35081.0	927.0
2022-09-15 03:00:00	YM	Futures	35078.8	35159.6	35064.2	35142.7	1875.0

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

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