PREVIEW / futures_daily / 2017-09-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-14.parquet
  size:    9 KB
  rows:    111

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-14	ES	Futures	2713.25	2715.16	2705.64	2712.98	1372582.0
2017-09-14	NQ	Futures	7055.6	7058.53	7010.96	7013.31	283913.0
2017-09-14	YM	Futures	23356.5	23419.8	23311.1	23413.5	110839.0
2017-09-14	CL	Futures	50.42	51.56	50.23	51.02	463265.0
2017-09-14	GC	Futures	1689.3	1698.5	1678.9	1691.4	336576.0
2017-09-14	ZN	Futures	124.718354	124.779973	124.39485	124.625924	1469070.0
2017-09-14	A6	Futures	0.82066	0.82385	0.81757	0.82076	79485.0
2017-09-14	AD	Futures	0.8363	0.83731	0.83162	0.83508	97172.0
2017-09-14	ALI	Futures	2728.8	2731.63	2728.8	2731.63	1.0
2017-09-14	B	Futures	38.58	39.26	38.52	38.9	327352.0
2017-09-14	B6	Futures	1.3808	1.4017	1.375	1.4006	118810.0
2017-09-14	BFX	Futures	4718.9	4739.2	4718.9	4739.2	37.0
2017-09-14	BR	Futures	0.23796	0.23932	0.23739	0.23932	26.0
2017-09-14	BZ	Futures	38.29	38.93	38.19	38.57	27549.0
2017-09-14	C	Futures	1474.0	1485.0	1450.0	1452.0	20734.0
2017-09-14	CB	Futures	308.823	313.862	308.823	311.469	35.0
2017-09-14	CC	Futures	1483.0	1494.0	1427.0	1465.0	26101.0
2017-09-14	CNH	Futures	6.7603	6.7725	6.752	6.752	12.0
2017-09-14	CSC	Futures	3.408	3.408	3.391	3.398	55.0
2017-09-14	CT	Futures	81.53	81.53	80.55	81.44	35.0
2017-09-14	DC	Futures	27.77	27.78	27.63	27.68	67.0
2017-09-14	DX	Futures	86.189	86.427	85.852	85.931	38970.0
2017-09-14	E1	Futures	1.27614	1.27896	1.26734	1.27614	21071.0
2017-09-14	E6	Futures	1.3632	1.36707	1.35726	1.36599	205269.0
2017-09-14	E7	Futures	1.3557	1.3599	1.3503	1.3589	8780.0
2017-09-14	EBM	Futures	174.51	176.4	174.51	176.13	18899.0
2017-09-14	ED	Futures	95.5812	95.5812	95.5424	95.5521	416676.0
2017-09-14	ER	Futures	98.347	98.347	98.342	98.342	53243.0
2017-09-14	EW	Futures	1856.7	1860.5	1851.9	1857.0	11660.0
2017-09-14	FBON	Futures	124.79	124.95	124.66	124.71	436.0
2017-09-14	FBTP	Futures	109.32	109.43	109.01	109.12	80728.0
2017-09-14	FBTS	Futures	103.182	103.182	103.146	103.164	29457.0
2017-09-14	FCE	Futures	4658.2	4678.8	4649.6	4671.1	62303.0
2017-09-14	FDAX	Futures	13200.4	13221.4	13158.8	13212.5	79457.0
2017-09-14	FDXM	Futures	13048.8	13072.8	13015.5	13066.0	1811.0
2017-09-14	FESX	Futures	2858.5	2869.1	2852.8	2866.7	1010499.0
2017-09-14	FEU3	Futures	99.021	99.021	99.016	99.016	1.0
2017-09-14	FGBL	Futures	149.52	149.84	149.21	149.38	731174.0
2017-09-14	FGBM	Futures	129.82	129.93	129.65	129.71	481390.0
2017-09-14	FGBS	Futures	112.477	112.492	112.442	112.457	288727.0
2017-09-14	FGBX	Futures	167.73	168.2	166.97	167.36	48814.0
2017-09-14	FMWO	Futures	6628.1	6635.3	6623.4	6635.3	7322.0
2017-09-14	FOAT	Futures	136.72	136.85	136.38	136.56	105374.0
2017-09-14	FTDX	Futures	2346.7	2362.2	2346.7	2361.2	497.0
2017-09-14	FTI	Futures	486.23	487.98	485.49	487.19	17970.0
2017-09-14	FTUK	Futures	6384.0	6387.0	6287.2	6300.2	164979.0
2017-09-14	FVSA	Futures	441.29	458.31	441.29	446.96	18836.0
2017-09-14	FXXP	Futures	322.7	323.7	322.1	323.6	50887.0
2017-09-14	G	Futures	115.32	115.94	114.33	114.67	284101.0
2017-09-14	GF	Futures	326.94	329.068	324.103	326.504	6366.0

> showing 50 of 111 rows — these rows as CSV

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