PREVIEW / etf_daily / 2009-08-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-26.parquet
  size:    29 KB
  rows:    667

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-08-26	SPY	ETF	102.84	103.64	102.49	103.17	194620700.0
2009-08-26	QQQ	ETF	40.29	40.601	40.08	40.3	96407482.0
2009-08-26	IWM	ETF	58.3	58.77	58.03	58.51	34163900.0
2009-08-26	DIA	ETF	95.26	95.85	94.87	95.46	11497200.0
2009-08-26	GLD	ETF	92.67	92.85	92.21	92.79	5224300.0
2009-08-26	TLT	ETF	96.18	96.55	95.91	96.45	3225800.0
2009-08-26	AAXJ	ETF	49.45	49.52	48.76	49.41	249700.0
2009-08-26	ACWI	ETF	39.01	39.2	38.84	39.18	78500.0
2009-08-26	ACWX	ETF	38.0	38.11	37.744	38.036	27781.0
2009-08-26	ADRE	ETF	38.64	38.75	38.344	38.62	136649.0
2009-08-26	AFK	ETF	27.95	28.0599	27.71	27.88	5444.0
2009-08-26	AGG	ETF	103.68	103.84	103.61	103.74	692400.0
2009-08-26	AGQ	ETF	86.48	86.88	85.08	86.78	40150.0
2009-08-26	AGZ	ETF	107.6	107.942	107.44	107.538	11972.0
2009-08-26	AIA	ETF	35.96	36.0187	35.64	35.74	15167.0
2009-08-26	AIQ	ETF	26.95	27.95	26.75	27.6	76453.0
2009-08-26	AIS	ETF	0.96	0.975	0.93	0.96	308543.0
2009-08-26	AIVI	ETF	40.75	40.75	40.31	40.61	29600.0
2009-08-26	AMJ	ETF	24.11	24.11	23.79	24.0	331128.0
2009-08-26	AOA	ETF	27.94	28.06	27.93	28.06	1600.0
2009-08-26	AOK	ETF	26.95	26.95	26.6915	26.74	7151.0
2009-08-26	AOM	ETF	27.24	27.3	27.1665	27.3	3004.0
2009-08-26	AOR	ETF	27.71	27.71	27.566	27.69	4498.0
2009-08-26	ARB	ETF	18.0	18.65	17.89	18.61	260625.0
2009-08-26	BAL	ETF	30.35	30.35	29.68	29.91	4410.0
2009-08-26	BBH	ETF	33.6	34.12	33.6	33.8767	297300.0
2009-08-26	BIL	ETF	91.7	91.72	91.7	91.72	90100.0
2009-08-26	BITS	ETF	21.32	21.32	20.16	20.72	2100.0
2009-08-26	BIV	ETF	79.42	79.42	79.13	79.37	112000.0
2009-08-26	BJK	ETF	23.88	23.88	23.5	23.61	17700.0
2009-08-26	BKF	ETF	38.7	38.7799	38.25	38.58	266462.0
2009-08-26	BLV	ETF	78.18	78.18	77.43	78.04	21600.0
2009-08-26	BMVP	ETF	11.81	11.9	11.81	11.879	26493.0
2009-08-26	BND	ETF	78.74	78.85	78.62	78.75	512000.0
2009-08-26	BNE	ETF	6.19	6.44	6.11	6.37	237925.0
2009-08-26	BRF	ETF	36.51	36.9	36.26	36.86	302482.0
2009-08-26	BSV	ETF	79.71	79.76	79.54	79.65	379000.0
2009-08-26	BTF	ETF	58.89999999999999	59.0	57.99999999999999	58.25	5207.8
2009-08-26	BWX	ETF	28.27	28.27	28.045	28.195	290118.0
2009-08-26	BWZ	ETF	36.1	36.1	35.9635	36.1	14825.0
2009-08-26	BZQ	ETF	6894.4	6958.4	6830.4	6830.4	22.5
2009-08-26	CEF	ETF	12.09	12.12	11.98	12.11	413900.0
2009-08-26	CEW	ETF	21.24	21.24	21.1927	21.23	33591.0
2009-08-26	CGO	ETF	13.41	13.41	13.19	13.19	30952.0
2009-08-26	CGW	ETF	17.22	17.22	16.9301	17.1	67360.0
2009-08-26	CHB	ETF	0.5	0.55	0.47	0.5	2332995.0
2009-08-26	CHI	ETF	11.36	11.43	11.15	11.42	185286.0
2009-08-26	CHIC	ETF	17.37	17.39	17.37	17.38	934850.0
2009-08-26	CHW	ETF	7.29	7.37	7.22	7.288	189445.0
2009-08-26	CHY	ETF	11.15	11.3	11.03	11.27	272349.0

> showing 50 of 667 rows — these rows as CSV

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