PREVIEW / etf_daily / 2008-08-22

all etf daily files

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

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-22	SPY	ETF	128.67	129.65	127.8	129.65	167715300.0
2008-08-22	QQQ	ETF	47.12	47.68	47.08	47.49	96525453.0
2008-08-22	IWM	ETF	72.75	73.81	72.62	73.68	77915300.0
2008-08-22	DIA	ETF	114.95	116.37	114.84	116.32	18078800.0
2008-08-22	GLD	ETF	81.49	81.96	80.94	81.08	7854700.0
2008-08-22	TLT	ETF	93.11	93.17	92.64	93.08	1990000.0
2008-08-22	AAXJ	ETF	49.25	49.25	49.16	49.22	3600.0
2008-08-22	ACWI	ETF	46.78	47.06	46.78	46.94	7900.0
2008-08-22	ACWX	ETF	45.59	45.73	45.34	45.38	67965.0
2008-08-22	ADRE	ETF	45.26	45.46	44.748	44.98	197240.0
2008-08-22	AFK	ETF	37.29	38.04	37.04	37.18	3639.0
2008-08-22	AGG	ETF	100.19	100.41	100.11	100.38	497800.0
2008-08-22	AIA	ETF	38.53	38.72	38.53	38.72	7782.0
2008-08-22	AIQ	ETF	55.3	55.85	54.977	55.45	22066.0
2008-08-22	AIS	ETF	0.75	0.76	0.73	0.76	21960.0
2008-08-22	AIVI	ETF	55.96	56.45	55.96	56.1	22500.0
2008-08-22	ARB	ETF	48.09	48.62	47.64	48.07	137972.0
2008-08-22	BAL	ETF	43.16	43.46	43.02	43.46	1216.0
2008-08-22	BBH	ETF	66.5967	67.3833	66.5867	67.1333	142200.0
2008-08-22	BIL	ETF	91.82	91.84	91.78	91.84	38950.0
2008-08-22	BITS	ETF	23.52	24.0	23.32	23.84	7604.0
2008-08-22	BIV	ETF	76.48	76.55	76.35	76.52	11500.0
2008-08-22	BJK	ETF	28.9	28.9	28.9	28.9	600.0
2008-08-22	BKF	ETF	44.83	44.83	43.967	44.69	72793.0
2008-08-22	BLV	ETF	74.34	74.37	74.15	74.37	5300.0
2008-08-22	BMVP	ETF	15.337	15.438	15.333	15.397	21013.0
2008-08-22	BND	ETF	75.98	76.0	75.75	76.0	146100.0
2008-08-22	BNE	ETF	12.8	12.97	12.62	12.79	166914.0
2008-08-22	BRF	ETF	14.77	14.77	14.77	14.77	200.0
2008-08-22	BSV	ETF	77.48	77.52	77.37	77.48	114300.0
2008-08-22	BTF	ETF	82.39999999999999	84.55	82.39999999999999	83.877	4583.0
2008-08-22	BWX	ETF	26.885	26.885	26.69	26.81	201268.0
2008-08-22	CBON	ETF	5.81	6.03	5.39	5.5	107108.0
2008-08-22	CDL	ETF	0.9	0.98	0.86	0.94	317869.0
2008-08-22	CEF	ETF	10.8	10.9	10.51	10.55	741900.0
2008-08-22	CGO	ETF	14.63	14.63	14.35	14.42	10309.0
2008-08-22	CGW	ETF	23.53	23.53	23.2	23.27	20703.0
2008-08-22	CHB	ETF	4.67	4.93	4.6	4.89	1105179.0
2008-08-22	CHI	ETF	13.45	13.48	13.31	13.48	131981.0
2008-08-22	CHIC	ETF	12.11	12.49	11.89	12.25	217512.0
2008-08-22	CHW	ETF	10.6	10.65	10.51	10.64	91153.0
2008-08-22	CHY	ETF	12.95	13.03	12.879	13.03	100474.0
2008-08-22	CMF	ETF	51.795	51.825	51.79	51.825	5790.0
2008-08-22	CN	ETF	53.01	53.66	53.01	53.44	243637.0
2008-08-22	CNXT	ETF	5.82	6.02	5.73	5.97	497286.0
2008-08-22	COW	ETF	43.78	43.84	43.5672	43.7	63800.0
2008-08-22	CPST	ETF	2.61	2.63	2.47	2.47	1442915.0
2008-08-22	CSA	ETF	18.18	19.14	17.8	18.96	38985.0
2008-08-22	CSB	ETF	19.5699	19.83	19.4	19.7599	7200.0
2008-08-22	CSD	ETF	21.46	21.48	21.46	21.48	400.0

> showing 50 of 606 rows — these rows as CSV

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