PREVIEW / etf_daily / 2005-07-29

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-29.parquet
  size:    15 KB
  rows:    270

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-29	SPY	ETF	124.41	124.63	123.5	123.74	62358100.0
2005-07-29	QQQ	ETF	39.87	39.92	39.52	39.575	74758605.0
2005-07-29	IWM	ETF	68.0	68.26	67.44	67.89	24809900.0
2005-07-29	DIA	ETF	107.02	107.16	106.39	106.63	5551000.0
2005-07-29	GLD	ETF	42.83	42.96	42.79	42.82	1185100.0
2005-07-29	TLT	ETF	93.8	93.8	92.85	93.11	1699500.0
2005-07-29	AAA	ETF	52.59	52.8	52.56	52.66	2300.0
2005-07-29	ADRE	ETF	95.89	96.94	95.89	96.7	11660.0
2005-07-29	AFK	ETF	25.87	25.87	25.7	25.71	2800.0
2005-07-29	AGG	ETF	102.14	102.14	101.81	101.98	106000.0
2005-07-29	AIQ	ETF	51.35	52.25	51.3	51.3	22560.0
2005-07-29	AIS	ETF	1.07	1.07	1.06	1.06	61300.0
2005-07-29	ARB	ETF	42.3	42.49	41.3	41.5	357600.0
2005-07-29	BAB	ETF	49.12	49.2	48.68	48.85	6900.0
2005-07-29	BBH	ETF	64.23	64.43	63.8	63.92	818400.0
2005-07-29	BCM	ETF	65.71	65.72	65.03	65.3	178400.0
2005-07-29	BITS	ETF	13.88	13.88	12.96	12.96	3532.0
2005-07-29	BKF	ETF	34.93	35.15	34.09	34.09	16400.0
2005-07-29	BNE	ETF	13.45	14.22	13.45	13.71	513700.0
2005-07-29	BRF	ETF	15.54	15.54	15.54	15.54	1800.0
2005-07-29	BTF	ETF	88.1	88.1	87.24999999999999	87.6	3260.0
2005-07-29	CBON	ETF	32.58	33.01	32.58	33.01	36987.0
2005-07-29	CDC	ETF	5.76	6.1	5.65	5.95	13900.0
2005-07-29	CDL	ETF	12.45	12.53	12.28	12.28	316200.0
2005-07-29	CEF	ETF	5.22	5.26	5.22	5.24	162100.0
2005-07-29	CEW	ETF	26.7	26.7	26.7	26.7	100.0
2005-07-29	CHB	ETF	12.65	12.74	12.0	12.06	350900.0
2005-07-29	CHI	ETF	20.28	20.42	20.15	20.37	108200.0
2005-07-29	CHIC	ETF	14.96	15.02	14.4	14.69	207981.0
2005-07-29	CHIR	ETF	36.5499	36.7401	36.0801	36.2301	1181666.0
2005-07-29	CHY	ETF	16.56	16.73	16.55	16.73	78800.0
2005-07-29	CN	ETF	30.75	30.83	30.66	30.66	6500.0
2005-07-29	CNXT	ETF	1.935	1.96	1.86	1.91	7119791.0
2005-07-29	CPST	ETF	1.83	1.86	1.81	1.82	344585.0
2005-07-29	CSB	ETF	30.15	30.2	29.85	29.915	6700.0
2005-07-29	CSQ	ETF	14.56	14.57	14.46	14.47	415400.0
2005-07-29	CTEC	ETF	57.0	57.15	55.849999999999994	56.3	8722.800000000001
2005-07-29	CURE	ETF	0.2888	0.2963	0.27	0.2787	817200.0
2005-07-29	CYA	ETF	115.6	127.0	115.6	127.0	925.0
2005-07-29	CYB	ETF	3.37	3.59	3.37	3.59	6500.0
2005-07-29	DGT	ETF	64.75	64.75	64.41	64.41	700.0
2005-07-29	DIG	ETF	12.125	12.125	12.125	12.125	320.0
2005-07-29	DIV	ETF	13.79	13.89	13.72	13.83	17200.0
2005-07-29	DRIV	ETF	40.03	40.58	39.61	39.975	1595642.0
2005-07-29	DUSA	ETF	9.49	9.5	9.33	9.37	133717.0
2005-07-29	DVY	ETF	64.32	64.46	63.85	63.97	482500.0
2005-07-29	EDEN	ETF	0.8	0.8	0.69	0.79	291207.0
2005-07-29	EDV	ETF	25.81	25.9	25.76	25.79	11700.0
2005-07-29	EEM	ETF	25.7433	25.8033	25.67	25.7	4639200.0
2005-07-29	EFA	ETF	54.13	54.22	53.9	53.96	3734500.0

> showing 50 of 270 rows — these rows as CSV

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