PREVIEW / futures_daily / 2013-07-19

all futures daily files

  file:    by_date/futures_daily/2013/2013-07-19.parquet
  size:    9 KB
  rows:    102

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
2013-07-19	ES	Futures	1730.34	1741.15	1725.45	1740.12	1145886.0
2013-07-19	NQ	Futures	3526.93	3526.93	3505.53	3517.39	203203.0
2013-07-19	YM	Futures	15328.3	15373.8	15292.6	15368.9	88567.0
2013-07-19	CL	Futures	188.38	190.25	186.72	188.39	316998.0
2013-07-19	GC	Futures	1702.4	1721.9	1701.1	1716.4	134153.0
2013-07-19	ZN	Futures	113.896446	114.233335	113.826261	114.177187	654620.0
2013-07-19	A6	Futures	0.8571	0.8631	0.8555	0.85916	76816.0
2013-07-19	AD	Futures	0.96956	0.97167	0.96794	0.97036	47694.0
2013-07-19	B	Futures	105.75	106.18	104.07	105.1	212190.0
2013-07-19	B6	Futures	1.5959	1.6017	1.5927	1.5995	68092.0
2013-07-19	BFX	Futures	3184.3	3184.3	3180.4	3180.4	90.0
2013-07-19	BR	Futures	0.2193	0.2193	0.21843	0.2193	92.0
2013-07-19	BZ	Futures	106.47	106.89	104.81	105.81	6176.0
2013-07-19	C	Futures	1713.0	1725.0	1701.0	1707.0	6583.0
2013-07-19	CB	Futures	77.139	77.139	76.78	77.139	42.0
2013-07-19	CC	Futures	1763.0	1776.0	1756.0	1766.0	15942.0
2013-07-19	CSC	Futures	3.545	3.551	3.528	3.551	30.0
2013-07-19	CT	Futures	101.49	103.04	101.49	103.04	7.0
2013-07-19	DC	Futures	27.08	27.52	27.08	27.41	380.0
2013-07-19	DX	Futures	79.237	79.38	78.96	79.047	21304.0
2013-07-19	E1	Futures	1.36154	1.36848	1.3591	1.36604	20532.0
2013-07-19	E6	Futures	1.54772	1.55279	1.545	1.55055	146551.0
2013-07-19	E7	Futures	1.5377	1.5425	1.5349	1.5404	2548.0
2013-07-19	ED	Futures	95.2916	95.2916	95.2869	95.2869	39619.0
2013-07-19	ER	Futures	97.832	97.837	97.817	97.822	56966.0
2013-07-19	EW	Futures	1250.6	1257.1	1247.8	1256.3	14942.0
2013-07-19	FBTP	Futures	77.4	77.64	77.31	77.49	17863.0
2013-07-19	FBTS	Futures	92.851	92.937	92.842	92.928	4787.0
2013-07-19	FCE	Futures	3024.2	3036.5	3015.6	3035.4	85956.0
2013-07-19	FDAX	Futures	9206.3	9258.5	9196.3	9252.9	82446.0
2013-07-19	FESX	Futures	1898.0	1907.8	1893.0	1906.4	826364.0
2013-07-19	FEU3	Futures	98.443	98.443	98.433	98.433	174.0
2013-07-19	FGBL	Futures	120.77	120.88	120.56	120.76	396795.0
2013-07-19	FGBM	Futures	117.91	117.98	117.82	117.88	253856.0
2013-07-19	FGBS	Futures	110.462	110.472	110.412	110.437	162911.0
2013-07-19	FGBX	Futures	125.82	126.24	125.34	125.59	6755.0
2013-07-19	FMWO	Futures	4950.9	4964.9	4942.1	4964.9	70.0
2013-07-19	FOAT	Futures	107.3	107.36	107.02	107.07	32784.0
2013-07-19	FTDX	Futures	933.4	937.6	932.0	932.4	44.0
2013-07-19	FTI	Futures	320.9	322.87	319.54	322.6	29580.0
2013-07-19	FTUK	Futures	4935.4	4942.9	4908.4	4940.3	75942.0
2013-07-19	FVSA	Futures	2816.18	2830.4	2766.4	2780.62	5146.0
2013-07-19	FXXP	Futures	219.3	221.9	218.9	220.3	2307.0
2013-07-19	G	Futures	95.8	95.88	95.3	95.46	93237.0
2013-07-19	GF	Futures	256.903	257.788	255.471	256.524	2105.0
2013-07-19	GSCI	Futures	1062.3	1070.24	1058.79	1063.28	307.0
2013-07-19	HE	Futures	99.871	99.948	99.38	99.664	9384.0
2013-07-19	HG	Futures	3.9708	4.0127	3.9493	3.9841	42561.0
2013-07-19	HH	Futures	42.027	42.372	41.882	42.205	1899.0
2013-07-19	HO	Futures	2.5009	2.5154	2.4618	2.482	37946.0

> showing 50 of 102 rows — these rows as CSV

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