PREVIEW / etf_daily / 2009-08-19

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-19.parquet
  size:    29 KB
  rows:    668

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-19	SPY	ETF	98.31	100.3	98.21	99.96	192812800.0
2009-08-19	QQQ	ETF	38.59	39.4	38.54	39.3	88036241.0
2009-08-19	IWM	ETF	54.93	56.27	54.82	56.23	37740100.0
2009-08-19	DIA	ETF	91.69	93.45	91.57	93.13	14296100.0
2009-08-19	GLD	ETF	91.68	92.78	91.66	92.53	7119800.0
2009-08-19	TLT	ETF	95.17	95.37	94.41	94.96	3518200.0
2009-08-19	AAXJ	ETF	47.17	48.09	47.17	48.08	177800.0
2009-08-19	ACWI	ETF	37.3	38.09	37.3	38.0	85100.0
2009-08-19	ACWX	ETF	36.18	36.92	36.15	36.79	35935.0
2009-08-19	ADRE	ETF	36.94	37.93	36.94	37.788	106047.0
2009-08-19	AFK	ETF	26.77	27.29	26.59	27.1	15498.0
2009-08-19	AGG	ETF	103.33	103.6	103.21	103.43	486900.0
2009-08-19	AGQ	ETF	78.64	82.78	78.12	81.04	151300.0
2009-08-19	AGZ	ETF	107.6729	107.86	107.5207	107.86	22037.0
2009-08-19	AIA	ETF	34.84	35.5199	34.84	35.4989	8116.0
2009-08-19	AIQ	ETF	25.65	26.15	25.5	25.85	55739.0
2009-08-19	AIS	ETF	0.96	0.97	0.94	0.959	160211.0
2009-08-19	AIVI	ETF	38.31	39.2	38.2	39.07	13700.0
2009-08-19	AMJ	ETF	24.18	24.32	24.05	24.28	111547.0
2009-08-19	AOA	ETF	27.0	27.3	27.0	27.3	4100.0
2009-08-19	AOK	ETF	26.72	27.3	26.2828	26.31	7342.0
2009-08-19	AOM	ETF	26.87	26.87	26.71	26.81	3484.0
2009-08-19	AOR	ETF	26.92	27.12	26.92	27.094	20579.0
2009-08-19	ARB	ETF	16.39	16.75	16.12	16.72	382722.0
2009-08-19	BAL	ETF	30.62	30.91	30.59	30.77	8885.0
2009-08-19	BBH	ETF	32.5233	32.9967	32.3	32.9733	257100.0
2009-08-19	BIL	ETF	91.7	91.74	91.7	91.7	67050.0
2009-08-19	BITS	ETF	21.68	21.76	20.92	21.56	1339.0
2009-08-19	BIV	ETF	79.22	79.22	78.67	79.07	99000.0
2009-08-19	BJK	ETF	22.35	23.14	22.35	22.83	17100.0
2009-08-19	BKF	ETF	37.0	37.8	36.7401	37.77	138464.0
2009-08-19	BLV	ETF	77.0	77.44	76.7	77.12	21200.0
2009-08-19	BMVP	ETF	11.35	11.57	11.35	11.56	27727.0
2009-08-19	BND	ETF	78.73	78.73	78.34	78.56	384500.0
2009-08-19	BNE	ETF	5.94	6.025	5.85	6.0	216223.0
2009-08-19	BRF	ETF	35.04	36.13	34.75	35.9	232560.0
2009-08-19	BSV	ETF	79.65	79.73	79.41	79.46	410200.0
2009-08-19	BTF	ETF	57.449999999999996	57.449999999999996	56.74999999999999	57.150499999999994	5112.8
2009-08-19	BWX	ETF	28.025	28.22	27.9836	28.115	267288.0
2009-08-19	BWZ	ETF	35.75	36.05	35.75	36.05	2960.0
2009-08-19	BZQ	ETF	7476.8	7476.8	6992.0	7060.8	41.25
2009-08-19	CEF	ETF	11.69	12.0	11.69	11.92	1058600.0
2009-08-19	CEW	ETF	21.09	21.25	21.09	21.22	12400.0
2009-08-19	CGO	ETF	12.78	12.95	12.78	12.888	27259.0
2009-08-19	CGW	ETF	15.98	16.42	15.9	16.32	25885.0
2009-08-19	CHB	ETF	0.39	0.42	0.384	0.42	843018.0
2009-08-19	CHI	ETF	10.81	11.04	10.76	10.9902	135774.0
2009-08-19	CHIC	ETF	13.83	14.05	13.71	13.88	155921.0
2009-08-19	CHW	ETF	7.11	7.314	7.11	7.27	166039.0
2009-08-19	CHY	ETF	10.52	10.68	10.5	10.654	162445.0

> showing 50 of 668 rows — these rows as CSV

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