PREVIEW / etf_daily / 2013-03-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-05.parquet
  size:    40 KB
  rows:    982

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-03-05	SPY	ETF	153.66	154.7	153.64	154.29	121431900.0
2013-03-05	QQQ	ETF	68.1	68.77	68.08	68.68	35589440.0
2013-03-05	IWM	ETF	91.61	92.35	91.6	92.19	35612300.0
2013-03-05	DIA	ETF	141.69	142.68	141.69	142.34	7962300.0
2013-03-05	GLD	ETF	153.1	153.39	152.11	152.38	10804200.0
2013-03-05	TLT	ETF	118.07	118.2	117.68	117.93	6539300.0
2013-03-05	AADR	ETF	33.31	33.31	33.31	33.31	300.0
2013-03-05	AAXJ	ETF	60.06	60.25	59.97	60.16	1210200.0
2013-03-05	ACTV	ETF	4.54	4.6	4.49	4.54	501079.0
2013-03-05	ACWI	ETF	50.3	50.59	50.3	50.46	348400.0
2013-03-05	ACWV	ETF	60.24	60.27	60.08	60.18	37400.0
2013-03-05	ACWX	ETF	42.82	43.06	42.82	43.0	321139.0
2013-03-05	ADRE	ETF	39.09	39.4	39.09	39.15	55309.0
2013-03-05	AFK	ETF	30.35	30.701	30.35	30.55	38057.0
2013-03-05	AGEM	ETF	22.95	22.95	22.73	22.7993	878.0
2013-03-05	AGG	ETF	110.54	110.57	110.48	110.49	804400.0
2013-03-05	AGQ	ETF	158.08	159.04	153.4	155.08	313875.0
2013-03-05	AGZ	ETF	113.1501	113.28	113.15	113.24	5063.0
2013-03-05	AIA	ETF	47.15	47.39	47.15	47.36	29851.0
2013-03-05	AIQ	ETF	7.05	7.05	6.68	7.02	10068.0
2013-03-05	AIVI	ETF	42.25	42.46	42.25	42.37	19900.0
2013-03-05	AMJ	ETF	43.59	43.679	43.2678	43.39	2595238.0
2013-03-05	AMLP	ETF	85.85	85.95	85.4	85.75	621180.0
2013-03-05	ANGL	ETF	27.14	27.14	26.87	26.97	4400.0
2013-03-05	AOA	ETF	39.13	39.33	39.13	39.28	21700.0
2013-03-05	AOK	ETF	31.01	31.08	31.01	31.036	45546.0
2013-03-05	AOM	ETF	32.5	32.6	32.5	32.6	32303.0
2013-03-05	AOR	ETF	35.24	35.36	35.24	35.36	18311.0
2013-03-05	ARB	ETF	46.94	46.94	46.75	46.82	359299.0
2013-03-05	ARGT	ETF	16.96	17.22	16.96	17.1	19800.0
2013-03-05	ASEA	ETF	17.33	17.39	17.3	17.33	16400.0
2013-03-05	AWAY	ETF	30.6	31.25	30.2	30.43	1352590.0
2013-03-05	BAB	ETF	30.52	30.59	30.49	30.54	160240.0
2013-03-05	BAL	ETF	56.23	56.4599	55.91	56.25	61334.0
2013-03-05	BALT	ETF	4.0	4.1	3.88	3.97	58140.0
2013-03-05	BBH	ETF	61.18	61.53	60.75	61.53	59900.0
2013-03-05	BCM	ETF	42.82	42.9	42.82	42.88	15969.0
2013-03-05	BIB	ETF	17.82	18.1023	17.7	17.99	110312.0
2013-03-05	BICK	ETF	24.93	25.076	24.93	24.97	3200.0
2013-03-05	BIL	ETF	91.6	91.62	91.6	91.62	133700.0
2013-03-05	BIS	ETF	2120.0	2120.0	2090.0	2090.0	107.5
2013-03-05	BIV	ETF	87.82	87.84	87.71	87.79	362400.0
2013-03-05	BIZD	ETF	20.5	20.56	20.47	20.53	6900.0
2013-03-05	BJK	ETF	38.49	38.54	38.39	38.47	7800.0
2013-03-05	BKF	ETF	39.78	39.97	39.7	39.73	144840.0
2013-03-05	BKLN	ETF	25.0	25.01	25.0	25.01	2233200.0
2013-03-05	BLV	ETF	91.99	92.15	91.9	92.06	38300.0
2013-03-05	BMVP	ETF	18.0322	18.0833	18.0167	18.0691	2807.0
2013-03-05	BND	ETF	83.6	83.61	83.53	83.55	1009500.0
2013-03-05	BNO	ETF	41.54	42.01	41.51	41.915	207600.0

> showing 50 of 982 rows — these rows as CSV

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