PREVIEW / etf_daily / 2009-02-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-17.parquet
  size:    28 KB
  rows:    635

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-02-17	SPY	ETF	80.16	82.96	79.17	79.22	478910100.0
2009-02-17	QQQ	ETF	29.47	29.67	29.06	29.22	157782517.0
2009-02-17	IWM	ETF	43.0	43.62	42.83	42.9	81542900.0
2009-02-17	DIA	ETF	76.6	77.06	75.72	75.75	36731400.0
2009-02-17	GLD	ETF	95.23	95.85	94.89	95.45	27085200.0
2009-02-17	TLT	ETF	104.55	105.66	104.35	105.6	2813900.0
2009-02-17	AAXJ	ETF	30.82	30.82	29.15	29.24	35800.0
2009-02-17	ACWI	ETF	28.13	28.13	27.47	27.6	134000.0
2009-02-17	ACWX	ETF	25.87	25.95	25.28	25.28	96359.0
2009-02-17	ADRE	ETF	26.32	26.36	25.78	25.81	340518.0
2009-02-17	AFK	ETF	18.55	18.55	17.63	18.434	740.0
2009-02-17	AGG	ETF	102.15	102.26	101.64	101.87	436100.0
2009-02-17	AGQ	ETF	94.02	96.16	93.1	94.72	93300.0
2009-02-17	AGZ	ETF	108.1	108.34	107.665	108.34	9994.0
2009-02-17	AIA	ETF	22.97	23.04	22.5801	22.73	29038.0
2009-02-17	AIQ	ETF	46.35	47.4	46.25	46.65	20449.0
2009-02-17	AIS	ETF	0.41	0.41	0.395	0.41	76278.0
2009-02-17	AIVI	ETF	27.98	27.98	27.01	27.1	32400.0
2009-02-17	AOA	ETF	21.65	21.74	21.36	21.5	58100.0
2009-02-17	AOK	ETF	24.05	24.91	24.05	24.74	2233.0
2009-02-17	AOM	ETF	23.9	23.94	23.75	23.75	4514.0
2009-02-17	AOR	ETF	22.57	23.05	22.57	22.72	4750.0
2009-02-17	ARB	ETF	13.12	13.42	12.34	13.2	291872.0
2009-02-17	BAL	ETF	25.485	25.8	25.38	25.8	1000.0
2009-02-17	BBH	ETF	57.4167	58.2333	56.7433	57.4633	529200.0
2009-02-17	BIL	ETF	91.76	91.78	91.72	91.76	2976300.0
2009-02-17	BITS	ETF	19.12	19.4328	18.8	18.84	612.0
2009-02-17	BIV	ETF	78.11	78.2	77.8	78.09	66300.0
2009-02-17	BJK	ETF	14.95	14.95	14.8	14.8	200.0
2009-02-17	BKF	ETF	23.72	23.72	22.56	22.6896	29487.0
2009-02-17	BLV	ETF	75.12	75.5	74.05	74.48	106900.0
2009-02-17	BMVP	ETF	9.99	10.05	9.89	9.9	58098.0
2009-02-17	BND	ETF	77.18	77.56	77.17	77.46	303100.0
2009-02-17	BNE	ETF	2.8	2.81	2.63	2.72	155706.0
2009-02-17	BSV	ETF	79.23	79.43	78.8	79.23	226800.0
2009-02-17	BTF	ETF	45.449999999999996	45.849999999999994	44.0	44.0	22317.4
2009-02-17	BWX	ETF	24.805	24.915	24.735	24.78	406746.0
2009-02-17	BWZ	ETF	31.82	32.0	31.8	31.82	1558.0
2009-02-17	CBON	ETF	1.85	1.85	1.52	1.57	39250.0
2009-02-17	CDL	ETF	0.15	0.16	0.11	0.11	1197798.0
2009-02-17	CEF	ETF	12.19	12.43	12.06	12.12	2208300.0
2009-02-17	CGO	ETF	10.07	10.07	9.42	9.48	34767.0
2009-02-17	CGW	ETF	12.9	12.9	12.5	12.6	100582.0
2009-02-17	CHB	ETF	0.45	0.45	0.28	0.33	415700.0
2009-02-17	CHI	ETF	8.5	8.51	8.05	8.32	363122.0
2009-02-17	CHIC	ETF	5.09	5.12	4.94	4.98	160318.0
2009-02-17	CHW	ETF	6.27	6.29	5.97	6.06	400182.0
2009-02-17	CHY	ETF	8.51	8.51	8.01	8.19	576098.0
2009-02-17	CMF	ETF	51.865	52.057	51.65	51.95	7948.0
2009-02-17	CNXT	ETF	0.64	0.659	0.6002	0.602	222416.0

> showing 50 of 635 rows — these rows as CSV

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