PREVIEW / etf_daily / 2005-07-14

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-14.parquet
  size:    15 KB
  rows:    275

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-07-14	SPY	ETF	122.98	123.44	122.49	122.91	63638800.0
2005-07-14	QQQ	ETF	38.659	38.88	38.52	38.77	103210918.0
2005-07-14	IWM	ETF	66.9	67.07	65.78	65.94	26043100.0
2005-07-14	DIA	ETF	106.07	106.57	106.04	106.42	10958900.0
2005-07-14	GLD	ETF	42.33	42.36	41.8	41.9	1642600.0
2005-07-14	TLT	ETF	94.1	94.14	93.6	93.72	874300.0
2005-07-14	AAA	ETF	51.07	51.17	50.8	50.95	3800.0
2005-07-14	ADRE	ETF	96.0	96.0	94.04	94.0401	7632.0
2005-07-14	AFK	ETF	25.87	25.91	25.76	25.9	4300.0
2005-07-14	AGG	ETF	102.36	102.38	102.06	102.24	139100.0
2005-07-14	AIQ	ETF	56.15	56.25	54.8	55.75	21760.0
2005-07-14	AIS	ETF	1.17	1.18	1.16	1.17	56000.0
2005-07-14	ARB	ETF	42.84	42.95	42.65	42.66	123500.0
2005-07-14	BAB	ETF	48.11	48.59	47.91	48.45	54700.0
2005-07-14	BBH	ETF	60.5933	61.8	60.41	61.8	3142200.0
2005-07-14	BCM	ETF	63.36	63.48	62.68	62.68	12600.0
2005-07-14	BIS	ETF	632.0	675.2	632.0	672.0	45.6
2005-07-14	BITS	ETF	13.64	13.92	13.0	13.72	7676.0
2005-07-14	BKF	ETF	36.51	36.51	35.66	35.84	10600.0
2005-07-14	BNE	ETF	14.35	14.41	14.18	14.25	115600.0
2005-07-14	BRF	ETF	15.5	15.53	15.478	15.49	6600.0
2005-07-14	BTF	ETF	87.5	87.5	87.39999999999999	87.5	720.0
2005-07-14	CBON	ETF	31.16	31.75	31.11	31.59	35952.0
2005-07-14	CDC	ETF	6.79	7.0	6.79	6.85	9000.0
2005-07-14	CDL	ETF	11.56	11.73	11.35	11.46	628800.0
2005-07-14	CEF	ETF	5.25	5.25	5.15	5.21	266800.0
2005-07-14	CEW	ETF	26.68	26.78	26.57	26.58	16500.0
2005-07-14	CHB	ETF	10.41	10.6	10.05	10.37	250900.0
2005-07-14	CHI	ETF	19.85	19.95	19.76	19.8	72800.0
2005-07-14	CHIC	ETF	13.95	14.05	13.81	13.92	332028.0
2005-07-14	CHIR	ETF	36.96	37.2801	36.5799	37.2699	690180.0
2005-07-14	CHY	ETF	16.63	16.65	16.5	16.56	130200.0
2005-07-14	CIL	ETF	25.65	25.65	25.65	25.65	300.0
2005-07-14	CIZ	ETF	22.5	22.6	22.5	22.6	300.0
2005-07-14	CN	ETF	30.2	30.45	30.2	30.35	36000.0
2005-07-14	CNXT	ETF	1.83	1.8901	1.76	1.87	7903929.0
2005-07-14	CPST	ETF	1.78	1.92	1.74	1.84	2109400.0
2005-07-14	CSB	ETF	29.43	29.66	29.38	29.45	6600.0
2005-07-14	CSQ	ETF	14.22	14.34	14.15	14.28	378900.0
2005-07-14	CTEC	ETF	54.699999999999996	55.7	54.199999999999996	54.349999999999994	3557.8
2005-07-14	CURE	ETF	0.3275	0.3337	0.3225	0.3262	586816.0
2005-07-14	CYA	ETF	138.0	141.0	138.0	141.0	345.0
2005-07-14	CYB	ETF	3.06	3.06	2.96	2.99	27500.0
2005-07-14	DGT	ETF	64.81	64.99	64.54	64.54	29300.0
2005-07-14	DIG	ETF	12.575	12.575	12.4375	12.4375	17520.0
2005-07-14	DIV	ETF	13.8	13.9	13.78	13.9	12300.0
2005-07-14	DRIV	ETF	35.72	36.2	35.11	35.43	586338.0
2005-07-14	DSI	ETF	5.845	5.845	5.845	5.845	200.0
2005-07-14	DUSA	ETF	9.86	10.21	9.84	10.13	100567.0
2005-07-14	DVY	ETF	63.77	64.0	63.31	63.45	731100.0

> showing 50 of 275 rows — these rows as CSV

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