PREVIEW / etf_daily / 2008-03-28

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-28.parquet
  size:    26 KB
  rows:    574

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-03-28	SPY	ETF	132.99	133.36	131.06	131.51	180896100.0
2008-03-28	QQQ	ETF	44.03	44.34	43.33	43.49	111838105.0
2008-03-28	IWM	ETF	69.11	69.41	67.97	68.19	228800.0
2008-03-28	DIA	ETF	123.43	123.71	121.87	122.23	11109600.0
2008-03-28	GLD	ETF	91.96	92.45	91.11	91.88	8786600.0
2008-03-28	TLT	ETF	95.09	95.56	94.75	95.55	1745500.0
2008-03-28	ACWI	ETF	50.0999	50.1	50.0999	50.1	200.0
2008-03-28	ADRE	ETF	49.03	49.06	48.34	48.45	407852.0
2008-03-28	AGG	ETF	102.62	102.86	102.52	102.84	466000.0
2008-03-28	AIA	ETF	43.73	43.73	43.33	43.35	10400.0
2008-03-28	AIQ	ETF	44.15	45.1	42.9	43.0	28623.0
2008-03-28	AIS	ETF	0.92	0.95	0.92	0.9499	79612.0
2008-03-28	AIVI	ETF	64.01	64.14	63.39	63.53	17800.0
2008-03-28	ARB	ETF	42.79	42.88	42.38	42.55	275800.0
2008-03-28	BBH	ETF	57.8	58.1833	56.8467	56.9567	647700.0
2008-03-28	BIL	ETF	91.9	91.9	91.8	91.8	33900.0
2008-03-28	BITS	ETF	22.24	22.24	21.0	21.0	4700.0
2008-03-28	BIV	ETF	79.1	79.52	79.02	79.48	25400.0
2008-03-28	BJK	ETF	40.0	40.06	39.64	39.64	1000.0
2008-03-28	BKF	ETF	50.54	50.54	49.03	49.03	31600.0
2008-03-28	BLV	ETF	76.7	76.76	76.38	76.76	400.0
2008-03-28	BMVP	ETF	15.4333	15.4595	15.24	15.24	32000.0
2008-03-28	BND	ETF	78.65	78.65	77.7	77.87	78900.0
2008-03-28	BNE	ETF	15.04	15.13	14.6	14.83	304200.0
2008-03-28	BRF	ETF	14.65	14.65	14.59	14.65	12500.0
2008-03-28	BSV	ETF	78.75	78.87	78.69	78.87	58300.0
2008-03-28	BTF	ETF	100.8	100.8	99.85049999999998	100.0	5660.0
2008-03-28	BWX	ETF	28.945	29.01	28.81	28.9975	170474.0
2008-03-28	CBON	ETF	13.72	13.96	13.52	13.75	123693.0
2008-03-28	CDL	ETF	1.51	1.66	1.51	1.55	796735.0
2008-03-28	CEF	ETF	12.87	13.04	12.77	12.99	913900.0
2008-03-28	CGO	ETF	16.55	16.55	16.1	16.15	8100.0
2008-03-28	CGW	ETF	23.8	23.8	23.24	23.29	59835.0
2008-03-28	CHB	ETF	9.28	9.67	9.23	9.47	1240119.0
2008-03-28	CHI	ETF	14.15	14.27	13.5	13.5	105048.0
2008-03-28	CHIC	ETF	17.43	17.43	17.03	17.21	951990.0
2008-03-28	CHW	ETF	11.3	11.35	11.11	11.11	90291.0
2008-03-28	CHY	ETF	12.84	13.14	12.35	12.4	195102.0
2008-03-28	CMF	ETF	51.42	51.62	51.41	51.62	2600.0
2008-03-28	CN	ETF	57.75	58.26	56.21	56.69	335621.0
2008-03-28	CNXT	ETF	0.59	0.59	0.56	0.5601	2781313.0
2008-03-28	COW	ETF	41.0	41.1	40.69	40.83	20100.0
2008-03-28	CPI	ETF	17.9922	17.9922	17.75	17.75	1100.0
2008-03-28	CPST	ETF	2.18	2.28	2.11	2.11	3849840.0
2008-03-28	CSA	ETF	15.7	15.8	15.67	15.71	27800.0
2008-03-28	CSD	ETF	22.22	22.87	22.22	22.56	7600.0
2008-03-28	CSQ	ETF	12.15	12.22	12.01	12.03	250900.0
2008-03-28	CUT	ETF	21.29	21.29	20.75	20.8	10500.0
2008-03-28	CVY	ETF	22.12	22.12	21.75	21.75	13600.0
2008-03-28	CWI	ETF	24.9333	25.2333	24.9333	24.9867	65400.0

> showing 50 of 574 rows — these rows as CSV

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