PREVIEW / futures_daily / 2017-05-04

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-04.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-05-04	ES	Futures	2586.95	2596.46	2580.44	2590.76	1229736.0
2017-05-04	NQ	Futures	6606.22	6635.67	6600.04	6625.95	223464.0
2017-05-04	YM	Futures	22023.5	22101.6	21921.1	22022.4	132693.0
2017-05-04	CL	Futures	49.66	49.82	47.25	47.49	943959.0
2017-05-04	GC	Futures	1583.8	1587.9	1567.4	1571.1	318317.0
2017-05-04	ZN	Futures	123.367376	123.38274	122.96793	123.075473	1245763.0
2017-05-04	A6	Futures	0.76172	0.76223	0.7573	0.75905	112986.0
2017-05-04	AD	Futures	0.7433	0.74478	0.74065	0.74136	78916.0
2017-05-04	ALI	Futures	2559.33	2559.33	2559.33	2559.33	0.0
2017-05-04	B	Futures	36.28	36.38	34.54	34.7	541579.0
2017-05-04	B6	Futures	1.3504	1.3574	1.3467	1.356	90499.0
2017-05-04	BR	Futures	0.22799	0.2281	0.22524	0.22567	1191.0
2017-05-04	BZ	Futures	36.04	36.11	34.31	34.45	52061.0
2017-05-04	C	Futures	1410.0	1467.0	1408.0	1464.0	5246.0
2017-05-04	CB	Futures	261.509	263.004	261.509	263.004	9.0
2017-05-04	CC	Futures	1357.0	1410.0	1355.0	1406.0	17464.0
2017-05-04	CNH	Futures	7.2232	7.2232	7.2111	7.2111	21.0
2017-05-04	CSC	Futures	3.484	3.531	3.469	3.525	48.0
2017-05-04	CT	Futures	87.42	87.86	87.14	87.39	8300.0
2017-05-04	DC	Futures	28.84	29.42	28.82	29.29	562.0
2017-05-04	DX	Futures	92.449	92.551	91.825	91.906	31363.0
2017-05-04	E1	Futures	1.24589	1.25602	1.24404	1.25466	31325.0
2017-05-04	E6	Futures	1.25651	1.26821	1.25525	1.26705	216954.0
2017-05-04	E7	Futures	1.25	1.2617	1.2488	1.2606	5253.0
2017-05-04	EBM	Futures	191.54	191.54	187.06	187.34	4180.0
2017-05-04	ED	Futures	95.5591	95.5591	95.5446	95.5494	202876.0
2017-05-04	ER	Futures	98.342	98.347	98.332	98.337	120370.0
2017-05-04	EW	Futures	1833.0	1841.2	1818.5	1831.0	13460.0
2017-05-04	FBON	Futures	122.19	122.62	122.15	122.59	737.0
2017-05-04	FBTP	Futures	105.75	106.01	105.6	105.92	96398.0
2017-05-04	FBTS	Futures	102.108	102.217	102.108	102.199	36428.0
2017-05-04	FCE	Futures	4691.5	4758.8	4684.4	4747.7	110856.0
2017-05-04	FDAX	Futures	13259.2	13368.4	13242.8	13342.6	80176.0
2017-05-04	FDXM	Futures	13148.4	13249.9	13126.5	13225.3	21262.0
2017-05-04	FESX	Futures	2890.4	2924.7	2888.7	2918.9	1063238.0
2017-05-04	FEU3	Futures	99.016	99.016	99.011	99.011	40.0
2017-05-04	FGBL	Futures	148.45	148.45	147.73	147.88	791024.0
2017-05-04	FGBM	Futures	129.22	129.24	128.97	129.07	529197.0
2017-05-04	FGBS	Futures	112.272	112.292	112.222	112.262	338722.0
2017-05-04	FGBX	Futures	168.45	168.45	166.25	166.65	59076.0
2017-05-04	FMWO	Futures	6323.0	6348.3	6323.0	6338.6	1443.0
2017-05-04	FOAT	Futures	134.29	134.36	134.08	134.23	190595.0
2017-05-04	FTDX	Futures	2084.2	2102.8	2072.4	2101.9	104.0
2017-05-04	FTI	Futures	478.41	481.57	478.32	481.07	26956.0
2017-05-04	FTUK	Futures	6165.8	6189.3	6141.0	6161.5	87144.0
2017-05-04	FVSA	Futures	560.13	563.71	531.5	540.45	41497.0
2017-05-04	FXXP	Futures	326.4	328.2	325.9	327.9	42009.0
2017-05-04	G	Futures	115.51	115.75	115.34	115.43	206041.0
2017-05-04	GF	Futures	352.853	359.154	338.762	339.736	4112.0
2017-05-04	GSCI	Futures	475.37	475.37	461.18	461.18	1480.0

> showing 50 of 110 rows — these rows as CSV

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