PREVIEW / futures_1hour / 2023-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-03.parquet
  size:    17 KB
  rows:    355

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-09-03 18:00:00	ES	Futures	4964.54	4967.01	4960.42	4960.97	3739.0
2023-09-03 19:00:00	ES	Futures	4961.24	4963.44	4960.42	4962.89	2080.0
2023-09-03 20:00:00	ES	Futures	4962.62	4966.73	4962.07	4966.19	4175.0
2023-09-03 21:00:00	ES	Futures	4966.19	4967.56	4962.62	4963.72	5280.0
2023-09-03 22:00:00	ES	Futures	4963.72	4967.56	4962.62	4967.56	4834.0
2023-09-03 23:00:00	ES	Futures	4967.56	4967.83	4965.09	4965.36	2006.0
2023-09-03 18:00:00	NQ	Futures	17263.04	17272.78	17244.69	17253.03	2723.0
2023-09-03 19:00:00	NQ	Futures	17253.59	17266.38	17250.53	17262.49	1171.0
2023-09-03 20:00:00	NQ	Futures	17262.77	17276.39	17256.37	17273.33	2485.0
2023-09-03 21:00:00	NQ	Futures	17273.89	17284.74	17261.65	17268.61	3077.0
2023-09-03 22:00:00	NQ	Futures	17267.77	17289.47	17265.82	17288.35	2571.0
2023-09-03 23:00:00	NQ	Futures	17288.63	17291.69	17279.18	17281.4	1530.0
2023-09-03 18:00:00	YM	Futures	38200.6	38223.6	38176.5	38186.3	533.0
2023-09-03 19:00:00	YM	Futures	38188.5	38201.7	38178.7	38199.5	346.0
2023-09-03 20:00:00	YM	Futures	38199.5	38223.6	38198.4	38219.2	482.0
2023-09-03 21:00:00	YM	Futures	38221.4	38226.9	38198.4	38204.9	478.0
2023-09-03 22:00:00	YM	Futures	38204.9	38221.4	38195.1	38220.3	516.0
2023-09-03 23:00:00	YM	Futures	38221.4	38225.8	38211.5	38213.7	317.0
2023-09-03 18:00:00	CL	Futures	70.53	70.55	70.26	70.43	1809.0
2023-09-03 19:00:00	CL	Futures	70.41	70.43	70.34	70.35	904.0
2023-09-03 20:00:00	CL	Futures	70.34	70.43	70.25	70.37	1964.0
2023-09-03 21:00:00	CL	Futures	70.37	70.39	70.16	70.19	3613.0
2023-09-03 22:00:00	CL	Futures	70.18	70.25	70.18	70.2	1422.0
2023-09-03 23:00:00	CL	Futures	70.2	70.21	70.15	70.18	1149.0
2023-09-03 18:00:00	GC	Futures	2196.7	2197.1	2195.2	2195.5	826.0
2023-09-03 19:00:00	GC	Futures	2195.5	2197.2	2195.5	2196.7	710.0
2023-09-03 20:00:00	GC	Futures	2196.5	2198.0	2196.2	2197.0	1107.0
2023-09-03 21:00:00	GC	Futures	2197.1	2201.4	2196.6	2199.5	3035.0
2023-09-03 22:00:00	GC	Futures	2199.6	2202.9	2199.4	2202.4	2118.0
2023-09-03 23:00:00	GC	Futures	2202.5	2202.8	2201.5	2201.6	1100.0
2023-09-03 18:00:00	ZN	Futures	112.22856	112.244492	112.22856	112.244492	25.0
2023-09-03 19:00:00	ZN	Futures	112.260425	112.324155	112.260425	112.324155	48.0
2023-09-03 20:00:00	ZN	Futures	112.308222	112.308222	112.22856	112.22856	209.0
2023-09-03 21:00:00	ZN	Futures	112.244492	112.244492	112.196695	112.196695	31.0
2023-09-03 22:00:00	ZN	Futures	112.180762	112.180762	112.148897	112.148897	43.0
2023-09-03 23:00:00	ZN	Futures	112.16483	112.16483	112.16483	112.16483	5.0

> showing 36 of 355 rows — these rows as CSV

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