PREVIEW / futures_daily / 2014-09-19

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-19.parquet
  size:    9 KB
  rows:    107

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-09-19	ES	Futures	2095.44	2104.32	2087.34	2093.09	1670453.0
2014-09-19	NQ	Futures	4750.35	4773.53	4723.99	4743.69	279619.0
2014-09-19	YM	Futures	17449.8	17530.0	17419.4	17462.0	137462.0
2014-09-19	CL	Futures	173.23	173.75	171.7	172.64	250463.0
2014-09-19	GC	Futures	1607.6	1612.3	1592.6	1595.8	173498.0
2014-09-19	ZN	Futures	116.020698	116.298925	115.742471	116.211064	1143681.0
2014-09-19	A6	Futures	0.86781	0.86888	0.86159	0.86276	131302.0
2014-09-19	AD	Futures	0.92667	0.93124	0.92322	0.92505	71731.0
2014-09-19	ALI	Futures	2969.68	2969.68	2969.68	2969.68	16.0
2014-09-19	B	Futures	102.01	102.88	101.52	102.78	158385.0
2014-09-19	B6	Futures	1.7277	1.736	1.7098	1.7134	260856.0
2014-09-19	BFX	Futures	3891.8	3899.4	3891.8	3895.0	63.0
2014-09-19	BR	Futures	0.22425	0.22495	0.22206	0.22246	560.0
2014-09-19	BZ	Futures	102.61	103.6	102.24	103.51	12442.0
2014-09-19	C	Futures	2197.0	2245.0	2195.0	2241.0	10589.0
2014-09-19	CB	Futures	163.404	163.404	161.091	161.862	58.0
2014-09-19	CC	Futures	2358.0	2416.0	2356.0	2406.0	19756.0
2014-09-19	CNH	Futures	7.09	7.0924	7.0883	7.0908	5.0
2014-09-19	CSC	Futures	5.468	5.51	5.444	5.444	15.0
2014-09-19	CT	Futures	82.64	83.25	82.48	83.25	17.0
2014-09-19	DC	Futures	43.82	44.45	43.65	43.84	223.0
2014-09-19	DX	Futures	80.09	80.626	80.057	80.56	37092.0
2014-09-19	E1	Futures	1.36957	1.37085	1.35972	1.36049	31487.0
2014-09-19	E6	Futures	1.52141	1.52283	1.51082	1.51188	218578.0
2014-09-19	E7	Futures	1.512	1.5131	1.5012	1.5024	3526.0
2014-09-19	ED	Futures	95.423	95.4278	95.4183	95.423	86394.0
2014-09-19	ER	Futures	97.999	98.014	97.994	98.009	67980.0
2014-09-19	EW	Futures	1484.0	1491.0	1470.4	1475.5	19101.0
2014-09-19	FBTP	Futures	94.99	95.18	94.74	95.13	70666.0
2014-09-19	FBTS	Futures	98.774	98.783	98.721	98.766	16195.0
2014-09-19	FCE	Futures	3560.3	3576.2	3539.2	3548.0	118607.0
2014-09-19	FDAX	Futures	10787.4	10840.6	10715.1	10760.0	122885.0
2014-09-19	FDIV	Futures	141.5	141.5	140.66	140.85	21.0
2014-09-19	FESX	Futures	2370.9	2385.4	2354.2	2364.3	1132288.0
2014-09-19	FEU3	Futures	98.636	98.636	98.636	98.636	204.0
2014-09-19	FGBL	Futures	130.21	131.01	130.06	130.81	763584.0
2014-09-19	FGBM	Futures	122.42	122.74	122.36	122.68	394261.0
2014-09-19	FGBS	Futures	110.908	110.948	110.888	110.943	226587.0
2014-09-19	FGBX	Futures	137.76	139.46	137.38	139.06	21730.0
2014-09-19	FMWO	Futures	5812.8	5812.8	5783.9	5783.9	112.0
2014-09-19	FOAT	Futures	119.99	120.74	119.92	120.67	65816.0
2014-09-19	FTDX	Futures	1187.1	1192.7	1187.1	1187.1	528.0
2014-09-19	FTI	Futures	365.66	367.78	365.19	366.31	39803.0
2014-09-19	FTUK	Futures	5264.7	5315.7	5262.4	5268.9	127681.0
2014-09-19	FVSA	Futures	1347.77	1355.89	1327.47	1331.53	18449.0
2014-09-19	FXXP	Futures	264.6	265.7	263.4	264.1	8114.0
2014-09-19	G	Futures	95.44	96.09	95.39	95.98	189829.0
2014-09-19	GF	Futures	354.711	356.5	353.778	355.839	2667.0
2014-09-19	GSCI	Futures	982.18	984.28	977.72	982.01	32.0
2014-09-19	HE	Futures	127.558	128.534	127.053	127.659	15596.0

> showing 50 of 107 rows — these rows as CSV

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