PREVIEW / futures_1hour / 2022-09-21

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-21.parquet
  size:    70 KB
  rows:    2,056

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-21 00:00:00	ES	Futures	4374.42	4374.71	4369.35	4371.61	3092.0
2022-09-21 01:00:00	ES	Futures	4371.61	4378.37	4362.02	4365.4	14471.0
2022-09-21 02:00:00	ES	Futures	4365.69	4374.99	4352.72	4357.23	42328.0
2022-09-21 03:00:00	ES	Futures	4357.23	4373.3	4346.52	4365.97	31893.0
2022-09-21 04:00:00	ES	Futures	4365.97	4373.86	4362.59	4370.48	18994.0
2022-09-21 05:00:00	ES	Futures	4370.2	4381.19	4365.69	4379.22	15746.0
2022-09-21 06:00:00	ES	Futures	4378.94	4380.63	4367.94	4376.4	18313.0
2022-09-21 07:00:00	ES	Futures	4376.4	4386.55	4372.73	4382.32	20463.0
2022-09-21 08:00:00	ES	Futures	4382.32	4393.88	4379.78	4389.37	36091.0
2022-09-21 09:00:00	ES	Futures	4389.37	4398.95	4381.75	4391.34	184801.0
2022-09-21 10:00:00	ES	Futures	4391.34	4403.18	4383.73	4388.24	215636.0
2022-09-21 11:00:00	ES	Futures	4388.52	4393.03	4381.75	4389.08	139234.0
2022-09-21 12:00:00	ES	Futures	4388.8	4398.39	4386.26	4387.39	89914.0
2022-09-21 13:00:00	ES	Futures	4387.39	4403.18	4383.73	4399.51	105033.0
2022-09-21 14:00:00	ES	Futures	4399.8	4426.01	4321.71	4404.87	691998.0
2022-09-21 15:00:00	ES	Futures	4404.87	4411.63	4289.29	4289.29	587217.0
2022-09-21 16:00:00	ES	Futures	4289.29	4293.24	4275.76	4281.12	107651.0
2022-09-21 18:00:00	ES	Futures	4278.02	4285.63	4265.33	4267.02	16612.0
2022-09-21 19:00:00	ES	Futures	4267.02	4269.84	4262.23	4263.92	13796.0
2022-09-21 20:00:00	ES	Futures	4263.64	4269.28	4252.93	4255.47	17997.0
2022-09-21 21:00:00	ES	Futures	4255.18	4260.82	4247.29	4260.26	18621.0
2022-09-21 22:00:00	ES	Futures	4260.26	4271.53	4256.88	4266.74	14647.0
2022-09-21 23:00:00	ES	Futures	4266.74	4269.0	4262.51	4265.61	6944.0
2022-09-21 00:00:00	NQ	Futures	13723.55	13724.41	13706.59	13712.34	1756.0
2022-09-21 01:00:00	NQ	Futures	13712.34	13737.05	13682.17	13693.95	5925.0
2022-09-21 02:00:00	NQ	Futures	13693.38	13724.7	13657.46	13670.1	18450.0
2022-09-21 03:00:00	NQ	Futures	13669.82	13729.87	13632.46	13700.85	19859.0
2022-09-21 04:00:00	NQ	Futures	13700.85	13719.24	13680.73	13706.59	8944.0
2022-09-21 05:00:00	NQ	Futures	13706.02	13730.44	13681.6	13720.39	7561.0
2022-09-21 06:00:00	NQ	Futures	13720.1	13723.83	13684.18	13706.88	7814.0
2022-09-21 07:00:00	NQ	Futures	13706.59	13733.89	13692.8	13722.11	9547.0
2022-09-21 08:00:00	NQ	Futures	13722.68	13779.86	13716.94	13764.92	17526.0
2022-09-21 09:00:00	NQ	Futures	13764.06	13788.77	13720.39	13758.03	62739.0
2022-09-21 10:00:00	NQ	Futures	13757.45	13791.36	13723.83	13742.22	74542.0
2022-09-21 11:00:00	NQ	Futures	13741.65	13766.93	13721.25	13754.86	46850.0
2022-09-21 12:00:00	NQ	Futures	13754.86	13803.14	13743.66	13770.38	39466.0
2022-09-21 13:00:00	NQ	Futures	13770.67	13864.05	13751.13	13825.55	33017.0
2022-09-21 14:00:00	NQ	Futures	13827.85	13953.12	13519.55	13877.27	236122.0
2022-09-21 15:00:00	NQ	Futures	13877.27	13903.99	13450.3	13451.16	163446.0
2022-09-21 16:00:00	NQ	Futures	13451.16	13456.33	13386.51	13410.07	33594.0
2022-09-21 18:00:00	NQ	Futures	13402.32	13421.85	13352.61	13359.22	7171.0
2022-09-21 19:00:00	NQ	Futures	13358.93	13371.57	13339.39	13346.0	6596.0
2022-09-21 20:00:00	NQ	Futures	13346.57	13363.81	13300.03	13310.95	8374.0
2022-09-21 21:00:00	NQ	Futures	13309.8	13332.5	13274.46	13331.63	11579.0
2022-09-21 22:00:00	NQ	Futures	13331.06	13368.41	13321.86	13351.17	7763.0
2022-09-21 23:00:00	NQ	Futures	13350.31	13358.07	13334.22	13343.7	4138.0
2022-09-21 00:00:00	YM	Futures	34622.0	34623.2	34583.9	34600.7	482.0
2022-09-21 01:00:00	YM	Futures	34601.8	34649.0	34535.6	34562.6	2204.0
2022-09-21 02:00:00	YM	Futures	34560.3	34620.9	34454.8	34493.0	5694.0
2022-09-21 03:00:00	YM	Futures	34491.9	34606.3	34413.3	34555.8	5026.0

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

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