PREVIEW / futures_daily / 2017-09-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-01.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-01	ES	Futures	2684.72	2695.05	2684.45	2689.07	1057024.0
2017-09-01	NQ	Futures	7046.19	7076.46	7021.8	7039.43	229855.0
2017-09-01	YM	Futures	23231.0	23295.5	23220.4	23235.2	87130.0
2017-09-01	CL	Futures	48.32	48.6	47.79	48.54	915708.0
2017-09-01	GC	Futures	1688.4	1698.0	1681.4	1692.8	376308.0
2017-09-01	ZN	Futures	125.350438	125.565896	124.965692	125.042641	123220.0
2017-09-01	A6	Futures	0.81615	0.82149	0.81369	0.81852	110850.0
2017-09-01	AD	Futures	0.81468	0.8243	0.81428	0.82099	112465.0
2017-09-01	ALI	Futures	2782.61	2782.61	2782.61	2782.61	0.0
2017-09-01	B	Futures	37.05	37.13	36.63	36.99	262197.0
2017-09-01	B6	Futures	1.3515	1.3588	1.3493	1.3545	105574.0
2017-09-01	BR	Futures	0.2366	0.23785	0.2366	0.23728	41.0
2017-09-01	BZ	Futures	36.69	36.8	36.31	36.67	43495.0
2017-09-01	C	Futures	1509.0	1531.0	1505.0	1515.0	3160.0
2017-09-01	CB	Futures	314.681	314.681	309.264	309.579	33.0
2017-09-01	CC	Futures	1429.0	1464.0	1426.0	1446.0	22231.0
2017-09-01	CNH	Futures	6.8055	6.8055	6.7836	6.7836	69.0
2017-09-01	CSC	Futures	3.418	3.423	3.406	3.416	88.0
2017-09-01	CT	Futures	83.91	84.86	83.9	84.67	28.0
2017-09-01	DC	Futures	28.46	28.46	28.23	28.33	78.0
2017-09-01	DX	Futures	86.467	86.752	85.953	86.625	44564.0
2017-09-01	E1	Futures	1.28267	1.28795	1.27346	1.27395	34738.0
2017-09-01	E6	Futures	1.36657	1.37367	1.35855	1.36061	273582.0
2017-09-01	E7	Futures	1.3595	1.3665	1.3514	1.3535	5266.0
2017-09-01	EBM	Futures	173.98	174.81	171.47	171.47	4609.0
2017-09-01	ED	Futures	95.6007	95.6032	95.5959	95.6007	167781.0
2017-09-01	ER	Futures	98.342	98.342	98.337	98.342	23826.0
2017-09-01	EW	Futures	1837.8	1848.5	1837.8	1844.8	10595.0
2017-09-01	FBON	Futures	125.19	125.2	124.64	124.8	358.0
2017-09-01	FBTP	Futures	109.26	109.55	108.82	108.97	179384.0
2017-09-01	FBTS	Futures	103.136	103.164	103.118	103.155	112320.0
2017-09-01	FCE	Futures	4559.2	4597.7	4557.9	4583.0	129358.0
2017-09-01	FDAX	Futures	12699.7	12834.5	12698.1	12785.0	79877.0
2017-09-01	FDXM	Futures	12626.3	12755.0	12622.1	12706.3	24577.0
2017-09-01	FESX	Futures	2796.5	2820.2	2796.5	2811.2	773139.0
2017-09-01	FGBL	Futures	150.03	150.08	149.46	149.77	946838.0
2017-09-01	FGBM	Futures	129.92	129.93	129.73	129.83	693975.0
2017-09-01	FGBS	Futures	112.482	112.482	112.442	112.467	542138.0
2017-09-01	FGBX	Futures	170.12	170.33	168.1	168.79	87393.0
2017-09-01	FMWO	Futures	6561.5	6575.8	6557.9	6567.4	4083.0
2017-09-01	FOAT	Futures	136.84	136.97	136.44	136.65	197072.0
2017-09-01	FTDX	Futures	2294.2	2323.7	2292.2	2313.2	258.0
2017-09-01	FTI	Futures	479.13	481.07	478.62	479.73	19831.0
2017-09-01	FTUK	Futures	6422.8	6444.4	6409.0	6432.8	71178.0
2017-09-01	FVSA	Futures	499.09	500.67	480.2	486.5	16835.0
2017-09-01	FXXP	Futures	318.9	321.0	318.9	320.4	23793.0
2017-09-01	G	Futures	116.51	116.65	116.1	116.23	166912.0
2017-09-01	GF	Futures	313.305	315.387	311.441	312.921	1741.0
2017-09-01	GSCI	Futures	461.45	462.7	458.7	461.99	157.0
2017-09-01	HE	Futures	85.8	87.585	85.625	86.01	22253.0

> showing 50 of 109 rows — these rows as CSV

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