PREVIEW / futures_daily / 2017-11-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-20.parquet
  size:    9 KB
  rows:    109

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-20	ES	Futures	2801.9	2810.6	2792.93	2808.43	1000520.0
2017-11-20	NQ	Futures	7414.15	7434.41	7389.78	7418.85	203721.0
2017-11-20	YM	Futures	24623.7	24738.8	24542.4	24705.0	110122.0
2017-11-20	CL	Futures	56.86	56.99	55.81	56.48	593241.0
2017-11-20	GC	Futures	1646.6	1647.9	1621.2	1622.7	425159.0
2017-11-20	ZN	Futures	123.20867	123.378124	122.931381	122.931381	1276235.0
2017-11-20	A6	Futures	0.77734	0.77909	0.7759	0.77621	79278.0
2017-11-20	AD	Futures	0.79697	0.79794	0.79372	0.79453	55306.0
2017-11-20	B	Futures	44.42	44.42	43.46	44.01	283479.0
2017-11-20	B6	Futures	1.379	1.3856	1.3758	1.3812	103119.0
2017-11-20	BR	Futures	0.23147	0.23147	0.23068	0.23094	4583.0
2017-11-20	BZ	Futures	43.97	44.02	43.07	43.62	23428.0
2017-11-20	C	Futures	1536.0	1536.0	1503.0	1511.0	5892.0
2017-11-20	CB	Futures	283.44	283.44	282.18	283.44	6.0
2017-11-20	CC	Futures	1582.0	1582.0	1553.0	1559.0	17942.0
2017-11-20	CNH	Futures	6.8217	6.8343	6.8217	6.8322	18.0
2017-11-20	CSC	Futures	3.363	3.4	3.363	3.387	29.0
2017-11-20	CT	Futures	81.98	83.98	81.97	83.83	8351.0
2017-11-20	DC	Futures	26.99	27.32	26.99	27.25	271.0
2017-11-20	DX	Futures	87.653	87.924	87.423	87.902	19683.0
2017-11-20	E1	Futures	1.23738	1.23983	1.23249	1.2331	21781.0
2017-11-20	E6	Futures	1.34494	1.34945	1.33952	1.34066	230765.0
2017-11-20	E7	Futures	1.3378	1.3423	1.3326	1.3337	5944.0
2017-11-20	EBM	Futures	170.73	171.27	170.19	170.19	19092.0
2017-11-20	ED	Futures	95.4624	95.4673	95.4552	95.4552	354320.0
2017-11-20	ER	Futures	98.347	98.347	98.342	98.347	11538.0
2017-11-20	EW	Futures	1954.2	1965.0	1948.8	1963.3	10057.0
2017-11-20	FBON	Futures	125.81	126.04	125.65	125.96	179.0
2017-11-20	FBTP	Futures	112.41	112.76	112.33	112.61	50981.0
2017-11-20	FBTS	Futures	103.796	103.869	103.796	103.814	38807.0
2017-11-20	FCE	Futures	4750.0	4789.0	4743.2	4781.3	62975.0
2017-11-20	FDAX	Futures	13524.6	13751.6	13508.8	13726.4	93664.0
2017-11-20	FDIV	Futures	152.68	153.19	152.68	153.19	3.0
2017-11-20	FDXM	Futures	13412.5	13641.8	13395.9	13610.5	30956.0
2017-11-20	FESX	Futures	2875.6	2907.5	2874.0	2903.4	868833.0
2017-11-20	FGBL	Futures	150.79	150.86	150.56	150.68	446828.0
2017-11-20	FGBM	Futures	130.15	130.19	130.05	130.1	309780.0
2017-11-20	FGBS	Futures	112.552	112.557	112.527	112.532	138226.0
2017-11-20	FGBX	Futures	169.54	169.97	169.07	169.52	35425.0
2017-11-20	FMWO	Futures	6756.9	6780.5	6756.9	6778.1	2974.0
2017-11-20	FOAT	Futures	138.91	139.03	138.81	138.97	75305.0
2017-11-20	FTDX	Futures	2488.0	2542.4	2480.5	2539.9	307.0
2017-11-20	FTI	Futures	495.53	502.22	495.12	501.06	23330.0
2017-11-20	FTUK	Futures	6400.4	6416.5	6371.8	6408.7	91566.0
2017-11-20	FVSA	Futures	354.48	354.48	322.79	323.97	29217.0
2017-11-20	FXXP	Futures	324.6	328.5	324.6	328.2	24886.0
2017-11-20	G	Futures	114.28	114.4	113.98	114.38	119866.0
2017-11-20	GF	Futures	326.462	328.3	322.787	323.328	6050.0
2017-11-20	GSCI	Futures	492.81	493.16	490.42	493.1	223.0
2017-11-20	HE	Futures	89.775	91.976	89.341	91.342	18084.0

> showing 50 of 109 rows — these rows as CSV

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