PREVIEW / etf_daily / 2009-06-05

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-05.parquet
  size:    29 KB
  rows:    652

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-06-05	SPY	ETF	95.49	95.67	93.8	94.55	284257900.0
2009-06-05	QQQ	ETF	36.96	37.08	36.42	36.78	121963044.0
2009-06-05	IWM	ETF	53.69	53.79	52.68	53.2	50619300.0
2009-06-05	DIA	ETF	88.25	88.55	87.12	87.91	16834300.0
2009-06-05	GLD	ETF	94.24	94.79	93.57	93.71	18600800.0
2009-06-05	TLT	ETF	89.91	90.9	89.55	89.84	8439600.0
2009-06-05	AAXJ	ETF	46.27	46.4	45.2	45.75	686700.0
2009-06-05	ACWI	ETF	35.96	36.01	35.43	35.55	103600.0
2009-06-05	ACWX	ETF	34.9	34.91	34.27	34.33	132421.0
2009-06-05	ADRE	ETF	36.85	36.87	35.92	36.24	144293.0
2009-06-05	AFK	ETF	29.51	29.51	27.95	27.95	60878.0
2009-06-05	AGG	ETF	100.5	100.57	100.07	100.07	479100.0
2009-06-05	AGQ	ETF	103.3	107.7	102.38	103.18	270900.0
2009-06-05	AGZ	ETF	106.45	106.45	105.7795	106.29	62857.0
2009-06-05	AIA	ETF	34.05	34.05	33.18	33.41	20939.0
2009-06-05	AIQ	ETF	37.45	37.5	36.1	36.65	44425.0
2009-06-05	AIS	ETF	0.77	0.84	0.75	0.77	949613.0
2009-06-05	AIVI	ETF	36.86	36.86	35.92	36.17	18800.0
2009-06-05	AMJ	ETF	23.49	23.49	22.93	23.23	1809092.0
2009-06-05	AOA	ETF	26.1	26.1	25.68	25.79	3300.0
2009-06-05	AOK	ETF	25.76	25.8361	25.76	25.83	835.0
2009-06-05	AOM	ETF	25.8468	25.961	25.39	25.77	10965.0
2009-06-05	AOR	ETF	26.09	26.15	25.85	25.88	18376.0
2009-06-05	ARB	ETF	20.8	20.98	20.34	20.89	184743.0
2009-06-05	BAL	ETF	31.59	31.59	30.93	31.23	7019.0
2009-06-05	BBH	ETF	31.2767	31.2767	30.4633	30.79	421800.0
2009-06-05	BIL	ETF	91.72	91.72	91.66	91.7	271900.0
2009-06-05	BITS	ETF	19.72	19.72	18.12	19.6	1773.0
2009-06-05	BIV	ETF	75.29	75.55	75.0	75.05	130200.0
2009-06-05	BJK	ETF	22.3	22.47	21.61	22.04	6800.0
2009-06-05	BKF	ETF	37.89	38.3	36.7201	36.91	369912.0
2009-06-05	BLV	ETF	71.53	72.09	71.25	71.26	33600.0
2009-06-05	BMVP	ETF	11.21	11.25	11.11	11.15	26211.0
2009-06-05	BND	ETF	76.52	76.57	76.17	76.24	546400.0
2009-06-05	BNE	ETF	6.85	7.07	6.61	6.65	122742.0
2009-06-05	BRF	ETF	28.93	28.93	27.73	28.04	164934.0
2009-06-05	BSV	ETF	78.53	78.61	78.25	78.4	288000.0
2009-06-05	BTF	ETF	49.05	49.15	48.6	48.8	6196.0
2009-06-05	BWX	ETF	26.845	26.855	26.545	26.545	388510.0
2009-06-05	BWZ	ETF	34.85	34.85	34.71	34.71	8359.0
2009-06-05	CBON	ETF	1.3	1.32	1.23	1.23	9506.0
2009-06-05	CEF	ETF	12.17	12.23	12.02	12.05	1082800.0
2009-06-05	CEW	ETF	20.73	20.77	20.65	20.69	51179.0
2009-06-05	CGO	ETF	11.9	12.0	11.6099	11.7237	68770.0
2009-06-05	CGW	ETF	15.63	15.63	15.3	15.43	104501.0
2009-06-05	CHB	ETF	0.44	0.54	0.44	0.51	1410339.0
2009-06-05	CHI	ETF	10.86	10.92	10.75	10.9	161929.0
2009-06-05	CHIC	ETF	11.4	11.47	11.14	11.41	233295.0
2009-06-05	CHW	ETF	7.64	7.64	7.5201	7.6	285323.0
2009-06-05	CHY	ETF	10.8	10.848	10.61	10.8	207162.0

> showing 50 of 652 rows — these rows as CSV

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