PREVIEW / futures_1hour / 2023-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-28.parquet
  size:    58 KB
  rows:    1,670

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-04-28 00:00:00	ES	Futures	4602.12	4605.73	4601.57	4603.51	6974.0
2023-04-28 01:00:00	ES	Futures	4603.23	4610.17	4601.02	4608.23	9255.0
2023-04-28 02:00:00	ES	Futures	4607.95	4608.23	4598.8	4598.8	12637.0
2023-04-28 03:00:00	ES	Futures	4599.07	4601.57	4593.53	4595.19	23068.0
2023-04-28 04:00:00	ES	Futures	4595.19	4596.3	4586.04	4587.7	25943.0
2023-04-28 05:00:00	ES	Futures	4587.98	4594.08	4583.54	4591.86	21826.0
2023-04-28 06:00:00	ES	Futures	4591.86	4594.08	4589.09	4589.37	13265.0
2023-04-28 07:00:00	ES	Futures	4589.37	4596.02	4589.09	4590.48	21372.0
2023-04-28 08:00:00	ES	Futures	4590.75	4599.63	4587.15	4596.3	52221.0
2023-04-28 09:00:00	ES	Futures	4596.3	4612.39	4595.75	4609.89	154688.0
2023-04-28 10:00:00	ES	Futures	4609.89	4635.41	4607.39	4617.66	342240.0
2023-04-28 11:00:00	ES	Futures	4617.66	4636.24	4607.12	4634.85	183776.0
2023-04-28 12:00:00	ES	Futures	4634.85	4643.73	4630.41	4642.9	126450.0
2023-04-28 13:00:00	ES	Futures	4642.9	4643.73	4632.63	4636.79	120143.0
2023-04-28 14:00:00	ES	Futures	4637.07	4643.17	4627.64	4635.41	150851.0
2023-04-28 15:00:00	ES	Futures	4635.41	4648.44	4633.47	4647.89	278545.0
2023-04-28 16:00:00	ES	Futures	4647.89	4652.6	4646.5	4649.27	97146.0
2023-04-28 00:00:00	NQ	Futures	14867.41	14884.02	14864.87	14874.45	3937.0
2023-04-28 01:00:00	NQ	Futures	14874.16	14906.54	14866.56	14892.18	4862.0
2023-04-28 02:00:00	NQ	Futures	14892.75	14894.15	14864.31	14865.15	5585.0
2023-04-28 03:00:00	NQ	Futures	14865.72	14878.11	14844.32	14862.62	9268.0
2023-04-28 04:00:00	NQ	Futures	14862.9	14872.47	14843.48	14853.61	9710.0
2023-04-28 05:00:00	NQ	Futures	14853.89	14864.87	14837.56	14852.77	6821.0
2023-04-28 06:00:00	NQ	Futures	14852.77	14864.03	14843.76	14856.43	5123.0
2023-04-28 07:00:00	NQ	Futures	14855.86	14875.01	14850.23	14850.23	9129.0
2023-04-28 08:00:00	NQ	Futures	14850.23	14892.47	14831.09	14876.42	25027.0
2023-04-28 09:00:00	NQ	Futures	14875.57	14915.55	14834.75	14876.14	88421.0
2023-04-28 10:00:00	NQ	Futures	14875.85	14970.74	14854.74	14876.42	157209.0
2023-04-28 11:00:00	NQ	Futures	14876.7	14931.88	14847.42	14927.94	74420.0
2023-04-28 12:00:00	NQ	Futures	14927.94	14963.98	14906.26	14961.45	54962.0
2023-04-28 13:00:00	NQ	Futures	14961.73	14969.05	14930.47	14952.72	46278.0
2023-04-28 14:00:00	NQ	Futures	14953.0	14972.14	14935.26	14962.29	44054.0
2023-04-28 15:00:00	NQ	Futures	14962.01	15005.93	14949.62	15005.09	69033.0
2023-04-28 16:00:00	NQ	Futures	15004.8	15019.16	14999.74	15007.62	18400.0
2023-04-28 00:00:00	YM	Futures	37450.1	37474.4	37447.8	37454.5	1217.0
2023-04-28 01:00:00	YM	Futures	37453.4	37495.4	37443.4	37485.4	1256.0
2023-04-28 02:00:00	YM	Futures	37486.5	37486.5	37426.8	37429.1	2665.0
2023-04-28 03:00:00	YM	Futures	37430.2	37447.8	37384.8	37395.9	3638.0
2023-04-28 04:00:00	YM	Futures	37395.9	37403.6	37310.8	37327.4	5359.0
2023-04-28 05:00:00	YM	Futures	37328.5	37398.1	37306.4	37388.2	4084.0
2023-04-28 06:00:00	YM	Futures	37386.0	37407.0	37341.7	37345.1	2997.0
2023-04-28 07:00:00	YM	Futures	37345.1	37393.7	37334.0	37361.6	3707.0
2023-04-28 08:00:00	YM	Futures	37361.6	37436.8	37332.9	37370.5	5914.0
2023-04-28 09:00:00	YM	Futures	37370.5	37546.2	37359.4	37527.4	17491.0
2023-04-28 10:00:00	YM	Futures	37526.3	37725.3	37519.7	37603.7	36950.0
2023-04-28 11:00:00	YM	Futures	37604.8	37745.2	37520.8	37731.9	20178.0
2023-04-28 12:00:00	YM	Futures	37731.9	37790.5	37702.1	37779.4	11586.0
2023-04-28 13:00:00	YM	Futures	37779.4	37781.7	37682.2	37715.3	9726.0
2023-04-28 14:00:00	YM	Futures	37715.3	37768.4	37642.4	37703.2	11249.0
2023-04-28 15:00:00	YM	Futures	37702.1	37810.4	37691.0	37809.3	17562.0

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

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