PREVIEW / etf_daily / 2009-10-06

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-06.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-06	SPY	ETF	104.77	106.11	104.71	105.51	202491100.0
2009-10-06	QQQ	ETF	41.43	42.14	41.2206	41.94	124627964.0
2009-10-06	IWM	ETF	59.52	60.45	59.36	60.14	52211000.0
2009-10-06	DIA	ETF	96.58	97.77	96.56	97.29	12439600.0
2009-10-06	GLD	ETF	101.33	102.42	100.54	102.28	33537500.0
2009-10-06	TLT	ETF	98.76	98.8	97.98	98.04	3936200.0
2009-10-06	AAXJ	ETF	52.79	53.25	52.53	52.9	120400.0
2009-10-06	ACWI	ETF	40.54	40.94	40.41	40.68	838800.0
2009-10-06	ACWX	ETF	39.49	39.91	39.37	39.585	48106.0
2009-10-06	ADRE	ETF	41.59	42.119	41.33	41.72	143309.0
2009-10-06	AFK	ETF	28.94	29.3899	28.73	29.06	10015.0
2009-10-06	AGG	ETF	104.79	104.82	104.54	104.54	509000.0
2009-10-06	AGQ	ETF	120.98	125.0	120.7	123.84	387150.0
2009-10-06	AGZ	ETF	108.621	108.85	108.6	108.64	14071.0
2009-10-06	AIA	ETF	37.91	38.36	37.85	38.14	226868.0
2009-10-06	AIQ	ETF	29.75	30.6	29.2875	30.3	119115.0
2009-10-06	AIS	ETF	1.12	1.14	1.11	1.12	539836.0
2009-10-06	AIVI	ETF	41.99	42.41	41.93	42.15	15200.0
2009-10-06	AMJ	ETF	25.03	25.36	24.75	25.27	339236.0
2009-10-06	AOA	ETF	28.84	29.04	28.82	28.89	15100.0
2009-10-06	AOK	ETF	27.23	27.23	26.96	27.08	25963.0
2009-10-06	AOM	ETF	27.7	27.76	27.62	27.694	6764.0
2009-10-06	AOR	ETF	28.2	28.36	28.1999	28.24	30548.0
2009-10-06	ARB	ETF	21.49	22.0	21.26	21.64	259557.0
2009-10-06	BAL	ETF	32.55	33.0	32.55	33.0	4478.0
2009-10-06	BBH	ETF	33.0367	33.4767	32.7867	33.3133	234600.0
2009-10-06	BIL	ETF	91.74	91.74	91.7	91.7	227700.0
2009-10-06	BITS	ETF	21.28	21.52	20.874	21.48	435.0
2009-10-06	BIV	ETF	80.66	80.72	80.5	80.5	195100.0
2009-10-06	BJK	ETF	26.26	26.26	25.75	25.9	28200.0
2009-10-06	BKF	ETF	42.56	43.2	42.41	42.68	207820.0
2009-10-06	BLV	ETF	79.92	80.0	79.55	79.55	45600.0
2009-10-06	BMVP	ETF	11.8833	12.0041	11.8833	11.9753	31522.0
2009-10-06	BND	ETF	79.53	79.61	79.4	79.58	769800.0
2009-10-06	BNE	ETF	7.56	7.9	7.5	7.9	158008.0
2009-10-06	BOSS	ETF	20.49	20.72	20.14	20.49	300.0
2009-10-06	BRF	ETF	41.69	42.4268	41.53	41.91	1163786.0
2009-10-06	BSV	ETF	80.04	80.05	79.86	79.9	285700.0
2009-10-06	BTF	ETF	59.55	60.13499999999999	59.55	59.85	10439.0
2009-10-06	BWX	ETF	29.41	29.5	29.32	29.32	359050.0
2009-10-06	BWZ	ETF	37.5	37.5	37.3214	37.4299	26929.0
2009-10-06	BZQ	ETF	4926.4	5017.6	4800.0	4968.0	40.0
2009-10-06	CEF	ETF	13.27	13.68	13.27	13.62	1695300.0
2009-10-06	CEW	ETF	21.85	21.97	21.82	21.92	155680.0
2009-10-06	CGO	ETF	14.05	14.35	14.05	14.15	39037.0
2009-10-06	CGW	ETF	17.39	17.61	17.32	17.4599	80945.0
2009-10-06	CHB	ETF	0.398	0.44	0.398	0.42	1303176.0
2009-10-06	CHI	ETF	11.88	11.98	11.84	11.85	160148.0
2009-10-06	CHIC	ETF	17.5	17.51	17.49	17.51	122878.0
2009-10-06	CHW	ETF	7.65	7.82	7.65	7.79	248796.0

> showing 50 of 674 rows — these rows as CSV

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