PREVIEW / etf_daily / 2009-07-31

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-31.parquet
  size:    29 KB
  rows:    665

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-07-31	SPY	ETF	98.65	99.47	98.38	98.81	207358000.0
2009-07-31	QQQ	ETF	39.56	39.8522	39.41	39.45	78208282.0
2009-07-31	IWM	ETF	55.58	56.28	55.54	55.57	40477300.0
2009-07-31	DIA	ETF	91.47	92.21	91.36	91.67	9151300.0
2009-07-31	GLD	ETF	91.86	94.03	91.83	93.35	14385900.0
2009-07-31	TLT	ETF	93.85	94.86	93.28	94.81	5697000.0
2009-07-31	AAXJ	ETF	50.08	50.44	49.81	50.21	151000.0
2009-07-31	ACWI	ETF	37.8	37.98	37.48	37.74	229700.0
2009-07-31	ACWX	ETF	36.6	37.0	36.32	36.8	187471.0
2009-07-31	ADRE	ETF	37.98	38.2899	37.74	38.06	105986.0
2009-07-31	AFK	ETF	27.29	27.68	27.15	27.436	13420.0
2009-07-31	AGG	ETF	102.95	103.33	102.75	103.1	1058900.0
2009-07-31	AGQ	ETF	78.56	84.4	78.3	84.0	108800.0
2009-07-31	AGZ	ETF	107.75	108.45	107.63	108.005	20687.0
2009-07-31	AIA	ETF	36.57	36.88	36.19	36.55	34420.0
2009-07-31	AIQ	ETF	25.8	25.85	24.2	24.65	517159.0
2009-07-31	AIS	ETF	0.89	0.91	0.8501	0.86	713369.0
2009-07-31	AIVI	ETF	38.36	39.02	38.25	38.79	15700.0
2009-07-31	AMJ	ETF	24.74	25.06	24.61	25.06	125453.0
2009-07-31	AOA	ETF	26.8	27.59	26.8	27.04	13600.0
2009-07-31	AOK	ETF	26.0848	26.34	25.94	25.94	2959.0
2009-07-31	AOM	ETF	26.62	26.88	26.48	26.64	6663.0
2009-07-31	AOR	ETF	26.92	26.97	26.8395	26.8395	10483.0
2009-07-31	ARB	ETF	16.6	16.6	16.06	16.28	339912.0
2009-07-31	BAL	ETF	30.8055	31.08	30.8055	31.08	4900.0
2009-07-31	BBH	ETF	34.3367	34.6867	33.9733	33.99	564300.0
2009-07-31	BIL	ETF	91.72	91.74	91.68	91.68	102950.0
2009-07-31	BITS	ETF	22.84	22.84	22.2	22.68	532.0
2009-07-31	BIV	ETF	78.23	79.0	78.23	78.87	116700.0
2009-07-31	BJK	ETF	23.05	23.4	22.43	22.86	91300.0
2009-07-31	BKF	ETF	38.47	38.84	38.1	38.65	244847.0
2009-07-31	BLV	ETF	76.24	76.51	74.89	76.5	12100.0
2009-07-31	BMVP	ETF	11.53	11.64	11.53	11.55	25553.0
2009-07-31	BND	ETF	78.27	78.48	78.1	78.44	481200.0
2009-07-31	BNE	ETF	8.54	8.85	8.03	8.03	168445.0
2009-07-31	BOSS	ETF	16.73	16.73	16.73	16.73	200.0
2009-07-31	BRF	ETF	33.4	34.17	33.35	33.9	206151.0
2009-07-31	BSV	ETF	79.49	79.62	79.3	79.57	231600.0
2009-07-31	BTF	ETF	51.25	54.3	51.25	53.8	5210.0
2009-07-31	BWX	ETF	27.745	28.185	27.745	28.185	783078.0
2009-07-31	BWZ	ETF	35.55	35.95	35.55	35.95	15223.0
2009-07-31	CBON	ETF	0.69	0.75	0.66	0.68	18645.0
2009-07-31	CEF	ETF	11.69	11.97	11.62	11.97	1187100.0
2009-07-31	CEW	ETF	21.32	21.44	21.27	21.39	28435.0
2009-07-31	CGO	ETF	12.75	12.97	12.25	12.9025	39226.0
2009-07-31	CGW	ETF	16.31	16.5	16.26	16.39	134060.0
2009-07-31	CHB	ETF	0.46	0.48	0.421	0.47	815261.0
2009-07-31	CHI	ETF	10.73	11.13	10.65	11.08	171181.0
2009-07-31	CHIC	ETF	14.69	15.24	14.56	15.01	248648.0
2009-07-31	CHW	ETF	6.93	7.19	6.91	7.03	158102.0

> showing 50 of 665 rows — these rows as CSV

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