PREVIEW / futures_daily / 2017-06-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-14.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-06-14	ES	Futures	2649.95	2655.38	2636.36	2646.68	1818280.0
2017-06-14	NQ	Futures	6773.76	6805.21	6685.3	6739.08	429542.0
2017-06-14	YM	Futures	22497.4	22565.0	22459.3	22544.9	170404.0
2017-06-14	CL	Futures	47.64	48.2	46.2	46.4	460269.0
2017-06-14	GC	Futures	1619.2	1639.4	1607.2	1628.8	348339.0
2017-06-14	ZN	Futures	124.442436	125.335048	124.427046	125.011861	2442293.0
2017-06-14	A6	Futures	0.77301	0.78328	0.7728	0.77876	64880.0
2017-06-14	AD	Futures	0.76948	0.77385	0.76765	0.76892	70483.0
2017-06-14	ALI	Futures	2484.63	2486.85	2484.0	2484.0	20.0
2017-06-14	B	Futures	34.27	34.64	33.25	33.43	464423.0
2017-06-14	B6	Futures	1.3367	1.3435	1.3336	1.336	110138.0
2017-06-14	BR	Futures	0.22059	0.22248	0.22059	0.22248	18.0
2017-06-14	BZ	Futures	34.13	34.48	33.13	33.29	44939.0
2017-06-14	C	Futures	1641.0	1652.0	1627.0	1649.0	6687.0
2017-06-14	CB	Futures	327.31	332.996	325.424	332.966	31.0
2017-06-14	CC	Futures	1555.0	1577.0	1544.0	1575.0	25972.0
2017-06-14	CNH	Futures	7.0754	7.0754	7.0572	7.0642	31.0
2017-06-14	CSC	Futures	3.655	3.655	3.629	3.655	55.0
2017-06-14	CT	Futures	82.47	82.87	81.29	81.4	16142.0
2017-06-14	DC	Futures	30.64	30.64	30.38	30.57	121.0
2017-06-14	DX	Futures	90.319	90.398	89.66	90.193	21432.0
2017-06-14	E1	Futures	1.27579	1.28181	1.26941	1.27149	18473.0
2017-06-14	E6	Futures	1.29084	1.3008	1.28906	1.29164	269316.0
2017-06-14	E7	Futures	1.2837	1.2939	1.2823	1.2849	6143.0
2017-06-14	EBM	Futures	189.84	191.24	188.45	189.01	12351.0
2017-06-14	ED	Futures	95.5644	95.6225	95.5644	95.5935	738949.0
2017-06-14	ER	Futures	98.337	98.342	98.332	98.337	105940.0
2017-06-14	EW	Futures	1880.5	1884.5	1863.5	1871.8	18443.0
2017-06-14	FBON	Futures	124.68	125.45	124.62	125.33	1532.0
2017-06-14	FBTP	Futures	109.14	109.63	109.02	109.49	97697.0
2017-06-14	FBTS	Futures	102.854	102.89	102.827	102.863	33172.0
2017-06-14	FCE	Futures	4748.8	4784.4	4711.8	4719.0	135914.0
2017-06-14	FDAX	Futures	13493.0	13642.4	13488.8	13541.0	146597.0
2017-06-14	FDXM	Futures	13364.0	13515.7	13364.0	13414.2	2635.0
2017-06-14	FESX	Futures	2900.2	2923.0	2882.2	2892.8	1580734.0
2017-06-14	FEU3	Futures	99.006	99.016	99.006	99.016	97.0
2017-06-14	FGBL	Futures	149.94	150.39	149.74	150.31	682811.0
2017-06-14	FGBM	Futures	129.87	129.94	129.72	129.93	416220.0
2017-06-14	FGBS	Futures	112.377	112.377	112.327	112.357	312603.0
2017-06-14	FGBX	Futures	169.96	171.9	169.74	171.5	51182.0
2017-06-14	FMWO	Futures	6501.2	6513.3	6484.4	6501.2	3627.0
2017-06-14	FOAT	Futures	137.21	137.45	137.01	137.38	111226.0
2017-06-14	FTDX	Futures	2294.7	2300.2	2279.2	2285.7	1903.0
2017-06-14	FTI	Futures	482.99	486.64	480.66	480.66	36829.0
2017-06-14	FTUK	Futures	6432.8	6465.6	6392.6	6420.2	213443.0
2017-06-14	FVSA	Futures	472.34	478.64	456.6	475.49	17201.0
2017-06-14	FXXP	Futures	330.3	331.9	328.4	329.0	108769.0
2017-06-14	G	Futures	116.23	117.3	116.11	117.16	232348.0
2017-06-14	GF	Futures	327.302	327.961	319.509	320.771	7649.0
2017-06-14	GSCI	Futures	449.26	449.26	439.95	440.8	199.0

> showing 50 of 110 rows — these rows as CSV

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