PREVIEW / etf_daily / 2006-10-23

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-23.parquet
  size:    19 KB
  rows:    374

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-10-23	SPY	ETF	136.56	137.8	136.39	137.47	66219900.0
2006-10-23	QQQ	ETF	41.92	42.58	41.82	42.43	127004422.0
2006-10-23	IWM	ETF	75.35	76.28	75.09	75.75	38995800.0
2006-10-23	DIA	ETF	119.72	121.13	119.7	120.87	9888200.0
2006-10-23	GLD	ETF	57.88	58.19	57.52	57.76	3521800.0
2006-10-23	TLT	ETF	87.15	87.21	86.88	87.2	1200600.0
2006-10-23	AAA	ETF	53.8	54.23	53.8	54.15	2200.0
2006-10-23	ADRE	ETF	34.0	34.0699	33.65	34.02	380921.0
2006-10-23	AGG	ETF	99.2	99.25	99.11	99.15	199000.0
2006-10-23	AIQ	ETF	40.55	41.4	40.55	40.95	10060.0
2006-10-23	AIS	ETF	1.36	1.36	1.25	1.27	252500.0
2006-10-23	ARB	ETF	40.81	42.45	40.79	41.88	633000.0
2006-10-23	BAB	ETF	85.98	86.92	85.92	86.79	33800.0
2006-10-23	BBC	ETF	9.36	10.25	9.36	9.67	392300.0
2006-10-23	BBH	ETF	62.9667	63.0033	62.34	62.8467	1446900.0
2006-10-23	BITS	ETF	40.12	40.9676	39.48	39.64	47836.0
2006-10-23	BNE	ETF	15.41	15.63	15.3	15.5	121900.0
2006-10-23	BRF	ETF	14.26	14.39	14.26	14.27	10800.0
2006-10-23	BTF	ETF	100.39999999999999	100.44999999999999	100.19999999999999	100.19999999999999	3620.0
2006-10-23	CBON	ETF	29.59	29.85	29.29	29.43	143742.0
2006-10-23	CDL	ETF	9.63	9.78	9.58	9.72	177900.0
2006-10-23	CEF	ETF	8.35	8.35	8.16	8.17	406000.0
2006-10-23	CEW	ETF	25.42	25.45	25.42	25.45	700.0
2006-10-23	CFO	ETF	10.11	10.11	10.03	10.03	16500.0
2006-10-23	CGO	ETF	15.8	15.8	15.66	15.79	26000.0
2006-10-23	CHB	ETF	7.76	7.82	7.34	7.64	1466700.0
2006-10-23	CHI	ETF	19.36	19.44	19.35	19.38	91100.0
2006-10-23	CHIC	ETF	27.89	28.89	27.77	28.72	240763.0
2006-10-23	CHY	ETF	17.01	17.04	16.93	16.96	126000.0
2006-10-23	CIL	ETF	25.74	25.8	25.74	25.8	2200.0
2006-10-23	CIZ	ETF	22.7	22.7	22.7	22.7	400.0
2006-10-23	CN	ETF	35.08	35.7	35.02	35.51	31500.0
2006-10-23	CNXT	ETF	1.981	2.04	1.97	1.98	17192258.0
2006-10-23	COMB	ETF	10.19	10.19	9.75	9.84	25957.0
2006-10-23	CPST	ETF	1.55	1.57	1.54	1.56	1242401.0
2006-10-23	CSA	ETF	21.58	21.74	21.5	21.5	22400.0
2006-10-23	CSB	ETF	30.14	30.34	30.14	30.2	5000.0
2006-10-23	CSQ	ETF	14.95	14.99	14.91	14.99	293100.0
2006-10-23	CTEC	ETF	62.64999999999999	63.25	61.15	62.0	10655.0
2006-10-23	CVY	ETF	25.7	25.75	25.68	25.75	17400.0
2006-10-23	CYB	ETF	7.45	7.6	7.35	7.37	94600.0
2006-10-23	DBC	ETF	23.81	24.15	23.65	24.1	645800.0
2006-10-23	DBV	ETF	25.49	25.62	25.49	25.59	24400.0
2006-10-23	DDM	ETF	6.9292	7.0767	6.9233	7.0558	838800.0
2006-10-23	DES	ETF	18.44	18.5867	18.43	18.5367	345600.0
2006-10-23	DEW	ETF	56.67	57.13	56.58	57.13	19400.0
2006-10-23	DFE	ETF	57.64	57.81	57.62	57.81	2200.0
2006-10-23	DFJ	ETF	49.85	50.23	49.82	50.23	46600.0
2006-10-23	DGT	ETF	73.23	73.83	73.05	73.76	34400.0
2006-10-23	DHS	ETF	56.08	56.38	55.9	56.38	21600.0

> showing 50 of 374 rows — these rows as CSV

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