PREVIEW / etf_daily / 2005-08-04

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-04.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-08-04	SPY	ETF	124.23	124.31	123.57	123.72	50855600.0
2005-08-04	QQQ	ETF	39.88	39.94	39.57	39.673	72061763.0
2005-08-04	IWM	ETF	67.56	67.8	66.78	66.89	19246400.0
2005-08-04	DIA	ETF	106.65	106.73	106.01	106.12	5165000.0
2005-08-04	GLD	ETF	43.68	43.82	43.63	43.68	867600.0
2005-08-04	TLT	ETF	92.59	92.79	92.2	92.38	1046800.0
2005-08-04	AAA	ETF	56.83	56.88	56.32	56.32	4600.0
2005-08-04	ADRE	ETF	101.05	101.05	98.8801	99.0599	11092.0
2005-08-04	AFK	ETF	25.78	25.84	25.76	25.77	2800.0
2005-08-04	AGG	ETF	101.68	101.7	101.46	101.6	196200.0
2005-08-04	AIQ	ETF	50.0	50.6	48.85	49.0	33420.0
2005-08-04	AIS	ETF	1.05	1.09	0.89	1.01	389400.0
2005-08-04	ARB	ETF	41.5	41.69	41.5	41.58	247600.0
2005-08-04	BAB	ETF	51.64	51.8	51.15	51.15	20700.0
2005-08-04	BBH	ETF	65.1667	65.1867	64.3667	64.7667	1312200.0
2005-08-04	BCM	ETF	60.45	60.7	57.82	58.95	284700.0
2005-08-04	BIS	ETF	691.2	691.2	659.2	680.0	28.75
2005-08-04	BITS	ETF	13.8	14.004	13.408	14.004	2652.0
2005-08-04	BKF	ETF	34.4	34.6	33.75	33.91	23900.0
2005-08-04	BNE	ETF	13.8	14.04	13.8	13.87	217500.0
2005-08-04	BRF	ETF	15.44	15.49	15.37	15.49	7700.0
2005-08-04	BTF	ETF	86.95	87.24999999999999	86.89999999999999	86.89999999999999	900.0
2005-08-04	CBON	ETF	33.19	33.47	32.5	32.5	9241.0
2005-08-04	CDC	ETF	5.02	5.17	4.85	4.91	14000.0
2005-08-04	CDL	ETF	12.95	13.01	12.65	12.68	431900.0
2005-08-04	CEF	ETF	5.4	5.42	5.37	5.4	332400.0
2005-08-04	CEW	ETF	26.74	26.74	26.72	26.72	1400.0
2005-08-04	CHB	ETF	12.32	12.39	11.8	12.01	248200.0
2005-08-04	CHI	ETF	20.6	20.67	20.55	20.56	85200.0
2005-08-04	CHIC	ETF	14.64	15.1	14.48	14.61	257839.0
2005-08-04	CHIR	ETF	36.7599	36.9801	36.4701	36.5001	673698.0
2005-08-04	CHY	ETF	16.63	16.68	16.58	16.59	85800.0
2005-08-04	CIL	ETF	25.8	25.8	25.8	25.8	400.0
2005-08-04	CIZ	ETF	23.65	23.65	23.5	23.5	1900.0
2005-08-04	CN	ETF	32.39	32.39	32.0	32.04	72900.0
2005-08-04	CNXT	ETF	1.82	1.83	1.73	1.75	7235787.0
2005-08-04	CPST	ETF	2.7	2.7	2.28	2.555	2531782.0
2005-08-04	CSB	ETF	31.2	32.03	31.2	32.0	22800.0
2005-08-04	CSM	ETF	2.4175	2.4175	2.4175	2.4175	13600.0
2005-08-04	CSQ	ETF	14.41	14.43	14.34	14.38	274500.0
2005-08-04	CTEC	ETF	56.55	58.75	56.5	57.99999999999999	12611.800000000001
2005-08-04	CURE	ETF	0.44	0.4412	0.4	0.4175	2399208.0
2005-08-04	CYA	ETF	109.6	109.6	97.0	100.0	1605.0
2005-08-04	CYB	ETF	3.9	4.0	3.76	3.76	35900.0
2005-08-04	DGT	ETF	64.9	65.02	64.9	64.96	19200.0
2005-08-04	DIG	ETF	13.1125	13.1125	13.1	13.1125	2080.0
2005-08-04	DIV	ETF	13.9	13.91	13.85	13.91	6300.0
2005-08-04	DRIV	ETF	38.75	39.12	38.01	38.18	679991.0
2005-08-04	DSI	ETF	5.82	5.82	5.82	5.82	400.0
2005-08-04	DUSA	ETF	10.29	10.97	10.19	10.76	355825.0

> showing 50 of 275 rows — these rows as CSV

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