PREVIEW / etf_daily / 2008-11-26

all etf daily files

  file:    by_date/etf_daily/2008/2008-11-26.parquet
  size:    28 KB
  rows:    625

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-11-26	SPY	ETF	84.3	89.19	84.24	88.97	370134200.0
2008-11-26	QQQ	ETF	27.88	29.36	27.81	29.35	165061342.0
2008-11-26	IWM	ETF	43.27	47.03	43.2	46.87	88144900.0
2008-11-26	DIA	ETF	83.16	87.3	82.99	87.18	29776700.0
2008-11-26	GLD	ETF	80.52	80.77	79.33	80.38	9141600.0
2008-11-26	TLT	ETF	104.72	105.62	104.09	104.43	2577600.0
2008-11-26	AAXJ	ETF	28.8	30.6	28.7	30.6	217900.0
2008-11-26	ACWI	ETF	29.15	31.06	29.03	30.64	601400.0
2008-11-26	ACWX	ETF	27.17	28.6	27.17	28.594	208840.0
2008-11-26	ADRE	ETF	23.92	25.98	23.92	25.97	324352.0
2008-11-26	AFK	ETF	21.5	21.68	21.5	21.68	13480.0
2008-11-26	AGG	ETF	99.2	99.77	98.29	98.64	859500.0
2008-11-26	AGZ	ETF	104.18	104.55	104.18	104.468	2100.0
2008-11-26	AIA	ETF	23.0	24.18	22.99	24.1	71122.0
2008-11-26	AIQ	ETF	36.75	39.05	35.9	38.9	37648.0
2008-11-26	AIS	ETF	0.34	0.38	0.34	0.35	485222.0
2008-11-26	AIVI	ETF	33.73	35.1	33.73	34.93	21800.0
2008-11-26	AOA	ETF	22.3	23.31	22.3	23.29	14100.0
2008-11-26	AOK	ETF	25.765	25.765	22.89	22.89	160120.0
2008-11-26	AOM	ETF	25.38	25.38	22.13	22.55	111591.0
2008-11-26	AOR	ETF	23.39	24.8	23.39	24.35	565495.0
2008-11-26	ARB	ETF	14.03	14.48	13.18	13.35	583998.0
2008-11-26	BAL	ETF	27.5	27.5	27.0801	27.0801	300.0
2008-11-26	BBH	ETF	52.7233	53.7433	52.7233	53.7433	241500.0
2008-11-26	BIL	ETF	91.9	91.94	91.82	91.94	118100.0
2008-11-26	BITS	ETF	14.72	16.76	14.72	16.6	6124.0
2008-11-26	BIV	ETF	74.04	75.23	74.04	74.95	106500.0
2008-11-26	BJK	ETF	15.55	15.91	15.55	15.91	300.0
2008-11-26	BKF	ETF	22.54	24.0	22.33	23.9964	27468.0
2008-11-26	BLV	ETF	72.02	72.2	71.82	71.93	10400.0
2008-11-26	BMVP	ETF	9.8533	10.49	9.85	10.4391	33587.0
2008-11-26	BND	ETF	75.1	75.94	75.09	75.93	211500.0
2008-11-26	BNE	ETF	2.35	3.11	2.2	3.03	406021.0
2008-11-26	BRF	ETF	14.93	14.95	14.93	14.95	5800.0
2008-11-26	BSV	ETF	78.5	78.53	78.0	78.46	101600.0
2008-11-26	BTF	ETF	42.55	44.15	41.55	44.149499999999996	20773.2
2008-11-26	BWX	ETF	25.37	25.39	25.25	25.25	279702.0
2008-11-26	CBON	ETF	2.3	2.49	2.22	2.28	45948.0
2008-11-26	CDL	ETF	0.151	0.18	0.13	0.18	976594.0
2008-11-26	CEF	ETF	10.04	10.13	9.76	9.97	871500.0
2008-11-26	CGO	ETF	7.77	8.34	7.76	8.328	33925.0
2008-11-26	CGW	ETF	13.89	14.55	13.82	14.51	74872.0
2008-11-26	CHB	ETF	0.56	0.83	0.56	0.69	1624006.0
2008-11-26	CHI	ETF	6.74	7.45	6.6	7.36	255836.0
2008-11-26	CHIC	ETF	4.36	5.06	4.25	5.04	227266.0
2008-11-26	CHW	ETF	4.76	4.97	4.58	4.97	180991.0
2008-11-26	CHY	ETF	6.34	6.82	6.17	6.78	237132.0
2008-11-26	CMF	ETF	48.95	48.95	48.125	48.3775	13842.0
2008-11-26	CNXT	ETF	0.85	1.13	0.83	1.02	733724.0
2008-11-26	COW	ETF	34.61	35.21	34.61	35.21	4358.0

> showing 50 of 625 rows — these rows as CSV

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