PREVIEW / futures_daily / 2017-05-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-05.parquet
  size:    9 KB
  rows:    112

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-05-05	ES	Futures	2591.3	2605.69	2583.7	2604.06	1127621.0
2017-05-05	NQ	Futures	6627.42	6653.92	6610.34	6652.45	166263.0
2017-05-05	YM	Futures	22027.7	22129.0	21961.2	22110.0	95622.0
2017-05-05	CL	Futures	47.48	48.7	45.66	48.22	1021610.0
2017-05-05	GC	Futures	1571.0	1580.6	1568.1	1569.0	275886.0
2017-05-05	ZN	Futures	123.06011	123.24447	122.768207	123.121563	1320832.0
2017-05-05	A6	Futures	0.76028	0.76182	0.75576	0.76048	101316.0
2017-05-05	AD	Futures	0.74228	0.74794	0.73973	0.74565	93815.0
2017-05-05	ALI	Futures	2548.47	2548.47	2548.47	2548.47	0.0
2017-05-05	B	Futures	34.75	35.59	33.45	35.21	530438.0
2017-05-05	B6	Futures	1.3557	1.3633	1.3538	1.3616	84230.0
2017-05-05	BFX	Futures	4818.2	4833.9	4818.2	4833.9	1.0
2017-05-05	BR	Futures	0.2251	0.22705	0.22459	0.22665	1294.0
2017-05-05	BZ	Futures	34.46	35.33	33.22	34.96	54485.0
2017-05-05	C	Futures	1461.0	1491.0	1435.0	1486.0	5015.0
2017-05-05	CB	Futures	263.95	264.255	262.424	263.431	16.0
2017-05-05	CC	Futures	1414.0	1435.0	1380.0	1427.0	19955.0
2017-05-05	CNH	Futures	7.2128	7.2253	7.2126	7.2189	70.0
2017-05-05	CSC	Futures	3.509	3.585	3.509	3.563	64.0
2017-05-05	CT	Futures	87.51	87.51	86.06	86.13	15226.0
2017-05-05	DC	Futures	29.23	30.11	29.21	29.62	528.0
2017-05-05	DX	Futures	91.89	92.137	91.685	91.795	24976.0
2017-05-05	E1	Futures	1.25614	1.25652	1.25071	1.25441	25614.0
2017-05-05	E6	Futures	1.26751	1.26976	1.26337	1.26832	180179.0
2017-05-05	E7	Futures	1.261	1.2632	1.2555	1.2618	4222.0
2017-05-05	EBM	Futures	187.34	189.29	186.5	189.01	12026.0
2017-05-05	ED	Futures	95.5542	95.5542	95.5349	95.5397	247313.0
2017-05-05	ER	Futures	98.337	98.337	98.332	98.332	35777.0
2017-05-05	EW	Futures	1832.5	1847.5	1826.2	1846.4	10566.0
2017-05-05	FBON	Futures	122.67	123.01	122.5	122.95	948.0
2017-05-05	FBTP	Futures	105.84	106.65	105.8	106.49	111745.0
2017-05-05	FBTS	Futures	102.163	102.281	102.163	102.244	40979.0
2017-05-05	FCE	Futures	4741.9	4852.9	4734.3	4813.6	109512.0
2017-05-05	FDAX	Futures	13315.6	13555.3	13303.5	13427.0	78227.0
2017-05-05	FDIV	Futures	150.92	151.67	150.92	151.67	30.0
2017-05-05	FDXM	Futures	13201.8	13437.2	13188.2	13309.1	21638.0
2017-05-05	FESX	Futures	2914.9	2975.3	2911.6	2950.0	1153334.0
2017-05-05	FEU3	Futures	99.006	99.011	99.006	99.011	103.0
2017-05-05	FGBL	Futures	147.97	148.12	147.39	147.47	714480.0
2017-05-05	FGBM	Futures	129.07	129.19	128.85	128.9	518096.0
2017-05-05	FGBS	Futures	112.252	112.277	112.202	112.222	315832.0
2017-05-05	FGBX	Futures	166.87	167.39	165.81	165.93	45169.0
2017-05-05	FMWO	Futures	6343.4	6374.8	6343.4	6365.1	3666.0
2017-05-05	FOAT	Futures	134.23	134.44	133.99	134.07	152355.0
2017-05-05	FTDX	Futures	2101.9	2101.9	2080.3	2090.6	94.0
2017-05-05	FTI	Futures	480.47	487.4	479.6	485.75	27298.0
2017-05-05	FTUK	Futures	6167.1	6217.2	6141.0	6197.0	79219.0
2017-05-05	FVSA	Futures	545.82	547.61	526.13	535.08	35943.0
2017-05-05	FXXP	Futures	327.2	332.1	326.7	329.9	51580.0
2017-05-05	G	Futures	115.49	115.67	115.3	115.35	155563.0

> showing 50 of 112 rows — these rows as CSV

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