PREVIEW / futures_daily / 2017-11-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-28.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-11-28	ES	Futures	2830.45	2857.37	2825.29	2856.28	1558414.0
2017-11-28	NQ	Futures	7533.08	7552.17	7504.3	7541.3	307329.0
2017-11-28	YM	Futures	24882.4	25161.2	24839.1	25144.3	143563.0
2017-11-28	CL	Futures	57.92	58.17	57.48	58.05	546526.0
2017-11-28	GC	Futures	1646.6	1649.8	1641.1	1647.1	230266.0
2017-11-28	ZN	Futures	123.316504	123.470554	123.17786	123.20867	2661242.0
2017-11-28	A6	Futures	0.78218	0.78393	0.78053	0.78146	91696.0
2017-11-28	AD	Futures	0.79728	0.79789	0.79351	0.79397	68766.0
2017-11-28	B	Futures	44.99	45.07	44.55	44.93	300440.0
2017-11-28	B6	Futures	1.3897	1.3967	1.3792	1.395	240629.0
2017-11-28	BFX	Futures	4735.6	4745.1	4735.6	4745.1	7.0
2017-11-28	BR	Futures	0.23374	0.23419	0.23374	0.23419	690.0
2017-11-28	BZ	Futures	44.65	44.71	44.22	44.58	24932.0
2017-11-28	C	Futures	1471.0	1472.0	1449.0	1455.0	6227.0
2017-11-28	CB	Futures	282.482	282.482	281.71	281.865	20.0
2017-11-28	CC	Futures	1538.0	1545.0	1522.0	1529.0	22367.0
2017-11-28	CNH	Futures	6.7792	6.7863	6.7792	6.7863	1.0
2017-11-28	CSC	Futures	3.381	3.393	3.361	3.376	92.0
2017-11-28	CT	Futures	83.22	84.43	82.95	84.26	19809.0
2017-11-28	DC	Futures	26.87	26.92	26.76	26.87	119.0
2017-11-28	DX	Futures	86.778	87.222	86.745	87.169	21741.0
2017-11-28	E1	Futures	1.24765	1.24876	1.24252	1.2435	25697.0
2017-11-28	E6	Futures	1.35932	1.3616	1.35099	1.35207	224825.0
2017-11-28	E7	Futures	1.3521	1.3545	1.3439	1.345	4658.0
2017-11-28	EBM	Futures	169.65	169.65	168.84	169.11	21004.0
2017-11-28	ED	Futures	95.4527	95.46	95.4503	95.4576	207850.0
2017-11-28	ER	Futures	98.347	98.347	98.342	98.342	24111.0
2017-11-28	EW	Futures	1973.0	1999.2	1969.6	1998.3	12035.0
2017-11-28	FBON	Futures	126.31	126.47	126.23	126.43	532.0
2017-11-28	FBTP	Futures	113.11	113.43	113.05	113.16	63224.0
2017-11-28	FBTS	Futures	103.823	103.86	103.823	103.842	42148.0
2017-11-28	FCE	Futures	4799.3	4854.8	4794.8	4827.0	61544.0
2017-11-28	FDAX	Futures	13661.2	13798.9	13621.8	13723.2	91623.0
2017-11-28	FDXM	Futures	13551.1	13681.4	13507.4	13607.4	37734.0
2017-11-28	FESX	Futures	2905.8	2938.5	2899.3	2922.1	837243.0
2017-11-28	FEU3	Futures	99.016	99.016	99.016	99.016	4.0
2017-11-28	FGBL	Futures	150.86	151.01	150.69	150.87	656547.0
2017-11-28	FGBM	Futures	130.06	130.14	130.01	130.08	459539.0
2017-11-28	FGBS	Futures	112.497	112.512	112.487	112.497	339674.0
2017-11-28	FGBX	Futures	171.18	171.38	170.67	171.09	66293.0
2017-11-28	FMWO	Futures	6841.9	6885.6	6841.9	6852.5	425.0
2017-11-28	FOAT	Futures	139.28	139.46	139.17	139.3	104967.0
2017-11-28	FTDX	Futures	2553.4	2572.3	2545.4	2557.9	177.0
2017-11-28	FTI	Futures	500.04	507.56	500.04	504.73	30596.0
2017-11-28	FTUK	Futures	6411.3	6485.1	6406.1	6479.4	148566.0
2017-11-28	FVSA	Futures	315.75	320.44	305.18	308.71	12034.0
2017-11-28	FXXP	Futures	327.2	330.9	326.7	328.8	31307.0
2017-11-28	G	Futures	114.72	114.91	114.26	114.72	235500.0
2017-11-28	GF	Futures	334.57	334.948	331.489	334.029	4535.0
2017-11-28	GSCI	Futures	499.05	500.63	498.35	500.1	696.0

> showing 50 of 110 rows — these rows as CSV

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