PREVIEW / etf_daily / 2008-10-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-07.parquet
  size:    27 KB
  rows:    613

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-10-07	SPY	ETF	106.84	107.33	99.65	100.03	540012100.0
2008-10-07	QQQ	ETF	35.14	35.2	32.27	32.65	329540153.0
2008-10-07	IWM	ETF	60.2	60.43	55.63	55.8	152283000.0
2008-10-07	DIA	ETF	100.54	101.21	94.41	95.07	38825600.0
2008-10-07	GLD	ETF	87.18	87.7	85.53	87.27	20282100.0
2008-10-07	TLT	ETF	98.32	99.67	97.98	98.87	1972000.0
2008-10-07	AAXJ	ETF	36.01	36.03	35.7	35.7	5000.0
2008-10-07	ACWI	ETF	37.9	37.9	35.31	35.35	166000.0
2008-10-07	ACWX	ETF	39.0	39.0	33.16	33.19	58384.0
2008-10-07	ADRE	ETF	31.01	31.777	28.73	28.73	598738.0
2008-10-07	AFK	ETF	29.7	29.7	27.11	28.05	12773.0
2008-10-07	AGG	ETF	98.41	98.6	96.52	96.61	818000.0
2008-10-07	AIA	ETF	29.702	29.72	28.558	28.558	22435.0
2008-10-07	AIQ	ETF	46.55	47.7	42.6	42.85	46872.0
2008-10-07	AIS	ETF	0.7	0.7	0.5412	0.6	124805.0
2008-10-07	AIVI	ETF	46.49	46.5	42.82	42.82	58700.0
2008-10-07	ARB	ETF	42.15	43.28	40.47	40.57	382071.0
2008-10-07	BAL	ETF	34.04	34.16	34.04	34.16	700.0
2008-10-07	BBH	ETF	56.11	57.15	54.0333	54.0333	971400.0
2008-10-07	BIL	ETF	91.96	91.96	91.74	91.92	146850.0
2008-10-07	BITS	ETF	20.0004	21.12	18.08	19.44	2874.0
2008-10-07	BIV	ETF	73.57	73.74	72.83	73.58	30100.0
2008-10-07	BJK	ETF	21.4	21.4	20.9	20.9	300.0
2008-10-07	BKF	ETF	28.0	28.97	26.16	26.1732	98405.0
2008-10-07	BLV	ETF	71.8	72.24	71.62	71.79	20800.0
2008-10-07	BMVP	ETF	12.17	12.3908	11.29	11.29	84831.0
2008-10-07	BND	ETF	75.49	76.0	75.0	75.6	252000.0
2008-10-07	BNE	ETF	9.26	9.39	8.09	8.21	214049.0
2008-10-07	BOSS	ETF	15.75	16.15	15.75	16.15	200.0
2008-10-07	BRF	ETF	14.64	14.73	14.6	14.65	70080.0
2008-10-07	BSV	ETF	77.33	78.04	77.25	77.52	183800.0
2008-10-07	BTF	ETF	72.02099999999999	72.64999999999999	65.7	67.24999999999999	7413.200000000001
2008-10-07	BWX	ETF	26.0	26.4	25.605	25.605	567880.0
2008-10-07	CBON	ETF	5.93	5.93	5.43	5.43	34493.0
2008-10-07	CDL	ETF	0.56	0.59	0.5	0.52	772048.0
2008-10-07	CEF	ETF	10.97	11.05	10.34	10.84	1621400.0
2008-10-07	CGO	ETF	9.41	9.59	8.9	8.9	63689.0
2008-10-07	CGW	ETF	17.61	17.636	16.36	16.54	149076.0
2008-10-07	CHB	ETF	4.62	4.84	3.7	3.87	2035708.0
2008-10-07	CHI	ETF	9.9	9.9	7.8	8.02	358139.0
2008-10-07	CHIC	ETF	9.71	9.84	9.49	9.79	694752.0
2008-10-07	CHW	ETF	6.9	6.9	5.89	6.04	414480.0
2008-10-07	CHY	ETF	8.99	9.54	8.762	9.17	417693.0
2008-10-07	CMF	ETF	49.25	50.26	49.0	49.8025	11846.0
2008-10-07	CNXT	ETF	3.3	3.32	2.82	2.9	452058.0
2008-10-07	COW	ETF	37.95	37.97	37.74	37.816	95329.0
2008-10-07	CPI	ETF	22.36	23.05	22.36	23.05	400.0
2008-10-07	CPST	ETF	1.22	1.25	1.13	1.13	5328780.0
2008-10-07	CSA	ETF	14.78	14.9	14.23	14.23	189916.0
2008-10-07	CSB	ETF	13.7	13.7	12.45	12.9	33037.0

> showing 50 of 613 rows — these rows as CSV

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