PREVIEW / etf_daily / 2008-08-26

all etf daily files

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

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-26	SPY	ETF	127.02	127.87	126.58	127.39	159117200.0
2008-08-26	QQQ	ETF	46.51	46.77	46.12	46.43	107233846.0
2008-08-26	IWM	ETF	72.18	72.58	71.46	72.17	53866300.0
2008-08-26	DIA	ETF	114.05	114.42	113.46	114.07	14475400.0
2008-08-26	GLD	ETF	80.61	81.85	80.6	81.23	8578700.0
2008-08-26	TLT	ETF	93.96	94.2	93.71	94.09	1270900.0
2008-08-26	AAXJ	ETF	48.92	48.92	48.55	48.76	5000.0
2008-08-26	ACWI	ETF	46.07	46.37	46.07	46.37	5800.0
2008-08-26	ACWX	ETF	44.8	45.078	44.7	45.01	12358.0
2008-08-26	ADRE	ETF	44.07	44.42	44.0	44.157	157809.0
2008-08-26	AFK	ETF	37.56	37.56	36.27	36.59	645.0
2008-08-26	AGG	ETF	100.52	100.73	100.44	100.57	634400.0
2008-08-26	AIA	ETF	38.37	38.59	37.89	38.15	51843.0
2008-08-26	AIQ	ETF	54.75	55.2	54.4	55.0	21164.0
2008-08-26	AIS	ETF	0.75	0.75	0.73	0.74	15228.0
2008-08-26	AIVI	ETF	54.82	55.55	54.82	55.2	15100.0
2008-08-26	ARB	ETF	47.69	48.18	47.25	47.82	202213.0
2008-08-26	BBH	ETF	66.5433	67.3733	66.5433	66.8733	179700.0
2008-08-26	BIL	ETF	91.84	91.86	91.74	91.84	143600.0
2008-08-26	BITS	ETF	23.56	24.0	23.36	23.68	37281.0
2008-08-26	BIV	ETF	76.78	76.96	76.62	76.96	69400.0
2008-08-26	BJK	ETF	28.01	28.4	28.01	28.34	1000.0
2008-08-26	BKF	ETF	43.3	43.5638	43.1	43.13	16330.0
2008-08-26	BLV	ETF	74.81	74.92	74.57	74.87	7000.0
2008-08-26	BMVP	ETF	15.12	15.24	15.11	15.18	12352.0
2008-08-26	BND	ETF	76.22	76.37	76.06	76.31	585500.0
2008-08-26	BNE	ETF	12.28	12.39	12.14	12.2	125503.0
2008-08-26	BRF	ETF	14.8	14.8	14.8	14.8	1000.0
2008-08-26	BSV	ETF	77.5	77.62	77.45	77.62	129900.0
2008-08-26	BTF	ETF	83.49999999999999	83.55	81.173	82.14999999999999	10074.0
2008-08-26	BWX	ETF	26.825	26.84	26.685	26.81	260132.0
2008-08-26	CBON	ETF	5.63	5.82	5.22	5.78	68106.0
2008-08-26	CDL	ETF	0.83	0.9399	0.81	0.88	260876.0
2008-08-26	CEF	ETF	10.6	10.79	10.55	10.61	530700.0
2008-08-26	CGO	ETF	14.14	14.32	14.0	14.22	20610.0
2008-08-26	CGW	ETF	23.1	23.1699	22.9	22.9	36205.0
2008-08-26	CHB	ETF	4.5	4.66	4.24	4.35	837272.0
2008-08-26	CHI	ETF	13.28	13.32	13.1	13.18	88613.0
2008-08-26	CHIC	ETF	11.71	12.232	11.22	12.16	318948.0
2008-08-26	CHW	ETF	10.51	10.536	10.33	10.52	220442.0
2008-08-26	CHY	ETF	12.9	12.93	12.706	12.78	123862.0
2008-08-26	CMF	ETF	51.825	51.945	51.755	51.931	14408.0
2008-08-26	CN	ETF	52.28	52.28	50.4	50.5	514396.0
2008-08-26	CNXT	ETF	5.77	5.95	5.72	5.76	338216.0
2008-08-26	COW	ETF	43.47	43.58	43.34	43.34	109788.0
2008-08-26	CPI	ETF	24.5	24.665	24.05	24.05	1300.0
2008-08-26	CPST	ETF	2.53	2.56	2.41	2.43	1586486.0
2008-08-26	CSA	ETF	19.0	19.34	18.83	19.33	65445.0
2008-08-26	CSB	ETF	19.32	19.5	19.0	19.205	23877.0
2008-08-26	CSD	ETF	21.18	21.18	21.18	21.18	500.0

> showing 50 of 604 rows — these rows as CSV

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