PREVIEW / futures_1hour / 2023-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-17.parquet
  size:    64 KB
  rows:    2,021

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-07-17 00:00:00	ES	Futures	4977.17	4977.72	4976.07	4977.17	1826.0
2023-07-17 01:00:00	ES	Futures	4977.17	4979.09	4977.17	4977.99	3544.0
2023-07-17 02:00:00	ES	Futures	4977.99	4978.26	4975.79	4978.26	5208.0
2023-07-17 03:00:00	ES	Futures	4977.99	4982.93	4975.79	4982.11	17301.0
2023-07-17 04:00:00	ES	Futures	4982.11	4984.3	4979.09	4979.91	12371.0
2023-07-17 05:00:00	ES	Futures	4979.91	4981.56	4973.6	4974.42	14500.0
2023-07-17 06:00:00	ES	Futures	4974.42	4976.89	4972.77	4973.32	10776.0
2023-07-17 07:00:00	ES	Futures	4973.32	4979.36	4973.05	4974.42	12540.0
2023-07-17 08:00:00	ES	Futures	4974.42	4978.26	4972.5	4977.72	18757.0
2023-07-17 09:00:00	ES	Futures	4977.44	4989.24	4977.17	4987.32	153337.0
2023-07-17 10:00:00	ES	Futures	4987.32	4993.36	4987.05	4991.17	138296.0
2023-07-17 11:00:00	ES	Futures	4991.44	4999.95	4988.97	4999.13	109323.0
2023-07-17 12:00:00	ES	Futures	4999.4	4999.95	4991.99	4998.3	75603.0
2023-07-17 13:00:00	ES	Futures	4998.03	5001.32	4994.73	5000.23	70519.0
2023-07-17 14:00:00	ES	Futures	5000.5	5004.07	4998.85	5001.32	65038.0
2023-07-17 15:00:00	ES	Futures	5001.6	5013.4	4997.75	5001.05	222171.0
2023-07-17 16:00:00	ES	Futures	5001.05	5001.05	4995.28	4996.11	47831.0
2023-07-17 18:00:00	ES	Futures	4996.38	4998.03	4994.46	4995.28	3617.0
2023-07-17 19:00:00	ES	Futures	4995.56	4996.93	4994.19	4994.46	2806.0
2023-07-17 20:00:00	ES	Futures	4994.46	4997.21	4994.19	4996.66	4610.0
2023-07-17 21:00:00	ES	Futures	4996.38	4999.13	4992.26	4995.28	8035.0
2023-07-17 22:00:00	ES	Futures	4995.01	4995.28	4993.64	4995.01	3996.0
2023-07-17 23:00:00	ES	Futures	4994.73	4997.21	4994.73	4995.28	3722.0
2023-07-17 00:00:00	NQ	Futures	17440.77	17447.44	17436.88	17446.33	1662.0
2023-07-17 01:00:00	NQ	Futures	17446.05	17457.18	17445.5	17447.72	2713.0
2023-07-17 02:00:00	NQ	Futures	17447.44	17463.85	17440.21	17460.52	3462.0
2023-07-17 03:00:00	NQ	Futures	17460.79	17490.83	17452.73	17484.71	7971.0
2023-07-17 04:00:00	NQ	Futures	17484.99	17498.34	17478.04	17478.87	6042.0
2023-07-17 05:00:00	NQ	Futures	17478.6	17481.38	17451.89	17454.4	7049.0
2023-07-17 06:00:00	NQ	Futures	17454.4	17465.24	17442.99	17450.78	5867.0
2023-07-17 07:00:00	NQ	Futures	17450.78	17470.81	17450.23	17454.95	6199.0
2023-07-17 08:00:00	NQ	Futures	17455.23	17477.2	17443.55	17476.65	10453.0
2023-07-17 09:00:00	NQ	Futures	17476.93	17557.31	17470.25	17511.41	86387.0
2023-07-17 10:00:00	NQ	Futures	17511.14	17547.02	17498.62	17528.66	74757.0
2023-07-17 11:00:00	NQ	Futures	17528.94	17590.13	17511.69	17586.23	67408.0
2023-07-17 12:00:00	NQ	Futures	17585.4	17588.18	17533.67	17572.88	46070.0
2023-07-17 13:00:00	NQ	Futures	17572.6	17601.53	17555.36	17599.3	36748.0
2023-07-17 14:00:00	NQ	Futures	17599.58	17617.66	17586.23	17606.26	36657.0
2023-07-17 15:00:00	NQ	Futures	17606.54	17669.95	17603.48	17627.4	80559.0
2023-07-17 16:00:00	NQ	Futures	17627.12	17627.67	17601.81	17607.09	14375.0
2023-07-17 18:00:00	NQ	Futures	17613.49	17616.55	17595.69	17598.47	2472.0
2023-07-17 19:00:00	NQ	Futures	17599.58	17609.6	17595.97	17598.75	2262.0
2023-07-17 20:00:00	NQ	Futures	17598.47	17606.54	17588.74	17595.13	3613.0
2023-07-17 21:00:00	NQ	Futures	17594.85	17607.37	17577.05	17588.18	5678.0
2023-07-17 22:00:00	NQ	Futures	17587.9	17596.52	17583.45	17594.58	3052.0
2023-07-17 23:00:00	NQ	Futures	17594.3	17600.69	17591.52	17593.19	2100.0
2023-07-17 00:00:00	YM	Futures	37962.8	37963.9	37951.9	37955.2	356.0
2023-07-17 01:00:00	YM	Futures	37955.2	37965.0	37949.7	37956.3	666.0
2023-07-17 02:00:00	YM	Futures	37956.3	37956.3	37937.6	37948.6	1092.0
2023-07-17 03:00:00	YM	Futures	37948.6	37968.3	37924.5	37966.1	2501.0

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

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