PREVIEW / etf_daily / 2009-09-03

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-03.parquet
  size:    29 KB
  rows:    662

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-09-03	SPY	ETF	100.4	100.77	99.59	100.65	143572300.0
2009-09-03	QQQ	ETF	39.44	39.5702	39.02	39.51	76783088.0
2009-09-03	IWM	ETF	55.92	56.31	55.21	56.26	43089000.0
2009-09-03	DIA	ETF	93.24	93.61	92.63	93.45	7262500.0
2009-09-03	GLD	ETF	96.52	97.94	96.2	97.46	26443600.0
2009-09-03	TLT	ETF	96.84	97.12	96.55	96.86	2703800.0
2009-09-03	AAXJ	ETF	48.93	49.23	48.44	49.23	54400.0
2009-09-03	ACWI	ETF	38.29	38.38	38.07	38.38	29500.0
2009-09-03	ACWX	ETF	37.44	37.44	37.14	37.4099	27446.0
2009-09-03	ADRE	ETF	37.69	37.924	37.5	37.924	88278.0
2009-09-03	AFK	ETF	27.56	27.56	27.35	27.45	1554.0
2009-09-03	AGG	ETF	103.83	104.03	103.66	103.87	750900.0
2009-09-03	AGQ	ETF	104.44	111.44	103.36	109.64	392400.0
2009-09-03	AGZ	ETF	108.47	108.47	107.9201	108.155	7339.0
2009-09-03	AIA	ETF	35.79	35.89	35.6	35.89	14191.0
2009-09-03	AIQ	ETF	25.85	26.2	25.5	25.95	127066.0
2009-09-03	AIS	ETF	0.95	0.95	0.905	0.93	108437.0
2009-09-03	AIVI	ETF	39.81	39.81	39.41	39.69	17200.0
2009-09-03	AMJ	ETF	23.4	23.52	23.338	23.5	93825.0
2009-09-03	AOA	ETF	27.43	27.54	27.32	27.54	5500.0
2009-09-03	AOK	ETF	26.78	26.78	26.2401	26.5192	732.0
2009-09-03	AOM	ETF	26.91	26.96	26.81	26.8939	3796.0
2009-09-03	AOR	ETF	27.22	27.33	27.21	27.33	11327.0
2009-09-03	ARB	ETF	17.75	17.86	17.56	17.71	274551.0
2009-09-03	BAL	ETF	32.68	32.68	30.6024	30.7499	11926.0
2009-09-03	BBH	ETF	33.0467	33.2	32.78	33.1233	156600.0
2009-09-03	BIL	ETF	91.72	91.76	91.72	91.76	174700.0
2009-09-03	BITS	ETF	19.8	19.8	19.456	19.8	500.0
2009-09-03	BIV	ETF	79.77	79.98	79.61	79.78	176200.0
2009-09-03	BJK	ETF	23.46	23.67	23.46	23.67	9300.0
2009-09-03	BKF	ETF	37.43	37.51	36.86	37.49	144043.0
2009-09-03	BLV	ETF	78.32	78.42	78.01	78.06	10800.0
2009-09-03	BMVP	ETF	11.5	11.53	11.4	11.53	32775.0
2009-09-03	BND	ETF	78.98	78.99	78.78	78.83	443300.0
2009-09-03	BNE	ETF	6.66	6.77	6.32	6.77	195803.0
2009-09-03	BRF	ETF	35.35	35.8	35.168	35.748	88746.0
2009-09-03	BSV	ETF	79.82	79.94	79.77	79.9	262600.0
2009-09-03	BTF	ETF	56.74999999999999	57.24999999999999	56.15	56.6	4184.2
2009-09-03	BWX	ETF	28.275	28.355	28.175	28.35	235380.0
2009-09-03	BWZ	ETF	36.17	36.17	36.17	36.17	7251.0
2009-09-03	BZQ	ETF	7313.6	7393.6	7276.8	7276.8	13.25
2009-09-03	CEF	ETF	12.75	13.09	12.65	12.8	2202600.0
2009-09-03	CEW	ETF	21.4	21.5	21.228	21.425	34780.0
2009-09-03	CGO	ETF	13.08	13.22	12.99	13.22	16965.0
2009-09-03	CGW	ETF	16.78	16.82	16.61	16.79	38645.0
2009-09-03	CHB	ETF	0.55	0.57	0.5025	0.52	1985055.0
2009-09-03	CHI	ETF	11.04	11.2	10.96	11.1999	134497.0
2009-09-03	CHIC	ETF	17.39	17.42	17.39	17.4	567846.0
2009-09-03	CHW	ETF	7.31	7.35	7.22	7.31	195277.0
2009-09-03	CHY	ETF	10.62	10.82	10.61	10.8	206093.0

> showing 50 of 662 rows — these rows as CSV

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