PREVIEW / futures_daily / 2016-09-22

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-22.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
2016-09-22	ES	Futures	2332.19	2350.04	2328.41	2345.17	1523998.0
2016-09-22	NQ	Futures	5714.78	5765.75	5707.42	5758.68	196512.0
2016-09-22	YM	Futures	19126.6	19285.2	19103.5	19214.8	128681.0
2016-09-22	CL	Futures	50.3	51.3	50.19	51.08	521680.0
2016-09-22	GC	Futures	1717.8	1729.2	1712.9	1725.3	166856.0
2016-09-22	ZN	Futures	127.150086	127.530092	127.104485	127.302089	1077100.0
2016-09-22	A6	Futures	0.77703	0.78142	0.77632	0.77744	89106.0
2016-09-22	AD	Futures	0.78247	0.78831	0.78221	0.78446	58640.0
2016-09-22	ALI	Futures	2148.61	2148.61	2148.61	2148.61	0.0
2016-09-22	B	Futures	36.94	37.61	36.94	37.46	290326.0
2016-09-22	B6	Futures	1.3742	1.3835	1.3736	1.3784	85887.0
2016-09-22	BFX	Futures	4250.3	4286.7	4250.3	4286.7	1.0
2016-09-22	BR	Futures	0.21068	0.21109	0.20897	0.20897	619.0
2016-09-22	BZ	Futures	36.89	37.45	36.83	37.31	32336.0
2016-09-22	C	Futures	2452.0	2491.0	2452.0	2475.0	7666.0
2016-09-22	CB	Futures	248.608	253.289	248.608	250.282	10.0
2016-09-22	CC	Futures	2132.0	2170.0	2130.0	2160.0	18943.0
2016-09-22	CNH	Futures	7.2132	7.2161	7.2132	7.2161	2.0
2016-09-22	CSC	Futures	3.88	3.886	3.84	3.84	49.0
2016-09-22	CT	Futures	81.67	81.76	80.48	80.62	168.0
2016-09-22	DC	Futures	30.6	30.68	30.22	30.32	222.0
2016-09-22	DX	Futures	88.842	88.875	88.372	88.773	24311.0
2016-09-22	E1	Futures	1.28568	1.29602	1.28493	1.29079	26495.0
2016-09-22	E6	Futures	1.30205	1.30976	1.30112	1.30309	164867.0
2016-09-22	E7	Futures	1.2946	1.3025	1.2942	1.296	2766.0
2016-09-22	EBM	Futures	190.35	190.94	189.76	190.64	11141.0
2016-09-22	ED	Futures	95.6345	95.6538	95.6297	95.6442	234220.0
2016-09-22	ER	Futures	98.288	98.293	98.283	98.283	83174.0
2016-09-22	EW	Futures	1638.7	1661.8	1637.2	1660.0	20922.0
2016-09-22	FBON	Futures	124.89	125.43	124.87	125.19	1131.0
2016-09-22	FBTP	Futures	109.56	110.29	109.52	110.09	96095.0
2016-09-22	FBTS	Futures	101.266	101.347	101.266	101.338	24822.0
2016-09-22	FCE	Futures	3933.3	4018.3	3928.9	4000.5	100266.0
2016-09-22	FDAX	Futures	11095.8	11305.1	11076.8	11259.6	118325.0
2016-09-22	FDXM	Futures	11076.1	11280.6	11053.9	11235.3	43553.0
2016-09-22	FESX	Futures	2392.5	2443.0	2388.5	2431.0	1358269.0
2016-09-22	FEU3	Futures	98.971	98.971	98.966	98.966	71.0
2016-09-22	FGBL	Futures	150.03	150.94	150.03	150.85	775785.0
2016-09-22	FGBM	Futures	128.92	129.13	128.92	129.1	414566.0
2016-09-22	FGBS	Futures	111.932	111.952	111.922	111.937	199762.0
2016-09-22	FGBX	Futures	185.0	187.93	185.0	187.38	40545.0
2016-09-22	FMWO	Futures	5772.7	5809.0	5770.3	5800.5	413.0
2016-09-22	FOAT	Futures	137.86	138.69	137.86	138.63	106269.0
2016-09-22	FTDX	Futures	1754.3	1775.9	1754.3	1772.9	336.0
2016-09-22	FTI	Futures	412.47	419.81	411.97	417.56	29823.0
2016-09-22	FTUK	Futures	5768.0	5824.2	5758.3	5800.1	109698.0
2016-09-22	FVSA	Futures	1540.8	1540.8	1462.15	1476.45	18829.0
2016-09-22	FXXP	Futures	282.8	286.6	282.6	285.8	37715.0
2016-09-22	G	Futures	116.23	116.65	116.07	116.46	170095.0
2016-09-22	GF	Futures	273.136	276.798	272.465	272.93	3767.0

> showing 50 of 110 rows — these rows as CSV

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