PREVIEW / futures_daily / 2021-04-20

all futures daily files

  file:    by_date/futures_daily/2021/2021-04-20.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-04-20	ES	Futures	4663.95	4676.3	4612.61	4630.57	1700883.0
2021-04-20	NQ	Futures	16032.53	16071.45	15824.04	15910.55	606019.0
2021-04-20	YM	Futures	36795.1	36870.8	36336.2	36478.0	168388.0
2021-04-20	CL	Futures	45.23	45.84	43.78	44.62	476046.0
2021-04-20	GC	Futures	2075.6	2087.7	2067.4	2084.9	169041.0
2021-04-20	ZN	Futures	132.877012	133.285333	132.657147	133.238219	1414513.0
2021-04-20	A6	Futures	0.79536	0.80156	0.79064	0.79121	96556.0
2021-04-20	AD	Futures	0.80878	0.81207	0.8026	0.803	84857.0
2021-04-20	ALI	Futures	2700.11	2700.68	2668.99	2668.99	379.0
2021-04-20	B	Futures	43.46	44.03	42.37	43.05	328240.0
2021-04-20	B6	Futures	1.4206	1.4228	1.4143	1.4146	78078.0
2021-04-20	BFX	Futures	4006.9	4009.9	3987.4	3991.5	8.0
2021-04-20	BR	Futures	0.14352	0.14447	0.14127	0.14198	195.0
2021-04-20	BTC	Futures	73285.0	74351.7	69505.9	73779.3	9193.0
2021-04-20	BZ	Futures	42.34	42.95	41.32	42.0	40194.0
2021-04-20	C	Futures	1472.0	1482.0	1459.0	1459.0	2147.0
2021-04-20	CB	Futures	155.62	155.64	151.223	151.925	16.0
2021-04-20	CC	Futures	1657.0	1667.0	1608.0	1611.0	21225.0
2021-04-20	CNH	Futures	6.3312	6.3352	6.3169	6.3253	271.0
2021-04-20	CSC	Futures	2.937	2.982	2.921	2.96	84.0
2021-04-20	CT	Futures	79.0	80.05	79.0	79.26	5171.0
2021-04-20	DC	Futures	26.82	27.37	26.67	27.24	289.0
2021-04-20	DX	Futures	87.978	88.2	87.784	88.158	25945.0
2021-04-20	E1	Futures	1.23184	1.23375	1.22903	1.23004	15228.0
2021-04-20	E6	Futures	1.284	1.28864	1.28246	1.28336	151021.0
2021-04-20	E7	Futures	1.2774	1.2821	1.276	1.2769	4324.0
2021-04-20	EBM	Futures	277.47	286.09	276.83	284.81	11078.0
2021-04-20	ED	Futures	96.4883	96.4932	96.4835	96.4883	74681.0
2021-04-20	ER	Futures	98.45	98.455	98.45	98.45	48287.0
2021-04-20	ESG	Futures	386.62	386.69	381.63	383.07	479.0
2021-04-20	EW	Futures	2890.9	2902.9	2830.8	2847.7	10718.0
2021-04-20	FBON	Futures	147.58	147.88	147.48	147.77	574.0
2021-04-20	FBTP	Futures	137.52	137.88	137.4	137.75	137243.0
2021-04-20	FBTS	Futures	109.981	110.01	109.961	109.991	54107.0
2021-04-20	FCE	Futures	6164.1	6165.1	6014.5	6029.8	79871.0
2021-04-20	FDAX	Futures	16434.3	16436.4	16119.8	16135.8	63398.0
2021-04-20	FDIV	Futures	185.29	185.29	182.21	182.21	196.0
2021-04-20	FDXM	Futures	16391.9	16413.2	16100.2	16116.2	58892.0
2021-04-20	FDXS	Futures	16275.9	16275.9	16018.6	16030.2	28.0
2021-04-20	FESX	Futures	3757.3	3759.2	3676.0	3679.8	974174.0
2021-04-20	FEU3	Futures	99.193	99.198	99.193	99.198	20.0
2021-04-20	FGBL	Futures	166.59	167.12	166.3	166.94	820263.0
2021-04-20	FGBM	Futures	134.49	134.68	134.4	134.64	416465.0
2021-04-20	FGBS	Futures	112.619	112.649	112.604	112.644	301115.0
2021-04-20	FGBX	Futures	216.17	217.94	215.49	217.26	85699.0
2021-04-20	FMWO	Futures	10354.5	10361.6	10190.1	10207.7	2493.0
2021-04-20	FOAT	Futures	154.99	155.41	154.77	155.26	176987.0
2021-04-20	FTDX	Futures	3608.7	3615.4	3553.7	3564.5	118.0
2021-04-20	FTI	Futures	670.7	672.12	658.46	659.57	22111.0
2021-04-20	FTUK	Futures	6777.4	6789.0	6637.1	6642.4	107588.0

> showing 50 of 123 rows — these rows as CSV

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