PREVIEW / etf_daily / 2008-09-29

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-29.parquet
  size:    27 KB
  rows:    617

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-29	SPY	ETF	119.14	119.34	110.97	111.38	459562300.0
2008-09-29	QQQ	ETF	40.26	40.38	37.18	37.82	307954348.0
2008-09-29	IWM	ETF	69.23	70.33	65.05	65.05	150003200.0
2008-09-29	DIA	ETF	109.83	109.99	104.01	104.75	36211100.0
2008-09-29	GLD	ETF	87.06	92.0	86.97	89.57	40569700.0
2008-09-29	TLT	ETF	95.17	97.93	95.16	97.25	4799800.0
2008-09-29	AAXJ	ETF	41.1	41.18	39.6	39.6	6900.0
2008-09-29	ACWI	ETF	42.85	43.53	39.45	39.83	71800.0
2008-09-29	ACWX	ETF	40.54	500.0	35.0	38.1	48359.0
2008-09-29	ADRE	ETF	38.6	38.6	33.7	34.62	473175.0
2008-09-29	AFK	ETF	32.35	32.68	30.87	30.87	3275.0
2008-09-29	AGG	ETF	98.55	99.22	97.0	98.26	751500.0
2008-09-29	AIA	ETF	36.46	36.46	31.6899	31.951	8439.0
2008-09-29	AIQ	ETF	53.35	54.0	51.65	51.75	42067.0
2008-09-29	AIS	ETF	0.71	0.73	0.6699	0.7	104500.0
2008-09-29	AIVI	ETF	51.62	51.62	47.45	47.58	127400.0
2008-09-29	ARB	ETF	46.74	47.07	45.81	45.94	342029.0
2008-09-29	BAL	ETF	35.87	36.14	35.63	35.666	16443.0
2008-09-29	BBH	ETF	62.6467	63.0667	58.2667	58.2667	584400.0
2008-09-29	BIL	ETF	92.1	94.56	91.4	92.48	388850.0
2008-09-29	BITS	ETF	22.24	22.24	19.92	21.2	2051.0
2008-09-29	BIV	ETF	74.92	75.45	74.37	74.37	73100.0
2008-09-29	BJK	ETF	25.25	25.25	23.0	24.5	1300.0
2008-09-29	BKF	ETF	36.03	36.03	31.354	32.0	188416.0
2008-09-29	BLV	ETF	72.44	72.92	71.5	72.65	17900.0
2008-09-29	BMVP	ETF	13.48	13.79	12.89	13.17	48919.0
2008-09-29	BND	ETF	76.99	76.99	75.72	76.49	461600.0
2008-09-29	BNE	ETF	11.76	11.85	11.12	11.23	139695.0
2008-09-29	BRF	ETF	14.69	14.695	14.6	14.67	38450.0
2008-09-29	BSV	ETF	78.17	79.4	76.85	77.63	243200.0
2008-09-29	BTF	ETF	78.05	78.05	69.8	70.05	16828.8
2008-09-29	BWX	ETF	26.675	26.695	25.8	25.835	175520.0
2008-09-29	CBON	ETF	7.1	7.1	5.21	6.69	62556.0
2008-09-29	CDL	ETF	0.81	0.9	0.67	0.71	420972.0
2008-09-29	CEF	ETF	11.13	11.84	11.03	11.47	2728200.0
2008-09-29	CGO	ETF	11.26	11.64	9.1682	10.65	35992.0
2008-09-29	CGW	ETF	22.51	22.51	19.0	19.51	152445.0
2008-09-29	CHB	ETF	6.08	6.12	5.28	5.53	1265945.0
2008-09-29	CHI	ETF	11.48	11.48	10.25	10.52	175080.0
2008-09-29	CHIC	ETF	11.11	11.45	10.41	10.55	706138.0
2008-09-29	CHW	ETF	8.44	8.44	7.01	7.33	306360.0
2008-09-29	CHY	ETF	10.02	10.1199	8.7	8.87	451021.0
2008-09-29	CMF	ETF	50.565	51.005	46.5993	50.275	35862.0
2008-09-29	CN	ETF	43.15	43.5	39.83	41.44	455248.0
2008-09-29	CNXT	ETF	3.25	3.25	2.68	2.88	526798.0
2008-09-29	COW	ETF	40.62	40.756	39.58	39.75	160205.0
2008-09-29	CPI	ETF	23.25	23.25	22.8	22.8	3700.0
2008-09-29	CPST	ETF	1.24	1.31	1.15	1.31	6168541.0
2008-09-29	CSA	ETF	17.3	17.89	17.01	17.15	266833.0
2008-09-29	CSB	ETF	14.25	14.25	12.6	13.49	62852.0

> showing 50 of 617 rows — these rows as CSV

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