PREVIEW / etf_daily / 2010-04-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-20.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-20	SPY	ETF	120.56	120.98	119.87	120.88	157708000.0
2010-04-20	QQQ	ETF	49.755	49.88	49.43	49.75	69543632.0
2010-04-20	IWM	ETF	71.49	72.13	71.18	72.08	50736600.0
2010-04-20	DIA	ETF	111.22	111.43	110.78	111.1	8901000.0
2010-04-20	GLD	ETF	111.73	112.21	111.33	111.46	7019800.0
2010-04-20	TLT	ETF	89.85	89.99	89.64	89.96	2285000.0
2010-04-20	AAXJ	ETF	58.04	58.07	57.63	58.07	131300.0
2010-04-20	ACWI	ETF	44.67	44.79	44.56	44.76	461900.0
2010-04-20	ACWX	ETF	42.39	42.58	42.323	42.51	104090.0
2010-04-20	ADRE	ETF	44.63	44.9108	44.63	44.7401	87551.0
2010-04-20	AFK	ETF	32.39	32.5	32.01	32.475	25808.0
2010-04-20	AGG	ETF	104.23	104.4	104.2	104.4	652200.0
2010-04-20	AGQ	ETF	120.92	122.32	119.4	119.46	202200.0
2010-04-20	AGZ	ETF	108.26	108.26	108.04	108.09	29860.0
2010-04-20	AIA	ETF	41.32	41.44	41.21	41.43	42967.0
2010-04-20	AIQ	ETF	28.95	29.1995	28.8	29.05	12876.0
2010-04-20	AIS	ETF	1.56	1.59	1.55	1.57	232780.0
2010-04-20	AIVI	ETF	43.97	44.08	43.84	43.91	27200.0
2010-04-20	AMJ	ETF	31.31	31.56	31.3	31.52	508424.0
2010-04-20	AOA	ETF	32.37	32.46	32.27	32.46	11400.0
2010-04-20	AOK	ETF	28.13	28.13	28.07	28.11	11905.0
2010-04-20	AOM	ETF	29.11	29.11	29.0435	29.1	6071.0
2010-04-20	AOR	ETF	30.34	30.38	30.2599	30.38	20030.0
2010-04-20	ARB	ETF	27.26	28.17	27.26	28.06	319495.0
2010-04-20	BAB	ETF	25.14	25.16	25.0836	25.16	256267.0
2010-04-20	BAL	ETF	39.42	40.11	39.42	40.1	8975.0
2010-04-20	BALT	ETF	13.75	13.94	13.75	13.93	496657.0
2010-04-20	BBH	ETF	34.5467	34.58	34.1267	34.2367	84000.0
2010-04-20	BIB	ETF	7.5637	7.5637	7.4437	7.52	23328.0
2010-04-20	BICK	ETF	29.68	32.07	29.57	29.82	36322.0
2010-04-20	BIL	ETF	91.68	91.7	91.68	91.68	69150.0
2010-04-20	BIS	ETF	9587.2	9652.8	9569.6	9569.6	8.1
2010-04-20	BITS	ETF	31.4404	32.2	31.0	31.4	1562.0
2010-04-20	BIV	ETF	80.46	80.46	80.29	80.42	60500.0
2010-04-20	BJK	ETF	26.68	27.02	26.64	26.92	6500.0
2010-04-20	BKF	ETF	47.03	47.1	46.63	46.96	154969.0
2010-04-20	BLV	ETF	77.5	77.5	77.27	77.39	18200.0
2010-04-20	BMVP	ETF	13.6	13.69	13.6	13.68	16136.0
2010-04-20	BND	ETF	79.38	79.39	79.28	79.39	391100.0
2010-04-20	BNE	ETF	11.15	11.19	11.15	11.19	410831.0
2010-04-20	BRF	ETF	46.42	46.56	46.0	46.36	377548.0
2010-04-20	BSV	ETF	80.03	80.04	79.98	80.03	615600.0
2010-04-20	BTF	ETF	74.1	74.8995	74.1	74.74999999999999	4626.8
2010-04-20	BWX	ETF	27.915	27.94	27.815	27.94	415090.0
2010-04-20	BWZ	ETF	36.14	36.14	35.565	35.6	13629.0
2010-04-20	BZQ	ETF	3520.0	3566.4	3488.0	3563.2	271.0
2010-04-20	CEF	ETF	14.45	14.5	14.31	14.36	690600.0
2010-04-20	CEW	ETF	22.35	22.37	22.31	22.35	165984.0
2010-04-20	CGO	ETF	14.9	15.12	14.85	15.07	79609.0
2010-04-20	CGW	ETF	18.7	18.85	18.7	18.76	39193.0

> showing 50 of 753 rows — these rows as CSV

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