PREVIEW / futures_daily / 2016-04-01

all futures daily files

  file:    by_date/futures_daily/2016/2016-04-01.parquet
  size:    9 KB
  rows:    108

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-04-01	ES	Futures	2204.07	2219.37	2185.28	2217.23	2051323.0
2016-04-01	NQ	Futures	5261.39	5322.19	5218.79	5321.02	245916.0
2016-04-01	YM	Futures	18313.2	18417.1	18162.4	18409.9	163740.0
2016-04-01	CL	Futures	46.3	46.81	44.46	44.66	547190.0
2016-04-01	GC	Futures	1590.7	1594.7	1560.0	1577.0	196902.0
2016-04-01	ZN	Futures	125.992693	126.007781	125.585341	125.811648	1275666.0
2016-04-01	A6	Futures	0.77314	0.77688	0.76656	0.77446	110564.0
2016-04-01	AD	Futures	0.7876	0.78842	0.77768	0.78494	83142.0
2016-04-01	ALI	Futures	2102.46	2102.46	2102.46	2102.46	0.0
2016-04-01	B	Futures	33.43	33.67	32.11	32.21	286168.0
2016-04-01	B6	Futures	1.5128	1.5137	1.4925	1.497	133667.0
2016-04-01	BR	Futures	0.1783	0.18087	0.1768	0.17986	49.0
2016-04-01	BZ	Futures	33.0	33.34	31.78	31.88	20407.0
2016-04-01	C	Futures	2270.0	2285.0	2241.0	2244.0	12511.0
2016-04-01	CB	Futures	248.342	250.049	248.342	250.049	5.0
2016-04-01	CC	Futures	2154.0	2166.0	2109.0	2110.0	35246.0
2016-04-01	CNH	Futures	7.0554	7.058	7.0533	7.0572	18.0
2016-04-01	CSC	Futures	3.682	3.723	3.663	3.68	134.0
2016-04-01	CT	Futures	66.91	68.21	66.79	67.99	23103.0
2016-04-01	DC	Futures	29.08	29.27	28.8	29.02	285.0
2016-04-01	DX	Futures	88.216	88.663	87.941	88.214	28247.0
2016-04-01	E1	Futures	1.31087	1.31904	1.30937	1.31452	18910.0
2016-04-01	E6	Futures	1.33004	1.3368	1.32467	1.33144	276466.0
2016-04-01	E7	Futures	1.3229	1.3296	1.3174	1.3243	6797.0
2016-04-01	EBM	Futures	197.52	198.81	196.24	198.17	21128.0
2016-04-01	ED	Futures	95.7208	95.7208	95.6919	95.7063	301109.0
2016-04-01	ER	Futures	98.254	98.264	98.254	98.259	30166.0
2016-04-01	EW	Futures	1523.6	1531.7	1507.9	1531.0	19480.0
2016-04-01	FBON	Futures	118.95	119.16	118.95	119.08	41.0
2016-04-01	FBTP	Futures	108.12	108.13	107.86	108.03	62781.0
2016-04-01	FBTS	Futures	101.06	101.087	101.051	101.078	11967.0
2016-04-01	FCE	Futures	3627.6	3628.0	3548.0	3599.7	139199.0
2016-04-01	FDAX	Futures	10650.7	10655.0	10433.2	10568.0	143442.0
2016-04-01	FDXM	Futures	10262.0	10262.0	10047.9	10176.1	28104.0
2016-04-01	FESX	Futures	2265.1	2265.9	2215.2	2244.8	1828855.0
2016-04-01	FGBL	Futures	146.17	146.51	146.0	146.25	554370.0
2016-04-01	FGBM	Futures	127.48	127.52	127.41	127.44	350498.0
2016-04-01	FGBS	Futures	111.633	111.638	111.608	111.608	180394.0
2016-04-01	FGBX	Futures	174.01	175.68	173.8	174.88	35008.0
2016-04-01	FMWO	Futures	5543.2	5543.2	5543.2	5543.2	0.0
2016-04-01	FOAT	Futures	133.92	134.33	133.76	134.1	83479.0
2016-04-01	FTDX	Futures	1530.0	1563.3	1530.0	1560.4	171.0
2016-04-01	FTI	Futures	387.32	387.37	379.69	385.06	48879.0
2016-04-01	FTUK	Futures	5033.7	5039.9	4966.5	5022.2	132809.0
2016-04-01	FVSA	Futures	2749.64	2849.03	2716.52	2766.21	14095.0
2016-04-01	FXXP	Futures	264.0	264.2	259.8	262.5	31252.0
2016-04-01	G	Futures	108.52	108.77	108.29	108.53	204446.0
2016-04-01	GF	Futures	308.618	309.502	305.035	306.655	1930.0
2016-04-01	GSCI	Futures	477.83	477.83	474.67	475.42	63.0
2016-04-01	HE	Futures	98.73	98.795	96.322	96.964	318.0

> showing 50 of 108 rows — these rows as CSV

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