PREVIEW / etf_daily / 2009-10-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-20.parquet
  size:    29 KB
  rows:    672

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
2009-10-20	SPY	ETF	109.95	109.99	108.68	109.21	180921100.0
2009-10-20	QQQ	ETF	43.45	43.46	42.94	43.22	89847824.0
2009-10-20	IWM	ETF	62.24	62.32	60.99	61.33	43952800.0
2009-10-20	DIA	ETF	100.97	101.01	99.9	100.39	9387400.0
2009-10-20	GLD	ETF	104.34	104.35	102.79	103.42	18250000.0
2009-10-20	TLT	ETF	97.02	97.25	96.54	96.72	2912400.0
2009-10-20	AAXJ	ETF	55.22	55.22	54.56	55.0	479400.0
2009-10-20	ACWI	ETF	42.61	42.61	41.97	42.22	80000.0
2009-10-20	ACWX	ETF	41.81	41.81	41.157	41.41	101424.0
2009-10-20	ADRE	ETF	44.0	44.04	42.94	43.52	321204.0
2009-10-20	AFK	ETF	30.5701	30.72	30.52	30.64	6704.0
2009-10-20	AGG	ETF	104.56	104.7	104.51	104.7	473300.0
2009-10-20	AGQ	ETF	129.52	129.54	124.22	125.44	225000.0
2009-10-20	AGZ	ETF	108.4	108.6	108.4	108.6	10720.0
2009-10-20	AIA	ETF	39.9	39.97	39.24	39.52	18090.0
2009-10-20	AIQ	ETF	31.65	31.9	30.65	30.7	41832.0
2009-10-20	AIS	ETF	1.28	1.28	1.21	1.25	828301.0
2009-10-20	AIVI	ETF	44.41	44.41	43.62	43.84	32100.0
2009-10-20	AMJ	ETF	26.49	26.52	26.37	26.47	307095.0
2009-10-20	AOA	ETF	29.95	30.0	29.69	29.74	5900.0
2009-10-20	AOK	ETF	27.34	27.79	27.33	27.34	4035.0
2009-10-20	AOM	ETF	28.24	28.24	28.09	28.12	10342.0
2009-10-20	AOR	ETF	28.99	29.03	28.846	28.87	11491.0
2009-10-20	ARB	ETF	23.45	23.45	22.49	22.85	847248.0
2009-10-20	BAL	ETF	37.56	37.56	34.47	35.05	18123.0
2009-10-20	BBH	ETF	33.9667	33.9667	33.04	33.0767	274500.0
2009-10-20	BIL	ETF	91.7	91.72	91.7	91.7	132850.0
2009-10-20	BITS	ETF	25.44	25.44	25.2044	25.4	694.0
2009-10-20	BIV	ETF	80.43	80.49	80.25	80.47	155600.0
2009-10-20	BJK	ETF	26.72	26.72	26.06	26.2	20700.0
2009-10-20	BKF	ETF	46.0	46.29	44.931	45.65	316927.0
2009-10-20	BLV	ETF	78.93	79.27	78.93	79.1	25300.0
2009-10-20	BMVP	ETF	12.5	12.5	12.35	12.397	43807.0
2009-10-20	BND	ETF	79.3	79.34	79.2	79.32	533100.0
2009-10-20	BNE	ETF	7.8	8.16	7.4	7.84	161451.0
2009-10-20	BOSS	ETF	22.01	22.31	22.01	22.01	100.0
2009-10-20	BRF	ETF	44.54	45.113	42.82	44.43	1438312.0
2009-10-20	BSV	ETF	79.99	80.0	79.81	80.0	577300.0
2009-10-20	BTF	ETF	63.05	63.05	61.349999999999994	61.8	3826.4
2009-10-20	BWX	ETF	29.67	29.67	29.5	29.565	398408.0
2009-10-20	BWZ	ETF	37.74	37.74	37.5504	37.64	78371.0
2009-10-20	BZQ	ETF	4368.0	4672.0	4356.8	4435.2	476.0
2009-10-20	CEF	ETF	13.86	13.97	13.58	13.65	853100.0
2009-10-20	CEW	ETF	22.2	22.77	22.0	22.05	162422.0
2009-10-20	CGO	ETF	14.34	14.47	14.2	14.22	28441.0
2009-10-20	CGW	ETF	18.14	18.19	17.8	17.922	190853.0
2009-10-20	CHB	ETF	0.34	0.47	0.32	0.39	12985682.0
2009-10-20	CHI	ETF	11.86	12.0165	11.85	11.94	160606.0
2009-10-20	CHW	ETF	8.0	8.035	7.89	7.98	151937.0
2009-10-20	CHY	ETF	11.57	11.68	11.57	11.6	128308.0

> showing 50 of 672 rows — these rows as CSV

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