PREVIEW / futures_1hour / 2022-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-12-28.parquet
  size:    66 KB
  rows:    2,046

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-12-28 00:00:00	ES	Futures	4315.73	4317.4	4310.97	4311.81	3685.0
2022-12-28 01:00:00	ES	Futures	4312.09	4321.04	4310.97	4321.04	4536.0
2022-12-28 02:00:00	ES	Futures	4321.04	4324.95	4319.64	4324.12	6668.0
2022-12-28 03:00:00	ES	Futures	4323.84	4327.75	4317.4	4317.4	11640.0
2022-12-28 04:00:00	ES	Futures	4317.4	4318.8	4308.18	4314.33	9610.0
2022-12-28 05:00:00	ES	Futures	4314.61	4322.72	4312.09	4320.2	6732.0
2022-12-28 06:00:00	ES	Futures	4320.48	4324.67	4317.13	4323.56	11149.0
2022-12-28 07:00:00	ES	Futures	4323.56	4325.79	4321.04	4324.39	11540.0
2022-12-28 08:00:00	ES	Futures	4324.39	4326.35	4312.37	4314.89	16690.0
2022-12-28 09:00:00	ES	Futures	4314.61	4333.9	4302.31	4319.36	152694.0
2022-12-28 10:00:00	ES	Futures	4319.36	4328.87	4287.77	4288.61	176140.0
2022-12-28 11:00:00	ES	Futures	4288.88	4291.68	4274.07	4275.18	141596.0
2022-12-28 12:00:00	ES	Futures	4275.18	4290.0	4264.84	4287.49	132525.0
2022-12-28 13:00:00	ES	Futures	4287.77	4298.11	4277.98	4280.5	115118.0
2022-12-28 14:00:00	ES	Futures	4280.78	4288.61	4274.35	4277.7	98452.0
2022-12-28 15:00:00	ES	Futures	4277.7	4278.26	4255.05	4257.57	226431.0
2022-12-28 16:00:00	ES	Futures	4257.57	4264.0	4255.33	4261.48	45974.0
2022-12-28 18:00:00	ES	Futures	4262.32	4266.24	4260.09	4263.44	5902.0
2022-12-28 19:00:00	ES	Futures	4263.72	4265.4	4257.01	4261.76	7315.0
2022-12-28 20:00:00	ES	Futures	4262.04	4264.28	4257.57	4259.81	6671.0
2022-12-28 21:00:00	ES	Futures	4259.81	4262.04	4257.29	4260.37	6515.0
2022-12-28 22:00:00	ES	Futures	4260.64	4261.48	4257.29	4260.37	4231.0
2022-12-28 23:00:00	ES	Futures	4260.37	4263.72	4259.53	4263.72	3411.0
2022-12-28 00:00:00	NQ	Futures	12432.39	12438.08	12416.17	12420.16	1994.0
2022-12-28 01:00:00	NQ	Futures	12421.58	12443.77	12417.88	12443.77	2093.0
2022-12-28 02:00:00	NQ	Futures	12444.05	12456.29	12439.22	12454.87	3743.0
2022-12-28 03:00:00	NQ	Futures	12455.72	12465.96	12432.68	12434.95	6183.0
2022-12-28 04:00:00	NQ	Futures	12434.95	12441.49	12394.84	12415.89	7344.0
2022-12-28 05:00:00	NQ	Futures	12415.32	12451.45	12402.23	12438.65	6599.0
2022-12-28 06:00:00	NQ	Futures	12439.22	12456.86	12427.27	12447.47	6646.0
2022-12-28 07:00:00	NQ	Futures	12447.75	12463.4	12435.8	12452.31	7655.0
2022-12-28 08:00:00	NQ	Futures	12452.31	12461.69	12412.48	12422.43	10815.0
2022-12-28 09:00:00	NQ	Futures	12422.43	12513.76	12360.41	12461.69	93540.0
2022-12-28 10:00:00	NQ	Futures	12461.69	12499.53	12320.3	12322.01	103997.0
2022-12-28 11:00:00	NQ	Futures	12322.29	12334.52	12279.33	12283.03	72906.0
2022-12-28 12:00:00	NQ	Futures	12283.6	12362.12	12259.42	12353.87	67522.0
2022-12-28 13:00:00	NQ	Futures	12354.44	12393.98	12304.65	12317.17	65141.0
2022-12-28 14:00:00	NQ	Futures	12317.45	12333.67	12280.47	12292.99	52912.0
2022-12-28 15:00:00	NQ	Futures	12292.7	12294.98	12243.2	12256.29	83375.0
2022-12-28 16:00:00	NQ	Futures	12256.29	12282.46	12249.18	12271.08	13551.0
2022-12-28 18:00:00	NQ	Futures	12273.93	12287.3	12270.51	12282.46	3197.0
2022-12-28 19:00:00	NQ	Futures	12282.75	12289.01	12264.54	12282.46	3117.0
2022-12-28 20:00:00	NQ	Futures	12283.03	12296.97	12271.65	12281.61	3688.0
2022-12-28 21:00:00	NQ	Futures	12282.18	12291.28	12269.66	12283.88	2738.0
2022-12-28 22:00:00	NQ	Futures	12284.45	12288.44	12274.78	12283.32	1771.0
2022-12-28 23:00:00	NQ	Futures	12283.03	12296.69	12279.05	12294.7	1519.0
2022-12-28 00:00:00	YM	Futures	37282.8	37290.6	37250.4	37256.0	630.0
2022-12-28 01:00:00	YM	Futures	37259.4	37320.6	37249.3	37320.6	732.0
2022-12-28 02:00:00	YM	Futures	37321.7	37345.1	37308.4	37334.0	1372.0
2022-12-28 03:00:00	YM	Futures	37336.2	37370.8	37296.1	37296.1	2350.0

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

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