PREVIEW / etf_daily / 2008-03-24

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-24.parquet
  size:    26 KB
  rows:    578

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-24	SPY	ETF	133.31	135.81	133.24	134.72	208977300.0
2008-03-24	QQQ	ETF	43.28	44.76	43.28	44.5799	125075618.0
2008-03-24	IWM	ETF	68.17	70.35	67.95	69.99	90751700.0
2008-03-24	DIA	ETF	124.05	126.1	123.96	125.34	15254400.0
2008-03-24	GLD	ETF	90.65	91.51	89.78	90.1	14325700.0
2008-03-24	TLT	ETF	96.48	96.48	95.2	95.3	5596200.0
2008-03-24	ADRE	ETF	47.22	48.6	47.22	48.05	588775.0
2008-03-24	AGG	ETF	102.88	102.88	102.35	102.66	423000.0
2008-03-24	AIA	ETF	41.66	43.88	41.66	43.55	26300.0
2008-03-24	AIQ	ETF	44.85	44.85	43.75	44.1	28924.0
2008-03-24	AIS	ETF	0.86	0.96	0.86	0.95	88500.0
2008-03-24	AIVI	ETF	62.01	63.28	61.8	62.88	46600.0
2008-03-24	ARB	ETF	42.45	43.27	42.37	42.87	308700.0
2008-03-24	BBH	ETF	56.0967	56.8667	55.97	56.6567	341100.0
2008-03-24	BIL	ETF	91.96	91.96	91.86	91.86	38750.0
2008-03-24	BITS	ETF	21.16	22.6	21.12	22.48	15408.0
2008-03-24	BIV	ETF	79.7	79.7	78.49	78.62	85400.0
2008-03-24	BJK	ETF	39.95	39.95	39.52	39.52	700.0
2008-03-24	BKF	ETF	47.1	48.85	47.1	47.92	43600.0
2008-03-24	BLV	ETF	76.76	77.3	76.76	76.76	24300.0
2008-03-24	BMVP	ETF	15.47	15.7106	15.47	15.65	91900.0
2008-03-24	BND	ETF	79.01	79.01	77.43	77.58	300600.0
2008-03-24	BNE	ETF	15.37	15.96	15.31	15.82	229191.0
2008-03-24	BRF	ETF	14.62	14.65	14.6	14.64	18000.0
2008-03-24	BSV	ETF	78.67	78.71	78.52	78.67	167200.0
2008-03-24	BTF	ETF	100.39999999999999	101.35	100.39999999999999	100.8	2867.0
2008-03-24	BWX	ETF	28.345	28.594	27.95	28.225	449862.0
2008-03-24	CBON	ETF	12.32	13.76	12.24	13.33	82586.0
2008-03-24	CDL	ETF	1.54	1.7401	1.54	1.69	1570041.0
2008-03-24	CEF	ETF	12.48	12.7	12.25	12.6	1388000.0
2008-03-24	CGO	ETF	16.53	16.5304	16.0	16.17	39598.0
2008-03-24	CGW	ETF	22.89	23.47	22.88	23.36	43584.0
2008-03-24	CHB	ETF	9.65	10.72	9.62	10.68	2913808.0
2008-03-24	CHI	ETF	13.34	14.18	13.34	13.94	210300.0
2008-03-24	CHIC	ETF	19.89	20.3379	19.77	19.99	472833.0
2008-03-24	CHW	ETF	10.98	11.57	10.96	11.27	203154.0
2008-03-24	CHY	ETF	12.34	13.2	12.3188	12.75	261728.0
2008-03-24	CMF	ETF	51.495	51.51	51.31	51.312	26000.0
2008-03-24	CN	ETF	52.9	55.22	52.9	53.97	389747.0
2008-03-24	CNXT	ETF	0.535	0.56	0.52	0.54	3868091.0
2008-03-24	COW	ETF	41.94	42.14	41.86	41.94	12500.0
2008-03-24	CPI	ETF	18.55	18.55	18.47	18.47	1100.0
2008-03-24	CPST	ETF	1.84	1.95	1.84	1.9	1439548.0
2008-03-24	CSA	ETF	15.38	15.97	15.38	15.74	32700.0
2008-03-24	CSD	ETF	23.71	23.71	23.11	23.44	20700.0
2008-03-24	CSQ	ETF	11.9	12.3	11.9	12.18	453298.0
2008-03-24	CUT	ETF	20.3	20.75	20.26	20.58	17100.0
2008-03-24	CVY	ETF	22.42	22.81	22.42	22.64	30000.0
2008-03-24	CWI	ETF	23.8667	24.84	23.8667	24.6867	122400.0
2008-03-24	CZA	ETF	23.01	23.01	23.01	23.01	400.0

> showing 50 of 578 rows — these rows as CSV

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