PREVIEW / etf_daily / 2006-01-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-09.parquet
  size:    16 KB
  rows:    302

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
2006-01-09	SPY	ETF	128.42	129.06	128.38	128.77	43527400.0
2006-01-09	QQQ	ETF	42.66	42.9201	42.52	42.8499	80775256.0
2006-01-09	IWM	ETF	69.61	70.38	69.57	70.07	22285700.0
2006-01-09	DIA	ETF	109.5	110.21	109.47	109.98	10420700.0
2006-01-09	GLD	ETF	53.46	54.99	53.31	54.6	5394200.0
2006-01-09	TLT	ETF	91.7	91.78	91.54	91.78	413600.0
2006-01-09	AAA	ETF	55.81	56.0	55.63	55.88	700.0
2006-01-09	ADRE	ETF	123.84	124.12	123.136	124.12	74976.0
2006-01-09	AFK	ETF	25.29	25.32	25.22	25.32	5600.0
2006-01-09	AGG	ETF	100.74	100.89	100.6	100.76	170500.0
2006-01-09	AIQ	ETF	28.65	28.8	27.75	28.8	28760.0
2006-01-09	AIS	ETF	1.5	1.51	1.45	1.5	176400.0
2006-01-09	AOM	ETF	4.34	4.34	4.28	4.28	14900.0
2006-01-09	ARB	ETF	38.55	39.05	38.55	38.85	112400.0
2006-01-09	BAB	ETF	58.67	58.68	58.05	58.58	13600.0
2006-01-09	BBC	ETF	15.5	15.8	15.18	15.35	231300.0
2006-01-09	BBH	ETF	67.6933	68.38	67.56	68.23	1962300.0
2006-01-09	BCM	ETF	67.07	67.88	66.98	67.63	37900.0
2006-01-09	BITS	ETF	15.2	15.2	14.956	15.0	1928.0
2006-01-09	BKF	ETF	18.7	18.74	18.24	18.48	56700.0
2006-01-09	BNE	ETF	14.87	15.05	14.86	14.96	112300.0
2006-01-09	BOSS	ETF	32.8	32.89	32.8	32.89	100.0
2006-01-09	BRF	ETF	15.36	15.42	15.35	15.36	6200.0
2006-01-09	BTF	ETF	84.74999999999999	85.7	84.74999999999999	85.44999999999999	6700.0
2006-01-09	CBON	ETF	31.9	32.72	31.9	32.3	20418.0
2006-01-09	CDL	ETF	13.54	13.58	13.43	13.48	836700.0
2006-01-09	CEF	ETF	7.1	7.17	7.01	7.15	625000.0
2006-01-09	CEW	ETF	26.14	26.25	26.14	26.25	600.0
2006-01-09	CFO	ETF	9.9	9.9	9.85	9.85	6900.0
2006-01-09	CGO	ETF	14.3	14.35	14.21	14.32	22000.0
2006-01-09	CHB	ETF	13.01	14.1	13.01	13.95	1283800.0
2006-01-09	CHI	ETF	20.2	20.44	20.2	20.42	70400.0
2006-01-09	CHIC	ETF	21.77	22.49	21.69	21.91	721919.0
2006-01-09	CHIR	ETF	44.6499	44.79	44.6499	44.7801	596445.0
2006-01-09	CHY	ETF	16.02	16.13	15.98	16.1	93700.0
2006-01-09	CIZ	ETF	22.5	22.5	22.5	22.5	200.0
2006-01-09	CN	ETF	35.2	35.2	34.66	34.75	68000.0
2006-01-09	CNXT	ETF	2.64	2.68	2.58	2.63	11839006.0
2006-01-09	COMB	ETF	8.35	8.65	8.35	8.65	500.0
2006-01-09	CPST	ETF	3.19	3.33	3.12	3.19	4051874.0
2006-01-09	CSA	ETF	17.48	17.6	17.41	17.41	52700.0
2006-01-09	CSB	ETF	32.23	32.37	32.0	32.29	9600.0
2006-01-09	CSM	ETF	2.46	2.46	2.46	2.46	10400.0
2006-01-09	CSQ	ETF	13.77	14.05	13.73	14.01	600600.0
2006-01-09	CTEC	ETF	50.599999999999994	50.99999999999999	49.949999999999996	49.949999999999996	10389.6
2006-01-09	CURE	ETF	0.03	0.0312	0.0275	0.03	2625384.0
2006-01-09	CYB	ETF	3.64	3.7	3.64	3.66	9600.0
2006-01-09	DGT	ETF	67.45	67.49	67.26	67.26	3000.0
2006-01-09	DIG	ETF	17.1125	17.1125	17.0125	17.0125	1600.0
2006-01-09	DIV	ETF	12.5	12.55	12.4	12.5	21600.0

> showing 50 of 302 rows — these rows as CSV

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