PREVIEW / futures_daily / 2016-07-01

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-01.parquet
  size:    9 KB
  rows:    109

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-07-01	ES	Futures	2252.77	2268.16	2247.38	2263.3	1665376.0
2016-07-01	NQ	Futures	5182.9	5240.95	5170.23	5225.63	176656.0
2016-07-01	YM	Futures	18580.9	18700.0	18552.7	18661.4	115502.0
2016-07-01	CL	Futures	56.2	57.27	55.64	56.91	405187.0
2016-07-01	GC	Futures	1704.4	1732.9	1702.2	1722.6	223728.0
2016-07-01	ZN	Futures	128.482561	129.342733	128.437289	128.527833	1346226.0
2016-07-01	A6	Futures	0.75523	0.76134	0.75452	0.7593	67942.0
2016-07-01	AD	Futures	0.79076	0.79557	0.78881	0.7925	40070.0
2016-07-01	ALI	Futures	2180.47	2180.47	2180.47	2180.47	3.0
2016-07-01	B	Futures	39.84	40.44	39.32	40.2	248693.0
2016-07-01	B6	Futures	1.4023	1.4083	1.3974	1.4014	101892.0
2016-07-01	BFX	Futures	3936.7	3953.1	3936.7	3953.1	1.0
2016-07-01	BR	Futures	0.20333	0.2041	0.2021	0.2026	129.0
2016-07-01	BZ	Futures	39.65	40.29	39.18	40.05	21731.0
2016-07-01	C	Futures	2496.0	2516.0	2483.0	2515.0	11592.0
2016-07-01	CB	Futures	281.359	281.71	281.036	281.329	25.0
2016-07-01	CC	Futures	2182.0	2200.0	2176.0	2196.0	12300.0
2016-07-01	CNH	Futures	7.2287	7.2371	7.2287	7.2371	2.0
2016-07-01	CSC	Futures	3.644	3.644	3.572	3.606	81.0
2016-07-01	CT	Futures	73.2	74.0	73.18	73.74	33.0
2016-07-01	DC	Futures	29.64	29.71	28.65	28.85	282.0
2016-07-01	DX	Futures	89.244	89.444	88.802	89.02	21140.0
2016-07-01	E1	Futures	1.28806	1.29483	1.28543	1.29107	13098.0
2016-07-01	E6	Futures	1.29603	1.30383	1.29248	1.29981	129733.0
2016-07-01	E7	Futures	1.2888	1.2968	1.2857	1.2929	1922.0
2016-07-01	EBM	Futures	186.45	186.45	181.33	183.14	22845.0
2016-07-01	ED	Futures	95.8486	95.8583	95.8341	95.8341	181944.0
2016-07-01	ER	Futures	98.313	98.328	98.313	98.328	39808.0
2016-07-01	EW	Futures	1580.5	1593.8	1576.0	1586.5	16553.0
2016-07-01	FBON	Futures	123.4	123.4	122.17	122.86	478.0
2016-07-01	FBTP	Futures	110.33	110.34	108.64	109.49	136197.0
2016-07-01	FBTS	Futures	101.526	101.553	101.266	101.338	39938.0
2016-07-01	FCE	Futures	3712.3	3734.1	3670.5	3720.6	94850.0
2016-07-01	FDAX	Futures	10341.8	10423.2	10264.1	10382.8	88146.0
2016-07-01	FDXM	Futures	10086.2	10160.9	10004.3	10120.5	23037.0
2016-07-01	FESX	Futures	2253.1	2260.9	2224.9	2249.2	1322188.0
2016-07-01	FEU3	Futures	98.981	98.981	98.976	98.976	11.0
2016-07-01	FGBL	Futures	149.67	150.55	149.45	150.24	646627.0
2016-07-01	FGBM	Futures	128.71	128.94	128.67	128.87	522153.0
2016-07-01	FGBS	Futures	111.887	111.927	111.857	111.917	222811.0
2016-07-01	FGBX	Futures	187.87	191.92	186.86	189.7	42134.0
2016-07-01	FMWO	Futures	5508.1	5539.7	5503.3	5539.7	72.0
2016-07-01	FOAT	Futures	138.06	138.45	137.71	138.27	120533.0
2016-07-01	FTDX	Futures	1547.4	1559.5	1537.8	1558.5	86.0
2016-07-01	FTI	Futures	394.9	395.75	389.81	394.36	30560.0
2016-07-01	FTUK	Futures	5423.8	5473.9	5376.7	5443.4	190449.0
2016-07-01	FVSA	Futures	2604.13	2649.64	2497.95	2548.51	21889.0
2016-07-01	FXXP	Futures	266.8	268.2	264.4	267.2	43092.0
2016-07-01	G	Futures	114.37	114.98	113.91	113.99	182338.0
2016-07-01	GF	Futures	286.945	289.64	283.3	284.449	4469.0

> showing 50 of 109 rows — these rows as CSV

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