PREVIEW / etf_daily / 2006-01-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-27.parquet
  size:    16 KB
  rows:    301

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-27	SPY	ETF	127.66	128.66	127.45	128.54	65771200.0
2006-01-27	QQQ	ETF	41.81	42.39	41.74	42.11	110836097.0
2006-01-27	IWM	ETF	72.54	73.24	72.26	72.77	29044200.0
2006-01-27	DIA	ETF	108.22	109.27	107.97	109.11	7922800.0
2006-01-27	GLD	ETF	55.96	56.23	55.47	55.63	4285400.0
2006-01-27	TLT	ETF	90.8	90.8	90.16	90.51	1091400.0
2006-01-27	AAA	ETF	55.23	55.29	54.65	55.0	5100.0
2006-01-27	ADRE	ETF	130.45	131.23	129.522	129.85	46000.0
2006-01-27	AFK	ETF	25.28	25.39	25.28	25.3	2800.0
2006-01-27	AGG	ETF	100.59	100.59	100.25	100.5	164400.0
2006-01-27	AIQ	ETF	22.75	23.75	22.7	23.05	296680.0
2006-01-27	AIS	ETF	1.51	1.53	1.45	1.46	127200.0
2006-01-27	AOM	ETF	5.71	5.71	5.55	5.7	42900.0
2006-01-27	ARB	ETF	40.06	40.25	39.8	40.17	122300.0
2006-01-27	BAB	ETF	59.2	59.24	58.5	58.5	18200.0
2006-01-27	BBC	ETF	18.61	19.58	18.61	19.11	231200.0
2006-01-27	BBH	ETF	64.4333	64.9533	64.2	64.9167	859800.0
2006-01-27	BCM	ETF	68.9	70.34	68.63	69.91	42700.0
2006-01-27	BITS	ETF	15.44	15.76	15.4	15.76	2358.0
2006-01-27	BKF	ETF	13.57	13.64	13.2	13.41	114000.0
2006-01-27	BNE	ETF	14.85	15.04	14.76	14.88	86100.0
2006-01-27	BRF	ETF	15.25	15.35	15.25	15.35	7500.0
2006-01-27	BTF	ETF	85.6	85.95	85.39999999999999	85.74999999999999	2400.0
2006-01-27	CBON	ETF	30.51	30.7	30.17	30.6	10680.0
2006-01-27	CDL	ETF	12.0	12.19	11.97	12.17	327700.0
2006-01-27	CEF	ETF	7.45	7.54	7.4	7.48	730400.0
2006-01-27	CEW	ETF	26.23	26.25	26.23	26.25	500.0
2006-01-27	CFO	ETF	10.08	10.09	10.07	10.07	8200.0
2006-01-27	CGO	ETF	14.32	14.5	14.1	14.26	94000.0
2006-01-27	CHB	ETF	13.3	14.14	13.2903	13.86	914100.0
2006-01-27	CHI	ETF	20.6	20.68	20.3701	20.47	78200.0
2006-01-27	CHIC	ETF	16.5	16.77	16.5	16.64	435991.0
2006-01-27	CHIR	ETF	45.0699	45.6099	45.0699	45.2901	1648404.0
2006-01-27	CHY	ETF	16.31	16.39	16.16	16.16	72900.0
2006-01-27	CIL	ETF	25.47	25.47	25.47	25.47	200.0
2006-01-27	CIZ	ETF	23.55	24.0	23.51	24.0	2500.0
2006-01-27	CN	ETF	33.66	34.55	33.66	34.41	50400.0
2006-01-27	CNXT	ETF	3.5	3.51	3.22	3.33	35417807.0
2006-01-27	COMB	ETF	8.35	8.56	8.35	8.56	3967.0
2006-01-27	CPI	ETF	30.0	30.0	29.85	29.85	400.0
2006-01-27	CPST	ETF	3.615	3.69	3.51	3.55	2081216.0
2006-01-27	CSA	ETF	17.95	18.0	17.8	18.0	10500.0
2006-01-27	CSB	ETF	32.96	33.13	32.68	32.89	3400.0
2006-01-27	CSM	ETF	2.4675	2.47	2.4675	2.47	12000.0
2006-01-27	CSQ	ETF	13.88	13.98	13.87	13.98	337900.0
2006-01-27	CTEC	ETF	52.599999999999994	53.949999999999996	51.449999999999996	53.099999999999994	11947.6
2006-01-27	CURE	ETF	0.0338	0.0338	0.0288	0.0312	2034872.0
2006-01-27	CYB	ETF	4.38	4.5	4.35	4.5	22400.0
2006-01-27	DGT	ETF	66.7	66.85	66.53	66.68	2700.0
2006-01-27	DIG	ETF	17.1875	17.375	17.1125	17.3125	5280.0

> showing 50 of 301 rows — these rows as CSV

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