PREVIEW / futures_1hour / 2023-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-10.parquet
  size:    18 KB
  rows:    392

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-10 18:00:00	ES	Futures	4901.13	4902.77	4898.11	4902.5	3614.0
2023-09-10 19:00:00	ES	Futures	4902.5	4903.87	4900.03	4903.32	1570.0
2023-09-10 20:00:00	ES	Futures	4903.6	4906.07	4899.48	4900.3	3923.0
2023-09-10 21:00:00	ES	Futures	4900.03	4902.22	4896.46	4901.95	3420.0
2023-09-10 22:00:00	ES	Futures	4902.22	4904.42	4900.03	4903.6	2236.0
2023-09-10 23:00:00	ES	Futures	4903.87	4904.15	4901.4	4902.5	1821.0
2023-09-10 18:00:00	NQ	Futures	17030.53	17045.82	17020.24	17044.99	2572.0
2023-09-10 19:00:00	NQ	Futures	17044.71	17049.72	17032.75	17046.38	1526.0
2023-09-10 20:00:00	NQ	Futures	17047.49	17060.84	17031.64	17035.25	3227.0
2023-09-10 21:00:00	NQ	Futures	17034.42	17043.6	17019.4	17041.37	3298.0
2023-09-10 22:00:00	NQ	Futures	17042.21	17054.17	17029.69	17050.27	2298.0
2023-09-10 23:00:00	NQ	Futures	17050.55	17051.94	17038.87	17044.99	1359.0
2023-09-10 18:00:00	YM	Futures	37913.5	37919.0	37874.5	37895.1	568.0
2023-09-10 19:00:00	YM	Futures	37895.1	37909.2	37883.2	37908.1	467.0
2023-09-10 20:00:00	YM	Futures	37909.2	37922.2	37876.7	37883.2	782.0
2023-09-10 21:00:00	YM	Futures	37883.2	37898.3	37863.6	37896.2	539.0
2023-09-10 22:00:00	YM	Futures	37897.3	37908.1	37879.9	37902.7	384.0
2023-09-10 23:00:00	YM	Futures	37903.8	37904.9	37888.6	37891.8	328.0
2023-09-10 18:00:00	CL	Futures	71.63	71.7	71.24	71.36	2613.0
2023-09-10 19:00:00	CL	Futures	71.36	71.36	71.22	71.27	1109.0
2023-09-10 20:00:00	CL	Futures	71.27	71.29	71.06	71.19	2154.0
2023-09-10 21:00:00	CL	Futures	71.18	71.28	71.09	71.26	4558.0
2023-09-10 22:00:00	CL	Futures	71.26	71.37	71.21	71.33	2276.0
2023-09-10 23:00:00	CL	Futures	71.34	71.36	71.28	71.31	1246.0
2023-09-10 18:00:00	GC	Futures	2170.6	2172.0	2168.6	2169.0	1506.0
2023-09-10 19:00:00	GC	Futures	2168.9	2170.4	2166.3	2169.4	2664.0
2023-09-10 20:00:00	GC	Futures	2169.4	2171.2	2168.7	2170.6	1988.0
2023-09-10 21:00:00	GC	Futures	2170.6	2174.1	2169.5	2173.2	4034.0
2023-09-10 22:00:00	GC	Futures	2173.2	2175.2	2173.2	2173.5	2563.0
2023-09-10 23:00:00	GC	Futures	2173.5	2174.5	2173.0	2174.2	1148.0
2023-09-10 18:00:00	ZN	Futures	111.513304	111.624389	111.497435	111.545043	13892.0
2023-09-10 19:00:00	ZN	Futures	111.560912	111.560912	111.433958	111.449827	12762.0
2023-09-10 20:00:00	ZN	Futures	111.433958	111.497435	111.418089	111.465697	19243.0
2023-09-10 21:00:00	ZN	Futures	111.449827	111.449827	111.370481	111.38635	16287.0
2023-09-10 22:00:00	ZN	Futures	111.38635	111.418089	111.370481	111.38635	5082.0
2023-09-10 23:00:00	ZN	Futures	111.38635	111.433958	111.370481	111.38635	7674.0

> showing 36 of 392 rows — these rows as CSV

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