PREVIEW / futures_daily / 2017-09-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-21.parquet
  size:    9 KB
  rows:    106

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-09-21	ES	Futures	2724.13	2726.03	2715.43	2720.32	1117630.0
2017-09-21	NQ	Futures	7019.48	7024.47	6952.82	6983.36	343404.0
2017-09-21	YM	Futures	23624.7	23640.6	23566.6	23583.5	96180.0
2017-09-21	CL	Futures	51.39	51.49	50.74	51.22	580569.0
2017-09-21	GC	Futures	1660.2	1660.5	1642.9	1647.5	402214.0
2017-09-21	ZN	Futures	123.917297	124.132966	123.794057	123.855677	1288393.0
2017-09-21	A6	Futures	0.82591	0.82591	0.81377	0.8151	147960.0
2017-09-21	AD	Futures	0.82587	0.82622	0.82302	0.82465	54004.0
2017-09-21	B	Futures	39.39	39.64	39.1	39.57	251616.0
2017-09-21	B6	Futures	1.4111	1.4203	1.4081	1.4188	131673.0
2017-09-21	BZ	Futures	39.06	39.3	38.78	39.23	23549.0
2017-09-21	C	Futures	1451.0	1471.0	1446.0	1460.0	9381.0
2017-09-21	CB	Futures	315.342	315.405	314.051	314.051	9.0
2017-09-21	CC	Futures	1481.0	1506.0	1472.0	1501.0	19361.0
2017-09-21	CNH	Futures	6.7996	6.7996	6.7724	6.7782	13.0
2017-09-21	CSC	Futures	3.429	3.431	3.414	3.429	15.0
2017-09-21	CT	Futures	80.58	80.58	80.58	80.58	1.0
2017-09-21	DC	Futures	27.86	28.09	27.73	28.01	99.0
2017-09-21	DX	Futures	86.409	86.465	85.932	86.081	22397.0
2017-09-21	E1	Futures	1.26783	1.2693	1.2611	1.26477	31109.0
2017-09-21	E6	Futures	1.36331	1.37021	1.36011	1.36765	214016.0
2017-09-21	E7	Futures	1.3563	1.363	1.3531	1.3605	5056.0
2017-09-21	EBM	Futures	176.4	177.75	176.13	177.75	16780.0
2017-09-21	ED	Futures	95.5085	95.5182	95.4939	95.4988	316313.0
2017-09-21	ER	Futures	98.337	98.342	98.337	98.337	29960.0
2017-09-21	EW	Futures	1878.2	1880.5	1872.4	1874.1	8137.0
2017-09-21	FBON	Futures	124.96	124.96	124.58	124.8	872.0
2017-09-21	FBTP	Futures	108.83	108.88	108.39	108.81	108353.0
2017-09-21	FBTS	Futures	103.246	103.246	103.173	103.219	53683.0
2017-09-21	FCE	Futures	4707.4	4720.0	4699.8	4709.2	51630.0
2017-09-21	FDAX	Futures	13240.3	13257.6	13209.8	13241.3	54427.0
2017-09-21	FDXM	Futures	13131.1	13143.7	13098.8	13129.6	15585.0
2017-09-21	FESX	Futures	2878.1	2883.0	2873.2	2879.7	619978.0
2017-09-21	FGBL	Futures	148.79	149.05	148.55	149.0	730373.0
2017-09-21	FGBM	Futures	129.42	129.48	129.27	129.44	592439.0
2017-09-21	FGBS	Futures	112.382	112.392	112.342	112.382	278226.0
2017-09-21	FGBX	Futures	166.5	167.03	165.6	166.91	45600.0
2017-09-21	FMWO	Futures	6622.3	6628.2	6612.8	6625.8	2235.0
2017-09-21	FOAT	Futures	136.08	136.31	135.81	136.24	148844.0
2017-09-21	FTDX	Futures	2389.2	2389.2	2374.2	2382.2	97.0
2017-09-21	FTI	Futures	488.58	488.67	486.13	486.5	16358.0
2017-09-21	FTUK	Futures	6289.8	6292.8	6257.3	6270.7	67534.0
2017-09-21	FVSA	Futures	417.16	418.58	407.23	407.23	18429.0
2017-09-21	FXXP	Futures	324.4	324.8	323.6	324.4	23249.0
2017-09-21	G	Futures	113.04	113.32	112.91	113.22	185401.0
2017-09-21	GF	Futures	342.436	342.763	339.544	340.199	6911.0
2017-09-21	GSCI	Futures	473.35	475.26	473.35	475.08	52.0
2017-09-21	HE	Futures	88.224	88.335	85.271	85.345	20714.0
2017-09-21	HG	Futures	3.5744	3.5793	3.5273	3.5448	117431.0
2017-09-21	HH	Futures	19.329	19.341	18.475	18.488	11154.0

> showing 50 of 106 rows — these rows as CSV

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