PREVIEW / etf_daily / 2008-08-29

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-29.parquet
  size:    27 KB
  rows:    609

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-29	SPY	ETF	129.73	130.14	128.51	128.79	189195800.0
2008-08-29	QQQ	ETF	46.61	47.1217	45.92	46.12	133272097.0
2008-08-29	IWM	ETF	74.17	74.52	73.53	73.87	83919800.0
2008-08-29	DIA	ETF	116.51	117.04	115.4	115.45	15914200.0
2008-08-29	GLD	ETF	82.31	82.47	81.58	81.71	5124800.0
2008-08-29	TLT	ETF	94.02	94.16	93.51	93.84	1739100.0
2008-08-29	AAXJ	ETF	49.39	49.39	49.33	49.33	400.0
2008-08-29	ACWI	ETF	47.43	47.45	47.03	47.06	25100.0
2008-08-29	ACWX	ETF	46.13	46.19	45.9	45.952	291095.0
2008-08-29	ADRE	ETF	45.19	45.7	44.731	45.7	147273.0
2008-08-29	AFK	ETF	39.48	39.48	38.29	38.5	1985.0
2008-08-29	AGG	ETF	101.26	101.26	100.42	100.75	701500.0
2008-08-29	AIA	ETF	38.83	38.83	38.1868	38.25	14072.0
2008-08-29	AIQ	ETF	57.0	58.05	56.875	58.05	53160.0
2008-08-29	AIS	ETF	0.73	0.75	0.72	0.75	22710.0
2008-08-29	AIVI	ETF	56.75	56.96	56.35	56.5	16400.0
2008-08-29	ARB	ETF	48.75	48.9	47.85	47.96	108648.0
2008-08-29	BAL	ETF	43.94	44.02	43.37	43.53	26800.0
2008-08-29	BBH	ETF	66.44	67.2367	66.44	66.6567	543600.0
2008-08-29	BIL	ETF	91.86	91.86	91.76	91.8	46150.0
2008-08-29	BITS	ETF	24.11	24.11	23.64	23.96	1848.0
2008-08-29	BIV	ETF	77.11	77.11	76.55	76.56	47900.0
2008-08-29	BJK	ETF	27.81	29.88	27.81	29.88	1100.0
2008-08-29	BKF	ETF	44.84	44.84	43.99	43.99	18210.0
2008-08-29	BLV	ETF	75.2	75.2	74.44	74.68	3300.0
2008-08-29	BMVP	ETF	15.5	15.5	15.3	15.3	24872.0
2008-08-29	BND	ETF	76.81	76.81	76.19	76.3	110900.0
2008-08-29	BNE	ETF	12.58	12.58	12.02	12.1	133209.0
2008-08-29	BRF	ETF	14.75	14.79	14.73	14.79	13800.0
2008-08-29	BSV	ETF	77.84	77.85	77.44	77.56	92500.0
2008-08-29	BTF	ETF	84.39999999999999	84.45	83.3005	83.45	3893.6000000000004
2008-08-29	BWX	ETF	26.78	26.915	26.63	26.63	169054.0
2008-08-29	CBON	ETF	5.75	6.0	5.02	5.26	333224.0
2008-08-29	CDL	ETF	0.99	1.0	0.92	0.9799	330162.0
2008-08-29	CEF	ETF	10.97	10.97	10.68	10.69	444300.0
2008-08-29	CGO	ETF	14.58	14.6352	14.51	14.55	6008.0
2008-08-29	CGW	ETF	23.43	23.58	23.2501	23.43	21253.0
2008-08-29	CHB	ETF	5.0	5.0	4.75	4.89	860111.0
2008-08-29	CHI	ETF	13.5	13.5	13.32	13.4	63159.0
2008-08-29	CHIC	ETF	12.03	12.04	11.74	11.81	462535.0
2008-08-29	CHW	ETF	10.56	10.63	10.47	10.63	123633.0
2008-08-29	CHY	ETF	13.1	13.12	13.02	13.11	50942.0
2008-08-29	CMF	ETF	51.865	51.94	51.515	51.93	19010.0
2008-08-29	CN	ETF	48.36	48.36	47.19	47.77	184725.0
2008-08-29	CNXT	ETF	6.02	6.02	5.86	5.89	244432.0
2008-08-29	COW	ETF	41.56	42.2	41.56	41.99	73665.0
2008-08-29	CPI	ETF	24.79	25.0	24.45	25.0	10068.0
2008-08-29	CPST	ETF	2.78	2.78	2.61	2.72	2071293.0
2008-08-29	CSA	ETF	19.75	19.87	19.42	19.42	37388.0
2008-08-29	CSB	ETF	18.44	18.6	18.01	18.4	18025.0

> showing 50 of 609 rows — these rows as CSV

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