PREVIEW / etf_daily / 2009-08-31

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-31.parquet
  size:    29 KB
  rows:    672

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-31	SPY	ETF	102.37	102.58	101.79	102.46	176051600.0
2009-08-31	QQQ	ETF	40.16	40.2	39.79	40.03	96415287.0
2009-08-31	IWM	ETF	57.46	57.62	56.93	57.2	35360500.0
2009-08-31	DIA	ETF	94.71	95.09	94.41	95.05	9890500.0
2009-08-31	GLD	ETF	93.14	93.5	92.92	93.4	4952900.0
2009-08-31	TLT	ETF	96.36	96.86	95.76	96.6	2899800.0
2009-08-31	AAXJ	ETF	48.24	48.26	47.83	48.26	113100.0
2009-08-31	ACWI	ETF	39.09	39.09	38.73	38.86	46100.0
2009-08-31	ACWX	ETF	37.88	37.89	37.6	37.834	51661.0
2009-08-31	ADRE	ETF	37.95	37.95	37.38	37.52	88666.0
2009-08-31	AFK	ETF	27.66	28.0999	27.66	27.81	8858.0
2009-08-31	AGG	ETF	103.75	104.02	103.7	104.02	809600.0
2009-08-31	AGQ	ETF	90.5	93.94	90.0	93.36	122050.0
2009-08-31	AGZ	ETF	108.16	108.23	107.7801	107.95	19607.0
2009-08-31	AIA	ETF	35.46	35.46	34.91	35.12	26200.0
2009-08-31	AIQ	ETF	27.2	27.85	27.1	27.65	83829.0
2009-08-31	AIS	ETF	0.91	0.95	0.9	0.94	178206.0
2009-08-31	AIVI	ETF	40.46	40.54	40.2	40.4	16700.0
2009-08-31	AMJ	ETF	23.84	23.84	23.608	23.79	157324.0
2009-08-31	AOA	ETF	28.0	28.0	27.82	27.91	7700.0
2009-08-31	AOK	ETF	26.77	26.77	26.52	26.7299	13152.0
2009-08-31	AOM	ETF	27.51	27.51	27.0	27.18	11055.0
2009-08-31	AOR	ETF	27.46	27.5399	27.36	27.5399	2309.0
2009-08-31	ARB	ETF	18.48	18.48	17.95	18.32	270603.0
2009-08-31	BAL	ETF	29.84	31.09	29.7949	31.082	7800.0
2009-08-31	BBH	ETF	33.0	33.63	32.7667	33.2733	215400.0
2009-08-31	BIL	ETF	91.74	91.74	91.72	91.74	153700.0
2009-08-31	BITS	ETF	20.4	20.4	19.6464	20.32	875.0
2009-08-31	BIV	ETF	79.54	79.73	79.4	79.67	96900.0
2009-08-31	BJK	ETF	23.91	24.06	23.89	23.97	8200.0
2009-08-31	BKF	ETF	37.76	37.76	37.25	37.4	255767.0
2009-08-31	BLV	ETF	77.97	78.25	77.61	78.1	25200.0
2009-08-31	BMVP	ETF	11.723	11.741	11.657	11.733	13042.0
2009-08-31	BND	ETF	78.85	78.98	78.63	78.97	421700.0
2009-08-31	BNE	ETF	6.93	7.26	6.8	7.0	1806881.0
2009-08-31	BOSS	ETF	19.66	19.66	19.02	19.4	100.0
2009-08-31	BRF	ETF	35.93	36.0	35.6	35.81	95886.0
2009-08-31	BSV	ETF	79.86	79.88	79.76	79.85	333200.0
2009-08-31	BTF	ETF	58.15	58.15	57.0	57.35	6499.6
2009-08-31	BWX	ETF	28.345	28.485	28.29	28.4	447170.0
2009-08-31	BWZ	ETF	36.2	36.3	36.184	36.3	5624.0
2009-08-31	BZQ	ETF	7246.4	7379.2	7198.4	7336.0	15.75
2009-08-31	CEF	ETF	11.99	12.21	11.99	12.19	520000.0
2009-08-31	CEW	ETF	21.22	21.29	21.19	21.2	11091.0
2009-08-31	CGO	ETF	13.05	13.31	13.05	13.146	12981.0
2009-08-31	CGW	ETF	16.93	17.0	16.77	16.93	67080.0
2009-08-31	CHB	ETF	0.64	0.64	0.53	0.58	2285996.0
2009-08-31	CHI	ETF	11.12	11.12	10.92	10.954	142905.0
2009-08-31	CHIC	ETF	17.37	17.4	17.37	17.39	2054152.0
2009-08-31	CHW	ETF	7.35	7.38	7.28	7.334	190997.0

> showing 50 of 672 rows — these rows as CSV

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