PREVIEW / etf_daily / 2013-03-21

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-21.parquet
  size:    40 KB
  rows:    981

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-21	SPY	ETF	154.76	155.64	154.1	154.36	128605000.0
2013-03-21	QQQ	ETF	68.09	68.25	67.77	67.93	30050789.0
2013-03-21	IWM	ETF	94.04	94.47	93.54	93.87	37122600.0
2013-03-21	DIA	ETF	144.12	144.59	143.49	143.89	6075700.0
2013-03-21	GLD	ETF	156.17	156.43	155.88	156.25	4992000.0
2013-03-21	TLT	ETF	116.86	117.25	116.53	117.24	6119400.0
2013-03-21	AADR	ETF	32.99	32.99	32.99	32.99	200.0
2013-03-21	AAXJ	ETF	58.05	58.17	57.77	57.83	891300.0
2013-03-21	ACTV	ETF	4.28	4.34	4.24	4.25	877441.0
2013-03-21	ACWI	ETF	50.39	50.57	50.2	50.2	761200.0
2013-03-21	ACWV	ETF	60.83	60.94	60.7	60.76	52300.0
2013-03-21	ACWX	ETF	42.65	42.86	42.606	42.65	165319.0
2013-03-21	ADRE	ETF	38.14	38.298	38.02	38.03	24299.0
2013-03-21	AFK	ETF	30.1	30.35	30.03	30.14	17750.0
2013-03-21	AGEM	ETF	22.34	22.34	22.34	22.34	225.0
2013-03-21	AGG	ETF	110.43	110.46	110.35	110.37	906400.0
2013-03-21	AGQ	ETF	160.2	161.32	159.48	159.8	342525.0
2013-03-21	AGZ	ETF	113.06	113.22	113.05	113.21	9859.0
2013-03-21	AIA	ETF	45.52	45.55	45.31	45.31	7065.0
2013-03-21	AIQ	ETF	7.15	7.19	7.15	7.16	7620.0
2013-03-21	AIVI	ETF	42.55	42.79	42.46	42.59	24700.0
2013-03-21	AMJ	ETF	43.69	44.52	43.51	44.22	1495514.0
2013-03-21	AMLP	ETF	86.0	87.25	85.75	86.9	576880.0
2013-03-21	AOA	ETF	39.5	39.59	39.43	39.43	22700.0
2013-03-21	AOK	ETF	31.12	31.14	31.0632	31.0632	14691.0
2013-03-21	AOM	ETF	32.68	32.72	32.63	32.63	16667.0
2013-03-21	AOR	ETF	35.5	35.5399	35.4	35.4	14093.0
2013-03-21	ARB	ETF	46.91	46.94	46.87	46.88	142742.0
2013-03-21	ARGT	ETF	17.68	17.72	17.66	17.68	2650.0
2013-03-21	ASEA	ETF	17.13	17.15	17.07	17.11	7200.0
2013-03-21	ATMP	ETF	25.38	25.52	25.19	25.4	20300.0
2013-03-21	AVIV	ETF	22.2	23.0	22.1	22.55	12088221.0
2013-03-21	AWAY	ETF	31.42	32.99	31.37	31.9	3107241.0
2013-03-21	BAB	ETF	30.19	30.3	30.1401	30.19	139172.0
2013-03-21	BAL	ETF	57.09	57.25	56.9	56.97	15832.0
2013-03-21	BALT	ETF	3.95	4.2	3.95	4.08	131056.0
2013-03-21	BBH	ETF	62.31	62.61	61.83	62.06	16800.0
2013-03-21	BCM	ETF	43.37	43.37	42.9499	42.9499	5966.0
2013-03-21	BIB	ETF	18.5675	18.585	18.3125	18.425	60536.0
2013-03-21	BICK	ETF	23.89	24.05	23.89	23.9	1761.0
2013-03-21	BIL	ETF	91.6	91.62	91.6	91.6	61650.0
2013-03-21	BIS	ETF	2030.8	2030.8	2030.8	2030.8	2.5
2013-03-21	BIV	ETF	87.7	87.7	87.58	87.68	182800.0
2013-03-21	BIZD	ETF	20.54	20.54	20.48	20.48	2800.0
2013-03-21	BJK	ETF	39.29	39.33	39.08	39.14	6700.0
2013-03-21	BKF	ETF	38.85	38.94	38.57	38.61	132329.0
2013-03-21	BKLN	ETF	25.07	25.08	25.06	25.08	2072300.0
2013-03-21	BLV	ETF	90.91	91.05	90.69	91.02	39000.0
2013-03-21	BMVP	ETF	18.3943	18.41	18.3333	18.41	1571.0
2013-03-21	BND	ETF	83.45	83.45	83.34	83.36	1017000.0

> showing 50 of 981 rows — these rows as CSV

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