PREVIEW / futures_1hour / 2023-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-22.parquet
  size:    55 KB
  rows:    1,631

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-09-22 00:00:00	ES	Futures	4757.16	4759.06	4756.34	4757.97	5769.0
2023-09-22 01:00:00	ES	Futures	4757.97	4760.96	4756.62	4759.33	11566.0
2023-09-22 02:00:00	ES	Futures	4759.33	4760.96	4757.43	4757.97	11954.0
2023-09-22 03:00:00	ES	Futures	4757.97	4762.32	4752.81	4754.17	38610.0
2023-09-22 04:00:00	ES	Futures	4754.17	4759.06	4750.64	4756.34	20775.0
2023-09-22 05:00:00	ES	Futures	4756.34	4762.32	4753.36	4761.23	16373.0
2023-09-22 06:00:00	ES	Futures	4760.96	4762.86	4756.89	4759.33	16413.0
2023-09-22 07:00:00	ES	Futures	4759.6	4760.69	4755.53	4759.88	16522.0
2023-09-22 08:00:00	ES	Futures	4759.88	4769.38	4759.88	4765.31	46392.0
2023-09-22 09:00:00	ES	Futures	4765.58	4767.21	4751.46	4760.15	191997.0
2023-09-22 10:00:00	ES	Futures	4760.15	4775.08	4754.72	4773.45	239265.0
2023-09-22 11:00:00	ES	Futures	4773.18	4778.34	4764.76	4765.03	145665.0
2023-09-22 12:00:00	ES	Futures	4765.31	4774.81	4762.32	4770.47	92057.0
2023-09-22 13:00:00	ES	Futures	4770.47	4771.28	4746.3	4750.64	161452.0
2023-09-22 14:00:00	ES	Futures	4750.37	4752.81	4738.97	4744.94	157576.0
2023-09-22 15:00:00	ES	Futures	4744.67	4768.56	4732.99	4737.61	349248.0
2023-09-22 16:00:00	ES	Futures	4737.61	4743.04	4736.79	4738.97	67706.0
2023-09-22 00:00:00	NQ	Futures	16365.59	16375.75	16361.75	16371.63	2671.0
2023-09-22 01:00:00	NQ	Futures	16371.36	16385.92	16365.32	16374.38	4486.0
2023-09-22 02:00:00	NQ	Futures	16374.66	16385.92	16365.59	16376.85	5086.0
2023-09-22 03:00:00	NQ	Futures	16376.58	16400.2	16359.27	16374.66	13812.0
2023-09-22 04:00:00	NQ	Futures	16375.2	16396.08	16362.3	16388.39	8680.0
2023-09-22 05:00:00	NQ	Futures	16388.39	16409.54	16375.48	16405.69	6551.0
2023-09-22 06:00:00	NQ	Futures	16405.14	16413.66	16389.76	16399.1	7062.0
2023-09-22 07:00:00	NQ	Futures	16399.1	16401.3	16383.72	16395.53	7203.0
2023-09-22 08:00:00	NQ	Futures	16395.53	16449.64	16395.25	16429.59	21976.0
2023-09-22 09:00:00	NQ	Futures	16429.86	16437.55	16356.8	16424.64	82395.0
2023-09-22 10:00:00	NQ	Futures	16425.19	16496.61	16382.9	16490.29	95614.0
2023-09-22 11:00:00	NQ	Futures	16490.01	16510.06	16454.03	16455.68	61857.0
2023-09-22 12:00:00	NQ	Futures	16455.68	16505.4	16448.54	16489.19	39802.0
2023-09-22 13:00:00	NQ	Futures	16489.46	16491.66	16380.15	16387.56	63119.0
2023-09-22 14:00:00	NQ	Futures	16387.84	16396.63	16332.91	16359.82	57986.0
2023-09-22 15:00:00	NQ	Futures	16359.55	16456.51	16317.8	16333.46	94050.0
2023-09-22 16:00:00	NQ	Futures	16333.46	16360.92	16332.08	16343.89	16032.0
2023-09-22 00:00:00	YM	Futures	37316.9	37332.1	37310.4	37319.1	724.0
2023-09-22 01:00:00	YM	Futures	37319.1	37332.1	37308.2	37320.2	1051.0
2023-09-22 02:00:00	YM	Futures	37321.2	37333.2	37297.4	37299.5	1947.0
2023-09-22 03:00:00	YM	Futures	37298.5	37326.7	37255.1	37267.0	5501.0
2023-09-22 04:00:00	YM	Futures	37265.9	37274.6	37222.5	37257.2	3303.0
2023-09-22 05:00:00	YM	Futures	37256.1	37295.2	37236.6	37287.6	2341.0
2023-09-22 06:00:00	YM	Futures	37288.7	37303.9	37256.1	37277.8	2680.0
2023-09-22 07:00:00	YM	Futures	37277.8	37291.9	37257.2	37284.4	2285.0
2023-09-22 08:00:00	YM	Futures	37286.5	37323.4	37281.1	37290.9	5672.0
2023-09-22 09:00:00	YM	Futures	37291.9	37300.6	37172.6	37249.6	28940.0
2023-09-22 10:00:00	YM	Futures	37250.7	37333.2	37233.4	37314.7	25265.0
2023-09-22 11:00:00	YM	Futures	37315.8	37339.7	37247.5	37270.3	15520.0
2023-09-22 12:00:00	YM	Futures	37271.3	37331.0	37251.8	37297.4	8857.0
2023-09-22 13:00:00	YM	Futures	37296.3	37315.8	37158.5	37207.3	15812.0
2023-09-22 14:00:00	YM	Futures	37206.2	37230.1	37145.5	37186.7	12999.0
2023-09-22 15:00:00	YM	Futures	37184.6	37337.5	37111.9	37134.7	27379.0

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

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