PREVIEW / etf_daily / 2014-04-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-28.parquet
  size:    44 KB
  rows:    1,089

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
2014-04-28	SPY	ETF	187.05	187.69	184.96	186.88	135121000.0
2014-04-28	QQQ	ETF	86.58	87.11	85.11	86.47	58623796.0
2014-04-28	IWM	ETF	112.01	112.54	109.32	110.96	66050100.0
2014-04-28	DIA	ETF	164.13	164.69	162.78	164.17	7236900.0
2014-04-28	GLD	ETF	125.3	125.34	124.45	124.88	4897900.0
2014-04-28	TLT	ETF	111.11	111.28	110.55	110.79	7606000.0
2014-04-28	AADR	ETF	37.74	37.74	37.74	37.74	300.0
2014-04-28	AAXJ	ETF	59.39	59.62	59.13	59.5	366100.0
2014-04-28	ACWI	ETF	58.19	58.44	57.78	58.26	833600.0
2014-04-28	ACWV	ETF	64.28	64.9	64.28	64.61	45300.0
2014-04-28	ACWX	ETF	46.94	46.96	46.57	46.91	171070.0
2014-04-28	ADRE	ETF	36.99	36.99	36.7601	36.97	10533.0
2014-04-28	AFK	ETF	32.56	32.56	31.991	32.3	21841.0
2014-04-28	AGG	ETF	108.39	108.46	108.26	108.32	523300.0
2014-04-28	AGQ	ETF	62.72	62.73	61.84	62.52	197300.0
2014-04-28	AGZ	ETF	112.0348	112.06	112.0	112.02	27244.0
2014-04-28	AGZD	ETF	25.04	25.04	25.04	25.04	400.0
2014-04-28	AIA	ETF	46.88	46.88	46.429	46.565	10153.0
2014-04-28	AIQ	ETF	30.02	30.49	29.04	29.55	22811.0
2014-04-28	AIRR	ETF	19.284	19.3	18.88	19.11	27900.0
2014-04-28	AIVI	ETF	49.5	49.72	49.24	49.58	16200.0
2014-04-28	AMJ	ETF	47.81	48.1	47.78	48.1	308796.0
2014-04-28	AMLP	ETF	90.05	90.2	89.7	90.05	528860.0
2014-04-28	ANGL	ETF	27.58	27.77	27.58	27.75	1100.0
2014-04-28	AOA	ETF	45.07	45.24	44.73	45.07	31800.0
2014-04-28	AOK	ETF	32.53	32.53	32.2832	32.4	34701.0
2014-04-28	AOM	ETF	34.86	34.86	34.58	34.73	31169.0
2014-04-28	AOR	ETF	38.95	39.055	38.751	38.96	40237.0
2014-04-28	ARGT	ETF	20.03	20.03	19.74	19.74	1500.0
2014-04-28	ASEA	ETF	16.22	16.27	16.18	16.26	5900.0
2014-04-28	ASHR	ETF	21.68	21.7	21.58	21.67	56900.0
2014-04-28	ATMP	ETF	28.79	28.79	28.54	28.71	49100.0
2014-04-28	AVIV	ETF	26.44	26.675	26.17	26.34	239572.0
2014-04-28	AWAY	ETF	33.5	34.02	31.45	32.6	3782606.0
2014-04-28	BAB	ETF	28.96	29.019	28.915	28.96	81380.0
2014-04-28	BAL	ETF	57.3	57.41	56.9	57.06	18548.0
2014-04-28	BALT	ETF	6.34	6.3996	5.89	6.05	1023376.0
2014-04-28	BBH	ETF	86.47	86.78	82.73	84.75	447200.0
2014-04-28	BCHP	ETF	19.98	19.98	19.82	19.86	2005.0
2014-04-28	BCM	ETF	41.509	41.509	41.4201	41.4201	696.0
2014-04-28	BFOR	ETF	7.435	7.4675	7.3175	7.405	224000.0
2014-04-28	BIB	ETF	36.075	36.795	33.34	35.205	1634428.0
2014-04-28	BICK	ETF	24.3	24.3	24.2972	24.2972	637.0
2014-04-28	BIL	ETF	91.54	91.56	91.54	91.54	81100.0
2014-04-28	BIS	ETF	757.2	811.56	737.2	771.6	30518.5
2014-04-28	BIV	ETF	83.64	83.78	83.5	83.62	233700.0
2014-04-28	BIZD	ETF	19.99	19.99	19.75	19.79	22400.0
2014-04-28	BJK	ETF	50.21	50.21	48.94	49.57	51100.0
2014-04-28	BKF	ETF	35.61	36.0	35.512	35.91	35085.0
2014-04-28	BKLN	ETF	24.67	24.7	24.65	24.7	1545700.0

> showing 50 of 1,089 rows — these rows as CSV

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