PREVIEW / futures_daily / 2014-07-01

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-01.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-01	ES	Futures	2030.33	2048.25	2029.29	2042.01	1455654.0
2014-07-01	NQ	Futures	4438.59	4493.39	4435.99	4482.14	195635.0
2014-07-01	YM	Futures	16907.6	17071.0	16899.5	17027.6	127883.0
2014-07-01	CL	Futures	192.61	193.79	191.07	192.42	221685.0
2014-07-01	GC	Futures	1749.1	1758.9	1744.5	1747.9	121098.0
2014-07-01	ZN	Futures	116.783747	116.856692	116.535737	116.594092	832276.0
2014-07-01	A6	Futures	0.90678	0.91374	0.90504	0.91297	91957.0
2014-07-01	AD	Futures	0.95023	0.95389	0.94942	0.95318	36312.0
2014-07-01	ALI	Futures	2791.86	2791.86	2791.86	2791.86	36.0
2014-07-01	B	Futures	117.59	118.37	117.46	117.91	203676.0
2014-07-01	B6	Futures	1.7976	1.8036	1.7962	1.802	83903.0
2014-07-01	BFX	Futures	3796.1	3820.2	3795.6	3820.2	35.0
2014-07-01	BR	Futures	0.23352	0.23574	0.23352	0.23532	454.0
2014-07-01	BZ	Futures	118.6	119.1	118.21	118.66	16952.0
2014-07-01	C	Futures	2052.0	2052.0	2027.0	2036.0	3461.0
2014-07-01	CB	Futures	126.463	126.463	123.528	123.528	42.0
2014-07-01	CC	Futures	2288.0	2298.0	2275.0	2292.0	7468.0
2014-07-01	CSC	Futures	4.578	4.578	4.475	4.495	18.0
2014-07-01	CT	Futures	92.22	92.44	90.92	91.59	66.0
2014-07-01	DC	Futures	36.66	36.71	35.34	35.69	337.0
2014-07-01	DX	Futures	75.786	75.839	75.72	75.791	18398.0
2014-07-01	E1	Futures	1.4466	1.44827	1.44468	1.44545	28733.0
2014-07-01	E6	Futures	1.61615	1.6171	1.61403	1.6145	120550.0
2014-07-01	E7	Futures	1.6055	1.6064	1.6036	1.604	1622.0
2014-07-01	ED	Futures	95.4115	95.4162	95.4115	95.4115	72694.0
2014-07-01	ER	Futures	97.92	97.925	97.911	97.925	33437.0
2014-07-01	EW	Futures	1487.6	1505.3	1487.5	1495.4	25091.0
2014-07-01	FBTP	Futures	91.52	91.69	91.42	91.62	42474.0
2014-07-01	FBTS	Futures	98.161	98.214	98.116	98.196	11269.0
2014-07-01	FCE	Futures	3534.9	3566.9	3534.5	3561.7	73557.0
2014-07-01	FDAX	Futures	10858.9	10941.5	10837.4	10904.1	71283.0
2014-07-01	FESX	Futures	2324.6	2345.4	2323.1	2338.9	624850.0
2014-07-01	FEU3	Futures	98.542	98.547	98.542	98.547	25.0
2014-07-01	FGBL	Futures	127.81	127.99	127.69	127.92	424746.0
2014-07-01	FGBM	Futures	121.46	121.58	121.42	121.54	326406.0
2014-07-01	FGBS	Futures	110.763	110.788	110.753	110.778	176066.0
2014-07-01	FGBX	Futures	133.09	133.21	132.67	133.03	15321.0
2014-07-01	FMWO	Futures	5817.9	5831.8	5817.9	5831.8	32.0
2014-07-01	FOAT	Futures	117.58	117.68	117.45	117.61	55270.0
2014-07-01	FTDX	Futures	1230.0	1242.7	1230.0	1239.8	101.0
2014-07-01	FTI	Futures	357.58	359.65	357.19	359.0	19100.0
2014-07-01	FTUK	Futures	5156.5	5202.3	5156.2	5195.0	65753.0
2014-07-01	FVSA	Futures	1315.15	1315.15	1267.87	1272.17	3734.0
2014-07-01	FXXP	Futures	257.4	259.4	257.3	259.0	6070.0
2014-07-01	G	Futures	93.72	93.79	93.46	93.55	144024.0
2014-07-01	GF	Futures	327.401	330.696	327.401	330.696	3046.0
2014-07-01	GSCI	Futures	1099.91	1099.91	1093.08	1096.33	190.0
2014-07-01	HE	Futures	139.572	139.966	136.319	136.87	22395.0
2014-07-01	HG	Futures	4.0941	4.1075	4.0826	4.0954	36049.0
2014-07-01	HH	Futures	56.334	56.334	56.334	56.334	254.0

> showing 50 of 103 rows — these rows as CSV

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