PREVIEW / etf_daily / 2009-04-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-23.parquet
  size:    29 KB
  rows:    645

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-04-23	SPY	ETF	84.71	85.42	83.63	85.37	324903700.0
2009-04-23	QQQ	ETF	33.01	33.14	32.49	33.11	181848784.0
2009-04-23	IWM	ETF	47.1	47.21	45.93	46.75	70030200.0
2009-04-23	DIA	ETF	78.94	79.85	78.02	79.65	19521000.0
2009-04-23	GLD	ETF	87.71	89.37	87.62	88.8	16621000.0
2009-04-23	TLT	ETF	101.35	101.75	100.94	101.59	1688300.0
2009-04-23	AAXJ	ETF	37.39	37.76	36.51	37.14	179600.0
2009-04-23	ACWI	ETF	30.82	31.07	30.49	30.99	203400.0
2009-04-23	ACWX	ETF	28.98	29.3	28.77	29.3	106509.0
2009-04-23	ADRE	ETF	29.66	29.92	29.45	29.89	176392.0
2009-04-23	AFK	ETF	20.53	20.88	20.53	20.88	1385.0
2009-04-23	AGG	ETF	101.2	101.36	100.96	101.33	318700.0
2009-04-23	AGQ	ETF	70.04	76.0	69.7	74.4	130550.0
2009-04-23	AGZ	ETF	107.17	108.1352	107.17	107.66	5113.0
2009-04-23	AIA	ETF	28.46	28.46	27.88	28.14	46446.0
2009-04-23	AIQ	ETF	41.25	41.25	39.1	39.45	33345.0
2009-04-23	AIS	ETF	0.41	0.43	0.41	0.42	6400.0
2009-04-23	AIVI	ETF	30.76	31.22	30.56	31.12	10900.0
2009-04-23	AMJ	ETF	20.32	20.47	20.28	20.4	283261.0
2009-04-23	AOA	ETF	23.18	23.18	23.03	23.18	3200.0
2009-04-23	AOK	ETF	25.16	25.27	25.16	25.27	1025.0
2009-04-23	AOM	ETF	24.5	25.0	24.5	25.0	7298.0
2009-04-23	AOR	ETF	24.17	24.17	23.8799	24.1	3245.0
2009-04-23	ARB	ETF	20.76	20.9799	19.33	19.93	397407.0
2009-04-23	BAL	ETF	28.66	29.47	28.65	29.47	6722.0
2009-04-23	BBH	ETF	28.3833	28.76	28.2433	28.7267	340800.0
2009-04-23	BIL	ETF	91.76	91.78	91.72	91.78	182200.0
2009-04-23	BITS	ETF	17.64	17.72	17.44	17.72	100.0
2009-04-23	BIV	ETF	76.59	76.6	76.17	76.38	134300.0
2009-04-23	BJK	ETF	18.52	19.36	18.36	18.76	7300.0
2009-04-23	BKF	ETF	28.4	28.72	28.2	28.64	52037.0
2009-04-23	BLV	ETF	73.15	73.4	72.76	73.14	23500.0
2009-04-23	BMVP	ETF	10.34	10.4	10.19	10.34	43270.0
2009-04-23	BND	ETF	77.27	77.3	76.95	77.27	374200.0
2009-04-23	BNE	ETF	5.37	5.48	4.95	5.08	296906.0
2009-04-23	BOSS	ETF	14.5	15.0	14.5	15.0	600.0
2009-04-23	BSV	ETF	78.58	78.93	78.58	78.93	178600.0
2009-04-23	BTF	ETF	45.14999999999999	45.199999999999996	43.449999999999996	44.9	19849.600000000002
2009-04-23	BWX	ETF	25.475	25.665	25.445	25.665	203390.0
2009-04-23	BWZ	ETF	32.95	32.95	32.95	32.95	15600.0
2009-04-23	CBON	ETF	2.4575	2.464	2.31	2.32	4403.0
2009-04-23	CEF	ETF	11.1	11.36	10.96	11.32	896500.0
2009-04-23	CGO	ETF	9.68	9.7472	9.47	9.64	18736.0
2009-04-23	CGW	ETF	13.11	13.31	13.0	13.31	38244.0
2009-04-23	CHB	ETF	0.56	0.58	0.52	0.52	435130.0
2009-04-23	CHI	ETF	9.25	9.27	9.05	9.23	119979.0
2009-04-23	CHIC	ETF	12.46	12.65	11.72	11.88	700596.0
2009-04-23	CHW	ETF	6.17	6.23	6.0608	6.2	245020.0
2009-04-23	CHY	ETF	9.08	9.1	8.97	9.09	168700.0
2009-04-23	CMF	ETF	52.05	52.535	52.05	52.5337	11852.0

> showing 50 of 645 rows — these rows as CSV

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