PREVIEW / futures_daily / 2017-03-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-20.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-03-20	ES	Futures	2577.99	2580.44	2569.04	2574.19	1076099.0
2017-03-20	NQ	Futures	6368.6	6393.04	6355.35	6381.85	144687.0
2017-03-20	YM	Futures	22001.3	22054.1	21972.8	22019.2	104838.0
2017-03-20	CL	Futures	51.62	51.73	50.79	51.26	593698.0
2017-03-20	GC	Futures	1570.0	1578.3	1569.8	1576.4	126337.0
2017-03-20	ZN	Futures	121.677412	122.000042	121.585232	121.923225	778950.0
2017-03-20	A6	Futures	0.78913	0.79405	0.78892	0.79179	72702.0
2017-03-20	AD	Futures	0.76508	0.76757	0.7636	0.76421	44242.0
2017-03-20	ALI	Futures	2569.67	2569.67	2569.67	2569.67	0.0
2017-03-20	B	Futures	37.83	37.93	37.25	37.69	239247.0
2017-03-20	B6	Futures	1.3016	1.3068	1.2963	1.2976	78582.0
2017-03-20	BR	Futures	0.22868	0.2318	0.22868	0.2318	666.0
2017-03-20	BZ	Futures	37.62	37.75	37.08	37.52	25177.0
2017-03-20	C	Futures	1707.0	1794.0	1688.0	1787.0	11628.0
2017-03-20	CB	Futures	266.696	266.696	264.865	264.865	63.0
2017-03-20	CC	Futures	1545.0	1622.0	1537.0	1615.0	25153.0
2017-03-20	CNH	Futures	7.232	7.2421	7.2289	7.2289	6.0
2017-03-20	CSC	Futures	3.609	3.616	3.571	3.589	96.0
2017-03-20	CT	Futures	87.31	87.77	86.16	86.19	12981.0
2017-03-20	DC	Futures	29.59	29.6	28.91	29.14	254.0
2017-03-20	DX	Futures	93.269	93.413	93.013	93.384	19260.0
2017-03-20	E1	Futures	1.24527	1.24787	1.24366	1.24404	13403.0
2017-03-20	E6	Futures	1.24275	1.24701	1.24096	1.24183	138540.0
2017-03-20	E7	Futures	1.2363	1.2406	1.2347	1.2355	2701.0
2017-03-20	EBM	Futures	193.22	193.22	191.54	191.82	14199.0
2017-03-20	ED	Futures	95.53	95.5349	95.5204	95.53	175106.0
2017-03-20	ER	Futures	98.303	98.308	98.298	98.308	51825.0
2017-03-20	EW	Futures	1839.2	1839.2	1825.3	1828.5	12761.0
2017-03-20	FBON	Futures	119.4	119.7	119.05	119.58	188.0
2017-03-20	FBTP	Futures	103.08	103.16	102.52	102.76	65869.0
2017-03-20	FBTS	Futures	101.51	101.583	101.474	101.51	42650.0
2017-03-20	FCE	Futures	4415.2	4430.6	4406.8	4414.7	56984.0
2017-03-20	FDAX	Futures	12747.1	12786.2	12729.7	12759.8	49144.0
2017-03-20	FDXM	Futures	12636.7	12673.3	12617.9	12647.7	13720.0
2017-03-20	FESX	Futures	2741.8	2754.1	2738.6	2746.7	540813.0
2017-03-20	FEU3	Futures	98.971	98.981	98.971	98.981	53.0
2017-03-20	FGBL	Futures	146.98	147.01	146.48	146.85	521511.0
2017-03-20	FGBM	Futures	128.93	128.93	128.73	128.92	339048.0
2017-03-20	FGBS	Futures	112.322	112.327	112.277	112.317	155708.0
2017-03-20	FGBX	Futures	166.27	166.27	164.65	165.51	38644.0
2017-03-20	FMWO	Futures	6244.7	6244.7	6235.0	6235.0	134.0
2017-03-20	FOAT	Futures	130.24	130.33	129.56	130.01	95593.0
2017-03-20	FTDX	Futures	1961.7	1962.6	1953.3	1953.8	78.0
2017-03-20	FTI	Futures	466.97	468.02	466.16	466.7	18019.0
2017-03-20	FTUK	Futures	6282.6	6300.6	6270.6	6298.0	58861.0
2017-03-20	FVSA	Futures	654.42	659.96	639.17	646.1	32519.0
2017-03-20	FXXP	Futures	313.0	313.7	312.5	313.0	20624.0
2017-03-20	G	Futures	113.78	113.97	113.53	113.93	112650.0
2017-03-20	GF	Futures	303.79	308.345	301.657	305.462	5390.0
2017-03-20	GSCI	Futures	486.75	489.62	486.69	487.39	446.0

> showing 50 of 109 rows — these rows as CSV

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