PREVIEW / etf_daily / 2006-11-16

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-16.parquet
  size:    19 KB
  rows:    382

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-11-16	SPY	ETF	140.44	140.68	139.49	140.38	76728800.0
2006-11-16	QQQ	ETF	44.25	44.42	44.02	44.3	113556028.0
2006-11-16	IWM	ETF	79.1	79.11	78.38	78.64	49327900.0
2006-11-16	DIA	ETF	123.05	123.45	122.8	123.36	6310100.0
2006-11-16	GLD	ETF	62.16	62.3	61.27	61.31	4347500.0
2006-11-16	TLT	ETF	90.0	90.05	89.28	89.44	1494400.0
2006-11-16	AAA	ETF	58.43	58.56	58.37	58.42	3400.0
2006-11-16	ADRE	ETF	36.27	36.3	35.71	35.75	125412.0
2006-11-16	AGG	ETF	100.36	100.37	99.98	100.06	305100.0
2006-11-16	AIQ	ETF	37.0	37.45	33.85	34.2	43020.0
2006-11-16	AIS	ETF	1.29	1.29	1.22	1.27	43200.0
2006-11-16	ARB	ETF	44.35	44.36	43.55	44.11	304100.0
2006-11-16	BAB	ETF	90.36	91.97	90.3	91.7	103700.0
2006-11-16	BBC	ETF	5.25	5.29	3.93	4.78	3493600.0
2006-11-16	BBH	ETF	62.5967	62.9233	62.4767	62.7	726600.0
2006-11-16	BITS	ETF	34.84	35.3376	33.32	34.36	58692.0
2006-11-16	BNE	ETF	15.95	15.99	15.67	15.78	86100.0
2006-11-16	BRF	ETF	14.22	14.25	14.21	14.23	22600.0
2006-11-16	BTF	ETF	105.64999999999999	106.19999999999999	105.64999999999999	106.05	3000.0
2006-11-16	CBON	ETF	31.17	31.65	30.39	31.38	65870.0
2006-11-16	CDL	ETF	10.32	10.33	9.88	9.89	693400.0
2006-11-16	CEF	ETF	9.28	9.3	9.03	9.05	502600.0
2006-11-16	CEW	ETF	25.53	25.53	25.53	25.53	300.0
2006-11-16	CFO	ETF	10.85	10.85	10.81	10.81	6000.0
2006-11-16	CGO	ETF	15.94	15.94	15.79	15.85	32500.0
2006-11-16	CHB	ETF	9.24	9.42	8.91	9.25	1737200.0
2006-11-16	CHI	ETF	19.53	19.68	19.53	19.6799	113400.0
2006-11-16	CHIC	ETF	28.03	28.26	27.64	28.01	942967.0
2006-11-16	CHY	ETF	16.74	16.85	16.7	16.84	135600.0
2006-11-16	CIL	ETF	25.97	25.97	25.97	25.97	100.0
2006-11-16	CN	ETF	39.25	39.59	39.211	39.47	65600.0
2006-11-16	CNXT	ETF	2.3	2.32	2.15	2.23	11456170.0
2006-11-16	CPST	ETF	1.4	1.48	1.38	1.4	2551035.0
2006-11-16	CSA	ETF	20.4	20.4	20.1	20.3	37900.0
2006-11-16	CSB	ETF	31.3	31.38	31.2172	31.38	9600.0
2006-11-16	CSM	ETF	1.3125	1.3125	1.3125	1.3125	2000.0
2006-11-16	CSQ	ETF	14.99	14.99	14.89	14.94	330700.0
2006-11-16	CTEC	ETF	88.64999999999999	92.2	88.39999999999999	91.75	41958.0
2006-11-16	CVY	ETF	26.25	26.3	26.19	26.22	34100.0
2006-11-16	CYB	ETF	6.51	6.75	6.51	6.69	30800.0
2006-11-16	DBC	ETF	24.84	24.9699	24.15	24.22	315300.0
2006-11-16	DBV	ETF	25.25	25.41	25.25	25.39	57600.0
2006-11-16	DDM	ETF	7.2725	7.3167	7.2433	7.2958	866400.0
2006-11-16	DES	ETF	19.1767	19.1767	19.1	19.15	28500.0
2006-11-16	DEW	ETF	59.61	59.71	59.6	59.65	19200.0
2006-11-16	DFE	ETF	60.73	60.81	60.73	60.75	900.0
2006-11-16	DFJ	ETF	48.32	48.36	48.12	48.28	13000.0
2006-11-16	DGT	ETF	74.8	74.98	74.6	74.77	5600.0
2006-11-16	DHS	ETF	56.5	56.69	56.39	56.61	28200.0
2006-11-16	DIM	ETF	60.08	60.08	59.9	59.9	10200.0

> showing 50 of 382 rows — these rows as CSV

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