PREVIEW / futures_daily / 2017-12-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-05.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
2017-12-05	ES	Futures	2867.16	2881.03	2857.64	2858.73	1392821.0
2017-12-05	NQ	Futures	7347.78	7446.74	7319.89	7366.87	443788.0
2017-12-05	YM	Futures	25654.3	25753.6	25506.5	25528.7	159349.0
2017-12-05	CL	Futures	57.54	57.98	57.14	57.68	499245.0
2017-12-05	GC	Futures	1621.6	1622.5	1601.5	1603.6	334825.0
2017-12-05	ZN	Futures	122.777332	122.885166	122.607877	122.838951	30474.0
2017-12-05	A6	Futures	0.78197	0.78743	0.78167	0.78249	98017.0
2017-12-05	AD	Futures	0.80236	0.80608	0.80099	0.80135	62736.0
2017-12-05	B	Futures	44.37	44.86	44.13	44.66	219338.0
2017-12-05	B6	Futures	1.4059	1.4059	1.3945	1.4019	141554.0
2017-12-05	BFX	Futures	4757.1	4762.4	4757.1	4762.4	6.0
2017-12-05	BR	Futures	0.23325	0.23325	0.2326	0.2326	5.0
2017-12-05	BZ	Futures	43.99	44.51	43.81	44.32	21380.0
2017-12-05	C	Futures	1376.0	1379.0	1322.0	1335.0	4445.0
2017-12-05	CB	Futures	280.228	280.228	277.973	279.826	105.0
2017-12-05	CC	Futures	1490.0	1493.0	1427.0	1441.0	38349.0
2017-12-05	CSC	Futures	3.366	3.383	3.366	3.368	32.0
2017-12-05	CT	Futures	84.68	85.44	84.26	84.69	18788.0
2017-12-05	DC	Futures	26.7	26.87	26.7	26.78	24.0
2017-12-05	DX	Futures	86.989	87.386	86.97	87.282	18286.0
2017-12-05	E1	Futures	1.24276	1.24399	1.23751	1.23812	20104.0
2017-12-05	E6	Futures	1.35504	1.35618	1.34734	1.34905	185404.0
2017-12-05	E7	Futures	1.348	1.349	1.3404	1.342	4387.0
2017-12-05	EBM	Futures	174.51	175.59	173.7	174.24	15399.0
2017-12-05	ED	Futures	95.443	95.4455	95.4309	95.4333	342360.0
2017-12-05	ER	Futures	98.342	98.342	98.337	98.342	31479.0
2017-12-05	EW	Futures	2010.9	2020.2	1995.2	1997.2	16709.0
2017-12-05	FBON	Futures	127.01	127.05	126.84	126.86	2682.0
2017-12-05	FBTP	Futures	113.83	114.1	113.83	114.01	193067.0
2017-12-05	FBTS	Futures	103.924	103.942	103.915	103.942	78559.0
2017-12-05	FCE	Futures	4826.2	4837.8	4793.4	4818.1	97076.0
2017-12-05	FDAX	Futures	13731.1	13764.2	13618.7	13731.6	93423.0
2017-12-05	FDXM	Futures	13614.7	13647.0	13502.2	13615.7	40129.0
2017-12-05	FESX	Futures	2915.6	2921.3	2896.0	2914.8	915991.0
2017-12-05	FGBL	Futures	150.97	151.39	150.87	151.21	1415385.0
2017-12-05	FGBM	Futures	130.04	130.29	130.02	130.2	1174769.0
2017-12-05	FGBS	Futures	112.527	112.567	112.512	112.547	964645.0
2017-12-05	FGBX	Futures	171.79	172.94	171.27	171.99	141102.0
2017-12-05	FMWO	Futures	6895.0	6897.4	6877.3	6896.2	1037.0
2017-12-05	FOAT	Futures	139.63	140.13	139.6	139.97	228921.0
2017-12-05	FTDX	Futures	2485.5	2489.5	2451.1	2487.5	279.0
2017-12-05	FTI	Futures	502.54	505.0	501.48	504.22	26032.0
2017-12-05	FTUK	Futures	6349.7	6397.8	6340.6	6361.4	115594.0
2017-12-05	FVSA	Futures	313.4	318.1	302.84	304.01	20132.0
2017-12-05	FXXP	Futures	329.1	329.5	327.3	329.1	39012.0
2017-12-05	G	Futures	114.39	114.79	114.36	114.63	153116.0
2017-12-05	GF	Futures	325.436	326.679	315.761	319.598	8117.0
2017-12-05	GSCI	Futures	493.04	493.68	493.04	493.68	466.0
2017-12-05	HE	Futures	95.644	95.644	93.577	94.044	15131.0
2017-12-05	HG	Futures	3.6959	3.7115	3.5229	3.5265	177600.0

> showing 50 of 109 rows — these rows as CSV

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