PREVIEW / etf_daily / 2009-02-24

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-24.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-24	SPY	ETF	75.29	77.95	74.7	77.48	426260900.0
2009-02-24	QQQ	ETF	28.0	28.98	27.96	28.78	181335783.0
2009-02-24	IWM	ETF	40.04	41.37	39.6	41.02	81463900.0
2009-02-24	DIA	ETF	71.57	73.8	71.15	73.38	37524300.0
2009-02-24	GLD	ETF	97.59	97.59	94.27	94.73	37460500.0
2009-02-24	TLT	ETF	105.7	106.68	104.77	104.77	4197100.0
2009-02-24	AAXJ	ETF	28.89	29.94	28.6	29.85	420200.0
2009-02-24	ACWI	ETF	26.16	27.05	25.94	26.92	407300.0
2009-02-24	ACWX	ETF	24.12	24.91	23.91	24.79	259792.0
2009-02-24	ADRE	ETF	24.15	25.34	24.15	25.13	332036.0
2009-02-24	AFK	ETF	17.82	18.27	17.82	18.27	20680.0
2009-02-24	AGG	ETF	101.34	101.85	101.11	101.3	605600.0
2009-02-24	AGQ	ETF	99.84	100.26	88.96	90.94	164150.0
2009-02-24	AGZ	ETF	107.84	108.03	107.295	107.72	12648.0
2009-02-24	AIA	ETF	22.67	22.95	22.08	22.93	8551.0
2009-02-24	AIQ	ETF	45.05	47.5	44.7	47.1	50927.0
2009-02-24	AIS	ETF	0.3622	0.39	0.3622	0.38	167561.0
2009-02-24	AIVI	ETF	26.18	27.27	25.88	27.17	29400.0
2009-02-24	AOA	ETF	20.47	21.03	19.85	21.03	4700.0
2009-02-24	AOK	ETF	24.46	24.49	24.4	24.4	1614.0
2009-02-24	AOM	ETF	23.38	23.48	23.34	23.46	6519.0
2009-02-24	AOR	ETF	22.23	22.45	22.08	22.45	2888.0
2009-02-24	ARB	ETF	13.04	13.73	12.87	13.56	284795.0
2009-02-24	BBH	ETF	57.6067	58.3	57.6	58.1167	220200.0
2009-02-24	BIL	ETF	91.76	91.76	91.64	91.7	3389950.0
2009-02-24	BITS	ETF	19.0	19.0	18.2	18.76	1431.0
2009-02-24	BIV	ETF	76.84	77.09	76.61	76.74	55900.0
2009-02-24	BJK	ETF	14.65	14.65	14.65	14.65	100.0
2009-02-24	BKF	ETF	21.09	22.47	19.78	22.2601	58670.0
2009-02-24	BLV	ETF	74.42	74.76	73.67	73.7	37600.0
2009-02-24	BMVP	ETF	9.39	9.68	9.39	9.65	52793.0
2009-02-24	BND	ETF	76.97	77.22	76.75	77.04	564800.0
2009-02-24	BNE	ETF	2.05	2.1	1.95	2.02	219245.0
2009-02-24	BSV	ETF	78.65	79.2	78.51	78.72	193800.0
2009-02-24	BTF	ETF	35.8	39.8	35.49999999999999	38.75	15933.800000000001
2009-02-24	BWX	ETF	24.825	24.955	24.705	24.95	272646.0
2009-02-24	BWZ	ETF	31.82	32.05	31.8	32.05	7490.0
2009-02-24	CBON	ETF	1.29	1.29	1.14	1.2	19254.0
2009-02-24	CDL	ETF	0.17	0.17	0.12	0.14	905183.0
2009-02-24	CEF	ETF	12.56	12.6	11.72	12.1	2514300.0
2009-02-24	CGO	ETF	8.32	8.76	8.24	8.65	41262.0
2009-02-24	CGW	ETF	11.64	12.22	11.6036	12.17	86504.0
2009-02-24	CHB	ETF	0.32	0.33	0.268	0.31	582453.0
2009-02-24	CHI	ETF	7.8	8.34	7.47	8.29	351261.0
2009-02-24	CHIC	ETF	5.03	5.54	4.9493	5.44	228258.0
2009-02-24	CHW	ETF	4.8	5.23	4.77	5.2	388134.0
2009-02-24	CHY	ETF	7.34	8.08	7.24	7.9	484659.0
2009-02-24	CMF	ETF	51.23	51.635	51.19	51.5	5046.0
2009-02-24	CNXT	ETF	0.46	0.49	0.44	0.44	306065.0
2009-02-24	COW	ETF	30.28	30.81	30.27	30.7	136918.0

> showing 50 of 643 rows — these rows as CSV

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