PREVIEW / futures_daily / 2017-09-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-13.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-09-13	ES	Futures	2713.8	2714.34	2707.0	2713.25	611367.0
2017-09-13	NQ	Futures	7052.07	7059.42	7024.45	7055.6	76177.0
2017-09-13	YM	Futures	23341.7	23357.5	23288.9	23350.2	108235.0
2017-09-13	CL	Futures	49.5	50.5	49.26	50.41	346440.0
2017-09-13	GC	Futures	1700.2	1705.7	1685.3	1689.8	306373.0
2017-09-13	ZN	Futures	124.856998	124.995642	124.625924	124.672139	1034784.0
2017-09-13	A6	Futures	0.82447	0.82663	0.81922	0.81953	88450.0
2017-09-13	AD	Futures	0.83584	0.83904	0.83294	0.83446	62969.0
2017-09-13	ALI	Futures	2731.63	2731.63	2731.63	2731.63	0.0
2017-09-13	B	Futures	37.99	38.72	37.89	38.68	291472.0
2017-09-13	B6	Futures	1.3898	1.3937	1.3785	1.3799	101350.0
2017-09-13	BR	Futures	0.23754	0.2383	0.23754	0.2383	1.0
2017-09-13	BZ	Futures	37.72	38.38	37.56	38.35	24868.0
2017-09-13	C	Futures	1444.0	1477.0	1443.0	1476.0	20048.0
2017-09-13	CB	Futures	307.816	309.863	307.375	307.564	30.0
2017-09-13	CC	Futures	1453.0	1481.0	1448.0	1478.0	25532.0
2017-09-13	CNH	Futures	6.7344	6.7575	6.7309	6.7511	25.0
2017-09-13	CSC	Futures	3.441	3.441	3.387	3.396	55.0
2017-09-13	CT	Futures	82.05	82.05	81.24	81.67	56.0
2017-09-13	DC	Futures	28.07	28.17	27.63	27.71	86.0
2017-09-13	DX	Futures	85.689	86.301	85.544	86.29	30956.0
2017-09-13	E1	Futures	1.28091	1.28348	1.27333	1.27358	20685.0
2017-09-13	E6	Futures	1.37232	1.37558	1.3616	1.36166	232597.0
2017-09-13	E7	Futures	1.3653	1.3682	1.3542	1.3546	4363.0
2017-09-13	EBM	Futures	173.97	175.32	173.43	173.97	17729.0
2017-09-13	ED	Futures	95.586	95.5957	95.5715	95.5763	243453.0
2017-09-13	ER	Futures	98.347	98.347	98.342	98.342	81229.0
2017-09-13	EW	Futures	1863.2	1863.4	1856.6	1858.3	16728.0
2017-09-13	FBON	Futures	124.82	124.97	124.75	124.87	494.0
2017-09-13	FBTP	Futures	109.52	109.67	109.18	109.26	92365.0
2017-09-13	FBTS	Futures	103.21	103.228	103.155	103.164	61150.0
2017-09-13	FCE	Futures	4655.0	4672.9	4646.5	4664.9	107872.0
2017-09-13	FDAX	Futures	13170.9	13232.5	13134.0	13224.6	123128.0
2017-09-13	FDIV	Futures	145.68	145.68	145.68	145.68	11.0
2017-09-13	FDXM	Futures	13030.1	13085.3	12995.7	13078.0	1729.0
2017-09-13	FESX	Futures	2852.8	2868.3	2846.3	2865.9	1564848.0
2017-09-13	FGBL	Futures	149.75	149.86	149.44	149.53	619335.0
2017-09-13	FGBM	Futures	129.86	129.92	129.75	129.78	404351.0
2017-09-13	FGBS	Futures	112.492	112.492	112.452	112.457	212275.0
2017-09-13	FGBX	Futures	167.87	168.34	167.46	167.69	48465.0
2017-09-13	FMWO	Futures	6635.3	6643.6	6632.9	6634.1	6797.0
2017-09-13	FOAT	Futures	136.68	136.83	136.54	136.67	92645.0
2017-09-13	FTDX	Futures	2336.8	2353.2	2336.8	2353.2	1020.0
2017-09-13	FTI	Futures	484.66	487.61	483.97	486.69	36196.0
2017-09-13	FTUK	Futures	6417.8	6417.8	6330.6	6376.6	234501.0
2017-09-13	FVSA	Futures	452.64	458.31	441.29	444.12	11372.0
2017-09-13	FXXP	Futures	322.6	323.5	321.5	322.9	81540.0
2017-09-13	G	Futures	115.47	115.77	115.33	115.41	198432.0
2017-09-13	GF	Futures	325.085	327.922	321.593	326.558	6687.0
2017-09-13	GSCI	Futures	466.29	469.7	466.29	468.92	3305.0

> showing 50 of 110 rows — these rows as CSV

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