PREVIEW / etf_daily / 2009-03-05

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-05.parquet
  size:    28 KB
  rows:    639

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-03-05	SPY	ETF	70.1	71.73	68.17	68.8	485549400.0
2009-03-05	QQQ	ETF	27.03	27.24	26.42	26.51	199616447.0
2009-03-05	IWM	ETF	36.25	36.69	34.92	35.02	97980100.0
2009-03-05	DIA	ETF	67.5	68.05	65.53	66.07	35056100.0
2009-03-05	GLD	ETF	89.92	92.17	89.23	91.99	23995500.0
2009-03-05	TLT	ETF	104.02	105.44	103.44	104.96	4562400.0
2009-03-05	AAXJ	ETF	28.59	28.59	27.69	27.87	53300.0
2009-03-05	ACWI	ETF	24.68	24.88	24.12	24.35	325400.0
2009-03-05	ACWX	ETF	23.05	23.22	22.49	22.69	80784.0
2009-03-05	ADRE	ETF	24.05	24.5	23.898	24.08	125254.0
2009-03-05	AFK	ETF	17.61	17.61	17.61	17.61	100.0
2009-03-05	AGG	ETF	100.29	100.67	100.05	100.43	685000.0
2009-03-05	AGQ	ETF	80.62	83.72	78.74	83.38	128200.0
2009-03-05	AGZ	ETF	107.4	107.99	107.4	107.99	16980.0
2009-03-05	AIA	ETF	21.94	21.94	21.17	21.46	34382.0
2009-03-05	AIQ	ETF	39.2	39.55	37.85	38.05	49072.0
2009-03-05	AIS	ETF	0.34	0.39	0.34	0.36	121900.0
2009-03-05	AIVI	ETF	24.45	24.53	23.73	23.91	53900.0
2009-03-05	AOA	ETF	19.49	19.49	19.12	19.12	1800.0
2009-03-05	AOK	ETF	23.91	23.91	23.91	23.91	6827.0
2009-03-05	AOM	ETF	22.5994	22.6	22.58	22.58	1100.0
2009-03-05	AOR	ETF	21.33	21.33	20.9994	21.05	1818.0
2009-03-05	ARB	ETF	12.89	12.93	12.23	12.51	227293.0
2009-03-05	BAL	ETF	23.78	23.86	23.65	23.65	1850.0
2009-03-05	BBH	ETF	52.3967	52.8367	51.92	52.15	444600.0
2009-03-05	BIL	ETF	91.74	91.78	91.7	91.78	246000.0
2009-03-05	BITS	ETF	16.84	18.4	15.74	16.84	4665.0
2009-03-05	BIV	ETF	75.6	75.89	75.22	75.87	65600.0
2009-03-05	BJK	ETF	14.01	14.01	13.35	13.36	1900.0
2009-03-05	BKF	ETF	21.22	21.6	21.0	21.08	23452.0
2009-03-05	BLV	ETF	72.31	73.42	72.25	73.33	28600.0
2009-03-05	BMVP	ETF	8.83	8.91	8.61	8.66	76882.0
2009-03-05	BND	ETF	76.14	76.58	76.07	76.52	679700.0
2009-03-05	BNE	ETF	1.34	1.34	0.96	1.17	356669.0
2009-03-05	BSV	ETF	78.28	78.4	78.06	78.3	346200.0
2009-03-05	BTF	ETF	34.24999999999999	34.35	31.8	31.8	42661.0
2009-03-05	BWX	ETF	24.15	24.3	24.105	24.215	288844.0
2009-03-05	CBON	ETF	0.57	0.85	0.5694	0.81	35132.0
2009-03-05	CDL	ETF	0.109	0.11	0.01	0.01	18707965.0
2009-03-05	CEF	ETF	11.31	11.92	11.22	11.87	1715500.0
2009-03-05	CGO	ETF	7.93	7.98	7.35	7.58	59586.0
2009-03-05	CGW	ETF	10.78	11.15	10.55	10.62	66312.0
2009-03-05	CHB	ETF	0.28	0.3	0.2	0.2	1002990.0
2009-03-05	CHI	ETF	7.3	7.42	7.0	7.12	332817.0
2009-03-05	CHIC	ETF	4.87	5.15	4.63	5.05	945089.0
2009-03-05	CHW	ETF	4.5	4.68	4.4	4.68	239197.0
2009-03-05	CHY	ETF	7.04	7.18	6.74	6.87	425246.0
2009-03-05	CMF	ETF	50.65	51.125	50.455	50.845	11446.0
2009-03-05	CNXT	ETF	0.4	0.4	0.3501	0.36	109222.0
2009-03-05	COW	ETF	31.31	31.31	31.09	31.27	5779.0

> showing 50 of 639 rows — these rows as CSV

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