PREVIEW / etf_daily / 2009-02-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-23.parquet
  size:    28 KB
  rows:    643

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-23	SPY	ETF	78.27	78.27	74.59	74.65	379641400.0
2009-02-23	QQQ	ETF	29.03	29.05	27.73	27.86	169469878.0
2009-02-23	IWM	ETF	41.38	41.45	39.47	39.56	78804200.0
2009-02-23	DIA	ETF	74.24	74.41	71.07	71.15	36003600.0
2009-02-23	GLD	ETF	96.59	98.22	95.89	97.73	24542700.0
2009-02-23	TLT	ETF	103.6	104.88	103.17	104.88	2688700.0
2009-02-23	AAXJ	ETF	29.71	29.71	28.32	28.62	451300.0
2009-02-23	ACWI	ETF	27.14	27.28	25.91	25.97	142900.0
2009-02-23	ACWX	ETF	24.89	24.92	23.77	23.84	88251.0
2009-02-23	ADRE	ETF	25.59	25.6	24.1406	24.35	253078.0
2009-02-23	AFK	ETF	18.7	18.7	18.0001	18.05	810.0
2009-02-23	AGG	ETF	101.65	101.65	100.9	101.5	621500.0
2009-02-23	AGQ	ETF	96.34	101.7	94.46	99.94	64700.0
2009-02-23	AGZ	ETF	107.48	107.81	107.25	107.77	7851.0
2009-02-23	AIA	ETF	22.82	22.82	21.84	21.933	10853.0
2009-02-23	AIQ	ETF	45.45	46.05	44.15	44.35	23415.0
2009-02-23	AIS	ETF	0.38	0.39	0.37	0.39	19700.0
2009-02-23	AIVI	ETF	27.03	27.06	25.9	25.9	24800.0
2009-02-23	AOA	ETF	20.65	20.65	20.64	20.64	400.0
2009-02-23	AOK	ETF	25.39	25.39	24.46	24.47	10352.0
2009-02-23	AOM	ETF	23.43	23.43	23.3094	23.31	11620.0
2009-02-23	AOR	ETF	22.2646	22.27	21.9868	22.02	1994.0
2009-02-23	ARB	ETF	13.22	13.5	12.79	12.85	411550.0
2009-02-23	BAL	ETF	25.23	25.24	25.23	25.24	200.0
2009-02-23	BBH	ETF	58.2	58.29	57.3333	57.4633	441900.0
2009-02-23	BIL	ETF	91.76	91.78	91.72	91.76	342350.0
2009-02-23	BITS	ETF	18.6	18.99	15.4	18.96	3688.0
2009-02-23	BIV	ETF	76.72	77.33	76.72	76.84	56100.0
2009-02-23	BKF	ETF	22.64	22.64	21.12	21.34	61351.0
2009-02-23	BLV	ETF	74.99	74.99	73.43	73.84	18600.0
2009-02-23	BMVP	ETF	9.74	9.77	9.31	9.31	73425.0
2009-02-23	BND	ETF	76.98	77.1	76.73	77.1	418400.0
2009-02-23	BNE	ETF	2.06	2.12	1.91	2.0	172356.0
2009-02-23	BSV	ETF	79.1	79.18	78.71	78.71	208100.0
2009-02-23	BTF	ETF	39.1	39.75	36.099999999999994	37.19949999999999	25113.800000000003
2009-02-23	BWX	ETF	25.0	25.015	24.8	24.9	223830.0
2009-02-23	BWZ	ETF	32.15	32.15	32.14	32.14	315.0
2009-02-23	CBON	ETF	1.1454	1.21	1.13	1.17	37025.0
2009-02-23	CDL	ETF	0.14	0.15	0.12	0.12	506049.0
2009-02-23	CEF	ETF	12.14	12.62	12.01	12.6	2238800.0
2009-02-23	CGO	ETF	8.84	8.84	8.2	8.21	31721.0
2009-02-23	CGW	ETF	12.03	12.26	11.53	11.68	90438.0
2009-02-23	CHB	ETF	0.32	0.37	0.29	0.3	415495.0
2009-02-23	CHI	ETF	7.9	8.16	7.52	7.57	255035.0
2009-02-23	CHIC	ETF	5.01	5.12	4.92	5.01	109648.0
2009-02-23	CHW	ETF	5.33	5.332	4.9	5.15	233804.0
2009-02-23	CHY	ETF	7.63	7.85	7.3622	7.5	661602.0
2009-02-23	CMF	ETF	50.875	51.745	50.755	51.423	35838.0
2009-02-23	CNXT	ETF	0.5	0.51	0.46	0.46	193791.0
2009-02-23	COW	ETF	30.31	30.58	30.26	30.37	101473.0

> showing 50 of 643 rows — these rows as CSV

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