PREVIEW / futures_daily / 2014-07-17

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-17.parquet
  size:    9 KB
  rows:    104

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-17	ES	Futures	2047.73	2052.66	2024.09	2029.29	2441561.0
2014-07-17	NQ	Futures	4521.66	4531.47	4452.72	4472.05	380375.0
2014-07-17	YM	Futures	17194.1	17238.5	17039.7	17093.2	225013.0
2014-07-17	CL	Futures	185.56	189.45	185.21	188.14	256902.0
2014-07-17	GC	Futures	1713.3	1747.0	1710.4	1735.1	176744.0
2014-07-17	ZN	Futures	116.696214	117.338124	116.681625	117.046347	1531360.0
2014-07-17	A6	Futures	0.90127	0.90407	0.89972	0.90272	58301.0
2014-07-17	AD	Futures	0.94394	0.94536	0.94221	0.94373	44888.0
2014-07-17	ALI	Futures	2879.87	2879.87	2879.87	2879.87	0.0
2014-07-17	B	Futures	112.68	114.22	112.33	113.48	296510.0
2014-07-17	B6	Futures	1.8007	1.8013	1.7953	1.7981	61046.0
2014-07-17	BFX	Futures	3807.2	3807.2	3786.7	3786.7	9.0
2014-07-17	BR	Futures	0.23323	0.23365	0.23028	0.23189	291.0
2014-07-17	BZ	Futures	113.55	115.06	113.06	114.2	11847.0
2014-07-17	C	Futures	2010.0	2029.0	2004.0	2015.0	7022.0
2014-07-17	CB	Futures	127.72	128.559	126.882	127.385	34.0
2014-07-17	CC	Futures	2248.0	2268.0	2246.0	2251.0	11739.0
2014-07-17	CSC	Futures	4.35	4.377	4.35	4.363	26.0
2014-07-17	CT	Futures	86.39	86.75	86.16	86.35	12.0
2014-07-17	DC	Futures	35.22	35.48	35.15	35.37	180.0
2014-07-17	DX	Futures	76.503	76.569	76.451	76.479	13438.0
2014-07-17	E1	Futures	1.4275	1.42981	1.42699	1.42865	31998.0
2014-07-17	E6	Futures	1.59621	1.59798	1.59515	1.59633	118396.0
2014-07-17	E7	Futures	1.5856	1.5875	1.5848	1.5859	1143.0
2014-07-17	ED	Futures	95.4162	95.4162	95.4115	95.4162	108831.0
2014-07-17	ER	Futures	97.901	97.906	97.901	97.901	25207.0
2014-07-17	EW	Futures	1461.4	1464.9	1441.4	1447.1	21909.0
2014-07-17	FBTP	Futures	91.82	92.05	91.73	91.94	41489.0
2014-07-17	FBTS	Futures	98.285	98.356	98.241	98.348	10525.0
2014-07-17	FCE	Futures	3464.6	3470.6	3403.4	3431.6	80856.0
2014-07-17	FDAX	Futures	10835.8	10851.2	10667.3	10740.0	123568.0
2014-07-17	FDIV	Futures	148.55	148.55	148.15	148.15	5.0
2014-07-17	FESX	Futures	2296.5	2297.2	2250.5	2268.5	1171288.0
2014-07-17	FGBL	Futures	128.65	129.11	128.58	128.87	644760.0
2014-07-17	FGBM	Futures	121.75	121.83	121.7	121.76	374369.0
2014-07-17	FGBS	Futures	110.783	110.788	110.773	110.778	154267.0
2014-07-17	FGBX	Futures	135.16	135.95	135.08	135.48	24897.0
2014-07-17	FMWO	Futures	5790.2	5790.2	5776.4	5778.9	1687.0
2014-07-17	FOAT	Futures	118.43	118.75	118.39	118.65	61353.0
2014-07-17	FTDX	Futures	1173.4	1183.7	1170.6	1176.7	487.0
2014-07-17	FTI	Futures	352.12	352.69	347.1	349.57	26784.0
2014-07-17	FTUK	Futures	5172.3	5175.4	5119.6	5143.1	91272.0
2014-07-17	FVSA	Futures	1354.2	1409.38	1345.71	1400.89	7546.0
2014-07-17	FXXP	Futures	257.1	257.4	254.3	255.5	4438.0
2014-07-17	G	Futures	94.17	94.69	94.17	94.56	145141.0
2014-07-17	GF	Futures	322.496	325.523	322.343	324.297	3208.0
2014-07-17	GSCI	Futures	1054.87	1061.31	1053.61	1059.55	83.0
2014-07-17	HE	Futures	136.896	137.421	134.614	135.217	19007.0
2014-07-17	HG	Futures	4.1107	4.1235	4.0928	4.1164	38519.0
2014-07-17	HH	Futures	50.125	50.201	49.821	49.998	826.0

> showing 50 of 104 rows — these rows as CSV

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