PREVIEW / futures_daily / 2017-11-02

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-02.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-02	ES	Futures	2797.01	2804.62	2786.94	2802.72	1297222.0
2017-11-02	NQ	Futures	7317.83	7356.59	7273.78	7324.58	356528.0
2017-11-02	YM	Futures	24667.0	24786.3	24593.1	24756.7	135674.0
2017-11-02	CL	Futures	54.74	55.3	54.44	55.0	482846.0
2017-11-02	GC	Futures	1622.6	1635.2	1621.1	1626.3	380142.0
2017-11-02	ZN	Futures	123.20867	123.501364	123.131645	123.378124	1419118.0
2017-11-02	A6	Futures	0.78969	0.79494	0.78907	0.7936	110985.0
2017-11-02	AD	Futures	0.79117	0.79519	0.79046	0.79453	70117.0
2017-11-02	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-02	B	Futures	42.79	43.05	42.45	42.88	289300.0
2017-11-02	B6	Futures	1.3831	1.3883	1.3613	1.3635	259415.0
2017-11-02	BR	Futures	0.22996	0.23189	0.22974	0.23083	290.0
2017-11-02	BZ	Futures	42.37	42.64	42.09	42.5	27721.0
2017-11-02	C	Futures	1536.0	1548.0	1511.0	1517.0	17576.0
2017-11-02	CB	Futures	288.479	288.479	285.329	285.959	35.0
2017-11-02	CC	Futures	1579.0	1579.0	1521.0	1524.0	45041.0
2017-11-02	CNH	Futures	6.7947	6.8038	6.7839	6.8018	22.0
2017-11-02	CSC	Futures	3.464	3.491	3.443	3.445	71.0
2017-11-02	CT	Futures	80.34	81.4	80.0	81.14	21896.0
2017-11-02	DC	Futures	28.1	28.3	27.77	27.84	357.0
2017-11-02	DX	Futures	88.527	88.555	88.19	88.455	17089.0
2017-11-02	E1	Futures	1.22283	1.23225	1.22198	1.22711	31442.0
2017-11-02	E6	Futures	1.32942	1.33667	1.32817	1.33364	220965.0
2017-11-02	E7	Futures	1.3218	1.3297	1.3213	1.3267	3440.0
2017-11-02	EBM	Futures	172.89	175.86	172.62	175.86	25683.0
2017-11-02	ED	Futures	95.4842	95.4939	95.4794	95.4891	155709.0
2017-11-02	ER	Futures	98.342	98.347	98.342	98.342	14515.0
2017-11-02	EW	Futures	1939.6	1952.9	1933.0	1945.5	15224.0
2017-11-02	FBON	Futures	126.41	126.42	126.15	126.23	828.0
2017-11-02	FBTP	Futures	112.65	112.76	112.43	112.65	92713.0
2017-11-02	FBTS	Futures	103.64	103.649	103.613	103.64	25564.0
2017-11-02	FCE	Futures	4935.9	4946.2	4914.0	4936.8	69339.0
2017-11-02	FDAX	Futures	14120.5	14154.7	14083.7	14125.2	63857.0
2017-11-02	FDXM	Futures	14004.5	14035.7	13965.9	14006.0	21276.0
2017-11-02	FESX	Futures	3006.2	3013.5	2991.5	3006.2	845324.0
2017-11-02	FGBL	Futures	150.28	150.44	150.01	150.43	776816.0
2017-11-02	FGBM	Futures	130.07	130.12	129.96	130.12	459532.0
2017-11-02	FGBS	Futures	112.547	112.557	112.527	112.552	237403.0
2017-11-02	FGBX	Futures	168.75	169.13	167.97	169.07	47553.0
2017-11-02	FMWO	Futures	6779.3	6789.9	6766.3	6787.6	465.0
2017-11-02	FOAT	Futures	137.98	138.14	137.67	138.13	189406.0
2017-11-02	FTDX	Futures	2562.8	2575.8	2552.9	2558.9	121.0
2017-11-02	FTI	Futures	511.87	513.72	509.6	512.15	22663.0
2017-11-02	FTUK	Futures	6452.1	6544.1	6442.5	6533.6	132883.0
2017-11-02	FVSA	Futures	332.53	342.76	328.69	331.25	23318.0
2017-11-02	FXXP	Futures	335.6	336.7	333.8	335.1	30135.0
2017-11-02	G	Futures	113.62	114.67	113.49	114.52	261961.0
2017-11-02	GF	Futures	344.236	346.014	339.441	340.357	2611.0
2017-11-02	GSCI	Futures	487.41	490.35	487.41	489.88	1080.0
2017-11-02	HE	Futures	98.154	98.154	96.419	97.158	25452.0

> showing 50 of 110 rows — these rows as CSV

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