PREVIEW / etf_daily / 2008-08-18

all etf daily files

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

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-18	SPY	ETF	130.43	130.48	127.66	128.39	172275100.0
2008-08-18	QQQ	ETF	48.29	48.31	47.26	47.6	151399004.0
2008-08-18	IWM	ETF	75.27	75.42	73.56	74.13	97838400.0
2008-08-18	DIA	ETF	116.86	116.89	114.29	114.86	23622600.0
2008-08-18	GLD	ETF	78.53	79.17	77.81	78.8	14071900.0
2008-08-18	TLT	ETF	93.08	93.54	92.96	93.41	1262200.0
2008-08-18	AAXJ	ETF	49.77	49.77	49.0	49.0	25600.0
2008-08-18	ACWI	ETF	47.15	47.15	46.47	46.62	4500.0
2008-08-18	ACWX	ETF	45.82	45.82	45.276	45.276	1818.0
2008-08-18	ADRE	ETF	44.75	44.82	43.53	43.64	295867.0
2008-08-18	AFK	ETF	37.8	37.8	37.08	37.08	5581.0
2008-08-18	AGG	ETF	100.25	100.42	100.13	100.39	526500.0
2008-08-18	AIA	ETF	39.51	39.51	38.45	38.45	26466.0
2008-08-18	AIQ	ETF	56.9	57.6	55.85	56.6	40285.0
2008-08-18	AIS	ETF	0.77	0.79	0.73	0.75	99804.0
2008-08-18	AIVI	ETF	57.44	57.65	56.59	56.63	23300.0
2008-08-18	ARB	ETF	50.0	50.28	49.28	49.75	280270.0
2008-08-18	BBH	ETF	68.4333	68.4333	67.8233	68.1	427800.0
2008-08-18	BIL	ETF	91.8	91.8	91.72	91.72	77450.0
2008-08-18	BITS	ETF	23.2	23.72	22.44	23.72	3625.0
2008-08-18	BIV	ETF	76.62	76.81	76.56	76.64	27800.0
2008-08-18	BJK	ETF	32.56	32.56	30.4	30.4	3600.0
2008-08-18	BKF	ETF	44.58	44.58	42.91	43.19	28316.0
2008-08-18	BLV	ETF	74.12	74.79	74.12	74.7	5400.0
2008-08-18	BMVP	ETF	15.45	15.45	15.212	15.24	33088.0
2008-08-18	BND	ETF	75.96	76.15	75.9	76.15	77600.0
2008-08-18	BNE	ETF	13.52	14.01	13.48	13.59	111670.0
2008-08-18	BRF	ETF	14.74	14.75	14.73	14.75	3700.0
2008-08-18	BSV	ETF	77.46	77.56	77.46	77.54	81000.0
2008-08-18	BTF	ETF	86.64999999999999	86.69999999999999	85.74999999999999	85.99999999999999	10568.2
2008-08-18	BWX	ETF	26.615	26.795	26.585	26.7475	252770.0
2008-08-18	CBON	ETF	6.78	6.91	6.48	6.85	112201.0
2008-08-18	CDL	ETF	0.9	1.03	0.8702	0.98	1134756.0
2008-08-18	CEF	ETF	10.65	10.65	10.18	10.2	1459800.0
2008-08-18	CGO	ETF	14.56	14.82	14.02	14.36	41844.0
2008-08-18	CGW	ETF	23.82	23.82	23.329	23.44	25216.0
2008-08-18	CHB	ETF	4.92	4.94	4.66	4.85	1090014.0
2008-08-18	CHI	ETF	13.45	13.48	13.21	13.28	45638.0
2008-08-18	CHIC	ETF	12.53	12.79	12.26	12.67	457703.0
2008-08-18	CHW	ETF	10.65	10.65	10.38	10.57	145374.0
2008-08-18	CHY	ETF	13.07	13.11	12.85	12.91	93988.0
2008-08-18	CMF	ETF	51.75	51.825	51.75	51.825	3580.0
2008-08-18	CN	ETF	54.07	54.11	53.13	53.4	274040.0
2008-08-18	CNXT	ETF	6.14	6.27	5.87	5.93	364308.0
2008-08-18	COW	ETF	43.85	44.32	43.77	44.04	52458.0
2008-08-18	CPI	ETF	26.0	26.0	25.35	25.35	6250.0
2008-08-18	CPST	ETF	2.65	2.66	2.5	2.53	1735821.0
2008-08-18	CSA	ETF	18.34	18.53	18.11	18.49	46632.0
2008-08-18	CSB	ETF	20.0	20.0	19.5801	19.5801	10087.0
2008-08-18	CSD	ETF	21.75	21.75	21.52	21.54	5000.0

> showing 50 of 603 rows — these rows as CSV

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