PREVIEW / etf_daily / 2009-07-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-23.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-07-23	SPY	ETF	95.61	98.08	95.53	97.66	258795500.0
2009-07-23	QQQ	ETF	38.45	39.49	38.39	39.35	160566419.0
2009-07-23	IWM	ETF	52.88	54.82	52.77	54.53	64531400.0
2009-07-23	DIA	ETF	88.9	91.0	88.84	90.63	16519600.0
2009-07-23	GLD	ETF	93.2	94.0	93.11	93.26	9763900.0
2009-07-23	TLT	ETF	92.76	92.8	90.57	91.01	3818800.0
2009-07-23	AAXJ	ETF	48.18	49.37	48.14	49.26	186200.0
2009-07-23	ACWI	ETF	36.36	37.21	36.34	37.05	341500.0
2009-07-23	ACWX	ETF	35.22	36.1	35.178	35.93	66724.0
2009-07-23	ADRE	ETF	37.19	38.2	37.19	37.95	137914.0
2009-07-23	AFK	ETF	26.79	28.2	26.08	27.84	110905.0
2009-07-23	AGG	ETF	102.74	102.74	102.24	102.39	564500.0
2009-07-23	AGQ	ETF	80.9	83.44	80.76	81.92	108250.0
2009-07-23	AGZ	ETF	107.565	107.565	106.758	106.93	47473.0
2009-07-23	AIA	ETF	35.13	36.013	35.13	35.89	76204.0
2009-07-23	AIQ	ETF	31.8	32.15	31.3	31.95	96819.0
2009-07-23	AIS	ETF	0.87	0.9	0.84	0.9	272714.0
2009-07-23	AIVI	ETF	37.01	37.89	37.01	37.44	103900.0
2009-07-23	AMJ	ETF	24.17	24.49	24.13	24.34	138809.0
2009-07-23	AOA	ETF	26.53	26.67	26.11	26.6	16200.0
2009-07-23	AOK	ETF	25.95	26.11	25.95	26.04	5190.0
2009-07-23	AOM	ETF	26.15	26.35	26.15	26.334	22877.0
2009-07-23	AOR	ETF	26.5094	26.52	26.4672	26.51	4977.0
2009-07-23	ARB	ETF	16.81	18.15	16.69	17.55	625808.0
2009-07-23	BAL	ETF	32.15	32.21	31.99	31.99	6270.0
2009-07-23	BBH	ETF	32.5067	33.3167	32.5067	33.3	473400.0
2009-07-23	BIL	ETF	91.72	91.72	91.7	91.72	461600.0
2009-07-23	BITS	ETF	22.48	22.48	21.4404	22.08	3978.0
2009-07-23	BIV	ETF	77.92	77.92	77.31	77.45	135600.0
2009-07-23	BJK	ETF	22.05	22.63	21.83	22.36	12100.0
2009-07-23	BKF	ETF	37.47	38.7	37.47	38.53	592827.0
2009-07-23	BLV	ETF	74.79	74.8	73.62	74.0	37600.0
2009-07-23	BMVP	ETF	11.33	11.5	11.28	11.42	17020.0
2009-07-23	BND	ETF	78.07	78.12	77.57	77.77	498100.0
2009-07-23	BNE	ETF	7.46	8.18	7.46	8.07	141430.0
2009-07-23	BOSS	ETF	17.01	17.01	16.44	17.01	100.0
2009-07-23	BRF	ETF	31.1	31.9229	31.1	31.76	157624.0
2009-07-23	BSV	ETF	79.55	79.61	79.3	79.41	240200.0
2009-07-23	BTF	ETF	51.25	52.15	50.95049999999999	51.95	11507.0
2009-07-23	BWX	ETF	27.805	27.805	27.655	27.655	317938.0
2009-07-23	BWZ	ETF	35.75	35.79	35.68	35.68	1820.0
2009-07-23	BZQ	ETF	8094.4	8094.4	7656.0	7761.6	31.25
2009-07-23	CBON	ETF	0.65	0.7	0.65	0.65	21900.0
2009-07-23	CEF	ETF	11.8	11.96	11.8	11.9	677900.0
2009-07-23	CEW	ETF	21.23	21.36	21.21	21.21	25258.0
2009-07-23	CGO	ETF	12.0	12.35	11.99	12.16	64716.0
2009-07-23	CGW	ETF	16.29	16.43	15.88	16.27	90499.0
2009-07-23	CHB	ETF	0.31	0.34	0.3002	0.33	631988.0
2009-07-23	CHI	ETF	10.72	10.98	10.72	10.89	193256.0
2009-07-23	CHIC	ETF	13.65	14.93	13.6	14.5	850885.0

> showing 50 of 668 rows — these rows as CSV

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