PREVIEW / futures_daily / 2017-09-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-05.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-09-05	ES	Futures	2674.94	2685.81	2657.82	2673.31	2123649.0
2017-09-05	NQ	Futures	7002.11	7035.32	6923.35	6981.83	485650.0
2017-09-05	YM	Futures	23134.8	23201.4	22942.4	23006.9	211617.0
2017-09-05	CL	Futures	48.52	50.27	48.39	49.94	742808.0
2017-09-05	GC	Futures	1704.6	1717.4	1693.7	1710.8	368173.0
2017-09-05	ZN	Futures	125.258099	125.796744	125.1042	125.750575	76783.0
2017-09-05	A6	Futures	0.81708	0.82468	0.81574	0.82139	143461.0
2017-09-05	AD	Futures	0.82018	0.8246	0.81855	0.82185	87514.0
2017-09-05	ALI	Futures	2732.58	2732.58	2732.58	2732.58	0.0
2017-09-05	B	Futures	36.68	37.63	36.53	37.43	300776.0
2017-09-05	B6	Futures	1.3554	1.3637	1.3495	1.3635	142419.0
2017-09-05	BZ	Futures	36.71	37.3	36.14	37.11	24873.0
2017-09-05	C	Futures	1517.0	1541.0	1507.0	1510.0	2537.0
2017-09-05	CB	Futures	308.036	308.036	304.32	306.083	27.0
2017-09-05	CC	Futures	1446.0	1472.0	1441.0	1445.0	18940.0
2017-09-05	CNH	Futures	6.7479	6.7714	6.7479	6.7606	28.0
2017-09-05	CSC	Futures	3.427	3.435	3.414	3.425	10.0
2017-09-05	CT	Futures	85.14	88.17	85.14	87.83	93.0
2017-09-05	DC	Futures	28.42	28.48	28.26	28.39	31.0
2017-09-05	DX	Futures	86.476	86.556	86.042	86.118	27653.0
2017-09-05	E1	Futures	1.27997	1.2893	1.278	1.28783	57979.0
2017-09-05	E6	Futures	1.36227	1.36898	1.36067	1.36645	251429.0
2017-09-05	E7	Futures	1.3545	1.3618	1.3535	1.3593	4982.0
2017-09-05	EBM	Futures	173.7	175.59	173.7	175.32	15802.0
2017-09-05	ED	Futures	95.6032	95.6056	95.5983	95.6056	166567.0
2017-09-05	ER	Futures	98.342	98.342	98.337	98.337	62545.0
2017-09-05	EW	Futures	1835.9	1851.7	1817.2	1824.4	17733.0
2017-09-05	FBON	Futures	125.08	125.4	125.08	125.4	2870.0
2017-09-05	FBTP	Futures	109.32	109.9	109.11	109.73	222412.0
2017-09-05	FBTS	Futures	103.155	103.21	103.136	103.2	102185.0
2017-09-05	FCE	Futures	4564.6	4586.1	4516.3	4549.9	80873.0
2017-09-05	FDAX	Futures	12751.3	12855.0	12675.5	12758.1	109431.0
2017-09-05	FDXM	Futures	12678.6	12776.9	12597.0	12679.6	34739.0
2017-09-05	FESX	Futures	2800.6	2814.5	2770.4	2792.4	908917.0
2017-09-05	FGBL	Futures	149.93	150.65	149.75	150.38	1066179.0
2017-09-05	FGBM	Futures	129.93	130.19	129.86	130.06	871166.0
2017-09-05	FGBS	Futures	112.492	112.537	112.472	112.497	777000.0
2017-09-05	FGBX	Futures	168.93	171.26	168.3	170.38	142003.0
2017-09-05	FMWO	Futures	6547.2	6553.1	6534.1	6536.5	616.0
2017-09-05	FOAT	Futures	136.73	137.38	136.52	137.16	301795.0
2017-09-05	FTDX	Futures	2305.2	2322.2	2297.7	2311.7	760.0
2017-09-05	FTI	Futures	478.29	480.42	473.99	477.14	23913.0
2017-09-05	FTUK	Futures	6414.2	6423.7	6332.5	6368.8	103972.0
2017-09-05	FVSA	Futures	511.69	540.03	497.52	511.69	16125.0
2017-09-05	FXXP	Futures	318.7	320.1	316.4	318.3	44459.0
2017-09-05	G	Futures	116.24	116.9	116.13	116.7	247870.0
2017-09-05	GF	Futures	312.921	316.374	310.783	311.441	1914.0
2017-09-05	GSCI	Futures	463.96	467.85	463.96	465.69	105.0
2017-09-05	HE	Futures	86.885	90.209	86.605	89.229	30415.0
2017-09-05	HG	Futures	3.7719	3.8396	3.7604	3.7786	72680.0

> showing 50 of 109 rows — these rows as CSV

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