PREVIEW / etf_daily / 2008-12-08

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-08.parquet
  size:    28 KB
  rows:    633

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-12-08	SPY	ETF	90.34	92.38	88.08	91.0	412859300.0
2008-12-08	QQQ	ETF	29.55	30.46	29.44	30.08	185853287.0
2008-12-08	IWM	ETF	47.23	48.57	46.97	48.14	99336100.0
2008-12-08	DIA	ETF	88.32	90.39	88.0	89.12	44114800.0
2008-12-08	GLD	ETF	76.48	76.62	75.4	76.2	7267700.0
2008-12-08	TLT	ETF	110.48	111.25	109.69	110.24	2119500.0
2008-12-08	AAXJ	ETF	31.96	32.51	31.66	32.48	41800.0
2008-12-08	ACWI	ETF	30.24	32.75	30.24	30.98	812500.0
2008-12-08	ACWX	ETF	28.21	28.8982	28.11	28.69	183878.0
2008-12-08	ADRE	ETF	25.5	26.58	25.5	26.21	265957.0
2008-12-08	AFK	ETF	20.41	20.41	20.06	20.07	800.0
2008-12-08	AGG	ETF	99.82	99.82	99.0	99.19	653600.0
2008-12-08	AGQ	ETF	52.24	54.28	49.72	51.1	5600.0
2008-12-08	AGZ	ETF	105.81	105.81	105.64	105.74	6581.0
2008-12-08	AIA	ETF	26.02	26.03	24.68	25.11	41518.0
2008-12-08	AIQ	ETF	33.3	34.35	32.7	33.0	64859.0
2008-12-08	AIS	ETF	0.37	0.38	0.36	0.37	41406.0
2008-12-08	AIVI	ETF	35.18	36.25	35.18	35.79	27000.0
2008-12-08	AOA	ETF	23.6	23.93	22.99	23.64	33200.0
2008-12-08	AOK	ETF	28.0	28.0	25.21	25.21	3405.0
2008-12-08	AOM	ETF	24.92	25.95	24.754	25.75	24508.0
2008-12-08	AOR	ETF	24.49	28.0	24.1	24.5	250523.0
2008-12-08	ARB	ETF	12.86	13.59	12.68	12.78	507354.0
2008-12-08	BAL	ETF	25.15	26.08	25.15	26.06	11000.0
2008-12-08	BBH	ETF	54.11	54.9967	53.9067	54.6767	327600.0
2008-12-08	BIL	ETF	91.8	91.86	91.74	91.78	190000.0
2008-12-08	BITS	ETF	16.8	17.2	15.88	17.0	4170.0
2008-12-08	BIV	ETF	75.11	75.34	74.95	75.02	87000.0
2008-12-08	BKF	ETF	24.53	24.87	24.0822	24.74	67563.0
2008-12-08	BLV	ETF	74.02	74.14	73.39	73.57	9200.0
2008-12-08	BMVP	ETF	10.6	10.6	10.3	10.46	99798.0
2008-12-08	BND	ETF	75.77	76.03	75.3	75.38	180600.0
2008-12-08	BNE	ETF	3.69	4.25	3.65	4.05	260379.0
2008-12-08	BOSS	ETF	13.5	13.5	12.7	12.7	700.0
2008-12-08	BRF	ETF	15.02	15.08	15.01	15.06	34100.0
2008-12-08	BSV	ETF	78.41	78.68	77.78	78.63	157600.0
2008-12-08	BTF	ETF	47.5	51.1	47.5	50.14999999999999	26672.4
2008-12-08	BWX	ETF	25.275	25.46	25.275	25.45	273216.0
2008-12-08	CBON	ETF	2.5	2.5	2.1	2.17	28605.0
2008-12-08	CDL	ETF	0.18	0.2	0.18	0.2	772486.0
2008-12-08	CEF	ETF	9.5	9.55	9.18	9.35	811100.0
2008-12-08	CGO	ETF	8.43	8.43	8.17	8.26	29041.0
2008-12-08	CGW	ETF	13.85	14.3	13.84	14.126	118583.0
2008-12-08	CHB	ETF	0.75	0.89	0.69	0.76	1555897.0
2008-12-08	CHI	ETF	7.29	8.5	7.1	8.5	464527.0
2008-12-08	CHIC	ETF	6.04	6.15	5.7	5.94	242643.0
2008-12-08	CHW	ETF	4.87	5.09	4.78	4.98	267823.0
2008-12-08	CHY	ETF	7.49	7.49	6.72	6.8301	307532.0
2008-12-08	CMF	ETF	48.99	48.99	48.2675	48.53	4304.0
2008-12-08	CNXT	ETF	1.05	1.1	1.01	1.08	294330.0

> showing 50 of 633 rows — these rows as CSV

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