PREVIEW / etf_daily / 2008-08-27

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-27.parquet
  size:    27 KB
  rows:    605

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
2008-08-27	SPY	ETF	127.55	128.83	127.3	128.63	171032800.0
2008-08-27	QQQ	ETF	46.45	47.09	46.29	46.73	108489879.0
2008-08-27	IWM	ETF	72.2	73.51	72.11	73.03	62031400.0
2008-08-27	DIA	ETF	114.24	115.59	113.84	115.0	15493000.0
2008-08-27	GLD	ETF	81.89	82.05	81.0	81.36	7097500.0
2008-08-27	TLT	ETF	93.49	94.29	93.44	94.25	1555300.0
2008-08-27	AAXJ	ETF	49.77	49.77	49.65	49.65	1500.0
2008-08-27	ACWI	ETF	46.53	47.76	46.37	46.7	21700.0
2008-08-27	ACWX	ETF	45.27	45.55	45.27	45.5	5367.0
2008-08-27	ADRE	ETF	43.8	45.44	43.8	45.32	181536.0
2008-08-27	AFK	ETF	37.515	37.55	37.515	37.55	327.0
2008-08-27	AGG	ETF	100.58	100.88	100.39	100.69	334400.0
2008-08-27	AIA	ETF	38.62	39.0	38.62	39.0	4648.0
2008-08-27	AIQ	ETF	54.45	55.95	54.45	55.55	37802.0
2008-08-27	AIS	ETF	0.73	0.74	0.72	0.74	13300.0
2008-08-27	AIVI	ETF	55.26	55.77	55.26	55.56	21100.0
2008-08-27	ARB	ETF	47.89	48.97	47.61	48.57	186707.0
2008-08-27	BAL	ETF	43.9	44.03	43.87	43.87	900.0
2008-08-27	BBH	ETF	66.6867	66.87	66.1733	66.7867	197400.0
2008-08-27	BIL	ETF	91.8	91.86	91.78	91.84	50300.0
2008-08-27	BITS	ETF	22.76	23.68	22.76	23.44	1375.0
2008-08-27	BIV	ETF	76.57	77.03	76.5	77.02	27900.0
2008-08-27	BJK	ETF	28.9	29.0	28.21	28.21	1000.0
2008-08-27	BKF	ETF	43.12	44.47	43.12	44.47	22595.0
2008-08-27	BLV	ETF	74.48	74.95	74.45	74.95	9500.0
2008-08-27	BMVP	ETF	15.26	15.37	15.26	15.31	15899.0
2008-08-27	BND	ETF	76.07	76.36	76.02	76.33	391900.0
2008-08-27	BNE	ETF	12.22	12.41	12.16	12.24	193797.0
2008-08-27	BSV	ETF	77.51	77.73	77.41	77.73	62400.0
2008-08-27	BTF	ETF	82.35	82.75	81.4	82.50049999999999	3572.0
2008-08-27	BWX	ETF	26.725	26.8	26.655	26.69	115678.0
2008-08-27	CBON	ETF	5.74	5.75	5.5	5.59	43156.0
2008-08-27	CDL	ETF	0.94	0.96	0.81	0.91	234335.0
2008-08-27	CEF	ETF	10.74	10.85	10.64	10.7	766200.0
2008-08-27	CGO	ETF	14.44	14.54	14.26	14.39	13293.0
2008-08-27	CGW	ETF	22.86	23.18	22.83	23.08	57680.0
2008-08-27	CHB	ETF	4.36	4.72	4.34	4.71	864925.0
2008-08-27	CHI	ETF	13.15	13.3	13.1	13.3	74480.0
2008-08-27	CHIC	ETF	12.26	12.4	12.106	12.37	294951.0
2008-08-27	CHW	ETF	10.69	10.69	10.4	10.54	143638.0
2008-08-27	CHY	ETF	13.4	13.4	12.7401	12.99	118549.0
2008-08-27	CMF	ETF	51.94	51.95	51.8075	51.95	18544.0
2008-08-27	CN	ETF	50.85	51.99	50.63	51.85	464783.0
2008-08-27	CNXT	ETF	5.77	5.94	5.76	5.92	289080.0
2008-08-27	COW	ETF	43.14	43.14	41.84	41.87	251539.0
2008-08-27	CPI	ETF	24.1	24.1	24.0501	24.0501	1200.0
2008-08-27	CPST	ETF	2.43	2.57	2.43	2.52	1944029.0
2008-08-27	CSA	ETF	19.22	19.39	19.01	19.13	45229.0
2008-08-27	CSB	ETF	18.49	18.9999	18.44	18.75	20581.0
2008-08-27	CSD	ETF	21.34	21.58	21.34	21.55	1600.0

> showing 50 of 605 rows — these rows as CSV

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