PREVIEW / etf_daily / 2013-04-19

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-19.parquet
  size:    40 KB
  rows:    977

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-19	SPY	ETF	154.5	155.55	154.12	155.48	149687600.0
2013-04-19	QQQ	ETF	67.31	68.231	67.2	68.09	43066868.0
2013-04-19	IWM	ETF	89.96	90.69	89.21	90.61	44931600.0
2013-04-19	DIA	ETF	144.71	145.21	144.36	145.14	6028600.0
2013-04-19	GLD	ETF	136.0	136.02	134.6	135.47	15659300.0
2013-04-19	TLT	ETF	122.94	122.98	122.63	122.83	5474300.0
2013-04-19	AADR	ETF	33.01	33.01	33.01	33.01	400.0
2013-04-19	AAXJ	ETF	58.12	58.38	58.04	58.33	398700.0
2013-04-19	ACTV	ETF	4.73	4.78	4.68	4.71	212922.0
2013-04-19	ACWI	ETF	50.23	50.41	50.07	50.39	239600.0
2013-04-19	ACWV	ETF	62.27	62.59	62.22	62.59	106600.0
2013-04-19	ACWX	ETF	42.33	42.48	42.26	42.45	153349.0
2013-04-19	ADRE	ETF	37.59	37.72	37.428	37.72	32463.0
2013-04-19	AFK	ETF	28.56	28.799	28.55	28.68	23050.0
2013-04-19	AGEM	ETF	21.75	21.9499	21.75	21.9499	1769.0
2013-04-19	AGG	ETF	111.25	111.28	111.2	111.24	373600.0
2013-04-19	AGQ	ETF	100.12	100.16	95.4	97.72	435675.0
2013-04-19	AGZ	ETF	113.91	113.91	113.6635	113.78	9124.0
2013-04-19	AIA	ETF	45.12	45.2948	45.09	45.226	9365.0
2013-04-19	AIQ	ETF	9.52	9.78	9.52	9.67	13304.0
2013-04-19	AIVI	ETF	41.94	42.05	41.83	41.96	17200.0
2013-04-19	AMJ	ETF	45.41	46.5	45.41	46.02	1348421.0
2013-04-19	AMLP	ETF	88.0	88.7	87.9	88.55	713080.0
2013-04-19	ANGL	ETF	29.2	29.21	29.16	29.16	1000.0
2013-04-19	AOA	ETF	39.25	39.37	39.12	39.37	34500.0
2013-04-19	AOK	ETF	31.1372	31.19	31.09	31.19	47149.0
2013-04-19	AOM	ETF	32.5828	32.68	32.5796	32.67	35843.0
2013-04-19	AOR	ETF	35.23	35.45	35.23	35.45	29911.0
2013-04-19	ARB	ETF	46.72	46.77	46.65	46.76	235687.0
2013-04-19	ARGT	ETF	16.14	16.28	16.14	16.2	400.0
2013-04-19	ASEA	ETF	17.99	18.03	17.96	18.02	64400.0
2013-04-19	ATMP	ETF	26.08	26.08	26.01	26.01	4900.0
2013-04-19	AVIV	ETF	24.2	25.17	24.2	24.78	641785.0
2013-04-19	AWAY	ETF	31.92	32.96	31.7771	32.37	767851.0
2013-04-19	BAB	ETF	30.79	30.85	30.73	30.85	114265.0
2013-04-19	BAL	ETF	53.8	54.12	53.48	53.59	64233.0
2013-04-19	BALT	ETF	3.23	3.24	3.16	3.24	29659.0
2013-04-19	BBH	ETF	68.43	70.7	68.43	70.66	112700.0
2013-04-19	BCM	ETF	39.8401	39.874	39.838	39.874	1507.0
2013-04-19	BIB	ETF	21.5	22.6623	20.5635	22.5925	301608.0
2013-04-19	BICK	ETF	23.3	23.3272	23.271	23.3272	678.0
2013-04-19	BIL	ETF	91.62	91.62	91.6	91.62	90300.0
2013-04-19	BIS	ETF	1718.0	1718.0	1619.912	1619.912	265.0
2013-04-19	BIV	ETF	88.46	88.47	88.36	88.47	172700.0
2013-04-19	BIZD	ETF	19.3	19.43	19.3	19.39	8200.0
2013-04-19	BJK	ETF	39.21	39.54	39.21	39.52	8700.0
2013-04-19	BKF	ETF	37.76	37.96	37.678	37.93	103033.0
2013-04-19	BKLN	ETF	25.1	25.12	25.09	25.11	2550700.0
2013-04-19	BLV	ETF	94.48	94.48	94.27	94.42	11400.0
2013-04-19	BMVP	ETF	18.05	18.2499	17.874	18.2499	1531.0

> showing 50 of 977 rows — these rows as CSV

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