PREVIEW / etf_daily / 2006-03-31

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-31.parquet
  size:    16 KB
  rows:    308

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-31	SPY	ETF	130.02	130.24	129.37	129.83	62925600.0
2006-03-31	QQQ	ETF	42.14	42.19	41.84	41.93	71090453.0
2006-03-31	IWM	ETF	75.93	76.0	75.33	75.97	24722400.0
2006-03-31	DIA	ETF	111.61	111.82	110.97	111.31	6037000.0
2006-03-31	GLD	ETF	58.07	58.31	57.56	58.1	5076400.0
2006-03-31	TLT	ETF	86.98	87.14	86.8	86.87	1167700.0
2006-03-31	AAA	ETF	61.87	62.36	61.87	62.07	3100.0
2006-03-31	ADRE	ETF	128.39	129.7799	128.39	129.28	22400.0
2006-03-31	AFK	ETF	25.07	25.11	25.07	25.07	8100.0
2006-03-31	AGG	ETF	98.91	99.17	98.91	99.08	154000.0
2006-03-31	AIQ	ETF	33.35	33.35	30.7	32.2	25260.0
2006-03-31	AIS	ETF	1.64	1.68	1.61	1.62	248400.0
2006-03-31	AOM	ETF	6.64	6.7364	6.49	6.6	39800.0
2006-03-31	ARB	ETF	33.76	34.01	33.46	33.82	260400.0
2006-03-31	BAB	ETF	61.66	61.76	61.26	61.43	13300.0
2006-03-31	BBC	ETF	15.75	15.85	15.31	15.77	101700.0
2006-03-31	BBH	ETF	64.3333	64.6667	64.16	64.55	1221000.0
2006-03-31	BCM	ETF	72.72	74.13	72.57	73.67	52300.0
2006-03-31	BITS	ETF	31.4	31.44	29.2	29.72	49812.0
2006-03-31	BKF	ETF	13.05	13.21	12.92	13.0	29100.0
2006-03-31	BNE	ETF	16.51	16.67	16.33	16.67	155500.0
2006-03-31	BOSS	ETF	34.5	34.73	34.5	34.73	100.0
2006-03-31	BRF	ETF	14.15	14.22	14.15	14.21	12800.0
2006-03-31	BTF	ETF	89.0	89.14999999999999	88.55	89.1	660.0
2006-03-31	CBON	ETF	30.91	31.21	30.79	30.97	38970.0
2006-03-31	CDL	ETF	10.97	11.11	10.93	11.09	329100.0
2006-03-31	CEF	ETF	8.07	8.08	7.92	7.95	1364700.0
2006-03-31	CEW	ETF	25.62	25.7	25.46	25.46	2400.0
2006-03-31	CFO	ETF	10.1	10.1	10.1	10.1	7500.0
2006-03-31	CGO	ETF	14.58	14.7	14.45	14.7	23400.0
2006-03-31	CHB	ETF	15.15	15.27	14.83	14.96	799900.0
2006-03-31	CHI	ETF	20.76	20.92	20.7	20.74	93600.0
2006-03-31	CHIC	ETF	21.07	21.47	21.06	21.4	540069.0
2006-03-31	CHIR	ETF	45.63	45.81	45.6	45.81	1055806.0
2006-03-31	CHY	ETF	16.36	16.4	16.3	16.37	78000.0
2006-03-31	CIL	ETF	25.63	25.73	25.63	25.63	3300.0
2006-03-31	CIZ	ETF	23.5	24.15	23.5	24.02	2300.0
2006-03-31	CN	ETF	35.21	35.73	35.21	35.41	43800.0
2006-03-31	CNXT	ETF	3.575	3.59	3.42	3.45	15500681.0
2006-03-31	COMB	ETF	8.5825	8.65	8.5825	8.65	200.0
2006-03-31	CPST	ETF	3.7	3.78	3.6	3.64	1903812.0
2006-03-31	CSA	ETF	21.44	21.44	21.2001	21.32	2800.0
2006-03-31	CSB	ETF	29.9	29.9	29.67	29.7	7400.0
2006-03-31	CSM	ETF	2.49	2.49	2.49	2.49	800.0
2006-03-31	CSQ	ETF	13.96	14.08	13.96	14.04	314700.0
2006-03-31	CTEC	ETF	64.55	65.94999999999999	63.699999999999996	65.14999999999999	11613.400000000001
2006-03-31	CYB	ETF	6.5	6.7	6.4	6.67	19100.0
2006-03-31	DBC	ETF	23.94	24.07	23.7	23.94	402600.0
2006-03-31	DGT	ETF	67.34	67.34	67.05	67.16	1600.0
2006-03-31	DIG	ETF	17.55	17.55	17.425	17.5	17200.0

> showing 50 of 308 rows — these rows as CSV

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