PREVIEW / futures_1hour / 2023-10-24

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-24.parquet
  size:    66 KB
  rows:    2,049

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-10-24 00:00:00	ES	Futures	4617.85	4621.11	4616.49	4621.11	4831.0
2023-10-24 01:00:00	ES	Futures	4621.11	4623.01	4619.48	4622.19	8661.0
2023-10-24 02:00:00	ES	Futures	4622.47	4627.63	4621.11	4626.27	12546.0
2023-10-24 03:00:00	ES	Futures	4626.27	4628.71	4617.04	4620.29	27984.0
2023-10-24 04:00:00	ES	Futures	4620.57	4625.45	4612.69	4623.82	28101.0
2023-10-24 05:00:00	ES	Futures	4623.82	4629.8	4622.19	4628.98	18716.0
2023-10-24 06:00:00	ES	Futures	4628.98	4631.97	4624.91	4631.16	23523.0
2023-10-24 07:00:00	ES	Futures	4631.16	4635.77	4629.8	4633.87	24762.0
2023-10-24 08:00:00	ES	Futures	4633.87	4636.32	4627.63	4635.23	37918.0
2023-10-24 09:00:00	ES	Futures	4634.96	4643.1	4626.0	4642.02	237073.0
2023-10-24 10:00:00	ES	Futures	4642.02	4652.88	4627.9	4645.82	285642.0
2023-10-24 11:00:00	ES	Futures	4646.09	4646.64	4627.9	4635.77	214612.0
2023-10-24 12:00:00	ES	Futures	4636.04	4639.3	4607.8	4613.78	196218.0
2023-10-24 13:00:00	ES	Futures	4613.51	4628.44	4611.06	4623.82	138139.0
2023-10-24 14:00:00	ES	Futures	4623.55	4641.2	4621.65	4638.76	122564.0
2023-10-24 15:00:00	ES	Futures	4638.76	4645.55	4635.23	4639.3	219199.0
2023-10-24 16:00:00	ES	Futures	4639.3	4660.48	4635.77	4638.49	108257.0
2023-10-24 18:00:00	ES	Futures	4637.67	4642.02	4626.27	4635.5	15814.0
2023-10-24 19:00:00	ES	Futures	4635.23	4637.67	4633.6	4636.32	3876.0
2023-10-24 20:00:00	ES	Futures	4636.32	4636.32	4629.8	4632.24	8695.0
2023-10-24 21:00:00	ES	Futures	4632.51	4636.32	4631.7	4635.5	9364.0
2023-10-24 22:00:00	ES	Futures	4635.5	4635.77	4633.06	4634.42	3878.0
2023-10-24 23:00:00	ES	Futures	4634.42	4635.5	4628.98	4629.53	5250.0
2023-10-24 00:00:00	NQ	Futures	16210.68	16227.16	16207.11	16226.34	2593.0
2023-10-24 01:00:00	NQ	Futures	16226.61	16246.39	16224.14	16241.72	5872.0
2023-10-24 02:00:00	NQ	Futures	16241.99	16270.83	16236.77	16266.71	6762.0
2023-10-24 03:00:00	NQ	Futures	16266.44	16287.59	16237.6	16244.19	13621.0
2023-10-24 04:00:00	NQ	Futures	16244.46	16254.63	16194.75	16234.58	13565.0
2023-10-24 05:00:00	NQ	Futures	16235.13	16273.85	16229.91	16266.99	8644.0
2023-10-24 06:00:00	NQ	Futures	16266.99	16272.75	16239.25	16255.45	8819.0
2023-10-24 07:00:00	NQ	Futures	16255.45	16280.17	16249.68	16266.71	9999.0
2023-10-24 08:00:00	NQ	Futures	16266.71	16269.46	16239.52	16262.59	15126.0
2023-10-24 09:00:00	NQ	Futures	16262.32	16301.87	16214.53	16290.33	107761.0
2023-10-24 10:00:00	NQ	Futures	16289.51	16345.82	16237.32	16310.38	112764.0
2023-10-24 11:00:00	NQ	Futures	16310.93	16326.31	16235.68	16283.74	75477.0
2023-10-24 12:00:00	NQ	Futures	16284.02	16297.47	16156.85	16175.25	80909.0
2023-10-24 13:00:00	NQ	Futures	16174.7	16248.86	16170.3	16229.91	53929.0
2023-10-24 14:00:00	NQ	Futures	16229.91	16301.32	16222.77	16289.78	51532.0
2023-10-24 15:00:00	NQ	Futures	16290.61	16326.86	16277.7	16310.93	65083.0
2023-10-24 16:00:00	NQ	Futures	16310.93	16423.55	16275.5	16293.9	38789.0
2023-10-24 18:00:00	NQ	Futures	16290.88	16320.55	16234.03	16273.85	11743.0
2023-10-24 19:00:00	NQ	Futures	16272.75	16284.84	16265.06	16276.6	2168.0
2023-10-24 20:00:00	NQ	Futures	16276.6	16278.52	16251.88	16260.39	5218.0
2023-10-24 21:00:00	NQ	Futures	16259.85	16277.15	16259.3	16274.13	4878.0
2023-10-24 22:00:00	NQ	Futures	16274.13	16274.4	16264.51	16269.46	2958.0
2023-10-24 23:00:00	NQ	Futures	16269.73	16273.58	16243.64	16244.74	4293.0
2023-10-24 00:00:00	YM	Futures	35926.2	35949.0	35917.5	35947.9	832.0
2023-10-24 01:00:00	YM	Futures	35947.9	35956.6	35932.7	35949.0	1504.0
2023-10-24 02:00:00	YM	Futures	35949.0	35984.8	35947.9	35973.9	3008.0
2023-10-24 03:00:00	YM	Futures	35973.9	35986.9	35902.3	35927.3	6092.0

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

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