PREVIEW / etf_daily / 2008-06-18

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-18.parquet
  size:    26 KB
  rows:    590

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-18	SPY	ETF	134.69	135.52	133.71	134.25	265893000.0
2008-06-18	QQQ	ETF	48.26	48.45	47.83	48.02	169338079.0
2008-06-18	IWM	ETF	73.29	73.49	72.49	73.13	88091900.0
2008-06-18	DIA	ETF	121.3	121.55	120.08	120.33	18091600.0
2008-06-18	GLD	ETF	87.66	88.41	87.13	88.28	7818800.0
2008-06-18	TLT	ETF	89.29	89.97	89.09	89.82	2590000.0
2008-06-18	ACWI	ETF	51.5	51.5	51.13	51.23	9800.0
2008-06-18	ACWX	ETF	52.37	52.4	52.268	52.372	6690.0
2008-06-18	ADRE	ETF	53.01	53.03	52.08	52.59	813769.0
2008-06-18	AGG	ETF	99.86	100.09	99.73	100.07	345900.0
2008-06-18	AIA	ETF	44.06	44.07	43.447	43.8	8762.0
2008-06-18	AIQ	ETF	45.7	46.65	45.3	45.6	33536.0
2008-06-18	AIS	ETF	0.75	0.77	0.75	0.77	62946.0
2008-06-18	AIVI	ETF	62.81	62.95	62.6	62.82	11200.0
2008-06-18	ARB	ETF	50.5	50.7788	49.69	50.18	204958.0
2008-06-18	BBH	ETF	55.0967	55.8	55.0967	55.3133	148500.0
2008-06-18	BIL	ETF	91.76	91.8	91.72	91.78	76650.0
2008-06-18	BITS	ETF	27.2	27.32	25.4	25.84	4888.0
2008-06-18	BIV	ETF	76.09	76.31	75.92	76.28	83600.0
2008-06-18	BJK	ETF	34.34	34.35	34.13	34.35	600.0
2008-06-18	BKF	ETF	55.0	55.28	54.214	54.53	84114.0
2008-06-18	BLV	ETF	73.24	74.03	73.24	74.03	1400.0
2008-06-18	BMVP	ETF	15.91	15.9533	15.82	15.8767	34785.0
2008-06-18	BND	ETF	75.48	75.84	75.48	75.75	110100.0
2008-06-18	BNE	ETF	14.86	14.86	14.29	14.59	182546.0
2008-06-18	BRF	ETF	14.72	14.73	14.71	14.73	7900.0
2008-06-18	BSV	ETF	76.9	77.02	76.79	76.98	98100.0
2008-06-18	BTF	ETF	100.7	100.99999999999999	99.89999999999999	100.95	9304.0
2008-06-18	BWX	ETF	27.05	27.255	27.05	27.11	362992.0
2008-06-18	CBON	ETF	6.25	6.29	6.01	6.17	104265.0
2008-06-18	CDL	ETF	1.44	1.51	1.34	1.5	1727901.0
2008-06-18	CEF	ETF	12.32	12.46	12.18	12.45	515700.0
2008-06-18	CGO	ETF	15.95	15.98	15.81	15.98	40450.0
2008-06-18	CGW	ETF	24.54	24.75	24.42	24.53	52706.0
2008-06-18	CHB	ETF	7.17	7.25	6.8	7.03	2137958.0
2008-06-18	CHI	ETF	14.9	14.92	14.81	14.9	103820.0
2008-06-18	CHIC	ETF	18.22	18.6	17.66	17.79	263800.0
2008-06-18	CHW	ETF	12.15	12.22	11.95	12.1	122173.0
2008-06-18	CHY	ETF	13.86	13.87	13.75	13.87	109213.0
2008-06-18	CMF	ETF	51.745	51.9	51.675	51.8999	4160.0
2008-06-18	CN	ETF	58.19	58.79	57.2	58.17	317171.0
2008-06-18	CNXT	ETF	0.59	0.6	0.58	0.59	2430635.0
2008-06-18	COW	ETF	44.71	44.9	44.46	44.89	495749.0
2008-06-18	CPST	ETF	4.11	4.13	3.86	3.97	5728601.0
2008-06-18	CSA	ETF	18.73	18.95	17.89	18.05	47580.0
2008-06-18	CSB	ETF	20.71	20.75	19.6301	19.85	54555.0
2008-06-18	CSD	ETF	23.05	23.05	22.86	22.94	50600.0
2008-06-18	CSQ	ETF	12.21	12.3434	12.21	12.32	447718.0
2008-06-18	CUT	ETF	20.49	20.58	20.43	20.5	28900.0
2008-06-18	CVY	ETF	22.0	22.0	21.84	21.93	12300.0

> showing 50 of 590 rows — these rows as CSV

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