PREVIEW / futures_1hour / 2022-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-20.parquet
  size:    68 KB
  rows:    2,015

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-20 00:00:00	ES	Futures	4427.14	4428.55	4425.73	4427.14	3444.0
2022-09-20 01:00:00	ES	Futures	4426.86	4431.37	4425.45	4429.68	5219.0
2022-09-20 02:00:00	ES	Futures	4429.68	4429.96	4422.35	4426.01	10247.0
2022-09-20 03:00:00	ES	Futures	4426.01	4438.41	4411.35	4414.74	29385.0
2022-09-20 04:00:00	ES	Futures	4414.45	4416.15	4404.59	4410.23	23251.0
2022-09-20 05:00:00	ES	Futures	4410.23	4411.63	4394.44	4398.95	25887.0
2022-09-20 06:00:00	ES	Futures	4398.95	4400.64	4392.18	4400.08	17983.0
2022-09-20 07:00:00	ES	Futures	4400.08	4405.15	4395.85	4395.85	27774.0
2022-09-20 08:00:00	ES	Futures	4395.85	4398.1	4380.91	4387.11	60111.0
2022-09-20 09:00:00	ES	Futures	4387.11	4390.77	4358.64	4364.28	280865.0
2022-09-20 10:00:00	ES	Futures	4364.28	4374.42	4351.31	4373.02	362696.0
2022-09-20 11:00:00	ES	Futures	4373.3	4386.83	4367.1	4385.14	239126.0
2022-09-20 12:00:00	ES	Futures	4385.14	4389.93	4363.71	4367.94	181551.0
2022-09-20 13:00:00	ES	Futures	4368.22	4369.35	4333.55	4336.09	241642.0
2022-09-20 14:00:00	ES	Futures	4336.09	4362.02	4335.52	4358.36	285962.0
2022-09-20 15:00:00	ES	Futures	4358.36	4383.45	4352.72	4368.22	383699.0
2022-09-20 16:00:00	ES	Futures	4367.94	4377.53	4367.94	4374.71	59206.0
2022-09-20 18:00:00	ES	Futures	4373.58	4374.42	4366.53	4371.32	5060.0
2022-09-20 19:00:00	ES	Futures	4371.04	4372.45	4363.99	4369.91	7632.0
2022-09-20 20:00:00	ES	Futures	4369.91	4376.12	4367.38	4372.73	9641.0
2022-09-20 21:00:00	ES	Futures	4372.73	4374.14	4364.28	4366.81	8920.0
2022-09-20 22:00:00	ES	Futures	4366.81	4375.27	4365.69	4373.58	7013.0
2022-09-20 23:00:00	ES	Futures	4373.3	4374.71	4369.91	4374.42	2769.0
2022-09-20 00:00:00	NQ	Futures	13856.29	13862.9	13850.26	13854.85	1917.0
2022-09-20 01:00:00	NQ	Futures	13854.57	13870.37	13850.26	13862.9	2624.0
2022-09-20 02:00:00	NQ	Futures	13863.47	13864.91	13833.88	13848.25	5854.0
2022-09-20 03:00:00	NQ	Futures	13847.1	13893.64	13797.1	13805.72	17915.0
2022-09-20 04:00:00	NQ	Futures	13805.43	13807.16	13762.62	13781.59	13311.0
2022-09-20 05:00:00	NQ	Futures	13781.3	13787.91	13731.3	13750.56	12606.0
2022-09-20 06:00:00	NQ	Futures	13750.27	13759.75	13726.99	13756.3	10142.0
2022-09-20 07:00:00	NQ	Futures	13756.3	13776.7	13734.75	13735.33	12229.0
2022-09-20 08:00:00	NQ	Futures	13735.61	13743.95	13693.95	13720.96	23239.0
2022-09-20 09:00:00	NQ	Futures	13720.96	13734.46	13661.77	13700.56	89096.0
2022-09-20 10:00:00	NQ	Futures	13700.85	13752.57	13665.51	13743.08	101655.0
2022-09-20 11:00:00	NQ	Futures	13743.08	13811.47	13725.27	13808.02	68116.0
2022-09-20 12:00:00	NQ	Futures	13808.31	13818.36	13716.36	13734.18	63055.0
2022-09-20 13:00:00	NQ	Futures	13734.46	13739.06	13594.25	13603.16	76409.0
2022-09-20 14:00:00	NQ	Futures	13603.44	13695.96	13599.13	13684.18	75482.0
2022-09-20 15:00:00	NQ	Futures	13683.9	13756.59	13667.23	13706.02	84654.0
2022-09-20 16:00:00	NQ	Futures	13706.31	13741.65	13706.02	13733.03	14565.0
2022-09-20 18:00:00	NQ	Futures	13729.58	13732.74	13705.73	13716.08	2803.0
2022-09-20 19:00:00	NQ	Futures	13716.36	13720.39	13689.07	13707.46	4098.0
2022-09-20 20:00:00	NQ	Futures	13707.17	13737.91	13700.85	13725.84	6122.0
2022-09-20 21:00:00	NQ	Futures	13725.27	13733.03	13688.78	13699.41	6933.0
2022-09-20 22:00:00	NQ	Futures	13699.41	13729.01	13695.96	13720.39	3875.0
2022-09-20 23:00:00	NQ	Futures	13720.1	13725.56	13706.31	13723.83	2339.0
2022-09-20 00:00:00	YM	Futures	34989.0	34998.0	34980.0	34987.9	512.0
2022-09-20 01:00:00	YM	Futures	34986.8	35017.1	34978.9	35005.8	594.0
2022-09-20 02:00:00	YM	Futures	35008.1	35011.4	34960.9	34983.4	1542.0
2022-09-20 03:00:00	YM	Futures	34982.3	35076.5	34890.2	34911.6	4786.0

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

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