PREVIEW / etf_daily / 2013-04-04

all etf daily files

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

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-04	SPY	ETF	155.43	156.17	155.09	155.86	131885000.0
2013-04-04	QQQ	ETF	68.41	68.6	68.06	68.43	32287367.0
2013-04-04	IWM	ETF	91.26	91.94	90.96	91.91	37706300.0
2013-04-04	DIA	ETF	145.36	145.98	145.09	145.77	7520100.0
2013-04-04	GLD	ETF	149.65	150.6	149.44	150.29	12429000.0
2013-04-04	TLT	ETF	119.59	120.41	119.47	120.39	9365700.0
2013-04-04	AAXJ	ETF	57.94	58.1	57.65	58.03	667500.0
2013-04-04	ACTV	ETF	4.09	4.17	4.04	4.16	332406.0
2013-04-04	ACWI	ETF	50.38	50.58	50.25	50.49	1684300.0
2013-04-04	ACWV	ETF	61.98	62.12	61.79	61.98	70000.0
2013-04-04	ACWX	ETF	42.31	42.59	42.289	42.5	310743.0
2013-04-04	ADRE	ETF	37.91	37.94	37.68	37.74	99761.0
2013-04-04	AFK	ETF	29.82	30.17	29.82	30.17	31973.0
2013-04-04	AGEM	ETF	22.0501	22.1074	22.0301	22.0301	812.0
2013-04-04	AGG	ETF	110.72	110.88	110.71	110.88	1263800.0
2013-04-04	AGQ	ETF	134.08	136.44	132.92	135.48	366625.0
2013-04-04	AGZ	ETF	113.46	113.6	113.3201	113.44	17605.0
2013-04-04	AIA	ETF	45.45	45.63	45.241	45.54	22556.0
2013-04-04	AIQ	ETF	8.03	8.15	8.03	8.13	25095.0
2013-04-04	AIVI	ETF	41.96	42.31	41.89	42.26	14200.0
2013-04-04	AMJ	ETF	45.19	45.19	44.65	44.95	1095070.0
2013-04-04	AMLP	ETF	87.35	87.5	87.15	87.2	410300.0
2013-04-04	AOA	ETF	39.29	39.42	39.25	39.42	13800.0
2013-04-04	AOK	ETF	31.11	31.14	31.078	31.1269	13115.0
2013-04-04	AOM	ETF	32.6	32.66	32.55	32.624	9706.0
2013-04-04	AOR	ETF	35.38	35.45	35.326	35.45	9138.0
2013-04-04	ARB	ETF	46.94	46.94	46.84	46.87	383913.0
2013-04-04	ARGT	ETF	16.92	16.98	16.82	16.98	9050.0
2013-04-04	ASEA	ETF	17.63	17.64	17.51	17.61	11900.0
2013-04-04	ATMP	ETF	25.67	25.7	25.66	25.7	5400.0
2013-04-04	AVIV	ETF	24.11	24.19	23.9	24.06	366480.0
2013-04-04	AWAY	ETF	30.18	30.4	29.85	30.31	1023518.0
2013-04-04	BAB	ETF	30.48	30.58	30.4102	30.54	154362.0
2013-04-04	BAL	ETF	57.31	57.6	56.8861	56.97	6177.0
2013-04-04	BALT	ETF	3.6	3.6	3.38	3.39	114806.0
2013-04-04	BBH	ETF	65.02	65.31	64.48	64.97	35200.0
2013-04-04	BCM	ETF	41.82	41.949	41.7	41.949	3808.0
2013-04-04	BIB	ETF	19.5525	19.9225	19.255	19.635	86084.0
2013-04-04	BICK	ETF	23.33	23.33	23.23	23.23	4900.0
2013-04-04	BIL	ETF	91.6	91.62	91.6	91.6	91800.0
2013-04-04	BIS	ETF	1920.0	1920.0	1920.0	1920.0	37.5
2013-04-04	BIV	ETF	87.76	88.01	87.76	87.95	168200.0
2013-04-04	BIZD	ETF	19.8	19.95	19.8	19.89	8100.0
2013-04-04	BJK	ETF	39.19	39.27	39.13	39.27	6900.0
2013-04-04	BKF	ETF	37.94	38.02	37.67	37.908	6848744.0
2013-04-04	BKLN	ETF	25.12	25.13	25.12	25.12	1640500.0
2013-04-04	BLV	ETF	92.23	92.67	92.1	92.61	47600.0
2013-04-04	BMVP	ETF	18.3367	18.3533	18.2876	18.3533	1845.0
2013-04-04	BND	ETF	83.58	83.74	83.58	83.71	784400.0
2013-04-04	BNO	ETF	40.34	40.505	39.885	40.29	117800.0

> showing 50 of 979 rows — these rows as CSV

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