PREVIEW / etf_daily / 2008-09-04

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-04.parquet
  size:    27 KB
  rows:    610

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-09-04	SPY	ETF	126.97	127.23	123.96	124.03	340042500.0
2008-09-04	QQQ	ETF	44.85	44.91	43.66	43.66	219363713.0
2008-09-04	IWM	ETF	73.52	73.68	71.48	71.82	126675300.0
2008-09-04	DIA	ETF	114.6	114.74	111.99	112.2	35201900.0
2008-09-04	GLD	ETF	79.7	79.78	78.14	78.39	10869900.0
2008-09-04	TLT	ETF	95.0	95.56	94.81	95.53	3049800.0
2008-09-04	AAXJ	ETF	46.71	46.71	45.9	45.96	2600.0
2008-09-04	ACWI	ETF	46.18	46.18	44.57	44.57	370800.0
2008-09-04	ACWX	ETF	44.12	44.12	42.98	42.98	5254.0
2008-09-04	ADRE	ETF	42.25	42.342	40.65	40.88	477733.0
2008-09-04	AFK	ETF	37.49	37.4999	36.4	36.41	12138.0
2008-09-04	AGG	ETF	100.99	101.19	100.82	101.04	338800.0
2008-09-04	AIA	ETF	36.21	36.42	34.77	35.262	15965.0
2008-09-04	AIQ	ETF	58.05	59.0	57.35	57.65	48340.0
2008-09-04	AIS	ETF	0.76	0.78	0.75	0.77	63760.0
2008-09-04	AIVI	ETF	55.54	55.54	53.61	53.74	24900.0
2008-09-04	ARB	ETF	48.12	48.78	47.57	47.82	175102.0
2008-09-04	BAL	ETF	43.32	43.32	42.4701	42.4701	10225.0
2008-09-04	BBH	ETF	65.6167	65.7133	64.4133	64.45	551700.0
2008-09-04	BIL	ETF	91.68	91.74	91.68	91.74	55350.0
2008-09-04	BITS	ETF	22.88	24.0	22.28	22.76	1872.0
2008-09-04	BIV	ETF	77.12	77.39	76.96	77.24	68600.0
2008-09-04	BJK	ETF	28.75	29.3	28.75	29.23	700.0
2008-09-04	BKF	ETF	42.35	42.35	40.1	40.1	82444.0
2008-09-04	BLV	ETF	75.16	75.52	75.15	75.41	23600.0
2008-09-04	BMVP	ETF	14.9	14.9	14.475	14.475	24021.0
2008-09-04	BND	ETF	76.49	76.68	76.36	76.4	184500.0
2008-09-04	BNE	ETF	12.1	12.1	11.63	11.83	209537.0
2008-09-04	BRF	ETF	14.75	14.8	14.75	14.8	8400.0
2008-09-04	BSV	ETF	77.73	77.8	77.63	77.77	106200.0
2008-09-04	BTF	ETF	85.55	85.55	82.79999999999998	83.14999999999999	11614.0
2008-09-04	BWX	ETF	26.4	26.4	26.23	26.35	188062.0
2008-09-04	CBON	ETF	5.7	5.7	5.29	5.36	139510.0
2008-09-04	CDL	ETF	0.94	0.98	0.86	0.86	1092560.0
2008-09-04	CEF	ETF	10.2	10.29	10.04	10.14	631600.0
2008-09-04	CGO	ETF	14.07	14.17	13.99	14.04	11345.0
2008-09-04	CGW	ETF	23.48	23.48	21.75	21.89	157834.0
2008-09-04	CHB	ETF	5.26	5.29	4.58	4.7	1366143.0
2008-09-04	CHI	ETF	13.31	13.34	12.95	12.99	176406.0
2008-09-04	CHIC	ETF	12.35	12.95	12.35	12.57	332657.0
2008-09-04	CHW	ETF	10.5	10.5	10.2	10.4	148886.0
2008-09-04	CHY	ETF	13.06	13.06	12.67	12.68	152337.0
2008-09-04	CMF	ETF	51.95	52.085	51.92	52.0438	13360.0
2008-09-04	CN	ETF	47.8	48.43	46.64	46.77	712608.0
2008-09-04	CNXT	ETF	5.75	5.79	5.28	5.32	641963.0
2008-09-04	COW	ETF	41.65	41.812	41.6	41.73	159360.0
2008-09-04	CPI	ETF	24.88	24.88	24.88	24.88	400.0
2008-09-04	CPST	ETF	2.45	2.5	2.08	2.11	6068647.0
2008-09-04	CSA	ETF	18.73	18.92	18.12	18.28	53848.0
2008-09-04	CSB	ETF	18.96	19.0	18.37	18.95	13700.0

> showing 50 of 610 rows — these rows as CSV

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