PREVIEW / etf_daily / 2013-04-23

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-23.parquet
  size:    40 KB
  rows:    985

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-04-23	SPY	ETF	156.95	157.93	156.17	157.78	166141300.0
2013-04-23	QQQ	ETF	69.2	69.7	68.82	69.45	53078214.0
2013-04-23	IWM	ETF	91.6	92.34	90.86	92.31	55313200.0
2013-04-23	DIA	ETF	146.13	146.9	145.15	146.8	10435300.0
2013-04-23	GLD	ETF	137.22	137.24	135.85	136.88	14644900.0
2013-04-23	TLT	ETF	123.26	123.79	122.38	122.49	8042900.0
2013-04-23	AAXJ	ETF	58.37	58.69	58.26	58.55	352500.0
2013-04-23	ACTV	ETF	4.69	4.8599	4.67	4.85	714569.0
2013-04-23	ACWI	ETF	50.83	51.14	50.73	51.08	910500.0
2013-04-23	ACWV	ETF	62.91	63.13	62.91	63.09	97500.0
2013-04-23	ACWX	ETF	42.85	43.07	42.816	43.02	256290.0
2013-04-23	ADRE	ETF	37.87	38.25	37.79	38.08	28700.0
2013-04-23	AFK	ETF	28.99	29.0076	28.7201	28.82	133877.0
2013-04-23	AGEM	ETF	21.84	21.84	21.84	21.84	497.0
2013-04-23	AGG	ETF	111.45	111.51	111.29	111.33	747900.0
2013-04-23	AGQ	ETF	95.8	96.48	94.12	95.76	398125.0
2013-04-23	AGZ	ETF	113.83	113.88	113.67	113.67	19631.0
2013-04-23	AIA	ETF	45.35	45.51	45.19	45.4438	19275.0
2013-04-23	AIQ	ETF	10.0	10.3	9.81	10.09	12310.0
2013-04-23	AIVI	ETF	42.48	42.86	42.48	42.79	59400.0
2013-04-23	AMJ	ETF	46.69	47.33	46.42	47.26	605407.0
2013-04-23	AMLP	ETF	88.95	89.45	88.8	89.35	714920.0
2013-04-23	ANGL	ETF	27.69	27.69	27.3	27.3	2000.0
2013-04-23	AOA	ETF	39.7	39.88	39.66	39.88	92600.0
2013-04-23	AOK	ETF	31.32	31.35	31.3199	31.35	18422.0
2013-04-23	AOM	ETF	32.8467	32.9372	32.82	32.88	26461.0
2013-04-23	AOR	ETF	35.68	35.79	35.65	35.76	35770.0
2013-04-23	ARB	ETF	46.82	46.84	46.6	46.76	349355.0
2013-04-23	ARGT	ETF	16.62	16.66	16.5	16.66	3000.0
2013-04-23	ASEA	ETF	17.88	18.11	17.83	18.01	69400.0
2013-04-23	ATMP	ETF	26.48	26.48	26.24	26.39	16300.0
2013-04-23	AVIV	ETF	25.05	25.07	24.75	25.05	391221.0
2013-04-23	AWAY	ETF	32.39	33.97	32.27	33.81	2094407.0
2013-04-23	BAB	ETF	30.88	31.0	30.8101	30.87	426790.0
2013-04-23	BAL	ETF	54.12	54.2	53.34	53.53	89884.0
2013-04-23	BALT	ETF	3.39	3.46	3.25	3.34	155956.0
2013-04-23	BBH	ETF	71.88	72.77	71.4	71.68	239700.0
2013-04-23	BCM	ETF	39.7	39.7	39.561	39.561	26990.0
2013-04-23	BIB	ETF	23.7675	24.2175	23.0	23.2475	329516.0
2013-04-23	BICK	ETF	23.51	23.56	23.4936	23.5415	825.0
2013-04-23	BIL	ETF	91.6	91.62	91.6	91.62	355500.0
2013-04-23	BIS	ETF	1586.4	1586.4	1530.4	1577.6	145.0
2013-04-23	BIV	ETF	88.6	88.72	88.47	88.51	288000.0
2013-04-23	BIZD	ETF	20.03	20.12	19.99	20.11	30400.0
2013-04-23	BJK	ETF	40.1	40.39	40.1	40.39	15200.0
2013-04-23	BKF	ETF	37.89	38.309	37.81	38.17	109079.0
2013-04-23	BKLN	ETF	25.12	25.14	25.12	25.13	6685900.0
2013-04-23	BLV	ETF	94.76	94.76	94.26	94.3	89100.0
2013-04-23	BMVP	ETF	18.56	18.5859	18.4267	18.5733	3506.0
2013-04-23	BND	ETF	84.09	84.17	83.99	84.07	899100.0

> showing 50 of 985 rows — these rows as CSV

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