PREVIEW / futures_daily / 2017-11-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-13.parquet
  size:    9 KB
  rows:    110

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-11-13	ES	Futures	2806.52	2812.23	2795.65	2808.43	1052173.0
2017-11-13	NQ	Futures	7414.74	7429.42	7377.74	7414.15	229366.0
2017-11-13	YM	Futures	24707.1	24740.9	24592.0	24716.6	110344.0
2017-11-13	CL	Futures	57.22	57.43	56.58	57.03	288046.0
2017-11-13	GC	Futures	1622.7	1628.6	1621.6	1627.3	220906.0
2017-11-13	ZN	Futures	122.915976	123.14705	122.792737	122.869761	960605.0
2017-11-13	A6	Futures	0.78691	0.78846	0.78331	0.78434	74194.0
2017-11-13	AD	Futures	0.80206	0.80282	0.79875	0.79967	44661.0
2017-11-13	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-13	B	Futures	45.04	45.11	44.28	44.67	335154.0
2017-11-13	B6	Futures	1.3744	1.3747	1.3631	1.3686	120057.0
2017-11-13	BR	Futures	0.22925	0.22974	0.22815	0.22842	3153.0
2017-11-13	BZ	Futures	44.6	44.68	43.9	44.28	29816.0
2017-11-13	C	Futures	1611.0	1616.0	1595.0	1603.0	11475.0
2017-11-13	CB	Futures	286.81	286.935	284.731	284.731	11.0
2017-11-13	CC	Futures	1641.0	1652.0	1625.0	1642.0	25847.0
2017-11-13	CNH	Futures	6.8406	6.8467	6.8377	6.8439	90.0
2017-11-13	CSC	Futures	3.41	3.474	3.41	3.42	28.0
2017-11-13	CT	Futures	81.04	81.84	80.87	80.9	24703.0
2017-11-13	DC	Futures	27.82	27.82	27.41	27.77	231.0
2017-11-13	DX	Futures	88.237	88.415	88.195	88.268	10711.0
2017-11-13	E1	Futures	1.22993	1.23323	1.22687	1.23066	19411.0
2017-11-13	E6	Futures	1.33244	1.33467	1.33028	1.33376	136647.0
2017-11-13	E7	Futures	1.3258	1.3276	1.3233	1.3268	2608.0
2017-11-13	EBM	Futures	172.89	172.89	172.08	172.08	16287.0
2017-11-13	ED	Futures	95.4721	95.477	95.4697	95.4721	210570.0
2017-11-13	ER	Futures	98.347	98.347	98.342	98.342	18612.0
2017-11-13	EW	Futures	1941.3	1944.5	1928.9	1943.8	11983.0
2017-11-13	FBON	Futures	125.58	125.77	125.48	125.66	247.0
2017-11-13	FBTP	Futures	112.21	112.6	112.21	112.31	79942.0
2017-11-13	FBTS	Futures	103.686	103.704	103.677	103.677	37267.0
2017-11-13	FCE	Futures	4822.1	4827.5	4745.9	4782.2	120428.0
2017-11-13	FDAX	Futures	13792.6	13832.5	13618.7	13755.3	103502.0
2017-11-13	FDXM	Futures	13678.3	13715.8	13504.2	13639.2	30968.0
2017-11-13	FESX	Futures	2929.5	2935.2	2887.9	2914.8	1095154.0
2017-11-13	FEU3	Futures	99.011	99.016	99.011	99.016	300.0
2017-11-13	FGBL	Futures	150.01	150.3	149.81	149.86	503710.0
2017-11-13	FGBM	Futures	130.01	130.11	129.95	129.96	290302.0
2017-11-13	FGBS	Futures	112.537	112.557	112.527	112.537	116738.0
2017-11-13	FGBX	Futures	167.38	168.18	166.93	167.03	37243.0
2017-11-13	FMWO	Futures	6753.3	6767.5	6739.2	6766.3	1791.0
2017-11-13	FOAT	Futures	137.91	138.27	137.85	137.88	84671.0
2017-11-13	FTDX	Futures	2478.0	2498.5	2445.6	2465.0	396.0
2017-11-13	FTI	Futures	507.6	508.25	503.1	505.24	8527.0
2017-11-13	FTUK	Futures	6445.1	6469.0	6406.5	6420.8	80775.0
2017-11-13	FVSA	Futures	356.83	368.57	343.92	350.96	45162.0
2017-11-13	FXXP	Futures	330.0	330.0	325.9	327.9	48747.0
2017-11-13	G	Futures	113.86	114.19	113.83	113.89	116848.0
2017-11-13	GF	Futures	338.299	340.624	335.921	339.38	6603.0
2017-11-13	GSCI	Futures	501.38	502.08	499.23	499.93	2786.0

> showing 50 of 110 rows — these rows as CSV

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