PREVIEW / etf_daily / 2013-06-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-28.parquet
  size:    41 KB
  rows:    1,005

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-06-28	SPY	ETF	160.63	161.4	159.86	160.42	160402900.0
2013-06-28	QQQ	ETF	70.92	71.69	70.79	71.27	28301066.0
2013-06-28	IWM	ETF	97.4	97.96	96.85	97.0	46135800.0
2013-06-28	DIA	ETF	149.32	150.03	148.47	148.55	6719200.0
2013-06-28	GLD	ETF	115.22	119.33	114.68	119.11	32981900.0
2013-06-28	TLT	ETF	109.01	110.48	108.72	110.44	12017000.0
2013-06-28	AADR	ETF	32.82	32.82	32.82	32.82	100.0
2013-06-28	AAXJ	ETF	54.48	54.87	54.26	54.77	684300.0
2013-06-28	ACTV	ETF	7.22	7.57	7.19	7.57	2621860.0
2013-06-28	ACWI	ETF	50.08	50.28	49.82	50.0	2171600.0
2013-06-28	ACWV	ETF	59.75	60.19	59.55	59.81	85800.0
2013-06-28	ACWX	ETF	40.6	40.87	40.46	40.71	397659.0
2013-06-28	ADRE	ETF	34.02	34.46	33.94	34.36	42678.0
2013-06-28	AFK	ETF	26.94	27.01	26.701	27.01	22336.0
2013-06-28	AGEM	ETF	20.5	20.685	20.5	20.6761	2367.0
2013-06-28	AGG	ETF	106.93	107.35	106.85	107.21	2674000.0
2013-06-28	AGQ	ETF	61.32	68.24	61.24	68.0	1181000.0
2013-06-28	AGZ	ETF	110.68	110.84	110.67	110.7	13110.0
2013-06-28	AIA	ETF	42.42	42.7	42.211	42.49	90908.0
2013-06-28	AIQ	ETF	15.77	15.8	15.28	15.64	779261.0
2013-06-28	AIVI	ETF	40.1	40.21	39.92	40.09	28500.0
2013-06-28	AMJ	ETF	47.88	47.88	46.6	46.64	764310.0
2013-06-28	AMLP	ETF	89.25	89.5	88.85	89.25	519520.0
2013-06-28	ANGL	ETF	26.56	26.58	26.23	26.38	5700.0
2013-06-28	AOA	ETF	39.85	39.99	39.85	39.97	30200.0
2013-06-28	AOK	ETF	30.681	30.789	30.67	30.76	13061.0
2013-06-28	AOM	ETF	32.39	32.4499	32.281	32.38	14887.0
2013-06-28	AOR	ETF	35.4175	35.5615	35.4175	35.46	11946.0
2013-06-28	ARB	ETF	46.19	46.54	46.19	46.45	282975.0
2013-06-28	ASEA	ETF	16.84	16.94	16.8	16.9	54300.0
2013-06-28	ATMP	ETF	26.0	27.63	25.8	26.0	108000.0
2013-06-28	AVIV	ETF	25.35	25.76	25.1	25.29	1059470.0
2013-06-28	AWAY	ETF	32.16	32.76	32.01	32.34	2984321.0
2013-06-28	BAB	ETF	28.13	28.25	27.83	28.18	637432.0
2013-06-28	BAL	ETF	54.05	54.139	53.4	54.139	11993.0
2013-06-28	BALT	ETF	3.65	3.71	3.59	3.71	859628.0
2013-06-28	BBH	ETF	68.93	69.25	68.5	68.51	130800.0
2013-06-28	BCM	ETF	37.67	38.77	37.67	38.4825	14138.0
2013-06-28	BFOR	ETF	6.2025	6.23	6.17	6.1875	275600.0
2013-06-28	BIB	ETF	23.0	23.2407	22.6625	22.6625	72628.0
2013-06-28	BICK	ETF	20.94	21.09	20.94	21.09	1400.0
2013-06-28	BIL	ETF	91.62	91.62	91.58	91.6	1420750.0
2013-06-28	BIS	ETF	1500.04	1525.12	1500.04	1516.0	41.25
2013-06-28	BIV	ETF	83.33	83.58	83.17	83.49	397800.0
2013-06-28	BIZD	ETF	19.81	19.95	19.81	19.93	5300.0
2013-06-28	BJK	ETF	40.13	40.42	40.11	40.33	30900.0
2013-06-28	BKF	ETF	33.76	34.169	33.7	34.05	60757.0
2013-06-28	BKLN	ETF	24.71	24.75	24.62	24.75	2505600.0
2013-06-28	BLV	ETF	84.63	85.17	84.31	85.16	229700.0
2013-06-28	BMVP	ETF	18.78	18.81	18.69	18.69	2802.0

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

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