PREVIEW / etf_daily / 2006-12-07

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-07.parquet
  size:    19 KB
  rows:    391

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-12-07	SPY	ETF	142.03	142.3	141.11	141.16	62857400.0
2006-12-07	QQQ	ETF	44.34	44.48	43.7	43.7	124973760.0
2006-12-07	IWM	ETF	79.29	79.51	78.66	78.77	39544100.0
2006-12-07	DIA	ETF	123.34	123.65	122.68	122.76	6432500.0
2006-12-07	GLD	ETF	62.64	62.78	61.99	62.73	5384600.0
2006-12-07	TLT	ETF	90.99	91.09	90.75	90.9	739200.0
2006-12-07	AAA	ETF	60.19	60.19	59.9	59.9	2900.0
2006-12-07	ADRE	ETF	37.82	37.8499	37.41	37.48	110013.0
2006-12-07	AGG	ETF	100.74	100.77	100.62	100.73	169600.0
2006-12-07	AIQ	ETF	30.9	31.95	30.85	31.65	82160.0
2006-12-07	AIS	ETF	1.2	1.24	1.18	1.209	470000.0
2006-12-07	ARB	ETF	44.31	44.66	44.08	44.32	120100.0
2006-12-07	BAB	ETF	97.94	98.38	97.03	97.53	42600.0
2006-12-07	BBC	ETF	5.01	5.07	4.9	4.96	179700.0
2006-12-07	BBH	ETF	62.6667	63.0433	62.3	62.3	403800.0
2006-12-07	BITS	ETF	34.72	34.84	33.2	33.8	26457.0
2006-12-07	BNE	ETF	15.87	15.91	15.6	15.7	78300.0
2006-12-07	BRF	ETF	14.35	14.36	14.35	14.35	13300.0
2006-12-07	BTF	ETF	110.99999999999999	111.89999999999999	110.99999999999999	111.85	1620.0
2006-12-07	CBON	ETF	30.15	30.44	30.04	30.34	14496.0
2006-12-07	CDL	ETF	9.75	9.81	9.66	9.68	176700.0
2006-12-07	CEF	ETF	9.57	9.57	9.37	9.56	597800.0
2006-12-07	CEW	ETF	25.71	25.71	25.71	25.71	200.0
2006-12-07	CFO	ETF	11.07	11.08	11.07	11.08	9800.0
2006-12-07	CGO	ETF	16.23	16.39	16.17	16.36	15100.0
2006-12-07	CHB	ETF	10.09	10.1	9.67	9.73	1365800.0
2006-12-07	CHI	ETF	20.01	20.2	19.97	20.0	75800.0
2006-12-07	CHIC	ETF	31.85	32.06	31.22	31.23	268882.0
2006-12-07	CHY	ETF	17.03	17.1099	16.95	16.95	131800.0
2006-12-07	CIL	ETF	25.24	25.24	25.24	25.24	100.0
2006-12-07	CN	ETF	44.8	44.8	43.75	43.77	75200.0
2006-12-07	CNXT	ETF	2.31	2.36	2.26	2.29	11627265.0
2006-12-07	CPI	ETF	23.4	23.4	23.4	23.4	100.0
2006-12-07	CPST	ETF	1.4	1.41	1.35	1.35	1406856.0
2006-12-07	CSA	ETF	22.32	22.32	22.05	22.21	63600.0
2006-12-07	CSB	ETF	33.18	33.18	32.88	33.02	17800.0
2006-12-07	CSM	ETF	1.3275	1.3275	1.3275	1.3275	32000.0
2006-12-07	CSQ	ETF	15.32	15.33	15.23	15.3	323000.0
2006-12-07	CTEC	ETF	91.89999999999999	92.05	90.64999999999999	91.14999999999999	12791.2
2006-12-07	CVY	ETF	26.82	26.9	26.7	26.75	14500.0
2006-12-07	DBC	ETF	25.28	25.38	25.08	25.3	137000.0
2006-12-07	DBV	ETF	25.07	25.13	25.05	25.05	20000.0
2006-12-07	DDM	ETF	7.3425	7.3525	7.2408	7.265	834000.0
2006-12-07	DES	ETF	19.3333	19.37	19.2433	19.25	39900.0
2006-12-07	DEW	ETF	61.05	61.1	60.75	60.75	15100.0
2006-12-07	DFE	ETF	63.86	64.14	63.76	63.8	9600.0
2006-12-07	DFJ	ETF	51.18	51.24	51.06	51.06	7500.0
2006-12-07	DGT	ETF	75.0	75.28	74.86	74.86	9000.0
2006-12-07	DHS	ETF	56.95	57.16	56.8	56.82	7900.0
2006-12-07	DIM	ETF	62.65	62.72	62.37	62.42	8500.0

> showing 50 of 391 rows — these rows as CSV

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