PREVIEW / etf_daily / 2008-06-19

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-19.parquet
  size:    26 KB
  rows:    587

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-06-19	SPY	ETF	134.15	135.24	133.5	134.42	304204900.0
2008-06-19	QQQ	ETF	47.92	49.01	47.61	48.77	221366486.0
2008-06-19	IWM	ETF	73.11	73.8	72.72	73.74	105967200.0
2008-06-19	DIA	ETF	120.55	121.32	119.94	120.63	20644400.0
2008-06-19	GLD	ETF	89.37	89.5	88.39	88.42	10520500.0
2008-06-19	TLT	ETF	89.52	89.75	89.03	89.29	1700500.0
2008-06-19	ACWI	ETF	51.13	51.13	50.55	50.55	76300.0
2008-06-19	ACWX	ETF	52.13	52.13	52.13	52.13	100.0
2008-06-19	ADRE	ETF	52.49	52.71	52.15	52.48	461477.0
2008-06-19	AGG	ETF	99.91	99.99	99.56	99.56	435900.0
2008-06-19	AIA	ETF	43.39	43.7799	43.01	43.7506	39535.0
2008-06-19	AIQ	ETF	45.05	46.0	44.8	46.0	53329.0
2008-06-19	AIS	ETF	0.77	0.77	0.75	0.75	38000.0
2008-06-19	AIVI	ETF	62.49	62.54	62.0	62.45	25900.0
2008-06-19	ARB	ETF	50.15	50.66	49.74	50.45	192421.0
2008-06-19	BBH	ETF	55.1867	56.51	55.1867	56.2567	350400.0
2008-06-19	BIL	ETF	91.78	91.8	91.74	91.76	45800.0
2008-06-19	BITS	ETF	26.3996	26.76	26.04	26.08	1966.0
2008-06-19	BIV	ETF	76.12	76.17	75.67	75.81	20900.0
2008-06-19	BJK	ETF	34.34	34.34	33.55	34.09	1700.0
2008-06-19	BKF	ETF	55.62	55.62	54.22	54.76	68874.0
2008-06-19	BLV	ETF	73.58	73.84	73.24	73.51	5200.0
2008-06-19	BMVP	ETF	15.863	15.974	15.799	15.933	14161.0
2008-06-19	BND	ETF	75.71	75.79	75.5	75.56	130100.0
2008-06-19	BNE	ETF	14.67	14.79	14.57	14.71	73269.0
2008-06-19	BRF	ETF	14.73	14.75	14.73	14.75	13400.0
2008-06-19	BSV	ETF	76.88	76.98	76.73	76.81	80000.0
2008-06-19	BTF	ETF	99.35	99.85	98.6	99.22	5889.0
2008-06-19	BWX	ETF	27.185	27.185	27.04	27.04	104828.0
2008-06-19	CBON	ETF	6.13	6.18	5.77	5.95	103380.0
2008-06-19	CDL	ETF	1.51	1.51	1.43	1.45	491261.0
2008-06-19	CEF	ETF	12.56	12.64	12.48	12.51	386100.0
2008-06-19	CGO	ETF	16.0	16.0	15.76	15.96	18313.0
2008-06-19	CGW	ETF	24.33	24.75	24.33	24.61	99560.0
2008-06-19	CHB	ETF	6.86	7.21	6.86	7.1	1731212.0
2008-06-19	CHI	ETF	14.95	15.06	14.8	14.8	66535.0
2008-06-19	CHIC	ETF	17.8	18.5	17.78	18.15	320254.0
2008-06-19	CHW	ETF	12.06	12.2028	12.0272	12.2	96830.0
2008-06-19	CHY	ETF	13.99	14.0	13.76	13.82	83083.0
2008-06-19	CMF	ETF	51.68	51.68	51.405	51.555	17000.0
2008-06-19	CN	ETF	56.86	56.99	55.89	56.52	233536.0
2008-06-19	CNXT	ETF	0.5808	0.62	0.5752	0.61	3866258.0
2008-06-19	COW	ETF	44.95	44.95	44.43	44.64	633430.0
2008-06-19	CPST	ETF	4.0	4.11	3.84	4.08	4844001.0
2008-06-19	CSA	ETF	18.05	18.5	17.93	18.5	105602.0
2008-06-19	CSB	ETF	19.85	20.18	18.15	18.65	21460.0
2008-06-19	CSD	ETF	22.89	22.89	22.75	22.75	2300.0
2008-06-19	CSQ	ETF	12.24	12.35	12.15	12.33	332868.0
2008-06-19	CUT	ETF	20.38	20.44	20.26	20.3	22100.0
2008-06-19	CVY	ETF	22.05	22.05	21.75	21.91	11100.0

> showing 50 of 587 rows — these rows as CSV

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