PREVIEW / etf_daily / 2013-01-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-30.parquet
  size:    40 KB
  rows:    976

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-01-30	SPY	ETF	150.64	150.94	149.93	150.07	137447700.0
2013-01-30	QQQ	ETF	67.28	67.48	66.87	67.02	34444953.0
2013-01-30	IWM	ETF	89.97	90.02	88.69	88.97	39299300.0
2013-01-30	DIA	ETF	139.23	139.37	138.67	138.76	5496100.0
2013-01-30	GLD	ETF	162.68	163.04	162.03	162.19	12010000.0
2013-01-30	TLT	ETF	116.67	116.96	116.16	116.75	9586800.0
2013-01-30	AADR	ETF	32.8	32.8	32.8	32.8	900.0
2013-01-30	AAXJ	ETF	60.66	60.77	60.51	60.63	573200.0
2013-01-30	ACTV	ETF	5.52	5.61	5.435	5.47	337575.0
2013-01-30	ACWI	ETF	50.18	50.23	50.0	50.04	1856800.0
2013-01-30	ACWV	ETF	57.85	58.15	57.85	57.95	61200.0
2013-01-30	ACWX	ETF	43.3	43.41	43.24	43.28	160901.0
2013-01-30	ADRE	ETF	40.87	40.95	40.765	40.8	62159.0
2013-01-30	AFK	ETF	30.99	31.185	30.6602	30.7	29609.0
2013-01-30	AGEM	ETF	23.86	23.91	23.64	23.7	9910.0
2013-01-30	AGG	ETF	110.21	110.3	110.15	110.29	1362200.0
2013-01-30	AGQ	ETF	193.04	197.6	192.12	194.2	398475.0
2013-01-30	AGZ	ETF	112.92	112.98	112.81	112.937	11972.0
2013-01-30	AIA	ETF	47.52	47.63	47.42	47.42	37073.0
2013-01-30	AIQ	ETF	6.36	6.49	6.266	6.47	14142.0
2013-01-30	AIVI	ETF	43.4	43.52	43.37	43.4	35500.0
2013-01-30	ALTL	ETF	27.73	27.741	27.73	27.741	300.0
2013-01-30	AMJ	ETF	43.18	43.2499	42.75	42.89	1485124.0
2013-01-30	AMLP	ETF	85.75	86.15	85.6	85.7	658860.0
2013-01-30	ANGL	ETF	27.25	27.25	27.0	27.0	10600.0
2013-01-30	AOA	ETF	38.83	38.88	38.69	38.72	12300.0
2013-01-30	AOK	ETF	30.93	30.93	30.89	30.89	12541.0
2013-01-30	AOM	ETF	32.38	32.38	32.26	32.26	45326.0
2013-01-30	AOR	ETF	34.99	35.009	34.889	34.9	38671.0
2013-01-30	ARB	ETF	47.0	47.04	46.9	46.97	181250.0
2013-01-30	ARGT	ETF	18.48	18.48	18.2	18.34	5150.0
2013-01-30	ASEA	ETF	16.99	17.03	16.95	16.96	23700.0
2013-01-30	AWAY	ETF	23.4	23.5	23.17	23.41	565328.0
2013-01-30	BAB	ETF	29.98	29.9815	29.88	29.94	191965.0
2013-01-30	BAL	ETF	54.11	54.45	53.7691	54.382	27249.0
2013-01-30	BALT	ETF	3.5	3.5	3.27	3.32	33803.0
2013-01-30	BBH	ETF	57.78	57.87	57.4	57.52	12800.0
2013-01-30	BCM	ETF	46.29	46.29	45.15	45.29	74758.0
2013-01-30	BIB	ETF	16.37	16.4875	16.125	16.125	44788.0
2013-01-30	BICK	ETF	25.79	25.9899	25.79	25.83	1442.0
2013-01-30	BIL	ETF	91.6	91.62	91.6	91.6	160750.0
2013-01-30	BIS	ETF	2343.6	2364.0	2343.6	2364.0	7.5
2013-01-30	BIV	ETF	87.2	87.36	87.16	87.32	383500.0
2013-01-30	BJK	ETF	38.3	38.4	38.25	38.27	28200.0
2013-01-30	BKF	ETF	42.0	42.12	41.91	42.04	76097.0
2013-01-30	BKLN	ETF	25.19	25.2	25.15	25.17	1325200.0
2013-01-30	BLNG	ETF	50.35	50.35	50.35	50.35	250.0
2013-01-30	BLV	ETF	91.17	91.3	90.96	91.19	369800.0
2013-01-30	BMVP	ETF	17.583	17.583	17.479	17.479	4461.0
2013-01-30	BND	ETF	83.34	83.37	83.25	83.3	1626700.0

> showing 50 of 976 rows — these rows as CSV

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