PREVIEW / etf_daily / 2009-01-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-26.parquet
  size:    28 KB
  rows:    630

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-26	SPY	ETF	83.59	85.36	82.81	83.68	317978800.0
2009-01-26	QQQ	ETF	28.96	29.59	28.75	29.11	140480978.0
2009-01-26	IWM	ETF	44.36	45.87	44.18	44.89	62967900.0
2009-01-26	DIA	ETF	80.86	82.29	80.19	81.07	28917300.0
2009-01-26	GLD	ETF	89.22	90.19	88.68	88.95	19129500.0
2009-01-26	TLT	ETF	107.43	107.82	106.3	106.75	2240900.0
2009-01-26	AAXJ	ETF	30.37	30.83	29.92	30.03	48200.0
2009-01-26	ACWI	ETF	28.75	29.43	28.63	29.02	350300.0
2009-01-26	ACWX	ETF	26.57	27.11	26.36	26.66	182878.0
2009-01-26	ADRE	ETF	25.4	26.0372	25.22	25.4	386163.0
2009-01-26	AFK	ETF	17.92	18.19	17.92	18.19	2310.0
2009-01-26	AGG	ETF	101.73	102.07	100.88	101.82	550800.0
2009-01-26	AGQ	ETF	70.44	72.8	70.02	70.22	45550.0
2009-01-26	AGZ	ETF	107.89	107.92	107.691	107.92	3257.0
2009-01-26	AIA	ETF	23.23	23.23	22.7	22.83	29634.0
2009-01-26	AIQ	ETF	41.95	43.15	41.75	42.35	32919.0
2009-01-26	AIS	ETF	0.48	0.49	0.45	0.48	73200.0
2009-01-26	AIVI	ETF	28.53	29.03	28.3	28.68	18500.0
2009-01-26	AOA	ETF	22.3	22.57	21.83	22.57	7600.0
2009-01-26	AOK	ETF	24.85	25.13	24.85	25.13	200.0
2009-01-26	AOM	ETF	24.34	24.44	24.04	24.44	1160.0
2009-01-26	AOR	ETF	23.43	23.7	23.29	23.59	2236.0
2009-01-26	ARB	ETF	14.2	15.18	14.08	14.41	212571.0
2009-01-26	BAL	ETF	30.18	31.24	30.18	30.7	4950.0
2009-01-26	BBH	ETF	56.37	57.1733	55.75	55.91	178200.0
2009-01-26	BIL	ETF	91.8	91.8	91.68	91.76	98500.0
2009-01-26	BITS	ETF	19.6	19.6	17.2	19.56	545.0
2009-01-26	BIV	ETF	77.55	78.08	76.63	77.19	92200.0
2009-01-26	BJK	ETF	15.93	16.12	15.93	16.12	300.0
2009-01-26	BKF	ETF	22.01	22.742	21.93	22.445	13556.0
2009-01-26	BLV	ETF	76.01	76.37	73.62	75.25	25200.0
2009-01-26	BMVP	ETF	10.233	10.448	10.19	10.303	44650.0
2009-01-26	BND	ETF	77.53	77.79	77.15	77.3	265600.0
2009-01-26	BNE	ETF	2.73	2.77	2.22	2.32	873108.0
2009-01-26	BSV	ETF	79.66	79.69	78.5	78.66	238800.0
2009-01-26	BTF	ETF	45.849999999999994	46.95	44.699999999999996	45.449999999999996	8372.6
2009-01-26	BWX	ETF	25.615	25.625	25.4774	25.55	448786.0
2009-01-26	CBON	ETF	2.38	2.72	2.35	2.61	11940.0
2009-01-26	CDL	ETF	0.2	0.22	0.19	0.22	472248.0
2009-01-26	CEF	ETF	11.14	11.6	11.0	11.02	1434500.0
2009-01-26	CGO	ETF	9.69	9.76	9.45	9.5247	33004.0
2009-01-26	CGW	ETF	13.03	13.14	12.69	12.79	115474.0
2009-01-26	CHB	ETF	0.54	0.59	0.51	0.54	208302.0
2009-01-26	CHI	ETF	8.9	9.13	8.9	8.91	186427.0
2009-01-26	CHIC	ETF	4.49	4.8	4.49	4.56	143356.0
2009-01-26	CHW	ETF	5.91	5.96	5.75	5.86	168729.0
2009-01-26	CHY	ETF	8.97	8.99	8.67	8.8	200455.0
2009-01-26	CMF	ETF	51.07	51.07	50.0	50.655	10260.0
2009-01-26	CNXT	ETF	0.708	0.708	0.66	0.6602	252968.0
2009-01-26	COW	ETF	32.21	32.3	31.6501	31.76	37210.0

> showing 50 of 630 rows — these rows as CSV

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