PREVIEW / futures_daily / 2017-10-25

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-25.parquet
  size:    9 KB
  rows:    110

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
2017-10-25	ES	Futures	2789.66	2791.29	2764.37	2782.87	2099172.0
2017-10-25	NQ	Futures	7134.0	7150.45	7060.59	7123.43	436671.0
2017-10-25	YM	Futures	24698.7	24727.2	24502.2	24605.7	189234.0
2017-10-25	CL	Futures	53.0	53.01	52.33	52.62	681739.0
2017-10-25	GC	Futures	1626.1	1630.3	1618.5	1627.4	379396.0
2017-10-25	ZN	Futures	122.885166	122.931381	122.438423	122.700307	2025047.0
2017-10-25	A6	Futures	0.79957	0.80049	0.79072	0.79123	145989.0
2017-10-25	AD	Futures	0.80272	0.80562	0.79412	0.79448	137626.0
2017-10-25	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-25	B	Futures	41.19	41.38	40.8	41.19	258536.0
2017-10-25	B6	Futures	1.3712	1.3857	1.369	1.384	152257.0
2017-10-25	BR	Futures	0.23181	0.23238	0.23079	0.23128	1351.0
2017-10-25	BZ	Futures	40.86	41.0	40.44	40.82	23095.0
2017-10-25	C	Futures	1528.0	1532.0	1507.0	1515.0	8745.0
2017-10-25	CB	Futures	287.313	294.809	287.313	294.494	39.0
2017-10-25	CC	Futures	1547.0	1568.0	1532.0	1544.0	22889.0
2017-10-25	CNH	Futures	6.8385	6.8447	6.8348	6.8348	14.0
2017-10-25	CSC	Futures	3.439	3.468	3.435	3.456	21.0
2017-10-25	CT	Futures	81.71	82.1	81.19	81.41	11524.0
2017-10-25	DC	Futures	27.7	28.01	27.7	27.87	323.0
2017-10-25	DX	Futures	87.746	87.802	87.414	87.509	24505.0
2017-10-25	E1	Futures	1.23775	1.24301	1.2342	1.2402	35577.0
2017-10-25	E6	Futures	1.34597	1.3523	1.34494	1.35093	208971.0
2017-10-25	E7	Futures	1.339	1.3452	1.3379	1.3439	3115.0
2017-10-25	EBM	Futures	174.24	175.59	174.24	174.51	14864.0
2017-10-25	ED	Futures	95.4939	95.4988	95.4842	95.4939	252499.0
2017-10-25	ER	Futures	98.342	98.347	98.337	98.342	54738.0
2017-10-25	EW	Futures	1943.1	1944.4	1920.7	1934.2	13307.0
2017-10-25	FBON	Futures	124.61	124.84	124.61	124.7	155.0
2017-10-25	FBTP	Futures	109.97	110.31	109.88	110.27	93541.0
2017-10-25	FBTS	Futures	103.448	103.475	103.439	103.457	28744.0
2017-10-25	FCE	Futures	4832.0	4851.2	4795.7	4813.6	74347.0
2017-10-25	FDAX	Futures	13658.6	13707.5	13565.0	13599.7	91359.0
2017-10-25	FDXM	Futures	13542.8	13591.8	13451.1	13485.0	32869.0
2017-10-25	FESX	Futures	2936.8	2949.9	2910.7	2920.5	959814.0
2017-10-25	FEU3	Futures	99.016	99.016	99.006	99.011	2.0
2017-10-25	FGBL	Futures	148.97	149.15	148.64	148.9	800662.0
2017-10-25	FGBM	Futures	129.56	129.62	129.42	129.52	524477.0
2017-10-25	FGBS	Futures	112.442	112.452	112.427	112.442	219972.0
2017-10-25	FGBX	Futures	166.18	166.58	165.46	165.95	55522.0
2017-10-25	FMWO	Futures	6751.0	6751.0	6706.1	6717.9	706.0
2017-10-25	FOAT	Futures	136.47	136.68	136.23	136.48	112118.0
2017-10-25	FTDX	Futures	2478.0	2483.5	2457.5	2463.0	198.0
2017-10-25	FTI	Futures	502.32	503.67	497.83	499.96	26757.0
2017-10-25	FTUK	Futures	6499.4	6505.9	6419.1	6433.0	112651.0
2017-10-25	FVSA	Futures	361.95	390.08	351.72	379.85	31370.0
2017-10-25	FXXP	Futures	329.6	331.1	327.1	328.1	30376.0
2017-10-25	G	Futures	113.68	113.75	112.74	113.05	220020.0
2017-10-25	GF	Futures	336.478	339.764	334.861	336.586	4171.0
2017-10-25	GSCI	Futures	479.16	479.4	478.99	478.99	6.0

> showing 50 of 110 rows — these rows as CSV

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