PREVIEW / futures_daily / 2017-06-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-12.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-06-12	ES	Futures	2639.08	2640.17	2627.14	2637.46	1253497.0
2017-06-12	NQ	Futures	6761.1	6768.17	6636.26	6726.36	260181.0
2017-06-12	YM	Futures	22423.4	22438.2	22346.2	22393.8	183267.0
2017-06-12	CL	Futures	47.44	48.38	47.29	47.73	666765.0
2017-06-12	GC	Futures	1620.9	1624.3	1615.6	1619.8	173005.0
2017-06-12	ZN	Futures	124.503996	124.611725	124.303927	124.427046	1072960.0
2017-06-12	A6	Futures	0.7728	0.77424	0.77167	0.77342	10989.0
2017-06-12	AD	Futures	0.75717	0.76505	0.75641	0.7647	30529.0
2017-06-12	ALI	Futures	2482.73	2482.73	2482.73	2482.73	0.0
2017-06-12	B	Futures	34.19	34.96	34.15	34.35	316560.0
2017-06-12	B6	Futures	1.3347	1.3385	1.3247	1.3269	39003.0
2017-06-12	BFX	Futures	4698.2	4704.3	4698.2	4704.3	4.0
2017-06-12	BR	Futures	0.22126	0.22126	0.22003	0.22003	10.0
2017-06-12	BZ	Futures	34.13	34.79	34.01	34.21	28229.0
2017-06-12	C	Futures	1628.0	1681.0	1624.0	1676.0	21753.0
2017-06-12	CB	Futures	312.317	316.24	311.739	316.24	22.0
2017-06-12	CC	Futures	1555.0	1589.0	1546.0	1585.0	37386.0
2017-06-12	CNH	Futures	7.0703	7.0771	7.0703	7.0743	2.0
2017-06-12	CSC	Futures	3.604	3.633	3.604	3.633	54.0
2017-06-12	CT	Futures	83.86	83.89	83.16	83.21	19061.0
2017-06-12	DC	Futures	30.12	30.52	30.12	30.47	162.0
2017-06-12	DX	Futures	90.594	90.594	90.342	90.432	9942.0
2017-06-12	E1	Futures	1.27579	1.27812	1.27481	1.27628	11515.0
2017-06-12	E6	Futures	1.29032	1.29359	1.28906	1.29084	47821.0
2017-06-12	E7	Futures	1.2837	1.2866	1.2824	1.2841	761.0
2017-06-12	EBM	Futures	188.45	188.45	187.06	187.34	9285.0
2017-06-12	ED	Futures	95.5741	95.5789	95.5596	95.5644	182885.0
2017-06-12	ER	Futures	98.337	98.342	98.332	98.337	73996.0
2017-06-12	EW	Futures	1867.4	1872.4	1860.2	1868.2	37154.0
2017-06-12	FBON	Futures	124.62	125.11	124.61	124.69	512.0
2017-06-12	FBTP	Futures	108.08	108.88	108.03	108.77	104416.0
2017-06-12	FBTS	Futures	102.708	102.836	102.708	102.827	49790.0
2017-06-12	FCE	Futures	4754.2	4757.3	4701.0	4716.3	130172.0
2017-06-12	FDAX	Futures	13472.9	13496.7	13367.9	13412.2	124013.0
2017-06-12	FDIV	Futures	151.23	151.49	151.23	151.49	20.0
2017-06-12	FEU3	Futures	99.011	99.011	99.006	99.006	15.0
2017-06-12	FGBL	Futures	149.85	150.13	149.77	149.98	474538.0
2017-06-12	FGBM	Futures	129.92	129.99	129.86	129.9	318636.0
2017-06-12	FGBS	Futures	112.407	112.427	112.382	112.397	183495.0
2017-06-12	FGBX	Futures	169.25	170.04	169.05	169.7	32028.0
2017-06-12	FMWO	Futures	6460.3	6461.5	6443.4	6455.5	11852.0
2017-06-12	FOAT	Futures	136.84	137.29	136.8	137.22	77311.0
2017-06-12	FTDX	Futures	2262.1	2262.1	2249.6	2249.6	421.0
2017-06-12	FTI	Futures	483.55	483.73	479.44	480.87	9504.0
2017-06-12	FTUK	Futures	6438.4	6460.8	6408.1	6435.8	201470.0
2017-06-12	FVSA	Futures	472.34	488.09	470.77	484.94	8646.0
2017-06-12	FXXP	Futures	329.1	329.5	327.1	327.9	112322.0
2017-06-12	G	Futures	116.49	116.96	116.36	116.73	124611.0
2017-06-12	GF	Futures	339.211	340.583	329.003	332.68	5888.0
2017-06-12	GSCI	Futures	453.4	453.4	448.17	448.96	3359.0

> showing 50 of 109 rows — these rows as CSV

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