PREVIEW / etf_daily / 2009-02-02

all etf daily files

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

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-02	SPY	ETF	81.57	83.18	81.31	82.58	288233300.0
2009-02-02	QQQ	ETF	28.77	29.61	28.74	29.41	126883395.0
2009-02-02	IWM	ETF	43.66	45.14	43.64	44.84	62907300.0
2009-02-02	DIA	ETF	79.14	79.92	78.65	79.32	22968000.0
2009-02-02	GLD	ETF	89.88	92.58	88.62	88.84	16983300.0
2009-02-02	TLT	ETF	104.02	105.68	103.39	105.39	2700200.0
2009-02-02	AAXJ	ETF	30.96	31.21	30.19	30.38	45100.0
2009-02-02	ACWI	ETF	28.45	28.8	28.25	28.69	62800.0
2009-02-02	ACWX	ETF	26.22	26.5	26.06	26.432	167519.0
2009-02-02	ADRE	ETF	25.25	25.85	25.19	25.59	431104.0
2009-02-02	AFK	ETF	17.0501	17.48	17.0501	17.48	300.0
2009-02-02	AGG	ETF	101.72	102.16	101.57	101.59	592000.0
2009-02-02	AGQ	ETF	74.24	76.02	73.64	73.78	32200.0
2009-02-02	AGZ	ETF	107.45	107.87	107.415	107.87	70793.0
2009-02-02	AIA	ETF	23.2	23.29	22.9252	23.14	1503.0
2009-02-02	AIQ	ETF	43.65	46.3	43.35	46.15	43019.0
2009-02-02	AIS	ETF	0.46	0.48	0.46	0.48	3416.0
2009-02-02	AIVI	ETF	27.78	29.0	27.78	28.23	7300.0
2009-02-02	AOA	ETF	22.0	22.01	21.61	22.0	5100.0
2009-02-02	AOK	ETF	24.8	25.15	24.8	25.04	6551.0
2009-02-02	AOM	ETF	25.27	25.27	23.43	23.99	26022.0
2009-02-02	AOR	ETF	23.25	23.3	23.2	23.2	1408.0
2009-02-02	ARB	ETF	14.79	14.79	13.65	14.0	645014.0
2009-02-02	BAL	ETF	28.6	29.34	28.48	29.17	3800.0
2009-02-02	BBH	ETF	56.32	57.41	56.32	57.34	192300.0
2009-02-02	BIL	ETF	91.74	91.82	91.66	91.8	513900.0
2009-02-02	BITS	ETF	19.5996	19.6	19.4	19.6	900.0
2009-02-02	BIV	ETF	77.41	77.42	77.0	77.37	82600.0
2009-02-02	BKF	ETF	22.45	22.592	22.0	22.27	13959.0
2009-02-02	BLV	ETF	75.39	75.59	74.79	75.57	6300.0
2009-02-02	BMVP	ETF	9.98	10.1949	9.98	10.15	35843.0
2009-02-02	BND	ETF	77.06	77.69	77.02	77.3	407600.0
2009-02-02	BNE	ETF	2.75	3.09	2.68	3.02	481960.0
2009-02-02	BSV	ETF	79.54	79.54	79.0	79.19	138500.0
2009-02-02	BTF	ETF	45.849999999999994	46.95	45.75	46.95	13877.0
2009-02-02	BWX	ETF	25.23	25.375	25.1722	25.375	148540.0
2009-02-02	BWZ	ETF	32.65	32.65	32.65	32.65	800.0
2009-02-02	CBON	ETF	2.61	2.71	2.3	2.42	49011.0
2009-02-02	CDL	ETF	0.2	0.21	0.18	0.2	574196.0
2009-02-02	CEF	ETF	11.05	11.15	10.8	10.9	1107000.0
2009-02-02	CGO	ETF	9.26	9.6	9.26	9.48	15654.0
2009-02-02	CGW	ETF	12.75	12.8499	12.5401	12.66	85043.0
2009-02-02	CHB	ETF	0.444	0.51	0.444	0.48	437376.0
2009-02-02	CHI	ETF	9.2	9.2	8.75	8.91	245512.0
2009-02-02	CHIC	ETF	5.1	5.3	4.98	5.01	198664.0
2009-02-02	CHW	ETF	6.06	6.06	5.83	6.05	186907.0
2009-02-02	CHY	ETF	8.98	8.98	8.76	8.81	198938.0
2009-02-02	CMF	ETF	50.515	51.0	50.515	50.7	5618.0
2009-02-02	CNXT	ETF	0.67	0.68	0.62	0.624	289733.0
2009-02-02	COW	ETF	30.33	31.98	30.33	31.8	11624.0

> showing 50 of 632 rows — these rows as CSV

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