PREVIEW / etf_daily / 2008-08-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-07.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-07	SPY	ETF	127.96	128.44	126.54	127.01	246312500.0
2008-08-07	QQQ	ETF	46.35	46.85	46.08	46.27	152805763.0
2008-08-07	IWM	ETF	71.72	72.34	70.97	71.24	89727900.0
2008-08-07	DIA	ETF	115.49	115.92	114.23	114.59	17902100.0
2008-08-07	GLD	ETF	86.64	86.78	85.51	86.09	9961700.0
2008-08-07	TLT	ETF	90.63	91.9	90.43	91.75	2765600.0
2008-08-07	ACWI	ETF	47.92	47.92	47.13	47.2	41900.0
2008-08-07	ACWX	ETF	47.37	47.68	47.09	47.13	30315.0
2008-08-07	ADRE	ETF	46.46	46.6	45.84	45.92	377737.0
2008-08-07	AFK	ETF	39.5	39.5	38.57	38.955	2000.0
2008-08-07	AGG	ETF	99.45	99.9	99.31	99.84	391300.0
2008-08-07	AIA	ETF	40.23	40.23	39.82	39.82	8390.0
2008-08-07	AIQ	ETF	53.2	53.95	52.8	53.5	50536.0
2008-08-07	AIS	ETF	0.76	0.8	0.76	0.8	23765.0
2008-08-07	AIVI	ETF	59.85	60.09	59.25	59.25	18400.0
2008-08-07	ARB	ETF	47.61	48.75	47.33	47.91	258908.0
2008-08-07	BAL	ETF	43.49	44.11	43.49	44.11	4000.0
2008-08-07	BBH	ETF	66.1433	67.2333	65.9733	66.0767	482400.0
2008-08-07	BIL	ETF	91.7	91.76	91.7	91.76	41350.0
2008-08-07	BITS	ETF	22.4	23.6	21.24	21.4	1238.0
2008-08-07	BIV	ETF	76.17	76.56	76.0	76.54	24100.0
2008-08-07	BJK	ETF	31.02	31.32	30.81	30.97	1500.0
2008-08-07	BKF	ETF	46.96	46.96	45.87	45.9701	36023.0
2008-08-07	BLV	ETF	73.31	73.88	73.22	73.85	3200.0
2008-08-07	BMVP	ETF	14.99	15.18	14.99	15.03	21936.0
2008-08-07	BND	ETF	75.31	75.76	75.24	75.73	245000.0
2008-08-07	BNE	ETF	12.6	13.0	12.27	12.37	138965.0
2008-08-07	BOSS	ETF	23.9	23.9	23.75	23.75	200.0
2008-08-07	BRF	ETF	14.7501	14.76	14.75	14.75	10449.0
2008-08-07	BSV	ETF	77.25	77.41	77.16	77.41	58300.0
2008-08-07	BTF	ETF	86.69999999999999	86.69999999999999	85.1	85.1	5435.0
2008-08-07	BWX	ETF	27.48	27.525	27.31	27.475	410894.0
2008-08-07	CBON	ETF	4.8	5.13	4.76	4.97	169970.0
2008-08-07	CDL	ETF	0.9	0.9	0.77	0.81	733050.0
2008-08-07	CEF	ETF	12.34	12.4	12.01	12.17	768500.0
2008-08-07	CGO	ETF	15.1	15.1	14.95	15.0	7052.0
2008-08-07	CGW	ETF	23.5	23.64	23.29	23.36	57074.0
2008-08-07	CHB	ETF	4.02	4.24	3.9	4.06	1185046.0
2008-08-07	CHI	ETF	13.4	13.4	13.15	13.27	126534.0
2008-08-07	CHIC	ETF	11.32	12.255	11.23	12.12	1092303.0
2008-08-07	CHW	ETF	11.02	11.02	10.75	10.89	87229.0
2008-08-07	CHY	ETF	12.98	12.98	12.75	12.79	106281.0
2008-08-07	CMF	ETF	51.035	51.25	51.01	51.106	15466.0
2008-08-07	CN	ETF	61.0	61.0	59.27	59.29	322117.0
2008-08-07	CNXT	ETF	5.2	5.73	5.2	5.62	548635.0
2008-08-07	COW	ETF	44.89	45.15	44.55	44.73	143083.0
2008-08-07	CPI	ETF	23.35	23.35	23.1	23.3161	654.0
2008-08-07	CPST	ETF	2.71	2.76	2.61	2.61	2279607.0
2008-08-07	CSA	ETF	18.9	19.05	17.94	18.24	47012.0
2008-08-07	CSB	ETF	19.4	19.7	19.0	19.65	42772.0

> showing 50 of 604 rows — these rows as CSV

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