PREVIEW / futures_daily / 2017-10-31

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-31.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-31	ES	Futures	2793.2	2801.36	2791.84	2798.36	1051279.0
2017-10-31	NQ	Futures	7308.14	7351.6	7305.2	7341.03	239132.0
2017-10-31	YM	Futures	24594.1	24659.6	24571.9	24631.1	85154.0
2017-10-31	CL	Futures	54.53	55.31	54.38	54.84	497295.0
2017-10-31	GC	Futures	1625.6	1627.5	1613.8	1616.6	272513.0
2017-10-31	ZN	Futures	123.23948	123.347314	123.11624	123.17786	1425885.0
2017-10-31	A6	Futures	0.79062	0.79165	0.78568	0.78732	80797.0
2017-10-31	AD	Futures	0.79346	0.79377	0.78807	0.78929	81957.0
2017-10-31	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-31	B	Futures	42.83	43.28	42.62	43.1	311141.0
2017-10-31	B6	Futures	1.3786	1.3874	1.3772	1.3868	116128.0
2017-10-31	BR	Futures	0.22879	0.23011	0.22759	0.22921	6375.0
2017-10-31	BZ	Futures	42.43	42.94	42.24	42.72	23581.0
2017-10-31	C	Futures	1537.0	1537.0	1517.0	1519.0	10426.0
2017-10-31	CB	Futures	294.179	294.179	293.171	293.203	4.0
2017-10-31	CC	Futures	1573.0	1574.0	1552.0	1555.0	19913.0
2017-10-31	CSC	Futures	3.483	3.503	3.456	3.478	161.0
2017-10-31	CT	Futures	80.7	80.94	80.0	80.32	17214.0
2017-10-31	DC	Futures	28.32	28.58	28.1	28.28	405.0
2017-10-31	DX	Futures	88.246	88.466	88.232	88.306	18904.0
2017-10-31	E1	Futures	1.23262	1.23298	1.22711	1.22895	27211.0
2017-10-31	E6	Futures	1.33267	1.33404	1.32948	1.33284	175146.0
2017-10-31	E7	Futures	1.3255	1.327	1.3223	1.3259	3002.0
2017-10-31	EBM	Futures	176.13	176.4	173.97	174.78	19246.0
2017-10-31	ED	Futures	95.4939	95.4988	95.4891	95.4939	166162.0
2017-10-31	ER	Futures	98.342	98.347	98.342	98.347	19391.0
2017-10-31	EW	Futures	1938.2	1952.8	1937.7	1949.3	11046.0
2017-10-31	FBON	Futures	126.1	126.58	126.1	126.42	485.0
2017-10-31	FBTP	Futures	112.24	112.47	112.04	112.45	113423.0
2017-10-31	FBTS	Futures	103.613	103.622	103.567	103.603	75123.0
2017-10-31	FCE	Futures	4919.8	4938.2	4917.1	4930.1	53128.0
2017-10-31	FESX	Futures	2980.1	3003.7	2980.1	3000.5	559748.0
2017-10-31	FEU3	Futures	99.011	99.016	99.011	99.016	1.0
2017-10-31	FGBL	Futures	150.5	150.56	150.2	150.48	625902.0
2017-10-31	FGBM	Futures	130.16	130.16	130.0	130.1	372471.0
2017-10-31	FGBS	Futures	112.557	112.562	112.532	112.542	202809.0
2017-10-31	FGBX	Futures	168.95	169.6	168.4	169.54	59480.0
2017-10-31	FMWO	Futures	6771.0	6784.0	6767.5	6778.1	308.0
2017-10-31	FOAT	Futures	137.97	138.13	137.79	138.1	118780.0
2017-10-31	FTI	Futures	507.19	511.96	507.19	511.27	17780.0
2017-10-31	FTUK	Futures	6467.3	6496.8	6465.1	6480.3	77840.0
2017-10-31	FVSA	Futures	342.76	346.6	332.53	336.37	16008.0
2017-10-31	FXXP	Futures	334.0	335.9	334.0	335.6	26783.0
2017-10-31	G	Futures	113.9	113.99	113.71	113.8	177167.0
2017-10-31	GF	Futures	341.596	344.937	340.357	343.59	3546.0
2017-10-31	GSCI	Futures	486.64	489.88	486.58	488.88	1132.0
2017-10-31	HE	Futures	96.899	100.664	96.604	100.406	35287.0
2017-10-31	HG	Futures	3.7538	3.7894	3.7357	3.746	97551.0
2017-10-31	HH	Futures	17.67	17.746	17.084	17.12	3672.0
2017-10-31	HO	Futures	1.2277	1.2362	1.2205	1.2302	58687.0

> showing 50 of 107 rows — these rows as CSV

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