PREVIEW / etf_daily / 2005-11-14

all etf daily files

  file:    by_date/etf_daily/2005/2005-11-14.parquet
  size:    15 KB
  rows:    285

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-11-14	SPY	ETF	123.79	124.02	123.38	123.69	45092200.0
2005-11-14	QQQ	ETF	40.77	40.86	40.603	40.714	53652320.0
2005-11-14	IWM	ETF	66.51	66.55	65.75	66.19	24330700.0
2005-11-14	DIA	ETF	106.96	107.24	106.89	107.2	3607500.0
2005-11-14	GLD	ETF	46.56	46.81	46.51	46.62	706500.0
2005-11-14	TLT	ETF	89.38	89.45	88.62	88.82	1230100.0
2005-11-14	AAA	ETF	56.42	56.71	56.42	56.71	400.0
2005-11-14	ADRE	ETF	107.79	107.79	106.9625	107.2015	11136.0
2005-11-14	AFK	ETF	25.48	25.48	25.4	25.41	12400.0
2005-11-14	AGG	ETF	99.98	100.0	99.58	99.75	530600.0
2005-11-14	AIQ	ETF	28.65	29.175	27.7	28.0	20460.0
2005-11-14	AIS	ETF	1.2	1.2399	1.2	1.23	103500.0
2005-11-14	AOM	ETF	3.48	3.48	3.4	3.4	11900.0
2005-11-14	ARB	ETF	37.74	37.9	37.3	37.52	66200.0
2005-11-14	BAB	ETF	55.64	56.14	55.39	55.6	23100.0
2005-11-14	BBC	ETF	6.5	6.79	6.5	6.62	39300.0
2005-11-14	BBH	ETF	68.0833	68.9633	68.0833	68.8667	2603700.0
2005-11-14	BCM	ETF	62.21	63.11	62.04	62.87	65800.0
2005-11-14	BITS	ETF	15.2	15.4	14.258	14.882	20844.0
2005-11-14	BKF	ETF	22.15	23.4	22.15	22.78	130400.0
2005-11-14	BNE	ETF	15.29	15.35	15.1	15.19	113400.0
2005-11-14	BRF	ETF	15.16	15.16	15.03	15.04	8700.0
2005-11-14	BTF	ETF	87.6	88.1	87.55	88.0	25100.0
2005-11-14	CBON	ETF	33.19	33.19	33.0	33.1	2140.0
2005-11-14	CDL	ETF	13.62	13.63	13.5	13.6	202100.0
2005-11-14	CEF	ETF	5.77	5.78	5.75	5.75	157800.0
2005-11-14	CEW	ETF	25.85	25.85	25.85	25.85	800.0
2005-11-14	CGO	ETF	15.0	15.01	15.0	15.0	41000.0
2005-11-14	CHB	ETF	14.92	15.0	14.6	14.76	308700.0
2005-11-14	CHI	ETF	20.28	20.39	20.2	20.25	78800.0
2005-11-14	CHIC	ETF	17.33	17.62	17.14	17.4	385098.0
2005-11-14	CHIR	ETF	44.1399	44.1999	44.0901	44.1099	946072.0
2005-11-14	CHY	ETF	16.03	16.0599	15.97	16.0	106700.0
2005-11-14	CN	ETF	33.19	33.4	33.19	33.35	23700.0
2005-11-14	CNXT	ETF	2.24	2.263	2.17	2.18	6002866.0
2005-11-14	CPST	ETF	3.16	3.42	3.03	3.16	20071717.0
2005-11-14	CSA	ETF	17.01	17.1	17.0	17.06	17000.0
2005-11-14	CSB	ETF	28.82	28.83	28.55	28.56	7500.0
2005-11-14	CSM	ETF	2.43	2.43	2.43	2.43	10800.0
2005-11-14	CSQ	ETF	13.15	13.23	13.06	13.12	357700.0
2005-11-14	CTEC	ETF	43.3	45.49999999999999	42.599999999999994	44.9	24312.2
2005-11-14	CURE	ETF	0.0688	0.0688	0.0563	0.0625	2112232.0
2005-11-14	CYB	ETF	3.6	3.7399	3.6	3.7399	2700.0
2005-11-14	DGT	ETF	64.86	64.99	64.64	64.72	900.0
2005-11-14	DIG	ETF	14.175	14.3125	14.175	14.3125	240.0
2005-11-14	DIV	ETF	12.04	12.099	11.75	11.92	46700.0
2005-11-14	DRIV	ETF	25.79	25.8	24.2	24.29	1732737.0
2005-11-14	DSI	ETF	5.93	5.935	5.89	5.89	3000.0
2005-11-14	DUSA	ETF	9.76	9.91	9.28	9.33	79733.0
2005-11-14	DVY	ETF	61.84	61.85	61.53	61.63	239800.0

> showing 50 of 285 rows — these rows as CSV

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