PREVIEW / futures_daily / 2017-11-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-07.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-11-07	ES	Futures	2814.68	2820.93	2807.07	2813.59	1163840.0
2017-11-07	NQ	Futures	7413.56	7437.05	7395.65	7418.85	284157.0
2017-11-07	YM	Futures	24816.9	24876.1	24725.1	24803.2	116835.0
2017-11-07	CL	Futures	57.75	58.17	57.31	57.68	750187.0
2017-11-07	GC	Futures	1632.0	1632.2	1618.9	1623.3	337265.0
2017-11-07	ZN	Futures	123.624603	123.701628	123.424339	123.655413	1281128.0
2017-11-07	A6	Futures	0.79062	0.79206	0.78444	0.78599	91492.0
2017-11-07	AD	Futures	0.80089	0.80089	0.79387	0.79611	61254.0
2017-11-07	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-07	B	Futures	45.35	45.73	44.91	45.05	389455.0
2017-11-07	B6	Futures	1.3747	1.3754	1.3682	1.3743	90830.0
2017-11-07	BR	Futures	0.23147	0.23162	0.22875	0.22951	2872.0
2017-11-07	BZ	Futures	44.93	45.31	44.51	44.65	34317.0
2017-11-07	C	Futures	1551.0	1563.0	1544.0	1562.0	15016.0
2017-11-07	CB	Futures	281.865	281.865	279.062	281.834	31.0
2017-11-07	CC	Futures	1578.0	1610.0	1564.0	1596.0	41223.0
2017-11-07	CNH	Futures	6.8255	6.8291	6.8255	6.8291	3.0
2017-11-07	CSC	Futures	3.416	3.425	3.381	3.396	86.0
2017-11-07	CT	Futures	80.87	80.92	79.88	79.95	29271.0
2017-11-07	DC	Futures	27.48	27.63	27.22	27.29	320.0
2017-11-07	DX	Futures	88.494	88.906	88.466	88.653	23725.0
2017-11-07	E1	Futures	1.22907	1.22907	1.22345	1.22614	22177.0
2017-11-07	E6	Futures	1.32771	1.32822	1.32115	1.32497	203388.0
2017-11-07	E7	Futures	1.3206	1.3213	1.3142	1.318	3659.0
2017-11-07	EBM	Futures	175.59	175.86	174.51	174.51	14334.0
2017-11-07	ED	Futures	95.4794	95.4842	95.4697	95.4697	279989.0
2017-11-07	ER	Futures	98.347	98.347	98.342	98.342	104389.0
2017-11-07	EW	Futures	1958.0	1962.7	1938.2	1945.0	10830.0
2017-11-07	FBON	Futures	126.42	127.03	126.39	126.94	581.0
2017-11-07	FBTP	Futures	112.87	113.68	112.79	113.6	124427.0
2017-11-07	FBTS	Futures	103.668	103.741	103.658	103.732	48483.0
2017-11-07	FCE	Futures	4946.7	4951.6	4897.8	4911.3	83182.0
2017-11-07	FDAX	Futures	14196.2	14223.5	14015.4	14071.6	91884.0
2017-11-07	FDXM	Futures	14074.3	14101.4	13896.1	13952.9	31898.0
2017-11-07	FESX	Futures	3008.6	3012.7	2971.9	2982.5	1043302.0
2017-11-07	FEU3	Futures	99.011	99.016	99.011	99.016	10.0
2017-11-07	FGBL	Futures	150.81	151.08	150.67	150.97	726027.0
2017-11-07	FGBM	Futures	130.22	130.31	130.18	130.29	411087.0
2017-11-07	FGBS	Futures	112.577	112.587	112.557	112.577	167699.0
2017-11-07	FGBX	Futures	169.89	170.42	169.38	169.91	51554.0
2017-11-07	FMWO	Futures	6823.0	6823.0	6789.9	6800.6	908.0
2017-11-07	FOAT	Futures	138.43	139.02	138.36	138.96	142274.0
2017-11-07	FTDX	Futures	2592.3	2592.3	2528.4	2555.4	345.0
2017-11-07	FTI	Futures	515.16	515.9	510.8	512.1	21250.0
2017-11-07	FTUK	Futures	6541.9	6560.6	6478.5	6498.9	86836.0
2017-11-07	FVSA	Futures	315.9	323.58	313.35	318.46	30076.0
2017-11-07	FXXP	Futures	337.7	337.8	334.0	335.1	26710.0
2017-11-07	G	Futures	114.48	114.88	114.37	114.76	235813.0
2017-11-07	GF	Futures	345.691	345.799	342.405	344.56	1426.0
2017-11-07	GSCI	Futures	504.13	504.37	502.37	503.07	2258.0

> showing 50 of 109 rows — these rows as CSV

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