PREVIEW / futures_daily / 2014-07-21

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-21.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-21	ES	Futures	2046.69	2047.99	2035.0	2042.53	1414256.0
2014-07-21	NQ	Futures	4533.77	4539.25	4510.99	4529.45	219804.0
2014-07-21	YM	Futures	17173.9	17182.0	17059.9	17135.6	129463.0
2014-07-21	CL	Futures	187.52	189.56	186.82	189.36	312630.0
2014-07-21	GC	Futures	1727.8	1737.9	1723.3	1731.2	85369.0
2014-07-21	ZN	Futures	116.929636	117.192235	116.885869	116.958814	710502.0
2014-07-21	A6	Futures	0.90485	0.90514	0.90214	0.90311	40341.0
2014-07-21	AD	Futures	0.94485	0.94556	0.94333	0.94475	29418.0
2014-07-21	ALI	Futures	2929.85	2929.85	2929.85	2929.85	0.0
2014-07-21	B	Futures	112.7	113.46	112.32	113.26	211696.0
2014-07-21	B6	Futures	1.7953	1.7968	1.7922	1.7941	47091.0
2014-07-21	BFX	Futures	3785.5	3785.5	3782.8	3782.8	1.0
2014-07-21	BR	Futures	0.23418	0.23481	0.23371	0.23458	589.0
2014-07-21	BZ	Futures	113.4	114.16	113.05	113.98	9604.0
2014-07-21	C	Futures	2029.0	2052.0	2021.0	2049.0	4540.0
2014-07-21	CB	Futures	126.044	126.882	125.764	126.323	10.0
2014-07-21	CC	Futures	2265.0	2300.0	2256.0	2298.0	22481.0
2014-07-21	CSC	Futures	4.339	4.377	4.339	4.377	5.0
2014-07-21	CT	Futures	86.27	86.75	86.27	86.44	3.0
2014-07-21	DC	Futures	35.2	35.39	34.89	35.37	175.0
2014-07-21	DX	Futures	76.489	76.569	76.403	76.533	11522.0
2014-07-21	E1	Futures	1.42814	1.42942	1.42647	1.42801	22026.0
2014-07-21	E6	Futures	1.59657	1.59905	1.59468	1.59586	96406.0
2014-07-21	E7	Futures	1.5859	1.5887	1.5844	1.5855	897.0
2014-07-21	ED	Futures	95.4162	95.4162	95.4115	95.4162	50274.0
2014-07-21	ER	Futures	97.891	97.896	97.886	97.886	42444.0
2014-07-21	EW	Futures	1461.5	1462.2	1452.1	1458.9	14265.0
2014-07-21	FBTP	Futures	92.04	92.22	91.79	92.05	36324.0
2014-07-21	FBTS	Futures	98.383	98.454	98.365	98.383	9465.0
2014-07-21	FCE	Futures	3447.1	3452.3	3416.1	3422.8	81644.0
2014-07-21	FDAX	Futures	10714.6	10720.1	10567.1	10600.1	99554.0
2014-07-21	FESX	Futures	2277.1	2279.3	2250.5	2258.4	782489.0
2014-07-21	FGBL	Futures	128.96	129.09	128.87	129.05	324674.0
2014-07-21	FGBM	Futures	121.73	121.76	121.69	121.75	231522.0
2014-07-21	FGBS	Futures	110.773	110.773	110.763	110.768	85390.0
2014-07-21	FGBX	Futures	136.03	136.21	135.84	136.11	16125.0
2014-07-21	FMWO	Futures	5782.7	5784.0	5758.8	5772.6	1156.0
2014-07-21	FOAT	Futures	118.78	118.9	118.62	118.87	33940.0
2014-07-21	FTDX	Futures	1167.8	1167.8	1156.6	1158.9	339.0
2014-07-21	FTI	Futures	349.35	349.65	346.92	348.48	25209.0
2014-07-21	FTUK	Futures	5155.4	5162.3	5127.7	5143.5	62172.0
2014-07-21	FVSA	Futures	1405.14	1451.83	1396.65	1430.61	10684.0
2014-07-21	FXXP	Futures	255.7	255.7	253.5	254.3	4721.0
2014-07-21	G	Futures	94.76	94.87	94.6	94.84	87148.0
2014-07-21	GF	Futures	325.676	327.477	323.722	326.481	3649.0
2014-07-21	GSCI	Futures	1053.86	1060.3	1053.86	1059.55	909.0
2014-07-21	HE	Futures	133.171	133.171	130.914	131.282	19120.0
2014-07-21	HG	Futures	4.0743	4.0954	4.0564	4.089	36805.0
2014-07-21	HH	Futures	48.797	49.063	48.405	48.671	2338.0
2014-07-21	HO	Futures	2.2831	2.2959	2.2795	2.2925	29046.0

> showing 50 of 103 rows — these rows as CSV

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