PREVIEW / etf_daily / 2006-12-04

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-04.parquet
  size:    19 KB
  rows:    387

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-04	SPY	ETF	140.25	141.55	140.23	141.29	87813200.0
2006-12-04	QQQ	ETF	43.79	44.48	43.79	44.26	89974658.0
2006-12-04	IWM	ETF	77.96	79.33	77.93	79.32	54369200.0
2006-12-04	DIA	ETF	122.04	123.11	122.0	122.8	6279300.0
2006-12-04	GLD	ETF	64.03	64.14	63.56	64.12	3469100.0
2006-12-04	TLT	ETF	91.3	91.62	91.22	91.58	460700.0
2006-12-04	AAA	ETF	58.84	59.1281	58.64	59.1281	3000.0
2006-12-04	ADRE	ETF	36.74	37.29	36.56	37.29	242192.0
2006-12-04	AGG	ETF	100.86	100.99	100.72	100.96	184600.0
2006-12-04	AIQ	ETF	29.75	30.0	29.6	29.95	83400.0
2006-12-04	AIS	ETF	1.31	1.31	1.25	1.27	227200.0
2006-12-04	ARB	ETF	44.0	44.9	44.0	44.73	164300.0
2006-12-04	BAB	ETF	96.55	98.25	96.55	97.73	45200.0
2006-12-04	BBC	ETF	5.01	5.04	4.69	4.82	414200.0
2006-12-04	BBH	ETF	61.8433	63.0567	61.8433	62.65	692400.0
2006-12-04	BITS	ETF	34.88	35.636	34.8	35.56	23270.0
2006-12-04	BNE	ETF	15.6	15.98	15.47	15.82	131300.0
2006-12-04	BRF	ETF	14.37	14.37	14.32	14.35	15900.0
2006-12-04	BTF	ETF	106.1	107.39999999999999	106.1	107.24999999999999	1640.0
2006-12-04	CBON	ETF	30.12	31.012	30.12	31.0	32677.0
2006-12-04	CDL	ETF	9.4	9.75	9.4	9.74	268100.0
2006-12-04	CEF	ETF	9.88	9.88	9.65	9.71	687900.0
2006-12-04	CFO	ETF	11.05	11.05	11.05	11.05	14700.0
2006-12-04	CGO	ETF	16.43	16.4699	16.18	16.31	44100.0
2006-12-04	CHB	ETF	9.57	9.82	9.57	9.79	990800.0
2006-12-04	CHI	ETF	19.76	20.0	19.76	19.9956	98300.0
2006-12-04	CHIC	ETF	30.5	31.57	30.4	31.26	544119.0
2006-12-04	CHY	ETF	17.04	17.06	16.93	17.01	122200.0
2006-12-04	CIL	ETF	25.2	25.2	25.14	25.2	900.0
2006-12-04	CN	ETF	38.4	38.8	38.4	38.8	27400.0
2006-12-04	CNXT	ETF	2.12	2.2	2.12	2.18	9884536.0
2006-12-04	CPI	ETF	24.2	24.2	22.6	23.37	8400.0
2006-12-04	CPST	ETF	1.34	1.4	1.33	1.36	1120565.0
2006-12-04	CSA	ETF	21.89	22.22	21.87	22.22	34300.0
2006-12-04	CSB	ETF	32.56	33.08	32.47	32.91	23600.0
2006-12-04	CSM	ETF	1.32	1.335	1.32	1.335	6400.0
2006-12-04	CSQ	ETF	15.29	15.4	15.25	15.37	377600.0
2006-12-04	CTEC	ETF	88.9	94.74999999999999	88.64999999999999	91.1	27098.600000000002
2006-12-04	CVY	ETF	26.56	26.74	26.56	26.74	28500.0
2006-12-04	DBC	ETF	25.8	25.8	25.41	25.65	249000.0
2006-12-04	DBV	ETF	25.0	25.09	24.96	25.09	42500.0
2006-12-04	DDM	ETF	7.1842	7.2967	7.1842	7.2583	552000.0
2006-12-04	DES	ETF	19.1133	19.3967	19.1133	19.3933	80100.0
2006-12-04	DEW	ETF	60.09	60.58	60.07	60.58	15100.0
2006-12-04	DFE	ETF	63.16	63.61	63.16	63.51	19600.0
2006-12-04	DFJ	ETF	50.46	51.0	50.46	50.93	24100.0
2006-12-04	DGT	ETF	74.4	75.08	74.4	74.79	5600.0
2006-12-04	DHS	ETF	56.7	56.99	56.68	56.89	18000.0
2006-12-04	DIM	ETF	61.58	62.13	61.58	62.04	16500.0
2006-12-04	DIV	ETF	13.38	13.65	13.38	13.5	40400.0

> showing 50 of 387 rows — these rows as CSV

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