PREVIEW / futures_daily / 2017-07-31

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-31.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-07-31	ES	Futures	2685.0	2689.89	2679.29	2682.28	1229202.0
2017-07-31	NQ	Futures	6947.45	6975.07	6900.72	6915.12	280483.0
2017-07-31	YM	Futures	23018.5	23125.3	22991.0	23089.4	94740.0
2017-07-31	CL	Futures	51.28	51.85	50.59	51.61	781539.0
2017-07-31	GC	Futures	1624.0	1625.2	1618.1	1620.3	165132.0
2017-07-31	ZN	Futures	124.02691	124.150029	123.934571	123.99613	1032988.0
2017-07-31	A6	Futures	0.81995	0.8218	0.81677	0.82119	76319.0
2017-07-31	AD	Futures	0.81819	0.81865	0.81229	0.81728	89600.0
2017-07-31	ALI	Futures	2531.51	2531.51	2531.51	2531.51	30.0
2017-07-31	B	Futures	36.58	37.0	36.22	36.88	376748.0
2017-07-31	B6	Futures	1.3753	1.3844	1.3709	1.3813	105755.0
2017-07-31	BR	Futures	0.23507	0.23693	0.2347	0.2367	1612.0
2017-07-31	BZ	Futures	36.4	36.68	35.92	36.56	31864.0
2017-07-31	C	Futures	1606.0	1618.0	1594.0	1602.0	13786.0
2017-07-31	CB	Futures	338.166	338.166	328.617	330.716	16.0
2017-07-31	CC	Futures	1565.0	1581.0	1547.0	1564.0	26278.0
2017-07-31	CNH	Futures	6.9738	6.9738	6.965	6.965	60.0
2017-07-31	CSC	Futures	3.581	3.631	3.581	3.61	106.0
2017-07-31	CT	Futures	82.09	83.01	81.5	82.28	12.0
2017-07-31	DC	Futures	29.82	30.36	29.82	30.14	868.0
2017-07-31	DX	Futures	86.999	87.2	86.5	86.577	29881.0
2017-07-31	E1	Futures	1.27051	1.27825	1.26818	1.27407	40280.0
2017-07-31	E6	Futures	1.34996	1.36061	1.34658	1.35889	241643.0
2017-07-31	E7	Futures	1.3429	1.3534	1.3396	1.3518	4754.0
2017-07-31	EBM	Futures	188.45	188.45	187.06	187.34	9112.0
2017-07-31	ED	Futures	95.5935	95.5983	95.5886	95.5935	110950.0
2017-07-31	ER	Futures	98.337	98.342	98.337	98.342	24241.0
2017-07-31	EW	Futures	1873.3	1877.4	1863.8	1869.3	12014.0
2017-07-31	FBON	Futures	124.18	124.45	124.18	124.3	230.0
2017-07-31	FBTP	Futures	108.07	108.5	108.03	108.35	62233.0
2017-07-31	FBTS	Futures	102.918	102.945	102.909	102.918	29851.0
2017-07-31	FCE	Futures	4601.1	4621.7	4559.7	4570.5	75347.0
2017-07-31	FDAX	Futures	12781.3	12849.2	12715.5	12750.3	73888.0
2017-07-31	FDXM	Futures	12701.6	12769.6	12637.8	12671.8	18833.0
2017-07-31	FESX	Futures	2820.2	2835.7	2803.0	2813.6	833764.0
2017-07-31	FGBL	Futures	147.24	147.34	146.91	147.12	511732.0
2017-07-31	FGBM	Futures	128.91	128.93	128.78	128.82	321331.0
2017-07-31	FGBS	Futures	112.272	112.282	112.257	112.267	224320.0
2017-07-31	FGBX	Futures	163.31	164.14	162.89	163.82	39977.0
2017-07-31	FMWO	Futures	6557.9	6561.5	6547.2	6548.4	447.0
2017-07-31	FOAT	Futures	135.17	135.21	134.86	135.06	106380.0
2017-07-31	FTDX	Futures	2268.2	2279.2	2253.6	2261.1	194.0
2017-07-31	FTI	Futures	482.56	484.83	481.77	482.61	19727.0
2017-07-31	FTUK	Futures	6307.9	6360.2	6300.1	6317.4	95732.0
2017-07-31	FVSA	Futures	430.15	436.08	421.25	431.63	12756.0
2017-07-31	FXXP	Futures	320.8	322.7	319.8	320.7	24478.0
2017-07-31	G	Futures	114.58	114.71	114.31	114.42	160516.0
2017-07-31	GF	Futures	320.662	323.57	317.534	320.881	5629.0
2017-07-31	GSCI	Futures	469.78	472.94	467.17	471.36	1570.0
2017-07-31	HE	Futures	93.071	93.617	92.181	92.238	7404.0

> showing 50 of 109 rows — these rows as CSV

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