PREVIEW / etf_daily / 2010-06-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-28.parquet
  size:    33 KB
  rows:    754

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-06-28	SPY	ETF	108.03	108.32	107.14	107.53	169218600.0
2010-06-28	QQQ	ETF	45.29	45.55	44.81	45.11	71378707.0
2010-06-28	IWM	ETF	64.59	65.24	63.91	64.26	64643900.0
2010-06-28	DIA	ETF	101.69	102.05	101.04	101.44	6770700.0
2010-06-28	GLD	ETF	122.79	123.56	120.81	121.09	19650700.0
2010-06-28	TLT	ETF	99.6	100.0	99.42	99.98	5436000.0
2010-06-28	AAXJ	ETF	54.57	54.57	54.05	54.29	403200.0
2010-06-28	ACWI	ETF	39.63	39.65	39.18	39.21	101600.0
2010-06-28	ACWX	ETF	36.98	37.16	36.67	36.7599	174792.0
2010-06-28	ADRE	ETF	41.59	41.59	41.07	41.15	54877.0
2010-06-28	AFK	ETF	28.95	29.055	28.54	28.702	3464.0
2010-06-28	AGG	ETF	106.97	107.0	106.81	106.92	529600.0
2010-06-28	AGQ	ETF	132.5	134.16	125.9	127.64	251450.0
2010-06-28	AGZ	ETF	110.08	110.17	109.99	110.17	32881.0
2010-06-28	AIA	ETF	38.55	38.55	38.28	38.33	13337.0
2010-06-28	AIQ	ETF	22.5	22.5	21.55	21.7	17087.0
2010-06-28	AIS	ETF	1.91	1.91	1.855	1.89	605545.0
2010-06-28	AIVI	ETF	37.46	37.8	37.27	37.32	48800.0
2010-06-28	AMJ	ETF	31.0	31.27	30.92	31.19	952807.0
2010-06-28	AOA	ETF	29.22	29.24	29.11	29.24	1100.0
2010-06-28	AOK	ETF	27.62	27.6599	27.62	27.647	10684.0
2010-06-28	AOM	ETF	27.9799	27.9799	27.88	27.886	3303.0
2010-06-28	AOR	ETF	28.4	28.5036	28.3201	28.433	3349.0
2010-06-28	ARB	ETF	26.96	27.96	26.73	27.45	130123.0
2010-06-28	BAB	ETF	26.15	26.15	25.92	26.02	170708.0
2010-06-28	BAL	ETF	38.5	38.5	38.05	38.25	10268.0
2010-06-28	BALT	ETF	11.71	11.84	11.315	11.7	118934.0
2010-06-28	BBH	ETF	30.7367	30.82	30.2967	30.4867	115200.0
2010-06-28	BIB	ETF	5.7237	5.7912	5.7237	5.76	7200.0
2010-06-28	BICK	ETF	28.0768	28.36	28.02	28.02	773.0
2010-06-28	BIL	ETF	91.7	91.72	91.7	91.72	198800.0
2010-06-28	BITS	ETF	27.6	27.8	27.166	27.4396	795.0
2010-06-28	BIV	ETF	83.03	83.41	83.03	83.4	183600.0
2010-06-28	BJK	ETF	24.35	24.56	24.16	24.19	99800.0
2010-06-28	BKF	ETF	43.36	43.47	43.0	43.01	103765.0
2010-06-28	BLV	ETF	81.5	81.77	81.29	81.73	27400.0
2010-06-28	BMVP	ETF	12.11	12.27	12.11	12.2	20435.0
2010-06-28	BND	ETF	81.11	81.23	81.06	81.17	1230200.0
2010-06-28	BNE	ETF	11.23	11.25	11.22	11.22	275506.0
2010-06-28	BNO	ETF	26.305	26.305	26.25	26.305	20800.0
2010-06-28	BRF	ETF	45.87	45.95	45.341	45.77	181565.0
2010-06-28	BSCE	ETF	20.3499	20.39	20.3499	20.39	11555.0
2010-06-28	BSV	ETF	80.83	80.94	80.83	80.89	452600.0
2010-06-28	BTF	ETF	68.7575	69.45	68.2	69.14999999999999	7780.0
2010-06-28	BWX	ETF	26.935	27.245	26.82	26.85	372170.0
2010-06-28	BWZ	ETF	33.65	33.88	33.61	33.68	2874.0
2010-06-28	BZQ	ETF	3820.8	3931.2	3820.8	3923.2	621.0
2010-06-28	CEF	ETF	15.31	15.38	15.0	15.13	1220800.0
2010-06-28	CEW	ETF	21.51	21.51	21.441	21.46	136613.0
2010-06-28	CGO	ETF	13.25	13.25	13.15	13.22	13231.0

> showing 50 of 754 rows — these rows as CSV

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