PREVIEW / futures_daily / 2021-07-23

all futures daily files

  file:    by_date/futures_daily/2021/2021-07-23.parquet
  size:    10 KB
  rows:    123

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
2021-07-23	ES	Futures	4913.89	4955.2	4909.11	4949.3	1173337.0
2021-07-23	NQ	Futures	17281.65	17440.58	17229.45	17418.37	449261.0
2021-07-23	YM	Futures	37699.6	37943.6	37668.2	37898.0	133043.0
2021-07-23	CL	Futures	51.9	52.26	51.67	52.16	274778.0
2021-07-23	GC	Futures	2114.3	2117.9	2092.6	2107.4	236764.0
2021-07-23	ZN	Futures	135.749395	135.84428	135.559624	135.765209	916473.0
2021-07-23	A6	Futures	0.75731	0.75803	0.75459	0.75536	57019.0
2021-07-23	AD	Futures	0.80703	0.80749	0.80414	0.80617	47159.0
2021-07-23	ALI	Futures	2880.47	2899.6	2880.18	2897.32	67.0
2021-07-23	B	Futures	48.57	49.0	48.41	48.92	181662.0
2021-07-23	B6	Futures	1.3974	1.3994	1.3932	1.3966	67044.0
2021-07-23	BFX	Futures	4321.9	4321.9	4318.3	4318.3	1.0
2021-07-23	BR	Futures	0.1537	0.15426	0.15234	0.15262	1290.0
2021-07-23	BTC	Futures	45844.0	46912.4	45559.0	45972.2	2498.0
2021-07-23	BZ	Futures	47.57	47.89	47.33	47.82	23724.0
2021-07-23	C	Futures	1393.0	1412.0	1380.0	1401.0	9095.0
2021-07-23	CB	Futures	136.413	136.413	135.591	135.591	21.0
2021-07-23	CC	Futures	1517.0	1532.0	1508.0	1522.0	15070.0
2021-07-23	CNH	Futures	6.2661	6.2803	6.263	6.2688	364.0
2021-07-23	CSC	Futures	2.464	2.472	2.456	2.464	459.0
2021-07-23	CT	Futures	83.81	83.82	82.98	83.53	20.0
2021-07-23	DC	Futures	22.23	22.23	21.91	22.06	145.0
2021-07-23	DX	Futures	89.748	89.931	89.685	89.823	12468.0
2021-07-23	E1	Futures	1.22336	1.22392	1.2192	1.22179	16157.0
2021-07-23	E6	Futures	1.25334	1.25493	1.25153	1.25329	127442.0
2021-07-23	E7	Futures	1.2473	1.2485	1.2453	1.2471	3315.0
2021-07-23	EBM	Futures	308.93	313.34	307.09	311.87	10091.0
2021-07-23	ED	Futures	96.5345	96.5393	96.5297	96.5393	71878.0
2021-07-23	ER	Futures	98.46	98.465	98.46	98.465	52769.0
2021-07-23	ESG	Futures	407.4	409.64	406.93	409.45	887.0
2021-07-23	EW	Futures	2841.9	2868.3	2838.1	2864.7	8619.0
2021-07-23	FBON	Futures	150.78	151.0	150.59	150.92	194.0
2021-07-23	FBTP	Futures	140.73	140.97	140.52	140.84	82810.0
2021-07-23	FBTS	Futures	110.322	110.38	110.322	110.36	40131.0
2021-07-23	FCE	Futures	6487.4	6564.7	6483.9	6552.2	41250.0
2021-07-23	FDAX	Futures	16649.1	16795.9	16635.2	16768.0	54150.0
2021-07-23	FDXM	Futures	16550.5	16713.6	16550.5	16684.8	33500.0
2021-07-23	FDXS	Futures	16446.5	16605.3	16446.5	16578.8	6229.0
2021-07-23	FESX	Futures	3848.9	3897.7	3847.5	3892.0	513836.0
2021-07-23	FGBL	Futures	170.39	170.46	170.06	170.31	476079.0
2021-07-23	FGBM	Futures	135.53	135.6	135.48	135.56	273637.0
2021-07-23	FGBS	Futures	112.699	112.719	112.694	112.714	235856.0
2021-07-23	FGBX	Futures	227.87	228.0	226.78	227.49	52802.0
2021-07-23	FMWO	Futures	10777.4	10860.9	10776.3	10846.8	3865.0
2021-07-23	FOAT	Futures	157.63	157.84	157.45	157.73	113718.0
2021-07-23	FTDX	Futures	3746.6	3767.1	3742.0	3759.4	18.0
2021-07-23	FTI	Futures	705.68	715.01	705.06	714.38	17930.0
2021-07-23	FTUK	Futures	6809.0	6864.7	6797.2	6854.8	66381.0
2021-07-23	FVSA	Futures	86.83	87.47	85.14	86.2	24649.0
2021-07-23	FXXP	Futures	433.4	438.6	432.7	438.2	52135.0

> showing 50 of 123 rows — these rows as CSV

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