PREVIEW / etf_daily / 2009-07-22

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-22.parquet
  size:    29 KB
  rows:    666

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-22	SPY	ETF	94.96	96.13	94.89	95.55	196068100.0
2009-07-22	QQQ	ETF	38.2	38.69	38.13	38.5	113808563.0
2009-07-22	IWM	ETF	52.22	53.21	52.14	52.86	47552200.0
2009-07-22	DIA	ETF	88.76	89.53	88.63	88.88	11857700.0
2009-07-22	GLD	ETF	92.82	93.82	92.73	93.44	10241300.0
2009-07-22	TLT	ETF	93.4	93.53	92.36	92.71	1986700.0
2009-07-22	AAXJ	ETF	47.39	48.99	47.2	47.82	193800.0
2009-07-22	ACWI	ETF	35.94	36.44	35.94	36.16	51700.0
2009-07-22	ACWX	ETF	34.91	35.36	34.888	35.16	156644.0
2009-07-22	ADRE	ETF	36.61	37.25	36.5	36.93	244338.0
2009-07-22	AFK	ETF	26.44	26.608	26.39	26.561	4826.0
2009-07-22	AGG	ETF	102.89	102.96	102.53	102.65	450600.0
2009-07-22	AGQ	ETF	78.2	81.94	78.18	81.08	112600.0
2009-07-22	AGZ	ETF	108.23	108.23	107.196	107.72	14673.0
2009-07-22	AIA	ETF	34.47	35.09	34.47	34.95	35348.0
2009-07-22	AIQ	ETF	32.05	32.2	31.4	31.45	79317.0
2009-07-22	AIS	ETF	0.87	0.91	0.83	0.86	368284.0
2009-07-22	AIVI	ETF	36.71	37.27	36.6	37.01	16300.0
2009-07-22	AMJ	ETF	24.03	24.14	23.9605	24.1	84031.0
2009-07-22	AOA	ETF	26.24	26.24	26.0	26.1	4100.0
2009-07-22	AOK	ETF	25.25	26.34	25.25	25.66	12402.0
2009-07-22	AOM	ETF	26.1	26.15	26.016	26.15	6764.0
2009-07-22	AOR	ETF	26.18	26.45	26.095	26.16	14964.0
2009-07-22	ARB	ETF	15.87	17.43	15.7	16.72	792156.0
2009-07-22	BAL	ETF	31.61	31.7108	31.43	31.7108	18922.0
2009-07-22	BBH	ETF	32.28	32.73	32.28	32.5833	402000.0
2009-07-22	BIL	ETF	91.72	91.74	91.7	91.74	266750.0
2009-07-22	BITS	ETF	22.8	22.8	22.4	22.48	375.0
2009-07-22	BIV	ETF	78.23	78.23	77.75	77.93	87000.0
2009-07-22	BJK	ETF	21.01	21.98	20.83	21.7	12900.0
2009-07-22	BKF	ETF	36.77	37.33	36.52	37.13	345525.0
2009-07-22	BLV	ETF	75.17	75.22	74.45	74.6	17800.0
2009-07-22	BMVP	ETF	11.2467	11.3611	11.2467	11.2967	12548.0
2009-07-22	BND	ETF	78.24	78.24	77.95	78.03	608300.0
2009-07-22	BNE	ETF	7.32	7.66	7.2	7.5	173563.0
2009-07-22	BRF	ETF	30.5	31.36	30.5	30.8	247043.0
2009-07-22	BSV	ETF	79.66	79.66	79.45	79.5	248800.0
2009-07-22	BTF	ETF	50.49999999999999	51.199999999999996	50.25	51.199999999999996	7283.0
2009-07-22	BWX	ETF	27.755	27.825	27.73	27.76	319460.0
2009-07-22	BWZ	ETF	35.78	35.88	35.58	35.7795	19961.0
2009-07-22	BZQ	ETF	8382.4	8382.4	8243.2	8243.2	4.5
2009-07-22	CBON	ETF	0.7	0.7	0.65	0.65	9344.0
2009-07-22	CEF	ETF	11.8	11.92	11.73	11.83	430500.0
2009-07-22	CEW	ETF	21.07	21.2368	21.04	21.22	26829.0
2009-07-22	CGO	ETF	11.87	12.0	11.86	11.86	11841.0
2009-07-22	CGW	ETF	16.0	16.22	15.87	16.16	50732.0
2009-07-22	CHB	ETF	0.3	0.34	0.2927	0.3	1697200.0
2009-07-22	CHI	ETF	10.67	10.75	10.66	10.7	82467.0
2009-07-22	CHIC	ETF	14.09	14.63	13.13	13.24	1378986.0
2009-07-22	CHW	ETF	6.75	6.85	6.7	6.81	186649.0

> showing 50 of 666 rows — these rows as CSV

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