PREVIEW / futures_1hour / 2022-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-26.parquet
  size:    67 KB
  rows:    2,024

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-05-26 00:00:00	ES	Futures	4506.98	4507.83	4495.93	4496.78	3497.0
2022-05-26 01:00:00	ES	Futures	4496.78	4501.31	4490.26	4493.94	8076.0
2022-05-26 02:00:00	ES	Futures	4493.66	4502.45	4490.26	4500.18	8355.0
2022-05-26 03:00:00	ES	Futures	4499.9	4526.82	4499.61	4526.54	24084.0
2022-05-26 04:00:00	ES	Futures	4526.54	4526.82	4498.76	4504.43	19079.0
2022-05-26 05:00:00	ES	Futures	4504.72	4522.01	4500.18	4519.74	13038.0
2022-05-26 06:00:00	ES	Futures	4519.45	4526.26	4512.37	4523.14	13366.0
2022-05-26 07:00:00	ES	Futures	4522.86	4546.1	4522.01	4537.03	39508.0
2022-05-26 08:00:00	ES	Futures	4537.31	4540.71	4518.6	4535.33	47174.0
2022-05-26 09:00:00	ES	Futures	4535.33	4569.62	4520.87	4567.07	204403.0
2022-05-26 10:00:00	ES	Futures	4566.79	4583.8	4565.09	4583.51	197537.0
2022-05-26 11:00:00	ES	Futures	4583.51	4594.0	4580.11	4588.05	145791.0
2022-05-26 12:00:00	ES	Futures	4588.33	4610.72	4586.06	4610.15	107020.0
2022-05-26 13:00:00	ES	Futures	4610.15	4618.09	4600.23	4609.3	106981.0
2022-05-26 14:00:00	ES	Futures	4609.3	4613.56	4599.38	4606.47	102402.0
2022-05-26 15:00:00	ES	Futures	4606.19	4618.37	4589.75	4597.97	270358.0
2022-05-26 16:00:00	ES	Futures	4598.25	4599.38	4587.76	4592.58	58245.0
2022-05-26 18:00:00	ES	Futures	4588.9	4600.52	4588.61	4596.27	6234.0
2022-05-26 19:00:00	ES	Futures	4596.27	4602.22	4594.0	4599.38	4156.0
2022-05-26 20:00:00	ES	Futures	4599.38	4602.5	4581.81	4588.33	11611.0
2022-05-26 21:00:00	ES	Futures	4588.61	4594.85	4586.06	4592.01	7698.0
2022-05-26 22:00:00	ES	Futures	4592.3	4594.0	4586.63	4587.76	4533.0
2022-05-26 23:00:00	ES	Futures	4588.05	4595.42	4587.48	4589.75	4144.0
2022-05-26 00:00:00	NQ	Futures	13818.47	13819.92	13769.18	13773.81	3025.0
2022-05-26 01:00:00	NQ	Futures	13772.65	13789.76	13747.14	13758.74	6733.0
2022-05-26 02:00:00	NQ	Futures	13758.16	13792.37	13742.79	13781.93	6277.0
2022-05-26 03:00:00	NQ	Futures	13781.35	13894.44	13781.06	13892.99	11055.0
2022-05-26 04:00:00	NQ	Futures	13892.12	13892.99	13771.2	13794.98	13033.0
2022-05-26 05:00:00	NQ	Futures	13794.69	13855.01	13777.0	13847.18	9125.0
2022-05-26 06:00:00	NQ	Futures	13847.18	13877.92	13821.95	13858.78	8763.0
2022-05-26 07:00:00	NQ	Futures	13858.49	13942.58	13853.85	13892.7	16202.0
2022-05-26 08:00:00	NQ	Futures	13893.57	13912.71	13840.8	13891.54	21071.0
2022-05-26 09:00:00	NQ	Futures	13890.96	14064.95	13801.65	14051.32	87508.0
2022-05-26 10:00:00	NQ	Futures	14051.03	14147.88	14030.44	14145.27	83236.0
2022-05-26 11:00:00	NQ	Futures	14145.56	14195.44	14130.19	14184.42	57570.0
2022-05-26 12:00:00	NQ	Futures	14184.71	14289.97	14166.15	14287.65	58782.0
2022-05-26 13:00:00	NQ	Futures	14287.36	14316.65	14247.63	14288.81	49832.0
2022-05-26 14:00:00	NQ	Futures	14288.52	14303.89	14253.14	14274.89	39093.0
2022-05-26 15:00:00	NQ	Futures	14275.18	14307.95	14190.22	14237.77	82271.0
2022-05-26 16:00:00	NQ	Futures	14238.35	14242.41	14203.27	14218.06	16828.0
2022-05-26 18:00:00	NQ	Futures	14208.78	14265.03	14207.04	14241.83	4977.0
2022-05-26 19:00:00	NQ	Futures	14242.41	14265.61	14238.64	14255.46	2867.0
2022-05-26 20:00:00	NQ	Futures	14255.46	14266.77	14176.3	14204.14	7185.0
2022-05-26 21:00:00	NQ	Futures	14204.43	14227.34	14195.73	14216.9	5269.0
2022-05-26 22:00:00	NQ	Futures	14216.9	14223.28	14195.73	14202.98	3040.0
2022-05-26 23:00:00	NQ	Futures	14202.69	14231.4	14199.5	14211.1	2610.0
2022-05-26 00:00:00	YM	Futures	36178.3	36180.6	36103.9	36111.8	588.0
2022-05-26 01:00:00	YM	Futures	36109.5	36145.6	36073.5	36093.7	1388.0
2022-05-26 02:00:00	YM	Futures	36092.6	36152.4	36070.1	36134.3	1559.0
2022-05-26 03:00:00	YM	Futures	36132.1	36303.4	36132.1	36301.2	3481.0

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

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