PREVIEW / etf_daily / 2010-04-30

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-30.parquet
  size:    33 KB
  rows:    753

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
2010-04-30	SPY	ETF	120.88	121.01	118.78	118.81	270000900.0
2010-04-30	QQQ	ETF	50.21	50.29	49.2	49.2375	110896907.0
2010-04-30	IWM	ETF	73.8	73.93	71.57	71.65	88759100.0
2010-04-30	DIA	ETF	111.81	112.0	110.04	110.1	14615900.0
2010-04-30	GLD	ETF	115.26	115.7	115.21	115.36	13403100.0
2010-04-30	TLT	ETF	91.28	92.17	91.11	92.13	6924800.0
2010-04-30	AAXJ	ETF	57.94	57.94	56.87	56.95	555100.0
2010-04-30	ACWI	ETF	44.31	44.31	43.41	43.41	135400.0
2010-04-30	ACWX	ETF	41.48	41.48	40.68	40.74	1695231.0
2010-04-30	ADRE	ETF	44.53	44.58	43.9612	44.014	164746.0
2010-04-30	AFK	ETF	31.99	31.99	31.63	31.7499	14770.0
2010-04-30	AGG	ETF	104.49	104.95	104.49	104.89	920200.0
2010-04-30	AGQ	ETF	131.3	131.88	129.44	129.9	161850.0
2010-04-30	AGZ	ETF	108.22	108.4644	108.22	108.45	9207.0
2010-04-30	AIA	ETF	41.42	41.52	40.63	40.63	70475.0
2010-04-30	AIQ	ETF	27.5	27.8	26.8	26.8	18654.0
2010-04-30	AIS	ETF	1.58	1.58	1.54	1.56	271087.0
2010-04-30	AIVI	ETF	42.39	42.43	41.74	41.79	8100.0
2010-04-30	AMJ	ETF	31.65	31.65	31.11	31.29	331497.0
2010-04-30	AOA	ETF	32.45	32.45	31.99	32.05	3600.0
2010-04-30	AOK	ETF	28.01	28.1854	28.01	28.09	1217.0
2010-04-30	AOM	ETF	29.04	29.085	28.912	28.912	19841.0
2010-04-30	AOR	ETF	30.4	30.4	30.0605	30.0605	6113.0
2010-04-30	ARB	ETF	32.02	32.03	30.79	30.81	189981.0
2010-04-30	BAB	ETF	25.53	25.69	25.44	25.67	108197.0
2010-04-30	BAL	ETF	39.62	39.92	39.55	39.7401	9605.0
2010-04-30	BALT	ETF	14.07	14.11	13.78	13.92	287916.0
2010-04-30	BBH	ETF	33.07	33.1667	32.3867	32.3867	93300.0
2010-04-30	BIB	ETF	7.5675	7.5675	7.3775	7.3788	7200.0
2010-04-30	BICK	ETF	30.1	30.18	29.75	29.75	11557.0
2010-04-30	BIL	ETF	91.68	91.7	91.68	91.68	191450.0
2010-04-30	BIS	ETF	9412.8	9652.8	9412.8	9652.784	21.9
2010-04-30	BITS	ETF	31.7596	31.8	31.44	31.8	250.0
2010-04-30	BIV	ETF	80.99	81.2	80.9	81.15	71600.0
2010-04-30	BJK	ETF	27.39	27.56	26.93	26.94	9400.0
2010-04-30	BKF	ETF	46.55	46.55	45.56	45.56	130290.0
2010-04-30	BLV	ETF	78.16	78.81	78.1	78.79	15900.0
2010-04-30	BMVP	ETF	13.77	13.77	13.46	13.46	12187.0
2010-04-30	BND	ETF	79.68	79.85	79.6	79.8	516100.0
2010-04-30	BNE	ETF	11.24	11.28	11.17	11.18	509023.0
2010-04-30	BRF	ETF	46.57	46.74	46.16	46.42	452087.0
2010-04-30	BSV	ETF	80.19	80.24	80.12	80.2	303600.0
2010-04-30	BTF	ETF	74.1	74.35	73.94999999999999	74.0	3725.4
2010-04-30	BWX	ETF	27.455	27.5891	27.405	27.575	347414.0
2010-04-30	BWZ	ETF	35.1501	35.25	35.045	35.1301	17004.0
2010-04-30	BZQ	ETF	3580.8	3667.2	3563.2	3654.4	761.0
2010-04-30	CEF	ETF	14.93	15.06	14.88	15.04	1446700.0
2010-04-30	CEW	ETF	22.39	22.43	22.34	22.34	138918.0
2010-04-30	CGO	ETF	14.82	14.94	14.66	14.67	30841.0
2010-04-30	CGW	ETF	18.84	18.84	18.43	18.43	35538.0

> showing 50 of 753 rows — these rows as CSV

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