PREVIEW / etf_daily / 2008-06-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-23.parquet
  size:    27 KB
  rows:    599

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-23	SPY	ETF	132.09	132.23	131.32	131.45	165096400.0
2008-06-23	QQQ	ETF	47.62	47.74	46.98	47.05	131548505.0
2008-06-23	IWM	ETF	72.92	72.99	71.86	71.89	73028000.0
2008-06-23	DIA	ETF	118.62	118.76	118.04	118.33	13844000.0
2008-06-23	GLD	ETF	87.01	87.4	86.74	87.09	12784300.0
2008-06-23	TLT	ETF	90.08	90.43	89.83	90.0	1594100.0
2008-06-23	ACWI	ETF	50.07	50.36	50.0	50.36	11300.0
2008-06-23	ACWX	ETF	50.85	51.14	50.83	50.93	10130.0
2008-06-23	ADRE	ETF	50.6	50.9185	50.44	50.73	212728.0
2008-06-23	AGG	ETF	99.93	99.98	99.6	99.73	515600.0
2008-06-23	AIA	ETF	42.56	42.56	42.09	42.32	4550.0
2008-06-23	AIQ	ETF	46.15	46.25	44.85	45.1	89580.0
2008-06-23	AIS	ETF	0.73	0.75	0.7	0.74	31838.0
2008-06-23	AIVI	ETF	60.58	61.18	60.26	60.65	101000.0
2008-06-23	ARB	ETF	49.88	50.09	49.02	49.13	144422.0
2008-06-23	BBH	ETF	55.8867	56.2633	55.7633	56.0067	218400.0
2008-06-23	BIL	ETF	91.8	91.82	91.76	91.8	21000.0
2008-06-23	BITS	ETF	25.4	25.92	24.28	24.88	2606.0
2008-06-23	BIV	ETF	76.1	76.1	75.82	75.9	13000.0
2008-06-23	BJK	ETF	34.2	34.2	34.2	34.2	200.0
2008-06-23	BKF	ETF	52.17	52.88	52.17	52.67	37659.0
2008-06-23	BLV	ETF	73.76	73.84	73.61	73.79	1700.0
2008-06-23	BMVP	ETF	15.65	15.749	15.65	15.65	43792.0
2008-06-23	BND	ETF	75.81	75.81	75.45	75.45	99200.0
2008-06-23	BNE	ETF	14.46	14.52	14.05	14.07	74815.0
2008-06-23	BRF	ETF	14.73	14.8	14.73	14.77	5398.0
2008-06-23	BSV	ETF	76.97	77.0	76.75	76.82	51600.0
2008-06-23	BTF	ETF	97.6	97.945	95.0	95.44999999999999	5760.0
2008-06-23	BWX	ETF	27.135	27.275	27.135	27.185	352408.0
2008-06-23	CBON	ETF	6.3	6.47	5.96	5.97	89360.0
2008-06-23	CDL	ETF	1.45	1.45	1.39	1.42	544232.0
2008-06-23	CEF	ETF	12.45	12.46	12.29	12.44	612800.0
2008-06-23	CGO	ETF	15.96	15.96	15.7	15.73	16815.0
2008-06-23	CGW	ETF	24.17	24.17	23.94	23.964	90644.0
2008-06-23	CHB	ETF	6.94	7.0	6.46	6.55	1379730.0
2008-06-23	CHI	ETF	14.81	14.85	14.32	14.35	129622.0
2008-06-23	CHIC	ETF	18.28	18.76	17.62	17.73	239470.0
2008-06-23	CHW	ETF	12.09	12.14	11.65	11.8	176484.0
2008-06-23	CHY	ETF	13.94	13.95	13.27	13.5	143985.0
2008-06-23	CMF	ETF	50.78	51.04	50.635	50.64	38450.0
2008-06-23	CN	ETF	53.75	53.75	52.63	53.12	207032.0
2008-06-23	CNXT	ETF	0.5913	0.6	0.57	0.58	4058057.0
2008-06-23	COW	ETF	45.69	45.89	45.21	45.43	522576.0
2008-06-23	CPI	ETF	21.5	21.65	21.5	21.616	450.0
2008-06-23	CPST	ETF	4.19	4.42	4.19	4.32	8911175.0
2008-06-23	CSA	ETF	17.48	17.68	17.23	17.59	57284.0
2008-06-23	CSB	ETF	18.97	19.34	18.12	18.8	19041.0
2008-06-23	CSD	ETF	22.58	22.63	22.45	22.45	7200.0
2008-06-23	CSQ	ETF	12.12	12.15	12.03	12.04	219841.0
2008-06-23	CUT	ETF	20.09	20.18	19.83	19.89	24100.0

> showing 50 of 599 rows — these rows as CSV

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