PREVIEW / futures_daily / 2023-07-18

all futures daily files

  file:    by_date/futures_daily/2023/2023-07-18.parquet
  size:    10 KB
  rows:    130

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2023-07-18	ES	Futures	4927.7	4975.62	4921.74	4968.31	1301460.0
2023-07-18	NQ	Futures	17322.93	17539.3	17214.61	17479.12	633272.0
2023-07-18	YM	Futures	36924.5	37380.4	36868.2	37347.5	155188.0
2023-07-18	CL	Futures	64.18	65.76	63.96	65.55	388371.0
2023-07-18	GC	Futures	2152.8	2185.8	2152.6	2177.6	264086.0
2023-07-18	ZN	Futures	114.646705	115.266932	114.614898	114.758028	1303657.0
2023-07-18	A6	Futures	0.69188	0.69401	0.68909	0.69158	85352.0
2023-07-18	AD	Futures	0.76628	0.76805	0.7636	0.76759	64515.0
2023-07-18	ALI	Futures	2520.35	2525.1	2455.52	2462.51	2924.0
2023-07-18	B	Futures	68.79	70.08	68.5	69.76	366473.0
2023-07-18	B6	Futures	1.31	1.3152	1.3055	1.3072	94909.0
2023-07-18	BFX	Futures	4077.2	4077.2	4077.2	4077.2	0.0
2023-07-18	BR	Futures	0.19142	0.19273	0.19142	0.19212	364.0
2023-07-18	BTC	Futures	40687.0	40713.9	39614.0	39949.3	5773.0
2023-07-18	BZ	Futures	68.68	69.97	68.39	69.64	30304.0
2023-07-18	C	Futures	2102.0	2133.0	2088.0	2120.0	9221.0
2023-07-18	CB	Futures	241.188	241.188	238.117	238.926	33.0
2023-07-18	CC	Futures	1954.0	1988.0	1938.0	1975.0	23093.0
2023-07-18	CNH	Futures	6.8752	6.8923	6.866	6.8917	198.0
2023-07-18	CSC	Futures	1.851	1.87	1.835	1.866	208.0
2023-07-18	CT	Futures	104.57	105.32	104.01	104.42	14.0
2023-07-18	DC	Futures	17.04	17.27	16.76	17.18	527.0
2023-07-18	DX	Futures	97.708	97.899	97.34	97.737	19202.0
2023-07-18	E1	Futures	1.24128	1.24802	1.24049	1.24526	24427.0
2023-07-18	E6	Futures	1.15363	1.15747	1.15061	1.15266	212460.0
2023-07-18	E7	Futures	1.1537	1.1575	1.1507	1.1528	5223.0
2023-07-18	EBM	Futures	341.95	346.34	340.12	343.42	24714.0
2023-07-18	ER	Futures	97.787	97.838	97.787	97.828	174505.0
2023-07-18	ESG	Futures	427.16	432.27	426.78	431.66	373.0
2023-07-18	EW	Futures	2860.3	2894.4	2855.8	2891.0	8842.0
2023-07-18	FBON	Futures	122.21	123.34	122.17	123.33	35.0
2023-07-18	FBTP	Futures	113.75	114.99	113.67	114.9	155691.0
2023-07-18	FBTS	Futures	105.967	106.31	105.946	106.29	96273.0
2023-07-18	FCE	Futures	7919.4	7961.9	7898.1	7945.2	40570.0
2023-07-18	FDAX	Futures	17128.2	17205.5	17070.0	17186.4	41625.0
2023-07-18	FDIV	Futures	186.48	187.25	186.48	187.25	4.0
2023-07-18	FDXM	Futures	17199.4	17277.0	17139.9	17256.8	34863.0
2023-07-18	FDXS	Futures	17079.7	17164.2	17029.0	17146.2	13857.0
2023-07-18	FESX	Futures	4441.1	4463.4	4422.9	4453.2	554549.0
2023-07-18	FEU3	Futures	97.817	97.817	97.817	97.817	0.0
2023-07-18	FGBL	Futures	134.75	136.0	134.75	135.94	777581.0
2023-07-18	FGBM	Futures	118.27	118.92	118.27	118.87	621020.0
2023-07-18	FGBS	Futures	107.274	107.509	107.269	107.479	574829.0
2023-07-18	FGBX	Futures	139.8	142.63	139.78	142.36	78868.0
2023-07-18	FMWO	Futures	10564.6	10658.5	10556.8	10620.5	10573.0
2023-07-18	FOAT	Futures	125.93	127.18	125.93	127.11	162503.0
2023-07-18	FSMX	Futures	29177.2	29437.2	29141.8	29386.2	135.0
2023-07-18	FTDX	Futures	3382.9	3390.8	3382.9	3389.2	2.0
2023-07-18	FTI	Futures	810.95	814.95	808.79	812.45	12204.0
2023-07-18	FTUK	Futures	7524.4	7580.8	7513.8	7574.7	83013.0

> showing 50 of 130 rows — these rows as CSV

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