PREVIEW / futures_daily / 2017-06-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-06.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-06	ES	Futures	2643.7	2645.33	2635.01	2639.9	1353806.0
2017-06-06	NQ	Futures	6925.7	6941.01	6888.3	6905.67	257087.0
2017-06-06	YM	Futures	22345.3	22353.7	22278.8	22323.1	114810.0
2017-06-06	CL	Futures	49.1	50.13	48.62	49.92	825056.0
2017-06-06	GC	Futures	1637.2	1658.0	1636.7	1656.4	257790.0
2017-06-06	ZN	Futures	124.627168	125.01125	124.611804	124.888344	34371.0
2017-06-06	A6	Futures	0.76818	0.77208	0.76531	0.77065	111726.0
2017-06-06	AD	Futures	0.75717	0.75911	0.75636	0.75799	61905.0
2017-06-06	ALI	Futures	2496.05	2496.05	2496.05	2496.05	0.0
2017-06-06	B	Futures	35.26	35.78	34.86	35.65	329713.0
2017-06-06	B6	Futures	1.353	1.3581	1.35	1.3516	93645.0
2017-06-06	BFX	Futures	4672.8	4698.2	4672.8	4698.2	6.0
2017-06-06	BR	Futures	0.22052	0.22241	0.22052	0.22241	3.0
2017-06-06	BZ	Futures	35.05	35.63	34.7	35.5	41397.0
2017-06-06	C	Futures	1571.0	1571.0	1546.0	1558.0	7215.0
2017-06-06	CB	Futures	313.686	314.568	310.158	310.188	39.0
2017-06-06	CC	Futures	1525.0	1531.0	1496.0	1516.0	25194.0
2017-06-06	CNH	Futures	7.0641	7.0641	7.0479	7.0479	17.0
2017-06-06	CSC	Futures	3.627	3.627	3.606	3.606	23.0
2017-06-06	CT	Futures	84.51	84.9	84.07	84.19	17551.0
2017-06-06	DC	Futures	30.07	30.47	30.07	30.26	100.0
2017-06-06	DX	Futures	90.138	90.138	89.873	89.99	18621.0
2017-06-06	E1	Futures	1.28148	1.28629	1.28098	1.28469	21932.0
2017-06-06	E6	Futures	1.29735	1.30063	1.2955	1.29879	156412.0
2017-06-06	E7	Futures	1.2906	1.2939	1.289	1.2922	2933.0
2017-06-06	EBM	Futures	184.56	186.5	184.0	185.67	9883.0
2017-06-06	ED	Futures	95.5809	95.593	95.5809	95.5905	230524.0
2017-06-06	ER	Futures	98.337	98.337	98.332	98.337	41314.0
2017-06-06	EW	Futures	1850.4	1852.5	1838.2	1845.3	14589.0
2017-06-06	FBON	Futures	123.56	123.77	123.54	123.77	1190.0
2017-06-06	FBTP	Futures	106.39	106.64	106.24	106.44	202663.0
2017-06-06	FBTS	Futures	102.444	102.48	102.435	102.444	76873.0
2017-06-06	FCE	Futures	4753.7	4754.2	4714.2	4726.8	86482.0
2017-06-06	FDAX	Futures	13486.7	13504.1	13356.3	13392.7	88586.0
2017-06-06	FDXM	Futures	13372.4	13387.0	13238.4	13275.0	23219.0
2017-06-06	FESX	Futures	2910.0	2913.2	2887.9	2896.1	853862.0
2017-06-06	FEU3	Futures	99.011	99.011	99.011	99.011	56.0
2017-06-06	FGBL	Futures	149.47	149.89	149.47	149.83	1201927.0
2017-06-06	FGBM	Futures	129.83	129.95	129.79	129.93	747311.0
2017-06-06	FGBS	Futures	112.332	112.392	112.327	112.367	796434.0
2017-06-06	FGBX	Futures	168.32	169.8	168.28	169.25	128319.0
2017-06-06	FMWO	Futures	6490.4	6491.6	6477.1	6485.6	1115.0
2017-06-06	FOAT	Futures	135.95	136.5	135.91	136.36	272309.0
2017-06-06	FTDX	Futures	2270.5	2270.5	2249.4	2261.7	190.0
2017-06-06	FTI	Futures	480.66	480.75	477.31	478.41	23920.0
2017-06-06	FTUK	Futures	6439.7	6446.1	6410.6	6426.0	111352.0
2017-06-06	FVSA	Futures	494.35	494.35	484.19	489.27	9453.0
2017-06-06	FXXP	Futures	329.3	329.6	327.6	328.1	24766.0
2017-06-06	G	Futures	116.17	116.67	116.14	116.63	161420.0
2017-06-06	GF	Futures	352.711	353.205	341.077	341.077	5409.0

> showing 50 of 110 rows — these rows as CSV

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