PREVIEW / etf_daily / 2010-05-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-20.parquet
  size:    33 KB
  rows:    761

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-05-20	SPY	ETF	109.38	109.89	107.47	107.54	530418300.0
2010-05-20	QQQ	ETF	45.17	45.28	44.25	44.35	189289774.0
2010-05-20	IWM	ETF	65.77	66.12	64.08	64.12	166841100.0
2010-05-20	DIA	ETF	102.97	103.25	101.0	101.11	28708100.0
2010-05-20	GLD	ETF	116.14	116.95	115.18	115.84	28908200.0
2010-05-20	TLT	ETF	97.91	98.57	97.53	98.33	17666900.0
2010-05-20	AAXJ	ETF	50.51	51.04	49.88	50.12	1158400.0
2010-05-20	ACWI	ETF	39.25	39.25	38.34	38.49	197800.0
2010-05-20	ACWX	ETF	35.73	36.09	35.2	35.47	171815.0
2010-05-20	ADRE	ETF	37.99	38.43	37.35	37.65	406713.0
2010-05-20	AFK	ETF	28.31	28.31	27.39	27.56	50452.0
2010-05-20	AGG	ETF	105.76	105.83	105.3	105.45	876900.0
2010-05-20	AGQ	ETF	115.34	118.8	113.0	115.72	332500.0
2010-05-20	AGZ	ETF	109.17	109.49	109.17	109.24	24993.0
2010-05-20	AIA	ETF	36.16	36.2564	35.68	35.8201	52805.0
2010-05-20	AIQ	ETF	27.9	28.15	25.95	26.05	18343.0
2010-05-20	AIS	ETF	1.55	1.62	1.5	1.53	846551.0
2010-05-20	AIVI	ETF	36.8	37.25	36.18	36.82	28900.0
2010-05-20	AMJ	ETF	28.25	28.29	27.55	27.94	1361259.0
2010-05-20	AOA	ETF	29.15	29.26	28.68	28.72	18800.0
2010-05-20	AOK	ETF	27.3615	27.49	26.97	27.3699	12094.0
2010-05-20	AOM	ETF	27.88	27.88	27.608	27.6655	4312.0
2010-05-20	AOR	ETF	28.38	28.48	28.11	28.11	23373.0
2010-05-20	ARB	ETF	31.46	31.46	29.48	29.5	415935.0
2010-05-20	BAB	ETF	26.2	26.32	26.1	26.222	320682.0
2010-05-20	BAL	ETF	38.84	39.144	38.5	38.81	7284.0
2010-05-20	BALT	ETF	12.34	12.58	11.65	11.66	297838.0
2010-05-20	BBH	ETF	30.8033	30.8033	29.7633	29.7633	264600.0
2010-05-20	BIB	ETF	6.0325	6.0325	5.715	5.7213	23200.0
2010-05-20	BICK	ETF	25.5	26.08	25.45	25.76	11352.0
2010-05-20	BIL	ETF	91.72	91.72	91.7	91.72	442650.0
2010-05-20	BIS	ETF	11971.2	12131.2	11929.6	11968.0	5.0
2010-05-20	BITS	ETF	29.64	29.64	28.04	29.52	4168.0
2010-05-20	BIV	ETF	82.21	82.42	82.02	82.3	210200.0
2010-05-20	BJK	ETF	23.35	23.53	22.86	22.97	25200.0
2010-05-20	BKF	ETF	38.87	39.41	38.24	38.79	413212.0
2010-05-20	BLV	ETF	81.22	81.22	80.36	80.5	70600.0
2010-05-20	BMVP	ETF	12.47	12.47	12.22	12.29	46402.0
2010-05-20	BND	ETF	80.65	80.7	80.4	80.59	801300.0
2010-05-20	BNE	ETF	11.07	11.08	10.99	11.0	967375.0
2010-05-20	BRF	ETF	38.22	39.02	36.86	38.108	871504.0
2010-05-20	BSV	ETF	80.69	80.69	80.48	80.48	563200.0
2010-05-20	BTF	ETF	66.25	66.25	64.0	64.3	14374.0
2010-05-20	BWX	ETF	26.41	26.76	26.01	26.625	452356.0
2010-05-20	BWZ	ETF	33.57	33.801	33.45	33.74	29469.0
2010-05-20	BZQ	ETF	5195.2	5396.8	4993.6	5219.2	3384.0
2010-05-20	CEF	ETF	14.35	14.62	14.31	14.36	2063600.0
2010-05-20	CEW	ETF	21.01	21.184	20.84	21.1	195502.0
2010-05-20	CGO	ETF	13.0	13.0	12.4001	12.75	55663.0
2010-05-20	CGW	ETF	16.72	16.72	16.25	16.31	94550.0

> showing 50 of 761 rows — these rows as CSV

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