PREVIEW / futures_daily / 2014-07-18

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-18.parquet
  size:    9 KB
  rows:    103

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
2014-07-18	ES	Futures	2024.87	2050.84	2017.86	2047.99	1796625.0
2014-07-18	NQ	Futures	4465.7	4540.98	4446.66	4534.64	291934.0
2014-07-18	YM	Futures	17040.7	17203.2	16986.3	17185.0	155631.0
2014-07-18	CL	Futures	189.19	189.58	187.13	187.68	217747.0
2014-07-18	GC	Futures	1738.0	1746.5	1719.5	1725.3	121624.0
2014-07-18	ZN	Futures	117.265179	117.396479	116.856692	116.973402	1002418.0
2014-07-18	A6	Futures	0.90001	0.9061	0.89876	0.90475	75079.0
2014-07-18	AD	Futures	0.94262	0.94719	0.94201	0.94505	42291.0
2014-07-18	ALI	Futures	2883.28	2883.28	2883.28	2883.28	0.0
2014-07-18	B	Futures	114.12	114.25	112.48	112.79	210876.0
2014-07-18	B6	Futures	1.7969	1.7987	1.7901	1.7962	94507.0
2014-07-18	BFX	Futures	3771.4	3792.3	3771.4	3787.9	45.0
2014-07-18	BR	Futures	0.23189	0.23389	0.23033	0.23373	3900.0
2014-07-18	BZ	Futures	114.75	114.99	113.22	113.51	10183.0
2014-07-18	C	Futures	2023.0	2035.0	2017.0	2030.0	5770.0
2014-07-18	CB	Futures	126.323	126.323	125.764	125.764	13.0
2014-07-18	CC	Futures	2259.0	2274.0	2251.0	2265.0	12268.0
2014-07-18	CNH	Futures	7.143	7.1443	7.1399	7.1419	5.0
2014-07-18	CSC	Futures	4.377	4.377	4.363	4.363	7.0
2014-07-18	CT	Futures	86.22	86.58	86.22	86.58	2.0
2014-07-18	DC	Futures	35.43	35.6	35.18	35.22	196.0
2014-07-18	DX	Futures	76.512	76.655	76.456	76.503	20980.0
2014-07-18	E1	Futures	1.42878	1.42968	1.4243	1.42814	36474.0
2014-07-18	E6	Futures	1.59633	1.59739	1.59208	1.59621	161533.0
2014-07-18	E7	Futures	1.586	1.587	1.5816	1.5858	1711.0
2014-07-18	ED	Futures	95.4162	95.421	95.4115	95.4162	55689.0
2014-07-18	ER	Futures	97.901	97.906	97.891	97.896	58521.0
2014-07-18	EW	Futures	1442.9	1464.9	1437.7	1462.4	16946.0
2014-07-18	FBTP	Futures	91.92	92.0	91.64	91.83	35336.0
2014-07-18	FBTS	Futures	98.339	98.401	98.276	98.348	7812.0
2014-07-18	FCE	Futures	3409.7	3463.4	3407.3	3449.5	101532.0
2014-07-18	FDAX	Futures	10684.9	10739.4	10630.9	10692.1	100613.0
2014-07-18	FESX	Futures	2254.1	2285.0	2251.9	2273.5	984639.0
2014-07-18	FGBL	Futures	129.0	129.12	128.8	128.91	467550.0
2014-07-18	FGBM	Futures	121.79	121.83	121.68	121.71	320335.0
2014-07-18	FGBS	Futures	110.778	110.783	110.758	110.763	148540.0
2014-07-18	FGBX	Futures	135.86	136.27	135.42	135.88	15502.0
2014-07-18	FMWO	Futures	5757.5	5780.2	5757.5	5780.2	40.0
2014-07-18	FOAT	Futures	118.77	118.83	118.56	118.72	44347.0
2014-07-18	FTDX	Futures	1167.3	1174.8	1159.4	1166.9	682.0
2014-07-18	FTI	Futures	347.53	349.83	346.66	349.0	35966.0
2014-07-18	FTUK	Futures	5115.0	5169.2	5108.1	5150.8	82915.0
2014-07-18	FVSA	Futures	1434.85	1473.06	1388.16	1400.89	11402.0
2014-07-18	FXXP	Futures	254.9	256.4	253.7	255.2	4656.0
2014-07-18	G	Futures	94.54	94.92	94.5	94.72	125546.0
2014-07-18	GF	Futures	323.339	326.749	322.535	324.374	2582.0
2014-07-18	GSCI	Futures	1058.04	1058.55	1053.95	1054.7	101.0
2014-07-18	HE	Futures	134.955	135.165	133.039	133.354	18620.0
2014-07-18	HG	Futures	4.1113	4.1145	4.0487	4.0704	45357.0
2014-07-18	HH	Futures	50.036	50.112	49.821	49.961	751.0

> showing 50 of 103 rows — these rows as CSV

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