PREVIEW / futures_daily / 2017-03-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-07.parquet
  size:    9 KB
  rows:    108

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-03-07	ES	Futures	2570.67	2575.28	2563.35	2565.52	1303962.0
2017-03-07	NQ	Futures	6311.15	6334.13	6295.54	6305.26	180791.0
2017-03-07	YM	Futures	22040.2	22082.4	22006.5	22027.6	113939.0
2017-03-07	CL	Futures	56.42	57.09	55.93	56.39	494677.0
2017-03-07	GC	Futures	1565.8	1568.0	1551.0	1553.5	203709.0
2017-03-07	ZN	Futures	121.43103	121.492158	121.262928	121.324056	19444.0
2017-03-07	A6	Futures	0.77607	0.7816	0.77587	0.77689	94082.0
2017-03-07	AD	Futures	0.76167	0.7632	0.76024	0.76111	64147.0
2017-03-07	ALI	Futures	2505.66	2511.43	2496.68	2507.26	100.0
2017-03-07	B	Futures	40.86	41.37	40.57	40.83	269515.0
2017-03-07	B6	Futures	1.2839	1.2855	1.2767	1.2799	106755.0
2017-03-07	BZ	Futures	40.7	41.17	40.38	40.65	28162.0
2017-03-07	C	Futures	1635.0	1648.0	1621.0	1638.0	6199.0
2017-03-07	CB	Futures	269.748	273.501	269.748	273.501	10.0
2017-03-07	CC	Futures	1474.0	1483.0	1454.0	1464.0	17169.0
2017-03-07	CNH	Futures	7.2861	7.287	7.2767	7.2799	188.0
2017-03-07	CSC	Futures	3.683	3.71	3.65	3.71	116.0
2017-03-07	CT	Futures	88.18	88.46	86.57	86.98	17213.0
2017-03-07	DC	Futures	30.05	30.41	29.66	30.41	421.0
2017-03-07	DX	Futures	94.729	94.882	94.524	94.789	20648.0
2017-03-07	E1	Futures	1.22475	1.22661	1.2188	1.22339	20497.0
2017-03-07	E6	Futures	1.22242	1.22496	1.21976	1.22086	201552.0
2017-03-07	E7	Futures	1.2162	1.2186	1.2136	1.2146	3805.0
2017-03-07	EBM	Futures	196.86	196.86	195.18	195.18	19435.0
2017-03-07	ED	Futures	95.5085	95.5158	95.5037	95.5109	220140.0
2017-03-07	ER	Futures	98.303	98.308	98.303	98.308	44369.0
2017-03-07	EW	Futures	1837.1	1841.1	1827.6	1829.1	11871.0
2017-03-07	FBON	Futures	120.67	121.15	120.62	120.76	813.0
2017-03-07	FBTP	Futures	104.36	104.58	104.12	104.26	175750.0
2017-03-07	FBTS	Futures	101.818	101.864	101.773	101.8	45362.0
2017-03-07	FCE	Futures	4391.3	4391.3	4346.5	4359.2	93707.0
2017-03-07	FDAX	Futures	12655.8	12655.8	12594.6	12620.5	54561.0
2017-03-07	FDXM	Futures	12601.7	12605.9	12544.9	12569.6	17962.0
2017-03-07	FESX	Futures	2717.5	2718.3	2699.1	2703.9	733121.0
2017-03-07	FEU3	Futures	98.976	98.976	98.971	98.976	255.0
2017-03-07	FGBL	Futures	147.89	148.47	147.82	148.24	955014.0
2017-03-07	FGBM	Futures	129.45	129.79	129.42	129.72	762413.0
2017-03-07	FGBS	Futures	112.407	112.492	112.387	112.477	423242.0
2017-03-07	FGBX	Futures	166.39	167.35	166.01	166.69	81878.0
2017-03-07	FMWO	Futures	6168.7	6171.1	6155.4	6160.2	3218.0
2017-03-07	FOAT	Futures	131.42	131.59	131.11	131.46	215431.0
2017-03-07	FTDX	Futures	1890.1	1905.8	1890.1	1900.4	62.0
2017-03-07	FTI	Futures	458.61	458.79	456.34	456.98	20052.0
2017-03-07	FTUK	Futures	6231.4	6237.8	6205.1	6212.3	75992.0
2017-03-07	FVSA	Futures	686.36	690.54	667.53	680.08	19183.0
2017-03-07	FXXP	Futures	309.9	309.9	308.1	308.6	25512.0
2017-03-07	G	Futures	114.1	114.48	114.0	114.42	181899.0
2017-03-07	GF	Futures	282.858	284.112	281.49	282.573	1711.0
2017-03-07	GSCI	Futures	513.17	515.16	510.85	510.85	2891.0
2017-03-07	HE	Futures	85.968	87.244	85.394	86.797	24696.0

> showing 50 of 108 rows — these rows as CSV

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