PREVIEW / etf_daily / 2009-02-25

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-25.parquet
  size:    28 KB
  rows:    637

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-25	SPY	ETF	77.14	78.42	75.63	76.87	461985800.0
2009-02-25	QQQ	ETF	28.62	29.17	28.14	28.59	220222983.0
2009-02-25	IWM	ETF	40.84	41.25	39.49	40.17	104493600.0
2009-02-25	DIA	ETF	73.03	74.05	71.56	72.67	43668900.0
2009-02-25	GLD	ETF	94.73	96.41	92.81	93.15	26142800.0
2009-02-25	TLT	ETF	105.24	105.49	103.03	103.56	3908100.0
2009-02-25	AAXJ	ETF	29.38	29.91	28.96	29.19	141000.0
2009-02-25	ACWI	ETF	26.74	27.01	26.17	26.47	147000.0
2009-02-25	ACWX	ETF	24.54	24.66	23.9	24.264	128140.0
2009-02-25	ADRE	ETF	24.93	25.43	24.46	24.97	201550.0
2009-02-25	AFK	ETF	18.56	18.56	18.56	18.56	100.0
2009-02-25	AGG	ETF	101.25	101.42	101.04	101.21	485800.0
2009-02-25	AGQ	ETF	91.38	94.76	87.62	88.16	123250.0
2009-02-25	AGZ	ETF	107.8	107.84	107.15	107.35	18973.0
2009-02-25	AIA	ETF	22.742	22.742	22.3	22.66	4019.0
2009-02-25	AIQ	ETF	46.85	48.95	45.35	45.55	64204.0
2009-02-25	AIS	ETF	0.38	0.39	0.3	0.39	216800.0
2009-02-25	AIVI	ETF	26.76	26.76	25.98	26.26	5800.0
2009-02-25	AOA	ETF	22.43	22.43	20.05	20.78	13900.0
2009-02-25	AOK	ETF	24.9	24.9	24.47	24.498	8887.0
2009-02-25	AOM	ETF	23.48	23.48	23.3232	23.36	913.0
2009-02-25	AOR	ETF	22.19	22.322	22.19	22.322	871.0
2009-02-25	ARB	ETF	13.46	13.63	12.54	12.84	315924.0
2009-02-25	BBH	ETF	57.9933	59.23	57.9933	58.5833	528900.0
2009-02-25	BIL	ETF	91.72	91.74	91.66	91.66	1315150.0
2009-02-25	BITS	ETF	18.8	18.8	16.96	17.28	500.0
2009-02-25	BIV	ETF	76.64	76.75	75.89	76.02	122700.0
2009-02-25	BJK	ETF	14.76	14.76	14.76	14.76	300.0
2009-02-25	BKF	ETF	23.8	23.8	21.35	21.93	44110.0
2009-02-25	BLV	ETF	74.11	74.11	73.24	73.28	28600.0
2009-02-25	BMVP	ETF	9.61	9.677	9.398	9.513	132645.0
2009-02-25	BND	ETF	76.91	76.95	76.55	76.65	553300.0
2009-02-25	BNE	ETF	2.04	2.04	1.74	1.81	307427.0
2009-02-25	BOSS	ETF	9.01	10.18	9.01	10.18	600.0
2009-02-25	BSV	ETF	78.57	78.96	78.19	78.56	330100.0
2009-02-25	BTF	ETF	38.15	39.3	37.75	38.699999999999996	7636.8
2009-02-25	BWX	ETF	24.85	24.85	24.6	24.705	267924.0
2009-02-25	BWZ	ETF	31.73	31.79	31.67	31.69	31706.0
2009-02-25	CBON	ETF	1.29	1.29	1.15	1.2	11100.0
2009-02-25	CDL	ETF	0.15	0.15	0.12	0.13	789473.0
2009-02-25	CEF	ETF	12.02	12.34	11.85	11.96	2578500.0
2009-02-25	CGO	ETF	8.69	8.75	8.15	8.65	22192.0
2009-02-25	CGW	ETF	11.95	12.0	11.6454	11.786	25317.0
2009-02-25	CHB	ETF	0.31	0.31	0.2803	0.29	284431.0
2009-02-25	CHI	ETF	8.16	8.4	8.05	8.19	221562.0
2009-02-25	CHIC	ETF	5.43	5.67	5.14	5.39	151610.0
2009-02-25	CHW	ETF	5.25	5.305	5.07	5.24	199073.0
2009-02-25	CHY	ETF	7.72	8.33	7.2	8.09	281507.0
2009-02-25	CMF	ETF	51.6325	51.6325	51.603	51.62	1362.0
2009-02-25	CNXT	ETF	0.46	0.47	0.45	0.46	143017.0

> showing 50 of 637 rows — these rows as CSV

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