PREVIEW / futures_daily / 2017-10-02

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-02.parquet
  size:    9 KB
  rows:    107

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-10-02	ES	Futures	2738.81	2749.69	2737.73	2747.79	1138362.0
2017-10-02	NQ	Futures	7028.88	7059.12	6998.92	7024.76	269518.0
2017-10-02	YM	Futures	23606.8	23781.0	23598.3	23767.3	104284.0
2017-10-02	CL	Futures	52.33	52.4	50.74	51.25	600933.0
2017-10-02	GC	Futures	1631.5	1632.2	1618.5	1623.3	272706.0
2017-10-02	ZN	Futures	123.470554	123.624603	123.17786	123.485959	1322271.0
2017-10-02	A6	Futures	0.80574	0.80667	0.80132	0.80523	83589.0
2017-10-02	AD	Futures	0.81579	0.8164	0.81269	0.81417	56940.0
2017-10-02	B	Futures	40.06	40.09	39.2	39.63	352045.0
2017-10-02	B6	Futures	1.3987	1.4005	1.3852	1.3882	113312.0
2017-10-02	BZ	Futures	39.66	39.75	38.88	39.31	19371.0
2017-10-02	C	Futures	1487.0	1497.0	1464.0	1496.0	12955.0
2017-10-02	CB	Futures	297.36	298.242	292.888	292.888	53.0
2017-10-02	CC	Futures	1518.0	1524.0	1473.0	1512.0	32632.0
2017-10-02	CNH	Futures	6.8767	6.8809	6.8699	6.8699	14.0
2017-10-02	CSC	Futures	3.466	3.487	3.456	3.485	76.0
2017-10-02	CT	Futures	80.81	80.81	79.34	79.37	14952.0
2017-10-02	DC	Futures	28.51	28.51	28.19	28.48	179.0
2017-10-02	DX	Futures	86.937	87.601	86.914	87.349	22433.0
2017-10-02	E1	Futures	1.26844	1.26905	1.25964	1.26074	26213.0
2017-10-02	E6	Futures	1.35287	1.35367	1.34397	1.34551	201079.0
2017-10-02	E7	Futures	1.3455	1.3465	1.3369	1.3385	3471.0
2017-10-02	EBM	Futures	179.09	179.36	177.75	178.55	15707.0
2017-10-02	ED	Futures	95.5182	95.523	95.5036	95.5133	257806.0
2017-10-02	ER	Futures	98.342	98.342	98.337	98.337	20228.0
2017-10-02	EW	Futures	1908.5	1926.6	1907.5	1925.0	17266.0
2017-10-02	FBON	Futures	124.53	124.53	123.95	124.25	1259.0
2017-10-02	FBTP	Futures	108.5	108.57	108.16	108.49	101289.0
2017-10-02	FBTS	Futures	103.255	103.274	103.228	103.265	28439.0
2017-10-02	FCE	Futures	4780.9	4797.5	4768.8	4789.9	56018.0
2017-10-02	FDAX	Futures	13519.9	13565.6	13493.6	13543.0	67287.0
2017-10-02	FDXM	Futures	13404.2	13458.4	13379.2	13428.7	13623.0
2017-10-02	FESX	Futures	2925.4	2934.4	2918.1	2927.0	752138.0
2017-10-02	FGBL	Futures	148.69	149.21	148.55	149.07	711476.0
2017-10-02	FGBM	Futures	129.46	129.64	129.39	129.61	458739.0
2017-10-02	FGBS	Futures	112.402	112.447	112.387	112.442	217260.0
2017-10-02	FGBX	Futures	166.24	167.46	165.69	167.09	45509.0
2017-10-02	FMWO	Futures	6647.1	6665.9	6643.5	6657.7	793.0
2017-10-02	FOAT	Futures	135.76	136.29	135.74	136.18	91123.0
2017-10-02	FTDX	Futures	2433.6	2474.0	2433.6	2472.5	170.0
2017-10-02	FTI	Futures	496.17	498.85	495.02	498.2	20469.0
2017-10-02	FTUK	Futures	6373.1	6421.7	6364.4	6412.2	97753.0
2017-10-02	FVSA	Futures	391.62	394.46	383.11	385.95	18243.0
2017-10-02	FXXP	Futures	329.6	330.7	329.0	330.0	24253.0
2017-10-02	G	Futures	113.11	113.81	113.02	113.68	173363.0
2017-10-02	GF	Futures	332.396	334.361	327.704	328.141	2248.0
2017-10-02	GSCI	Futures	470.89	471.37	469.4	471.37	549.0
2017-10-02	HE	Futures	88.187	92.543	88.04	91.51	26414.0
2017-10-02	HG	Futures	3.5738	3.6119	3.5484	3.5702	53501.0
2017-10-02	HH	Futures	18.631	18.637	17.894	18.055	2101.0

> showing 50 of 107 rows — these rows as CSV

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