PREVIEW / etf_daily / 2009-10-22

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-22.parquet
  size:    30 KB
  rows:    674

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-22	SPY	ETF	108.19	109.68	107.5	109.33	238444000.0
2009-10-22	QQQ	ETF	43.07	43.49	42.79	43.31	85871768.0
2009-10-22	IWM	ETF	60.48	61.61	59.77	61.34	58421000.0
2009-10-22	DIA	ETF	99.62	101.09	99.2	100.74	13423200.0
2009-10-22	GLD	ETF	103.46	104.09	103.1	103.92	11575600.0
2009-10-22	TLT	ETF	95.38	95.83	95.33	95.67	2572200.0
2009-10-22	AAXJ	ETF	54.38	54.73	53.75	54.64	562700.0
2009-10-22	ACWI	ETF	42.04	42.55	41.74	42.46	37500.0
2009-10-22	ACWX	ETF	41.27	41.77	40.93	41.72	150372.0
2009-10-22	ADRE	ETF	43.45	43.8722	43.01	43.74	195795.0
2009-10-22	AFK	ETF	30.45	30.6	30.13	30.54	20285.0
2009-10-22	AGG	ETF	104.4	104.54	104.3	104.47	518700.0
2009-10-22	AGQ	ETF	124.96	127.66	123.22	126.98	157100.0
2009-10-22	AGZ	ETF	108.5	108.62	108.4101	108.546	10399.0
2009-10-22	AIA	ETF	38.91	39.23	38.56	39.18	36685.0
2009-10-22	AIQ	ETF	30.35	31.0	29.724	30.7	24055.0
2009-10-22	AIS	ETF	1.2	1.2	1.12	1.18	827586.0
2009-10-22	AIVI	ETF	43.87	44.4	43.62	44.35	13400.0
2009-10-22	AMJ	ETF	26.58	26.68	26.25	26.55	300084.0
2009-10-22	AOA	ETF	29.87	29.87	29.43	29.79	8100.0
2009-10-22	AOK	ETF	27.2045	27.33	27.15	27.33	5820.0
2009-10-22	AOM	ETF	28.05	28.16	27.942	28.12	33174.0
2009-10-22	AOR	ETF	28.99	28.99	28.67	28.95	13601.0
2009-10-22	ARB	ETF	23.0	23.69	22.78	23.51	325799.0
2009-10-22	BAL	ETF	35.15	36.365	34.98	35.1601	2517.0
2009-10-22	BBH	ETF	32.18	32.5133	32.04	32.31	337800.0
2009-10-22	BIL	ETF	91.7	91.72	91.7	91.7	135300.0
2009-10-22	BITS	ETF	25.2	25.52	24.6	25.44	1675.0
2009-10-22	BIV	ETF	80.05	80.19	79.87	80.16	92600.0
2009-10-22	BJK	ETF	26.41	26.59	25.79	26.59	9500.0
2009-10-22	BKF	ETF	45.77	46.27	45.17	46.03	165090.0
2009-10-22	BLV	ETF	78.41	78.53	78.12	78.33	21200.0
2009-10-22	BMVP	ETF	12.25	12.4	12.24	12.38	33161.0
2009-10-22	BND	ETF	79.16	79.31	79.11	79.24	349200.0
2009-10-22	BNE	ETF	7.74	7.99	7.45	7.87	136686.0
2009-10-22	BRF	ETF	45.2	45.68	44.58	45.64	385493.0
2009-10-22	BSV	ETF	79.96	79.96	79.81	79.95	480300.0
2009-10-22	BTF	ETF	62.55	62.75	62.24999999999999	62.5	4320.0
2009-10-22	BWX	ETF	29.55	29.6	29.435	29.6	325480.0
2009-10-22	BWZ	ETF	37.65	37.7	37.5203	37.68	37870.0
2009-10-22	BZQ	ETF	4291.2	4393.6	4198.4	4225.6	96.0
2009-10-22	CEF	ETF	13.71	13.87	13.68	13.86	712900.0
2009-10-22	CEW	ETF	22.06	22.14	22.0	22.13	86133.0
2009-10-22	CGO	ETF	14.24	14.32	14.14	14.32	30087.0
2009-10-22	CGW	ETF	17.82	18.13	17.82	18.1199	62209.0
2009-10-22	CHB	ETF	0.37	0.37	0.35	0.35	1305655.0
2009-10-22	CHI	ETF	11.93	12.04	11.89	12.0	133718.0
2009-10-22	CHW	ETF	7.92	8.0024	7.84	7.94	180068.0
2009-10-22	CHY	ETF	11.74	11.88	11.72	11.74	192644.0
2009-10-22	CMF	ETF	53.55	53.55	53.0325	53.4	17222.0

> showing 50 of 674 rows — these rows as CSV

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