PREVIEW / etf_daily / 2006-03-23

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-23.parquet
  size:    16 KB
  rows:    309

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-03-23	SPY	ETF	130.26	130.39	129.66	130.11	46704200.0
2006-03-23	QQQ	ETF	41.09	41.22	40.82	41.09	75220667.0
2006-03-23	IWM	ETF	74.03	74.45	73.75	74.45	25409600.0
2006-03-23	DIA	ETF	113.0	113.18	112.25	112.78	6603900.0
2006-03-23	GLD	ETF	54.36	54.85	54.24	54.7	4000800.0
2006-03-23	TLT	ETF	88.82	88.87	88.34	88.44	613400.0
2006-03-23	AAA	ETF	59.97	59.97	59.7	59.7	3500.0
2006-03-23	ADRE	ETF	127.0	128.68	127.0	127.35	49368.0
2006-03-23	AFK	ETF	25.14	25.16	25.11	25.15	5300.0
2006-03-23	AGG	ETF	99.7	99.74	99.4	99.4	168700.0
2006-03-23	AIQ	ETF	32.25	33.0	32.25	32.65	22600.0
2006-03-23	AIS	ETF	1.77	1.77	1.67	1.75	379500.0
2006-03-23	AOM	ETF	6.3	6.38	6.18	6.35	52800.0
2006-03-23	ARB	ETF	33.75	34.05	33.53	33.95	314600.0
2006-03-23	BAB	ETF	63.47	63.56	62.27	62.36	53500.0
2006-03-23	BBC	ETF	18.04	18.45	17.8	18.25	186600.0
2006-03-23	BBH	ETF	65.0233	65.33	64.43	64.8667	1568100.0
2006-03-23	BCM	ETF	72.96	73.3	72.55	73.3	22000.0
2006-03-23	BITS	ETF	31.16	32.52	30.12	31.8	17522.0
2006-03-23	BKF	ETF	12.83	13.06	12.77	13.01	50100.0
2006-03-23	BNE	ETF	15.45	15.97	15.27	15.94	211100.0
2006-03-23	BOSS	ETF	35.81	35.81	35.43	35.43	100.0
2006-03-23	BRF	ETF	14.29	14.41	14.29	14.41	7500.0
2006-03-23	BTF	ETF	88.9	88.9	88.69999999999999	88.69999999999999	2020.0
2006-03-23	CBON	ETF	31.84	31.94	30.72	31.13	15793.0
2006-03-23	CDL	ETF	11.32	11.32	11.16	11.27	376000.0
2006-03-23	CEF	ETF	7.71	7.79	7.63	7.7	696300.0
2006-03-23	CEW	ETF	25.55	25.55	25.53	25.53	1200.0
2006-03-23	CFO	ETF	9.65	9.8	9.65	9.8	5800.0
2006-03-23	CGO	ETF	14.48	14.48	14.37	14.45	24000.0
2006-03-23	CHB	ETF	15.4	15.51	15.05	15.3	554900.0
2006-03-23	CHI	ETF	20.9	20.9	20.71	20.78	59000.0
2006-03-23	CHIC	ETF	18.86	19.13	18.64	18.95	270759.0
2006-03-23	CHIR	ETF	45.6201	45.81	45.5001	45.7299	734234.0
2006-03-23	CHY	ETF	16.58	16.6	16.33	16.36	130700.0
2006-03-23	CIL	ETF	25.6	25.63	25.6	25.63	900.0
2006-03-23	CIZ	ETF	23.4	23.6	22.9	23.6	3300.0
2006-03-23	CN	ETF	35.55	35.58	35.05	35.12	51600.0
2006-03-23	CNXT	ETF	3.22	3.3	3.15	3.22	11002796.0
2006-03-23	COMB	ETF	8.5	8.56	8.5	8.56	4831.0
2006-03-23	CPST	ETF	3.27	3.36	3.25	3.35	1299287.0
2006-03-23	CSA	ETF	21.45	21.5	21.35	21.49	43000.0
2006-03-23	CSB	ETF	30.6	30.6	30.19	30.24	4200.0
2006-03-23	CSM	ETF	2.4875	2.4875	2.4875	2.4875	800.0
2006-03-23	CSQ	ETF	14.24	14.31	14.2	14.27	430700.0
2006-03-23	CTEC	ETF	60.0	60.14999999999999	59.15	60.0	3276.0
2006-03-23	CYB	ETF	6.16	6.6	6.16	6.33	64500.0
2006-03-23	DBC	ETF	22.95	23.27	22.8	23.27	224500.0
2006-03-23	DGT	ETF	67.75	67.75	67.21	67.21	500.0
2006-03-23	DIV	ETF	12.62	12.65	12.5	12.56	11900.0

> showing 50 of 309 rows — these rows as CSV

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