PREVIEW / etf_daily / 2008-07-22

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-22.parquet
  size:    27 KB
  rows:    608

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-07-22	SPY	ETF	125.15	127.8	124.85	127.48	296904200.0
2008-07-22	QQQ	ETF	44.02	44.81	43.86	44.78	152524415.0
2008-07-22	IWM	ETF	69.19	71.59	69.02	71.47	136363600.0
2008-07-22	DIA	ETF	113.96	116.08	113.75	115.7	24757900.0
2008-07-22	GLD	ETF	95.73	95.86	92.94	93.06	17553700.0
2008-07-22	TLT	ETF	90.64	90.76	90.03	90.35	2675200.0
2008-07-22	ACWI	ETF	48.0	48.2	47.81	48.13	17800.0
2008-07-22	ACWX	ETF	48.77	49.27	48.732	49.27	5517.0
2008-07-22	ADRE	ETF	48.16	48.39	47.82	48.39	705130.0
2008-07-22	AFK	ETF	41.68	41.68	40.9	41.03	5900.0
2008-07-22	AGG	ETF	99.42	99.44	99.02	99.16	302900.0
2008-07-22	AIA	ETF	41.0	41.8	40.9	41.8	29315.0
2008-07-22	AIQ	ETF	43.3	44.3	42.95	44.3	30360.0
2008-07-22	AIS	ETF	0.68	0.72	0.66	0.72	25540.0
2008-07-22	AIVI	ETF	58.86	60.0	58.86	60.0	31500.0
2008-07-22	ARB	ETF	46.6	47.63	44.07	47.57	793877.0
2008-07-22	BBH	ETF	63.6833	64.74	63.5533	64.6167	891000.0
2008-07-22	BIL	ETF	91.86	91.86	91.78	91.8	76300.0
2008-07-22	BITS	ETF	23.3352	23.8	23.24	23.36	575.0
2008-07-22	BIV	ETF	75.81	75.88	75.54	75.54	23200.0
2008-07-22	BJK	ETF	31.59	31.59	30.54	30.86	2900.0
2008-07-22	BKF	ETF	49.3	50.039	48.9	50.01	19199.0
2008-07-22	BLV	ETF	73.38	73.38	72.83	73.05	9000.0
2008-07-22	BMVP	ETF	14.72	14.97	14.71	14.96	25773.0
2008-07-22	BND	ETF	75.37	75.43	75.08	75.22	118000.0
2008-07-22	BNE	ETF	11.79	12.91	11.78	12.89	192154.0
2008-07-22	BRF	ETF	14.73	14.7401	14.72	14.7401	4700.0
2008-07-22	BSV	ETF	76.9	76.99	76.82	76.85	88400.0
2008-07-22	BTF	ETF	84.14999999999999	84.49999999999999	82.44999999999999	84.35	10035.400000000001
2008-07-22	BWX	ETF	27.9	27.985	27.683	27.765	212404.0
2008-07-22	CBON	ETF	4.53	5.49	4.3	5.39	311818.0
2008-07-22	CDL	ETF	0.78	1.02	0.78	1.0	998565.0
2008-07-22	CEF	ETF	13.57	13.57	13.17	13.21	790800.0
2008-07-22	CGO	ETF	14.96	15.12	14.85	15.12	30053.0
2008-07-22	CGW	ETF	23.49	23.7	23.288	23.7	49742.0
2008-07-22	CHB	ETF	2.9	3.27	2.84	3.23	2840326.0
2008-07-22	CHI	ETF	13.22	13.59	13.2	13.59	188320.0
2008-07-22	CHIC	ETF	13.31	14.28	13.0	14.24	1339756.0
2008-07-22	CHW	ETF	10.88	10.93	10.7772	10.92	101698.0
2008-07-22	CHY	ETF	12.7	13.0	12.51	13.0	148072.0
2008-07-22	CMF	ETF	51.455	51.455	51.31	51.41	8748.0
2008-07-22	CN	ETF	60.29	61.79	60.18	61.5	295691.0
2008-07-22	COW	ETF	43.19	43.4	43.05	43.3	73792.0
2008-07-22	CPST	ETF	3.5	3.52	3.33	3.38	4836472.0
2008-07-22	CSA	ETF	17.9	18.46	17.8	18.37	58601.0
2008-07-22	CSB	ETF	17.0	18.48	17.0	18.25	36231.0
2008-07-22	CSD	ETF	20.78	21.0	20.78	20.98	8600.0
2008-07-22	CSQ	ETF	10.64	11.05	10.64	11.05	408279.0
2008-07-22	CUT	ETF	18.55	18.79	18.51	18.79	86300.0
2008-07-22	CVY	ETF	20.05	20.52	20.0	20.52	6100.0

> showing 50 of 608 rows — these rows as CSV

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