PREVIEW / etf_daily / 2012-06-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-11.parquet
  size:    38 KB
  rows:    925

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
2012-06-11	SPY	ETF	134.17	134.25	131.28	131.41	169756100.0
2012-06-11	QQQ	ETF	63.35	63.38	61.77	61.805	51008831.0
2012-06-11	IWM	ETF	77.79	77.86	75.09	75.27	52803000.0
2012-06-11	DIA	ETF	126.38	126.49	123.85	123.98	7232100.0
2012-06-11	GLD	ETF	154.83	155.4	153.55	155.36	9166600.0
2012-06-11	TLT	ETF	124.79	126.21	124.77	125.78	10693800.0
2012-06-11	AAXJ	ETF	51.42	51.43	50.42	50.46	274900.0
2012-06-11	ACTV	ETF	14.6	14.855	14.42	14.62	509088.0
2012-06-11	ACWI	ETF	43.24	43.34	42.34	42.37	525700.0
2012-06-11	ACWV	ETF	53.87	54.26	53.05	53.1	20900.0
2012-06-11	ACWX	ETF	36.51	36.55	35.7	35.73	171563.0
2012-06-11	ADRE	ETF	37.13	37.28	36.2	36.2	30223.0
2012-06-11	AFK	ETF	27.38	27.44	26.8505	26.9245	80650.0
2012-06-11	AGEM	ETF	20.5	20.5	20.086	20.086	1302.0
2012-06-11	AGG	ETF	110.87	111.09	110.81	111.0	516100.0
2012-06-11	AGQ	ETF	167.52	167.52	162.92	166.76	296975.0
2012-06-11	AGZ	ETF	113.46	113.46	113.27	113.2998	5963.0
2012-06-11	AIA	ETF	40.54	40.54	39.91	39.91	11990.0
2012-06-11	AIQ	ETF	5.2	5.2	4.75	4.7885	14131.0
2012-06-11	AIS	ETF	3.22	3.33	3.21	3.25	1382632.0
2012-06-11	AIVI	ETF	37.52	37.52	36.64	36.68	32100.0
2012-06-11	AMJ	ETF	36.43	37.04	36.31	36.34	935664.0
2012-06-11	AMLP	ETF	78.05	78.95	78.05	78.15	225800.0
2012-06-11	ANGL	ETF	25.43	25.43	24.89	24.89	2200.0
2012-06-11	AOA	ETF	34.39	34.39	34.04	34.08	4400.0
2012-06-11	AOK	ETF	29.68	29.7337	29.5264	29.5264	10650.0
2012-06-11	AOM	ETF	30.4245	30.47	30.3	30.3	3989.0
2012-06-11	AOR	ETF	32.25	32.259	31.83	31.8495	17678.0
2012-06-11	ARB	ETF	34.49	34.49	33.38	33.41	147846.0
2012-06-11	ARGT	ETF	15.68	15.68	15.68	15.68	50.0
2012-06-11	ASEA	ETF	14.77	14.87	14.67	14.67	40200.0
2012-06-11	AWAY	ETF	22.03	22.3	21.38	21.7	607779.0
2012-06-11	BAB	ETF	29.81	29.9885	29.81	29.944	158499.0
2012-06-11	BAL	ETF	45.53	45.93	44.9709	45.46	22546.0
2012-06-11	BALT	ETF	3.3	3.3854	3.16	3.16	121599.0
2012-06-11	BBH	ETF	45.38	45.38	44.35	44.36	5200.0
2012-06-11	BCM	ETF	40.51	40.58	40.3737	40.3737	2477.0
2012-06-11	BIB	ETF	12.1625	12.1625	11.5711	11.5711	17648.0
2012-06-11	BICK	ETF	22.37	22.37	21.85	21.85	8187.0
2012-06-11	BIL	ETF	91.64	91.66	91.64	91.64	119800.0
2012-06-11	BIS	ETF	3502.4	3651.12	3502.4	3651.12	16.95
2012-06-11	BIV	ETF	88.34	88.76	88.34	88.73	431800.0
2012-06-11	BJK	ETF	31.46	31.5	31.11	31.11	5300.0
2012-06-11	BKF	ETF	35.66	35.66	34.66	34.7	162536.0
2012-06-11	BKLN	ETF	24.07	24.15	24.03	24.12	128200.0
2012-06-11	BLV	ETF	94.05	94.98	94.05	94.82	43900.0
2012-06-11	BMVP	ETF	14.66	14.66	14.44	14.44	4509.0
2012-06-11	BND	ETF	84.14	84.3	84.12	84.23	1175500.0
2012-06-11	BNO	ETF	35.395	35.395	34.145	34.165	218000.0
2012-06-11	BOIL	ETF	642600.0	657400.0	613200.0	615400.0	9.8

> showing 50 of 925 rows — these rows as CSV

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