PREVIEW / etf_daily / 2005-02-02

all etf daily files

  file:    by_date/etf_daily/2005/2005-02-02.parquet
  size:    14 KB
  rows:    250

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
2005-02-02	SPY	ETF	119.06	119.59	118.9	119.27	52468900.0
2005-02-02	QQQ	ETF	37.64	37.73	37.31	37.58	101911126.0
2005-02-02	IWM	ETF	62.56	62.995	62.46	62.945	17766800.0
2005-02-02	DIA	ETF	105.46	106.13	105.35	105.88	4660100.0
2005-02-02	GLD	ETF	42.22	42.23	42.02	42.16	956500.0
2005-02-02	TLT	ETF	91.2	91.46	91.09	91.43	760300.0
2005-02-02	AAA	ETF	58.46	58.46	58.38	58.4	900.0
2005-02-02	ADRE	ETF	84.95	84.95	83.5	83.89	17432.0
2005-02-02	AFK	ETF	26.4	26.43	26.35	26.43	26300.0
2005-02-02	AGG	ETF	102.72	102.8	102.6	102.78	203100.0
2005-02-02	AIQ	ETF	70.5	70.65	66.0	67.2	86960.0
2005-02-02	ARB	ETF	41.08	41.57	41.0	41.25	185000.0
2005-02-02	BAB	ETF	50.87	51.7	50.76	51.19	27800.0
2005-02-02	BBH	ETF	47.96	48.1333	47.6133	47.93	1785600.0
2005-02-02	BCM	ETF	55.43	55.45	55.1	55.42	15300.0
2005-02-02	BITS	ETF	9.16	9.88	9.0	9.36	16466.0
2005-02-02	BKF	ETF	37.55	38.1	37.5	38.1	20200.0
2005-02-02	BNE	ETF	15.07	15.31	14.95	15.31	150500.0
2005-02-02	BOSS	ETF	24.1	24.34	24.1	24.34	100.0
2005-02-02	BRF	ETF	15.62	15.64	15.58	15.59	12000.0
2005-02-02	BTF	ETF	91.89999999999999	92.14499999999998	91.69999999999999	91.99999999999999	1900.0
2005-02-02	CBON	ETF	27.75	27.9	27.3	27.69	19901.0
2005-02-02	CDC	ETF	10.8	11.15	10.8	11.05	3900.0
2005-02-02	CDL	ETF	14.0	14.14	13.97	14.11	717900.0
2005-02-02	CEF	ETF	5.29	5.38	5.27	5.33	278800.0
2005-02-02	CEW	ETF	27.45	27.45	27.45	27.45	300.0
2005-02-02	CHB	ETF	10.9	10.9	10.4	10.65	486400.0
2005-02-02	CHIC	ETF	10.81	10.89	10.58	10.89	415791.0
2005-02-02	CHIR	ETF	33.0999	33.1701	32.4501	32.76	1399370.0
2005-02-02	CID	ETF	9.19	9.19	8.97	8.97	1000.0
2005-02-02	CIL	ETF	26.35	26.35	26.21	26.32	5800.0
2005-02-02	CN	ETF	29.05	29.1	28.85	29.02	79500.0
2005-02-02	CNXT	ETF	1.6	1.63	1.57	1.57	3594338.0
2005-02-02	CPI	ETF	19.07	19.07	18.9	18.9	900.0
2005-02-02	CSB	ETF	33.7	33.8	33.69	33.8	7300.0
2005-02-02	CSM	ETF	2.38	2.38	2.38	2.38	5600.0
2005-02-02	CTEC	ETF	67.1	67.1	62.75	64.05	114715.8
2005-02-02	CURE	ETF	0.6112	0.6275	0.6112	0.625	727560.0
2005-02-02	CYA	ETF	214.0	225.2	214.0	224.4	990.0
2005-02-02	CYB	ETF	4.0	4.0	3.95	3.99	1300.0
2005-02-02	CZA	ETF	10.43	10.43	10.31	10.31	2400.0
2005-02-02	DGT	ETF	63.44	63.69	63.44	63.69	12600.0
2005-02-02	DIV	ETF	14.27	14.28	14.23	14.26	19800.0
2005-02-02	DJP	ETF	26.78	26.8	26.78	26.8	1000.0
2005-02-02	DRIV	ETF	39.04	40.48	38.54	39.22	1106788.0
2005-02-02	DSI	ETF	5.975	6.02	5.95	5.995	26000.0
2005-02-02	DTH	ETF	25.36	25.36	25.35	25.35	1200.0
2005-02-02	DUSA	ETF	13.91	13.91	13.75	13.75	25073.0
2005-02-02	DVY	ETF	60.09	60.3	59.9	60.25	505900.0
2005-02-02	EDEN	ETF	1.23	1.26	1.2	1.25	39942.0

> showing 50 of 250 rows — these rows as CSV

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