PREVIEW / futures_daily / 2020-04-01

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-01.parquet
  size:    10 KB
  rows:    118

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
2020-04-01	ES	Futures	2834.82	2835.09	2693.46	2708.68	2091378.0
2020-04-01	NQ	Futures	8910.7	8911.85	8488.53	8528.08	411364.0
2020-04-01	YM	Futures	23157.2	23157.2	22032.5	22130.7	207275.0
2020-04-01	CL	Futures	19.92	21.36	19.72	20.13	703286.0
2020-04-01	GC	Futures	1927.5	1955.4	1911.3	1929.9	164482.0
2020-04-01	ZN	Futures	137.114642	137.732067	137.099206	137.299869	1342210.0
2020-04-01	A6	Futures	0.63254	0.63573	0.62062	0.62402	89234.0
2020-04-01	AD	Futures	0.7208	0.721	0.71036	0.7131	71850.0
2020-04-01	ALI	Futures	1823.48	1826.21	1816.2	1822.87	27.0
2020-04-01	B	Futures	19.91	20.13	18.78	18.95	347286.0
2020-04-01	B6	Futures	1.2627	1.2642	1.2531	1.2571	64615.0
2020-04-01	BR	Futures	0.15501	0.15611	0.15489	0.15534	86.0
2020-04-01	BTC	Futures	9156.4	9170.6	8730.9	8808.9	2656.0
2020-04-01	BZ	Futures	19.27	19.52	18.24	18.38	43466.0
2020-04-01	C	Futures	1616.0	1622.0	1604.0	1605.0	7268.0
2020-04-01	CB	Futures	161.722	166.462	161.722	166.462	82.0
2020-04-01	CC	Futures	1463.0	1472.0	1451.0	1458.0	11954.0
2020-04-01	CNH	Futures	7.0287	7.0648	7.0151	7.0648	601.0
2020-04-01	CSC	Futures	2.648	2.714	2.642	2.714	232.0
2020-04-01	CT	Futures	49.08	49.34	46.55	46.61	19089.0
2020-04-01	DC	Futures	20.83	21.65	20.83	21.57	678.0
2020-04-01	DX	Futures	95.755	96.615	95.687	96.459	12125.0
2020-04-01	E1	Futures	1.18943	1.19	1.17896	1.18157	24434.0
2020-04-01	E6	Futures	1.18896	1.18971	1.17483	1.17762	158748.0
2020-04-01	E7	Futures	1.1835	1.1835	1.1687	1.1715	6195.0
2020-04-01	EBM	Futures	218.65	218.93	216.13	216.69	16117.0
2020-04-01	ED	Futures	96.1793	96.1889	96.1406	96.1502	304359.0
2020-04-01	ER	Futures	98.318	98.323	98.303	98.308	75092.0
2020-04-01	EW	Futures	1510.7	1510.7	1420.6	1432.1	11599.0
2020-04-01	FBON	Futures	141.3	141.42	140.52	140.63	470.0
2020-04-01	FBTP	Futures	126.46	127.26	125.59	126.37	70327.0
2020-04-01	FBTS	Futures	107.364	107.46	107.133	107.268	35672.0
2020-04-01	FCE	Futures	4142.7	4145.1	3993.5	4072.0	63749.0
2020-04-01	FDAX	Futures	10238.0	10301.4	9836.1	10033.9	111565.0
2020-04-01	FDIV	Futures	108.74	108.74	107.07	107.07	100.0
2020-04-01	FDXM	Futures	10271.0	10349.6	9880.9	10081.8	96958.0
2020-04-01	FESX	Futures	2459.8	2476.3	2367.1	2414.8	1360727.0
2020-04-01	FGBL	Futures	167.87	168.63	167.41	167.75	483245.0
2020-04-01	FGBM	Futures	134.57	134.82	134.31	134.45	314420.0
2020-04-01	FGBS	Futures	112.845	112.925	112.78	112.82	211926.0
2020-04-01	FGBX	Futures	223.05	226.16	222.88	224.83	40983.0
2020-04-01	FMWO	Futures	6229.2	6252.7	6125.7	6212.7	12659.0
2020-04-01	FOAT	Futures	152.74	153.06	152.03	152.26	104243.0
2020-04-01	FTDX	Futures	2551.8	2570.0	2540.2	2546.8	36.0
2020-04-01	FTI	Futures	438.81	444.96	431.13	440.78	30460.0
2020-04-01	FTUK	Futures	5186.8	5237.2	5035.9	5110.4	148783.0
2020-04-01	FVSA	Futures	420.39	435.69	402.39	415.89	17045.0
2020-04-01	FXXP	Futures	283.6	287.0	279.3	283.8	92494.0
2020-04-01	G	Futures	125.4	125.67	125.16	125.35	202379.0
2020-04-01	GF	Futures	246.053	247.559	243.821	243.821	796.0

> showing 50 of 118 rows — these rows as CSV

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