PREVIEW / etf_daily / 2009-01-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-08.parquet
  size:    28 KB
  rows:    635

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-01-08	SPY	ETF	90.16	91.09	89.67	91.04	263834400.0
2009-01-08	QQQ	ETF	30.34	30.8	30.08	30.76	131926048.0
2009-01-08	IWM	ETF	49.38	50.15	49.17	49.98	59214100.0
2009-01-08	DIA	ETF	87.07	87.57	86.55	87.43	23641700.0
2009-01-08	GLD	ETF	84.4	84.89	83.75	84.46	10715700.0
2009-01-08	TLT	ETF	112.64	112.92	111.99	112.56	2603600.0
2009-01-08	AAXJ	ETF	33.61	34.03	33.28	34.03	12000.0
2009-01-08	ACWI	ETF	32.47	32.63	32.16	32.5	293700.0
2009-01-08	ACWX	ETF	30.79	31.03	30.42	31.01	198675.0
2009-01-08	ADRE	ETF	27.79	28.35	27.56	28.35	136929.0
2009-01-08	AFK	ETF	21.2	21.2	21.1	21.1	12200.0
2009-01-08	AGG	ETF	103.91	104.06	102.6	102.86	1616300.0
2009-01-08	AGQ	ETF	61.4	61.52	59.64	60.66	15550.0
2009-01-08	AGZ	ETF	107.94	108.15	107.93	108.07	2072.0
2009-01-08	AIA	ETF	25.54	25.71	24.54	25.676	14096.0
2009-01-08	AIQ	ETF	42.85	43.4	41.35	43.0	67803.0
2009-01-08	AIS	ETF	0.45	0.53	0.41	0.44	158950.0
2009-01-08	AIVI	ETF	33.93	34.58	33.9	34.58	7100.0
2009-01-08	AOA	ETF	25.68	25.68	24.04	24.44	8700.0
2009-01-08	AOK	ETF	25.51	25.68	25.51	25.63	6231.0
2009-01-08	AOM	ETF	25.31	25.4	25.216	25.216	6097.0
2009-01-08	AOR	ETF	24.83	24.93	24.772	24.93	45725.0
2009-01-08	ARB	ETF	16.26	16.45	15.63	16.15	538839.0
2009-01-08	BAL	ETF	28.9699	29.3801	28.9699	29.3801	1300.0
2009-01-08	BBH	ETF	57.32	57.7133	57.0967	57.6033	124800.0
2009-01-08	BIL	ETF	91.66	91.72	91.64	91.66	64900.0
2009-01-08	BITS	ETF	19.4	19.84	18.76	19.6	238.0
2009-01-08	BIV	ETF	77.99	78.25	77.72	78.23	103200.0
2009-01-08	BJK	ETF	18.5	19.08	18.35	18.76	2000.0
2009-01-08	BKF	ETF	24.82	25.3099	24.74	25.15	46090.0
2009-01-08	BLV	ETF	77.59	77.91	77.44	77.91	10300.0
2009-01-08	BMVP	ETF	10.74	10.89	10.71	10.87	220486.0
2009-01-08	BND	ETF	78.09	78.09	77.3	77.96	305700.0
2009-01-08	BNE	ETF	5.96	6.58	5.75	6.25	359700.0
2009-01-08	BSV	ETF	80.22	80.22	79.21	79.28	118800.0
2009-01-08	BTF	ETF	53.8	54.0	52.0505	53.099999999999994	13195.2
2009-01-08	BWX	ETF	26.815	26.9	26.66	26.7664	719672.0
2009-01-08	CBON	ETF	3.0	3.08	2.85	2.85	29070.0
2009-01-08	CDL	ETF	0.219	0.29	0.21	0.24	2326721.0
2009-01-08	CEF	ETF	10.53	10.53	10.22	10.32	879200.0
2009-01-08	CGO	ETF	10.4	10.4	10.1	10.2	30610.0
2009-01-08	CGW	ETF	14.18	14.66	14.18	14.51	15858.0
2009-01-08	CHB	ETF	0.77	0.85	0.73	0.84	340694.0
2009-01-08	CHI	ETF	9.19	9.75	9.05	9.69	375737.0
2009-01-08	CHIC	ETF	6.24	6.56	5.94	6.56	152869.0
2009-01-08	CHW	ETF	6.23	6.36	6.17	6.35	258864.0
2009-01-08	CHY	ETF	9.06	9.42	9.03	9.41	333881.0
2009-01-08	CMF	ETF	51.7	51.9015	51.465	51.9015	25962.0
2009-01-08	CNXT	ETF	0.78	0.86	0.75	0.83	654983.0
2009-01-08	COW	ETF	33.9401	34.0	33.1	33.21	43516.0

> showing 50 of 635 rows — these rows as CSV

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