PREVIEW / futures_daily / 2017-04-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-27.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-04-27	ES	Futures	2586.41	2594.29	2583.43	2591.3	1115269.0
2017-04-27	NQ	Futures	6519.36	6594.44	6518.18	6585.02	194734.0
2017-04-27	YM	Futures	22053.0	22104.7	22022.4	22050.9	116450.0
2017-04-27	CL	Futures	51.36	51.57	50.29	51.09	771189.0
2017-04-27	GC	Futures	1624.3	1625.5	1613.6	1618.8	210731.0
2017-04-27	ZN	Futures	123.490283	123.674642	123.33665	123.536373	1417606.0
2017-04-27	A6	Futures	0.76664	0.76849	0.76305	0.76623	81571.0
2017-04-27	AD	Futures	0.74917	0.75427	0.74646	0.74937	94035.0
2017-04-27	ALI	Futures	2548.47	2548.47	2548.47	2548.47	0.0
2017-04-27	B	Futures	37.37	37.49	36.58	37.16	538784.0
2017-04-27	B6	Futures	1.3481	1.356	1.3479	1.3549	112294.0
2017-04-27	BR	Futures	0.22553	0.22741	0.22553	0.22618	3419.0
2017-04-27	BZ	Futures	37.14	37.21	36.3	36.9	43490.0
2017-04-27	C	Futures	1492.0	1495.0	1468.0	1489.0	2090.0
2017-04-27	CB	Futures	262.119	262.424	262.119	262.424	7.0
2017-04-27	CC	Futures	1437.0	1440.0	1408.0	1428.0	14847.0
2017-04-27	CNH	Futures	7.2175	7.2197	7.2165	7.2172	34.0
2017-04-27	CSC	Futures	3.484	3.527	3.484	3.527	84.0
2017-04-27	CT	Futures	87.83	87.89	86.22	86.34	15468.0
2017-04-27	DC	Futures	28.71	29.25	28.65	29.19	492.0
2017-04-27	DX	Futures	92.1	92.43	91.946	92.193	40179.0
2017-04-27	E1	Futures	1.24737	1.2491	1.24379	1.2475	23344.0
2017-04-27	E6	Futures	1.25911	1.26233	1.25289	1.25651	246616.0
2017-04-27	E7	Futures	1.2525	1.2559	1.2466	1.2502	8250.0
2017-04-27	EBM	Futures	187.06	188.46	186.78	187.9	23827.0
2017-04-27	ED	Futures	95.5446	95.5688	95.5397	95.5639	178187.0
2017-04-27	ER	Futures	98.332	98.337	98.328	98.337	92396.0
2017-04-27	EW	Futures	1855.3	1864.1	1851.6	1857.6	13583.0
2017-04-27	FBON	Futures	121.57	122.31	121.51	122.13	828.0
2017-04-27	FBTP	Futures	105.31	105.9	105.1	105.74	129883.0
2017-04-27	FBTS	Futures	102.009	102.081	101.981	102.054	27042.0
2017-04-27	FCE	Futures	4644.7	4656.3	4639.8	4648.7	79087.0
2017-04-27	FDAX	Futures	13153.1	13193.2	13138.8	13159.9	63157.0
2017-04-27	FDXM	Futures	13038.6	13076.2	13023.9	13044.3	17955.0
2017-04-27	FESX	Futures	2859.4	2867.5	2852.0	2857.7	794053.0
2017-04-27	FEU3	Futures	99.011	99.011	99.011	99.011	3.0
2017-04-27	FGBL	Futures	148.2	149.02	147.99	148.9	773143.0
2017-04-27	FGBM	Futures	129.09	129.48	128.99	129.46	533024.0
2017-04-27	FGBS	Futures	112.237	112.357	112.212	112.347	366327.0
2017-04-27	FGBX	Futures	168.43	170.03	167.95	169.73	48817.0
2017-04-27	FMWO	Futures	6316.9	6324.2	6304.9	6307.3	290.0
2017-04-27	FOAT	Futures	133.62	134.35	133.45	134.31	114027.0
2017-04-27	FTDX	Futures	2048.4	2048.4	2034.7	2047.4	109.0
2017-04-27	FTI	Futures	474.47	475.47	473.46	474.28	21450.0
2017-04-27	FTUK	Futures	6170.1	6176.9	6138.4	6145.3	85937.0
2017-04-27	FVSA	Futures	567.29	579.82	563.71	578.03	11432.0
2017-04-27	FXXP	Futures	323.1	324.1	322.7	323.6	21396.0
2017-04-27	G	Futures	115.63	115.94	115.48	115.91	148130.0
2017-04-27	GF	Futures	326.389	335.841	324.728	335.841	4578.0
2017-04-27	GSCI	Futures	475.94	478.57	474.12	478.57	10.0

> showing 50 of 110 rows — these rows as CSV

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