PREVIEW / etf_daily / 2010-07-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-23.parquet
  size:    33 KB
  rows:    757

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-07-23	SPY	ETF	109.24	110.57	108.93	110.41	222020800.0
2010-07-23	QQQ	ETF	45.46	46.1	45.38	46.06	81056045.0
2010-07-23	IWM	ETF	63.11	65.11	62.94	64.98	73916800.0
2010-07-23	DIA	ETF	103.11	104.5	102.92	104.27	13384300.0
2010-07-23	GLD	ETF	117.12	117.47	115.79	116.09	8337000.0
2010-07-23	TLT	ETF	100.8	100.97	99.69	99.78	6259100.0
2010-07-23	AADR	ETF	25.54	25.54	25.08	25.28	8600.0
2010-07-23	AAXJ	ETF	55.48	56.08	55.29	55.94	580900.0
2010-07-23	ACWI	ETF	40.5	40.87	40.29	40.8	76900.0
2010-07-23	ACWX	ETF	38.28	38.69	38.2	38.66	52734.0
2010-07-23	ADRE	ETF	42.07	42.43	41.77	42.41	63263.0
2010-07-23	AFK	ETF	29.89	30.32	29.85	30.27	22032.0
2010-07-23	AGG	ETF	107.64	107.64	107.29	107.43	708800.0
2010-07-23	AGQ	ETF	118.62	119.34	116.98	117.38	62400.0
2010-07-23	AGZ	ETF	110.41	110.556	110.4	110.46	29554.0
2010-07-23	AIA	ETF	39.26	39.5499	39.02	39.481	30123.0
2010-07-23	AIQ	ETF	19.1	19.45	19.1	19.2	30241.0
2010-07-23	AIS	ETF	1.49	1.53	1.47	1.51	328668.0
2010-07-23	AIVI	ETF	39.66	40.24	39.66	40.1	12600.0
2010-07-23	AMJ	ETF	33.3	33.3	33.0354	33.26	594247.0
2010-07-23	AOA	ETF	29.75	30.04	29.75	30.03	8200.0
2010-07-23	AOK	ETF	27.73	27.81	27.688	27.81	6939.0
2010-07-23	AOM	ETF	28.24	28.36	28.185	28.316	13807.0
2010-07-23	AOR	ETF	28.8	28.9799	28.74	28.96	9126.0
2010-07-23	ARB	ETF	29.16	30.29	29.16	30.26	179380.0
2010-07-23	BAB	ETF	25.92	26.05	25.86	25.91	250577.0
2010-07-23	BAL	ETF	36.38	36.9199	36.34	36.9199	1250.0
2010-07-23	BALT	ETF	11.34	11.47	11.15	11.34	130458.0
2010-07-23	BBH	ETF	30.1933	30.4333	29.6233	30.2	707400.0
2010-07-23	BIB	ETF	5.3513	5.3513	5.2562	5.2562	7992.0
2010-07-23	BICK	ETF	28.78	28.9	28.61	28.9	4998.0
2010-07-23	BIL	ETF	91.72	91.72	91.7	91.72	73600.0
2010-07-23	BIS	ETF	11883.2	12403.2	11883.2	11940.8	56.0
2010-07-23	BITS	ETF	26.4	27.44	25.92	26.0	4700.0
2010-07-23	BIV	ETF	84.29	84.3	83.96	83.98	131700.0
2010-07-23	BJK	ETF	24.4	24.8	24.34	24.78	12600.0
2010-07-23	BKF	ETF	44.04	44.7	43.88	44.7	73799.0
2010-07-23	BLV	ETF	82.57	82.61	82.02	82.19	38500.0
2010-07-23	BMVP	ETF	12.3133	12.45	12.29	12.4489	12145.0
2010-07-23	BND	ETF	81.64	81.65	81.45	81.5	713500.0
2010-07-23	BNE	ETF	11.32	11.35	11.31	11.35	490509.0
2010-07-23	BNO	ETF	26.055	26.29	26.05	26.28	25600.0
2010-07-23	BRF	ETF	48.29	48.73	47.96	48.69	181688.0
2010-07-23	BSCE	ETF	20.66	20.6799	20.642	20.66	16640.0
2010-07-23	BSV	ETF	81.21	81.23	81.12	81.16	455700.0
2010-07-23	BTF	ETF	69.1	70.3	69.05	70.01899999999999	2836.2000000000003
2010-07-23	BWX	ETF	28.005	28.0925	27.795	27.94	210492.0
2010-07-23	BWZ	ETF	34.87	34.909	34.66	34.83	22808.0
2010-07-23	BZQ	ETF	3536.0	3571.2	3452.8	3457.6	944.5
2010-07-23	CEF	ETF	14.62	14.68	14.48	14.48	467800.0

> showing 50 of 757 rows — these rows as CSV

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