PREVIEW / etf_daily / 2013-07-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-11.parquet
  size:    41 KB
  rows:    1,012

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-11	SPY	ETF	167.11	167.61	165.18	167.44	135592200.0
2013-07-11	QQQ	ETF	74.29	75.03	74.25	74.97	47777675.0
2013-07-11	IWM	ETF	102.42	102.59	101.94	102.47	34434200.0
2013-07-11	DIA	ETF	154.35	154.62	153.71	154.38	5848400.0
2013-07-11	GLD	ETF	124.26	124.36	123.47	124.24	11279400.0
2013-07-11	TLT	ETF	107.45	107.87	106.94	107.81	10035500.0
2013-07-11	AADR	ETF	33.37	33.44	33.37	33.44	1900.0
2013-07-11	AAXJ	ETF	56.14	56.77	55.92	56.73	775000.0
2013-07-11	ACTV	ETF	8.67	8.8	8.64	8.7	384963.0
2013-07-11	ACWI	ETF	52.0	52.23	51.77	52.21	893600.0
2013-07-11	ACWV	ETF	61.63	62.06	61.55	62.06	51900.0
2013-07-11	ACWX	ETF	42.18	42.62	42.14	42.62	534117.0
2013-07-11	ADRE	ETF	34.54	34.89	34.39	34.84	77398.0
2013-07-11	AFK	ETF	28.23	28.49	28.08	28.48	38676.0
2013-07-11	AGEM	ETF	20.99	20.99	20.821	20.93	2045.0
2013-07-11	AGG	ETF	106.77	106.94	106.62	106.93	1044200.0
2013-07-11	AGQ	ETF	70.96	72.0	69.88	71.96	618350.0
2013-07-11	AGZ	ETF	110.44	111.0699	110.44	110.83	26170.0
2013-07-11	AIA	ETF	43.7846	44.32	43.7846	44.32	22940.0
2013-07-11	AIQ	ETF	16.72	16.9	16.47	16.59	108872.0
2013-07-11	AIVI	ETF	41.4	41.77	41.3	41.72	39000.0
2013-07-11	AMJ	ETF	47.93	48.58	47.62	48.5	789149.0
2013-07-11	AMLP	ETF	90.9	90.95	90.4	90.9	645700.0
2013-07-11	ANGL	ETF	26.58	26.58	26.56	26.58	600.0
2013-07-11	AOA	ETF	40.93	41.04	40.83	41.03	47900.0
2013-07-11	AOK	ETF	30.97	31.064	30.97	31.0598	23613.0
2013-07-11	AOM	ETF	32.73	32.85	32.71	32.85	70792.0
2013-07-11	AOR	ETF	36.15	36.24	36.01	36.23	24540.0
2013-07-11	ARB	ETF	46.4	46.52	46.37	46.4	242727.0
2013-07-11	ASEA	ETF	17.12	17.39	17.12	17.36	54500.0
2013-07-11	ATMP	ETF	26.73	26.81	26.71	26.8	5900.0
2013-07-11	AVIV	ETF	25.89	26.2	25.63	25.89	241968.0
2013-07-11	AWAY	ETF	32.62	32.62	30.83	31.39	1188976.0
2013-07-11	BAB	ETF	27.92	28.08	27.76	28.03	388370.0
2013-07-11	BAL	ETF	55.58	55.82	54.3	54.3801	29231.0
2013-07-11	BALT	ETF	3.85	3.85	3.68	3.7	46217.0
2013-07-11	BBH	ETF	75.34	75.48	74.82	75.48	110500.0
2013-07-11	BCM	ETF	40.0399	40.04	39.9701	40.04	700.0
2013-07-11	BFOR	ETF	6.49	6.535	6.4725	6.5075	305200.0
2013-07-11	BIB	ETF	26.475	26.715	26.2575	26.67	216040.0
2013-07-11	BICK	ETF	21.38	21.54	21.38	21.54	1100.0
2013-07-11	BIL	ETF	91.58	91.6	91.58	91.58	790050.0
2013-07-11	BIS	ETF	1329.2	1329.2	1294.004	1295.152	449.0
2013-07-11	BIV	ETF	83.19	83.39	83.13	83.35	2588600.0
2013-07-11	BIZD	ETF	20.22	20.3	20.18	20.3	8500.0
2013-07-11	BJK	ETF	41.2	41.7	41.2	41.7	37100.0
2013-07-11	BKF	ETF	34.3	34.73	34.16	34.72	107055.0
2013-07-11	BKLN	ETF	24.81	24.87	24.81	24.84	3800000.0
2013-07-11	BLV	ETF	84.02	84.39	83.67	84.28	111300.0
2013-07-11	BMVP	ETF	19.5367	19.6033	19.4134	19.6033	6455.0

> showing 50 of 1,012 rows — these rows as CSV

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