PREVIEW / etf_daily / 2008-08-04

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-04.parquet
  size:    27 KB
  rows:    605

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-04	SPY	ETF	126.04	126.14	124.76	124.99	188239600.0
2008-08-04	QQQ	ETF	44.87	44.92	44.3	44.43	116306830.0
2008-08-04	IWM	ETF	71.43	71.49	69.81	70.75	104200100.0
2008-08-04	DIA	ETF	113.14	113.75	112.13	112.77	16207200.0
2008-08-04	GLD	ETF	89.08	89.68	88.04	88.14	14979800.0
2008-08-04	TLT	ETF	91.09	91.64	91.01	91.33	2029900.0
2008-08-04	ACWI	ETF	47.06	47.13	46.7	46.82	15600.0
2008-08-04	ACWX	ETF	47.59	47.62	46.96	47.11	105978.0
2008-08-04	ADRE	ETF	46.29	46.32	45.13	45.29	470891.0
2008-08-04	AFK	ETF	41.29	41.29	39.66	39.66	1246.0
2008-08-04	AGG	ETF	99.81	100.02	99.57	99.6	391600.0
2008-08-04	AIA	ETF	40.52	40.6	39.89	40.02	5950.0
2008-08-04	AIQ	ETF	51.65	52.75	50.85	51.45	68227.0
2008-08-04	AIS	ETF	0.8	0.85	0.7901	0.8	67150.0
2008-08-04	AIVI	ETF	58.28	58.28	57.58	57.87	12000.0
2008-08-04	ARB	ETF	45.97	46.28	44.72	45.72	253181.0
2008-08-04	BAL	ETF	44.0	44.0	44.0	44.0	500.0
2008-08-04	BBH	ETF	66.0533	66.0533	64.8933	65.8	640200.0
2008-08-04	BIL	ETF	91.74	91.74	91.7	91.72	190500.0
2008-08-04	BITS	ETF	21.72	21.7204	21.24	21.72	1054.0
2008-08-04	BIV	ETF	75.84	76.26	75.84	76.14	16800.0
2008-08-04	BJK	ETF	31.05	31.05	30.2	30.45	700.0
2008-08-04	BKF	ETF	47.74	47.74	46.09	46.25	45561.0
2008-08-04	BLV	ETF	73.57	73.79	73.17	73.42	6100.0
2008-08-04	BMVP	ETF	14.95	14.95	14.78	14.78	17770.0
2008-08-04	BND	ETF	75.61	75.83	75.52	75.66	190900.0
2008-08-04	BNE	ETF	12.26	12.5	12.2	12.39	155920.0
2008-08-04	BRF	ETF	14.73	14.741	14.72	14.73	24795.0
2008-08-04	BSV	ETF	77.15	77.29	77.06	77.16	51400.0
2008-08-04	BTF	ETF	84.1	84.1	83.3	83.49999999999999	2790.8
2008-08-04	BWX	ETF	27.73	27.84	27.69	27.76	440764.0
2008-08-04	CBON	ETF	4.55	4.58	3.95	4.51	178415.0
2008-08-04	CDL	ETF	0.86	0.86	0.77	0.83	946928.0
2008-08-04	CEF	ETF	12.6	12.82	12.4	12.43	521800.0
2008-08-04	CGO	ETF	15.21	15.21	15.07	15.09	6450.0
2008-08-04	CGW	ETF	23.0	23.41	22.62	22.62	48519.0
2008-08-04	CHB	ETF	3.81	3.97	3.73	3.9	1995020.0
2008-08-04	CHI	ETF	13.66	13.72	13.31	13.34	118768.0
2008-08-04	CHIC	ETF	11.01	11.02	9.9	10.49	4086215.0
2008-08-04	CHW	ETF	11.19	11.19	10.8344	10.98	87343.0
2008-08-04	CHY	ETF	13.38	13.38	12.81	12.89	116069.0
2008-08-04	CMF	ETF	51.145	51.145	51.015	51.045	5800.0
2008-08-04	CN	ETF	65.0	65.0	60.39	60.55	242598.0
2008-08-04	CNXT	ETF	5.4	5.62	5.39	5.41	869562.0
2008-08-04	COW	ETF	44.15	44.44	44.0	44.12	163577.0
2008-08-04	CPI	ETF	23.45	23.45	22.55	22.75	1675.0
2008-08-04	CPST	ETF	2.93	2.94	2.64	2.74	6674311.0
2008-08-04	CSA	ETF	18.49	18.7	18.02	18.09	56174.0
2008-08-04	CSB	ETF	19.0	19.2799	18.68	19.0	22783.0
2008-08-04	CSD	ETF	20.9	20.9	20.63	20.63	2500.0

> showing 50 of 605 rows — these rows as CSV

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