PREVIEW / etf_daily / 2013-09-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-12.parquet
  size:    41 KB
  rows:    1,024

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-09-12	SPY	ETF	169.34	169.56	168.72	168.95	83209000.0
2013-09-12	QQQ	ETF	78.06	78.25	77.85	78.01	18332687.0
2013-09-12	IWM	ETF	104.91	105.02	104.21	104.24	32707600.0
2013-09-12	DIA	ETF	153.33	153.41	152.78	153.03	5555700.0
2013-09-12	GLD	ETF	128.62	128.78	127.61	127.67	12944000.0
2013-09-12	TLT	ETF	103.85	104.0	103.06	103.15	6254400.0
2013-09-12	AADR	ETF	35.03	35.05	34.87	34.95	13200.0
2013-09-12	AAXJ	ETF	58.58	58.67	58.05	58.09	969900.0
2013-09-12	ACTV	ETF	10.23	10.545	10.1	10.32	416886.0
2013-09-12	ACWI	ETF	53.49	53.61	53.35	53.38	792500.0
2013-09-12	ACWV	ETF	61.38	61.38	61.05	61.07	99600.0
2013-09-12	ACWX	ETF	44.26	44.42	44.19	44.19	158341.0
2013-09-12	ADRE	ETF	37.3	37.3	36.92	36.92	29282.0
2013-09-12	AFK	ETF	29.38	29.51	29.25	29.251	29971.0
2013-09-12	AGEM	ETF	22.3501	22.51	22.16	22.16	21404.0
2013-09-12	AGG	ETF	105.8	105.83	105.54	105.54	846400.0
2013-09-12	AGQ	ETF	85.24	86.0	82.28	82.36	935025.0
2013-09-12	AGZ	ETF	110.07	110.249	110.07	110.12	8760.0
2013-09-12	AIA	ETF	46.68	46.79	46.41	46.42	392501.0
2013-09-12	AIQ	ETF	23.43	23.89	22.441	23.44	64904.0
2013-09-12	AIVI	ETF	44.64	44.92	44.63	44.71	25600.0
2013-09-12	AMJ	ETF	44.65	44.949	44.24	44.24	838637.0
2013-09-12	AMLP	ETF	87.25	87.4	86.7	86.8	420240.0
2013-09-12	ANGL	ETF	26.45	26.45	26.23	26.23	2800.0
2013-09-12	AOA	ETF	41.69	41.75	41.61	41.63	19200.0
2013-09-12	AOK	ETF	31.14	31.1799	31.05	31.05	21211.0
2013-09-12	AOM	ETF	33.09	33.0999	33.01	33.02	15082.0
2013-09-12	AOR	ETF	36.61	36.62	36.5	36.5	22901.0
2013-09-12	ARB	ETF	47.55	47.595	47.45	47.45	119819.0
2013-09-12	ARGT	ETF	19.58	19.58	19.17	19.17	3300.0
2013-09-12	ASEA	ETF	16.4	16.4	16.22	16.22	3100.0
2013-09-12	ATMP	ETF	26.12	26.12	25.64	25.64	31700.0
2013-09-12	AVIV	ETF	22.3	22.42	22.05	22.25	140987.0
2013-09-12	AWAY	ETF	31.98	32.02	31.72	31.84	522514.0
2013-09-12	BAB	ETF	27.08	27.17	26.88	26.93	146972.0
2013-09-12	BAL	ETF	53.95	54.234	53.52	54.2099	22909.0
2013-09-12	BALT	ETF	5.52	5.6	5.1401	5.2	431218.0
2013-09-12	BBH	ETF	82.51	82.8	82.08	82.47	59600.0
2013-09-12	BFOR	ETF	6.725	6.73	6.6825	6.69	204400.0
2013-09-12	BIB	ETF	31.67	32.0571	31.3875	31.56	133152.0
2013-09-12	BICK	ETF	23.41	23.52	23.41	23.52	3340.0
2013-09-12	BIL	ETF	91.6	91.6	91.58	91.58	97150.0
2013-09-12	BIS	ETF	1058.8	1062.004	1053.6	1055.6	31.25
2013-09-12	BIV	ETF	81.89	81.98	81.67	81.69	345900.0
2013-09-12	BIZD	ETF	20.38	20.39	20.31	20.39	18600.0
2013-09-12	BJK	ETF	46.57	46.57	46.1	46.12	29400.0
2013-09-12	BKF	ETF	37.38	37.38	37.0	37.01	45663.0
2013-09-12	BKLN	ETF	24.81	24.82	24.79	24.8	2423000.0
2013-09-12	BLV	ETF	81.33	81.55	80.83	80.86	152000.0
2013-09-12	BMVP	ETF	20.16	20.16	20.05	20.07	8390.0

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

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