PREVIEW / etf_daily / 2008-07-31

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-31.parquet
  size:    27 KB
  rows:    610

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-07-31	SPY	ETF	127.4	128.57	126.63	126.83	277402100.0
2008-07-31	QQQ	ETF	45.11	46.15	45.02	45.46	180730831.0
2008-07-31	IWM	ETF	70.82	72.01	70.74	71.32	95287500.0
2008-07-31	DIA	ETF	114.72	115.56	113.58	113.7	24805900.0
2008-07-31	GLD	ETF	91.05	91.14	89.87	90.08	10976400.0
2008-07-31	TLT	ETF	91.72	92.05	91.27	91.67	3898700.0
2008-07-31	ACWI	ETF	48.03	48.32	47.86	47.86	9300.0
2008-07-31	ACWX	ETF	49.1	49.1	48.32	48.33	11645.0
2008-07-31	ADRE	ETF	47.84	48.02	47.37	47.44	691960.0
2008-07-31	AFK	ETF	41.83	41.83	39.61	40.64	5200.0
2008-07-31	AGG	ETF	100.37	100.65	100.11	100.41	559600.0
2008-07-31	AIA	ETF	41.06	41.0899	40.7532	40.7532	16057.0
2008-07-31	AIQ	ETF	46.0	47.75	45.9	47.4	33722.0
2008-07-31	AIS	ETF	0.79	0.83	0.7899	0.82	144159.0
2008-07-31	AIVI	ETF	59.18	59.45	58.79	58.83	22600.0
2008-07-31	ARB	ETF	46.55	47.41	46.03	47.0	215405.0
2008-07-31	BAL	ETF	46.41	46.43	46.41	46.43	430.0
2008-07-31	BBH	ETF	67.19	68.2067	66.8767	67.45	495300.0
2008-07-31	BIL	ETF	91.84	91.86	91.78	91.86	48650.0
2008-07-31	BITS	ETF	20.92	22.68	20.08	22.64	3448.0
2008-07-31	BIV	ETF	76.39	76.47	76.25	76.45	33500.0
2008-07-31	BJK	ETF	30.5	31.49	30.5	31.49	900.0
2008-07-31	BKF	ETF	49.1	49.25	48.42	48.42	40167.0
2008-07-31	BLV	ETF	74.09	74.09	73.81	74.07	3500.0
2008-07-31	BMVP	ETF	15.033	15.166	15.007	15.027	61196.0
2008-07-31	BND	ETF	75.99	76.0	75.85	75.97	120300.0
2008-07-31	BNE	ETF	12.86	13.19	12.81	12.93	231911.0
2008-07-31	BRF	ETF	14.73	14.73	14.72	14.73	4744.0
2008-07-31	BSV	ETF	77.32	77.52	77.31	77.46	66600.0
2008-07-31	BTF	ETF	83.14999999999999	83.6495	83.0	83.0	3252.0
2008-07-31	BWX	ETF	27.95	27.95	27.815	27.879	114028.0
2008-07-31	CBON	ETF	4.4	4.94	4.4	4.81	310979.0
2008-07-31	CDL	ETF	0.88	0.92	0.795	0.89	1486165.0
2008-07-31	CEF	ETF	12.97	13.1	12.89	12.94	433500.0
2008-07-31	CGO	ETF	15.04	15.3	15.02	15.1	16894.0
2008-07-31	CGW	ETF	23.14	23.51	23.09	23.2099	51120.0
2008-07-31	CHB	ETF	3.89	4.04	3.67	3.95	1913392.0
2008-07-31	CHI	ETF	13.32	13.44	13.25	13.26	116490.0
2008-07-31	CHIC	ETF	12.76	13.25	12.59	12.96	469532.0
2008-07-31	CHW	ETF	10.98	11.15	10.93	11.04	130820.0
2008-07-31	CHY	ETF	13.0	13.0	12.68	12.69	89173.0
2008-07-31	CMF	ETF	50.995	51.12	50.995	51.12	31164.0
2008-07-31	CN	ETF	61.23	62.37	60.52	60.58	161860.0
2008-07-31	CNXT	ETF	4.26	4.81	4.12	4.77	260252.0
2008-07-31	COW	ETF	43.35	43.88	43.35	43.8	58129.0
2008-07-31	CPI	ETF	22.5	22.87	22.5	22.5	1004.0
2008-07-31	CPST	ETF	3.2	3.22	3.06	3.06	2908355.0
2008-07-31	CSA	ETF	18.29	18.8	17.94	18.8	43991.0
2008-07-31	CSB	ETF	18.73	19.04	18.5	19.03	31643.0
2008-07-31	CSD	ETF	20.96	21.34	20.96	21.26	2500.0

> showing 50 of 610 rows — these rows as CSV

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