PREVIEW / futures_daily / 2017-11-08

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-08.parquet
  size:    9 KB
  rows:    111

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-11-08	ES	Futures	2810.6	2819.85	2805.98	2818.22	1058023.0
2017-11-08	NQ	Futures	7412.39	7453.5	7401.81	7448.8	218248.0
2017-11-08	YM	Futures	24774.7	24823.3	24746.2	24806.4	97478.0
2017-11-08	CL	Futures	57.44	58.41	56.88	57.29	919147.0
2017-11-08	GC	Futures	1624.1	1639.0	1623.7	1633.4	358132.0
2017-11-08	ZN	Futures	123.609198	123.701628	123.393529	123.485959	1001966.0
2017-11-08	A6	Futures	0.78671	0.79041	0.78619	0.78959	76470.0
2017-11-08	AD	Futures	0.79692	0.80043	0.79667	0.79977	53568.0
2017-11-08	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-08	B	Futures	45.05	45.72	44.53	44.91	418072.0
2017-11-08	B6	Futures	1.3745	1.3752	1.3658	1.3685	92458.0
2017-11-08	BFX	Futures	4854.2	4854.8	4854.2	4854.8	1.0
2017-11-08	BR	Futures	0.22943	0.23204	0.22943	0.23143	2397.0
2017-11-08	BZ	Futures	44.61	45.31	44.13	44.51	41527.0
2017-11-08	C	Futures	1565.0	1600.0	1564.0	1594.0	23622.0
2017-11-08	CB	Futures	281.802	281.802	275.881	275.881	33.0
2017-11-08	CC	Futures	1607.0	1639.0	1600.0	1632.0	43895.0
2017-11-08	CNH	Futures	6.8295	6.8355	6.8192	6.8192	12.0
2017-11-08	CSC	Futures	3.394	3.394	3.363	3.369	134.0
2017-11-08	CT	Futures	79.95	81.22	79.94	80.61	33534.0
2017-11-08	DC	Futures	27.32	27.32	26.92	27.04	528.0
2017-11-08	DX	Futures	88.62	88.714	88.541	88.623	11409.0
2017-11-08	E1	Futures	1.22626	1.22809	1.22491	1.22552	15721.0
2017-11-08	E6	Futures	1.32543	1.32765	1.32394	1.32583	149685.0
2017-11-08	E7	Futures	1.3185	1.3206	1.3171	1.3189	2652.0
2017-11-08	EBM	Futures	174.51	174.78	173.16	173.16	18655.0
2017-11-08	ED	Futures	95.4697	95.4745	95.4648	95.4648	170859.0
2017-11-08	ER	Futures	98.347	98.347	98.342	98.347	9274.0
2017-11-08	EW	Futures	1943.2	1952.2	1938.0	1950.8	10510.0
2017-11-08	FBON	Futures	126.91	126.91	126.18	126.34	1239.0
2017-11-08	FBTP	Futures	113.62	113.74	113.15	113.31	115125.0
2017-11-08	FBTS	Futures	103.722	103.75	103.686	103.732	72162.0
2017-11-08	FCE	Futures	4913.5	4926.1	4885.7	4903.7	73088.0
2017-11-08	FDAX	Futures	14044.3	14102.6	14022.2	14071.6	75759.0
2017-11-08	FDXM	Futures	13921.1	13983.6	13903.4	13952.9	25169.0
2017-11-08	FESX	Futures	2980.1	2988.2	2966.2	2976.0	1009420.0
2017-11-08	FEU3	Futures	99.011	99.016	99.011	99.016	8.0
2017-11-08	FGBL	Futures	151.04	151.3	150.92	151.08	690255.0
2017-11-08	FGBM	Futures	130.3	130.38	130.26	130.31	386094.0
2017-11-08	FGBS	Futures	112.582	112.587	112.567	112.572	165037.0
2017-11-08	FGBX	Futures	170.24	170.93	169.95	170.38	45262.0
2017-11-08	FMWO	Futures	6813.6	6813.6	6797.0	6807.6	2119.0
2017-11-08	FOAT	Futures	138.95	139.17	138.85	138.96	128353.0
2017-11-08	FTDX	Futures	2544.9	2546.4	2505.5	2519.9	222.0
2017-11-08	FTI	Futures	512.61	514.14	511.92	513.03	20017.0
2017-11-08	FTUK	Futures	6482.9	6515.9	6479.0	6506.7	82429.0
2017-11-08	FVSA	Futures	319.74	327.41	312.07	321.02	30972.0
2017-11-08	FXXP	Futures	334.6	335.2	333.4	334.6	24646.0
2017-11-08	G	Futures	114.84	115.21	114.79	115.02	177407.0
2017-11-08	GF	Futures	343.913	344.344	338.633	339.064	1853.0

> showing 50 of 111 rows — these rows as CSV

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