PREVIEW / etf_daily / 2010-04-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-05.parquet
  size:    32 KB
  rows:    740

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-05	SPY	ETF	118.25	118.84	117.92	118.76	105847600.0
2010-04-05	QQQ	ETF	48.26	48.72	48.14	48.61	56220249.0
2010-04-05	IWM	ETF	68.61	69.76	68.44	69.71	52020600.0
2010-04-05	DIA	ETF	109.59	109.88	109.25	109.73	4237800.0
2010-04-05	GLD	ETF	110.56	110.98	110.27	110.89	8207900.0
2010-04-05	TLT	ETF	87.98	88.14	87.41	87.47	5652000.0
2010-04-05	AAXJ	ETF	58.49	58.81	58.27	58.8	107500.0
2010-04-05	ACWI	ETF	44.42	44.47	44.12	44.42	33600.0
2010-04-05	ACWX	ETF	42.57	42.77	42.42	42.6	95887.0
2010-04-05	ADRE	ETF	45.34	45.5	45.17	45.41	105277.0
2010-04-05	AFK	ETF	32.09	33.33	32.05	32.32	69040.0
2010-04-05	AGG	ETF	103.59	103.59	103.13	103.2	849300.0
2010-04-05	AGQ	ETF	122.24	124.42	121.58	123.92	145200.0
2010-04-05	AGZ	ETF	107.69	107.7	107.4	107.48	18919.0
2010-04-05	AIA	ETF	41.72	41.89	41.72	41.8	16771.0
2010-04-05	AIQ	ETF	27.85	28.1	27.7	27.8	16020.0
2010-04-05	AIS	ETF	1.6	2.0	1.56	1.6	2771309.0
2010-04-05	AIVI	ETF	43.33	43.6	43.26	43.39	11300.0
2010-04-05	AMJ	ETF	30.99	31.19	30.76	31.18	396934.0
2010-04-05	AOA	ETF	31.93	32.08	31.83	32.02	19500.0
2010-04-05	AOK	ETF	27.86	27.87	27.802	27.85	17674.0
2010-04-05	AOM	ETF	28.85	28.88	28.792	28.8799	3108.0
2010-04-05	AOR	ETF	29.9	30.04	29.84	30.0099	10525.0
2010-04-05	ARB	ETF	26.24	28.16	26.24	28.02	411116.0
2010-04-05	BAB	ETF	24.95	24.95	24.65	24.7	378883.0
2010-04-05	BAL	ETF	39.32	39.75	39.32	39.75	2600.0
2010-04-05	BALT	ETF	13.87	14.0	13.67	14.0	681656.0
2010-04-05	BBH	ETF	34.81	34.9433	34.6133	34.73	48300.0
2010-04-05	BIL	ETF	91.7	91.72	91.68	91.68	464050.0
2010-04-05	BITS	ETF	31.88	32.16	31.68	31.68	900.0
2010-04-05	BIV	ETF	79.53	79.6	79.1	79.34	273400.0
2010-04-05	BJK	ETF	26.21	26.7	26.21	26.7	16300.0
2010-04-05	BKF	ETF	47.95	48.21	47.73	48.15	212565.0
2010-04-05	BLV	ETF	76.03	76.03	75.37	75.51	40500.0
2010-04-05	BMVP	ETF	13.33	13.42	13.31	13.42	15830.0
2010-04-05	BND	ETF	78.68	78.69	78.4	78.47	817000.0
2010-04-05	BNE	ETF	11.13	11.2	11.09	11.12	1153791.0
2010-04-05	BRF	ETF	46.78	46.94	46.1	46.25	603864.0
2010-04-05	BSV	ETF	79.63	79.67	79.45	79.47	1683000.0
2010-04-05	BTF	ETF	74.55	75.35	74.55	74.85	6984.6
2010-04-05	BWX	ETF	27.98	27.98	27.785	27.845	492388.0
2010-04-05	BWZ	ETF	35.74	36.47	35.46	35.56	24074.0
2010-04-05	BZQ	ETF	3366.4	3430.4	3344.0	3408.0	354.0
2010-04-05	CEF	ETF	14.31	14.39	14.23	14.36	839800.0
2010-04-05	CEW	ETF	22.35	22.4	22.34	22.4	242802.0
2010-04-05	CGO	ETF	15.08	15.18	14.96	15.08	37971.0
2010-04-05	CGW	ETF	18.8	18.94	18.77	18.881	80972.0
2010-04-05	CHI	ETF	12.79	12.88	12.78	12.85	192923.0
2010-04-05	CHIE	ETF	15.01	15.12	15.0	15.1	7950.0
2010-04-05	CHII	ETF	15.76	15.95	15.76	15.9	5609.0

> showing 50 of 740 rows — these rows as CSV

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