PREVIEW / futures_daily / 2017-08-04

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-04.parquet
  size:    9 KB
  rows:    109

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-08-04	ES	Futures	2685.27	2692.87	2682.01	2686.63	1070866.0
2017-08-04	NQ	Futures	6922.76	6949.8	6905.42	6933.34	256730.0
2017-08-04	YM	Futures	23236.3	23305.0	23209.9	23274.3	99367.0
2017-08-04	CL	Futures	50.35	51.06	49.89	51.0	745664.0
2017-08-04	GC	Futures	1622.7	1624.2	1603.0	1609.1	270853.0
2017-08-04	ZN	Futures	124.488606	124.534775	124.01152	124.180808	1266517.0
2017-08-04	A6	Futures	0.81636	0.81934	0.81019	0.81369	113579.0
2017-08-04	AD	Futures	0.80894	0.81148	0.8034	0.80441	83906.0
2017-08-04	ALI	Futures	2522.32	2522.32	2522.32	2522.32	0.0
2017-08-04	B	Futures	36.35	36.74	35.98	36.67	278784.0
2017-08-04	B6	Futures	1.375	1.3777	1.3629	1.3641	107974.0
2017-08-04	BR	Futures	0.23759	0.23759	0.23581	0.23629	1133.0
2017-08-04	BZ	Futures	36.0	36.42	35.67	36.35	26969.0
2017-08-04	C	Futures	1606.0	1626.0	1566.0	1575.0	11096.0
2017-08-04	CB	Futures	333.179	333.787	333.057	333.301	3.0
2017-08-04	CC	Futures	1564.0	1574.0	1505.0	1514.0	36243.0
2017-08-04	CNH	Futures	6.9736	6.9759	6.9719	6.9719	7.0
2017-08-04	CSC	Futures	3.536	3.536	3.48	3.487	58.0
2017-08-04	CT	Futures	84.03	84.29	82.16	82.85	86.0
2017-08-04	DC	Futures	29.27	29.65	28.99	29.06	439.0
2017-08-04	DX	Futures	86.476	87.438	86.448	87.229	31041.0
2017-08-04	E1	Futures	1.27149	1.27334	1.26105	1.26547	36334.0
2017-08-04	E6	Futures	1.36296	1.36514	1.34663	1.35087	262476.0
2017-08-04	E7	Futures	1.356	1.3579	1.3397	1.3438	5717.0
2017-08-04	EBM	Futures	181.77	182.89	181.49	181.77	8182.0
2017-08-04	ED	Futures	95.5983	95.5983	95.5886	95.5983	152889.0
2017-08-04	ER	Futures	98.342	98.342	98.337	98.342	33098.0
2017-08-04	EW	Futures	1854.9	1861.9	1852.6	1859.3	12896.0
2017-08-04	FBON	Futures	124.9	124.9	124.48	124.63	359.0
2017-08-04	FBTP	Futures	109.61	109.74	109.16	109.29	57599.0
2017-08-04	FBTS	Futures	103.009	103.009	102.954	102.982	25595.0
2017-08-04	FCE	Futures	4604.2	4684.1	4593.0	4673.8	87611.0
2017-08-04	FDAX	Futures	12778.7	12970.3	12758.1	12941.9	78642.0
2017-08-04	FDXM	Futures	12701.6	12888.9	12679.6	12862.2	23626.0
2017-08-04	FESX	Futures	2823.4	2868.3	2818.5	2861.0	882689.0
2017-08-04	FGBL	Futures	148.51	148.54	147.98	148.19	490143.0
2017-08-04	FGBM	Futures	129.19	129.21	129.03	129.12	256808.0
2017-08-04	FGBS	Futures	112.307	112.307	112.267	112.292	213971.0
2017-08-04	FGBX	Futures	167.62	167.62	166.08	166.59	27773.0
2017-08-04	FMWO	Futures	6575.8	6582.9	6572.2	6574.6	510.0
2017-08-04	FOAT	Futures	136.15	136.15	135.61	135.75	103711.0
2017-08-04	FTDX	Futures	2257.6	2287.2	2257.6	2280.2	71.0
2017-08-04	FTI	Futures	483.62	488.48	482.38	487.74	25002.0
2017-08-04	FTUK	Futures	6400.8	6451.3	6397.3	6444.0	67983.0
2017-08-04	FVSA	Futures	428.67	433.12	416.8	419.77	20428.0
2017-08-04	FXXP	Futures	321.8	325.5	321.0	325.0	27695.0
2017-08-04	G	Futures	115.31	115.34	114.89	115.06	127320.0
2017-08-04	GF	Futures	329.991	330.705	327.796	329.168	3088.0
2017-08-04	GSCI	Futures	466.56	466.87	464.01	466.38	671.0
2017-08-04	HE	Futures	92.238	93.708	92.168	93.463	12265.0

> showing 50 of 109 rows — these rows as CSV

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