PREVIEW / futures_daily / 2016-09-26

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-26.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
2016-09-26	ES	Futures	2332.19	2335.71	2311.1	2314.35	1602771.0
2016-09-26	NQ	Futures	5718.32	5727.16	5665.87	5674.71	209587.0
2016-09-26	YM	Futures	19081.5	19114.0	18893.5	18915.6	128492.0
2016-09-26	CL	Futures	49.2	50.94	48.99	50.65	527119.0
2016-09-26	GC	Futures	1720.3	1727.1	1714.7	1724.5	126603.0
2016-09-26	ZN	Futures	127.499692	127.879698	127.438891	127.742896	828179.0
2016-09-26	A6	Futures	0.77561	0.77897	0.77418	0.77765	58206.0
2016-09-26	AD	Futures	0.77781	0.78006	0.77371	0.77453	60285.0
2016-09-26	ALI	Futures	2157.83	2179.45	2157.83	2179.45	15.0
2016-09-26	B	Futures	36.08	37.33	35.83	37.09	236073.0
2016-09-26	B6	Futures	1.3667	1.3693	1.3618	1.3673	66943.0
2016-09-26	BR	Futures	0.20794	0.20794	0.20725	0.20739	31.0
2016-09-26	BZ	Futures	35.93	37.12	35.66	36.88	14158.0
2016-09-26	C	Futures	2443.0	2443.0	2410.0	2425.0	9716.0
2016-09-26	CB	Futures	248.05	248.05	246.717	246.717	14.0
2016-09-26	CC	Futures	2103.0	2106.0	2078.0	2104.0	11818.0
2016-09-26	CNH	Futures	7.2273	7.2273	7.2128	7.2142	5.0
2016-09-26	CSC	Futures	3.804	3.804	3.76	3.776	84.0
2016-09-26	CT	Futures	78.25	79.54	78.06	78.51	11182.0
2016-09-26	DC	Futures	30.05	30.2	29.42	29.53	392.0
2016-09-26	DX	Futures	88.781	88.833	88.437	88.614	10782.0
2016-09-26	E1	Futures	1.29029	1.29552	1.28917	1.29216	16874.0
2016-09-26	E6	Futures	1.30599	1.31225	1.30535	1.30941	119056.0
2016-09-26	E7	Futures	1.2997	1.305	1.2983	1.3024	1883.0
2016-09-26	EBM	Futures	189.76	190.35	188.0	188.29	12676.0
2016-09-26	ED	Futures	95.6538	95.6731	95.649	95.6683	162652.0
2016-09-26	ER	Futures	98.288	98.293	98.283	98.283	67309.0
2016-09-26	EW	Futures	1647.1	1647.4	1634.5	1636.8	16782.0
2016-09-26	FBON	Futures	124.98	125.26	124.65	125.19	620.0
2016-09-26	FBTP	Futures	109.96	110.15	109.74	110.07	69038.0
2016-09-26	FBTS	Futures	101.329	101.338	101.311	101.329	15719.0
2016-09-26	FCE	Futures	3956.5	3961.3	3903.1	3908.9	100604.0
2016-09-26	FDAX	Futures	11148.7	11169.8	10957.4	10966.4	99729.0
2016-09-26	FDXM	Futures	11130.9	11145.7	10932.7	10942.7	34999.0
2016-09-26	FESX	Futures	2403.8	2407.8	2369.3	2373.3	1132336.0
2016-09-26	FGBL	Futures	150.78	151.34	150.73	151.11	536174.0
2016-09-26	FGBM	Futures	129.13	129.3	129.11	129.21	263851.0
2016-09-26	FGBS	Futures	111.942	111.987	111.942	111.957	180502.0
2016-09-26	FGBX	Futures	187.69	189.05	187.36	188.34	31437.0
2016-09-26	FMWO	Futures	5719.5	5721.9	5714.6	5719.5	124.0
2016-09-26	FOAT	Futures	138.53	138.98	138.5	138.8	89744.0
2016-09-26	FTDX	Futures	1754.8	1761.2	1743.5	1746.5	171.0
2016-09-26	FTI	Futures	414.58	414.67	409.63	410.59	29235.0
2016-09-26	FTUK	Futures	5796.3	5798.0	5711.1	5725.4	108847.0
2016-09-26	FVSA	Futures	1501.47	1583.7	1494.32	1576.55	20501.0
2016-09-26	FXXP	Futures	282.8	282.8	279.0	279.3	24394.0
2016-09-26	G	Futures	116.66	116.86	116.51	116.61	131603.0
2016-09-26	GF	Futures	270.97	273.033	267.824	270.351	3855.0
2016-09-26	GSCI	Futures	503.21	508.47	503.21	505.05	189.0
2016-09-26	HE	Futures	74.757	75.218	73.76	74.604	14089.0

> showing 50 of 108 rows — these rows as CSV

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