PREVIEW / etf_daily / 2006-09-08

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-08.parquet
  size:    18 KB
  rows:    356

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-09-08	SPY	ETF	130.08	130.46	129.83	130.28	45096300.0
2006-09-08	QQQ	ETF	38.54	38.82	38.46	38.72	96629978.0
2006-09-08	IWM	ETF	70.53	70.68	70.17	70.57	27806500.0
2006-09-08	DIA	ETF	113.61	114.05	113.49	113.87	3220000.0
2006-09-08	GLD	ETF	60.52	60.77	60.28	60.64	3693400.0
2006-09-08	TLT	ETF	87.49	87.6	87.33	87.33	540300.0
2006-09-08	AAA	ETF	57.07	57.9	57.05	57.52	16600.0
2006-09-08	ADRE	ETF	32.4	32.4	31.81	31.9056	128878.0
2006-09-08	AFK	ETF	25.34	25.38	25.34	25.38	4500.0
2006-09-08	AGG	ETF	99.27	99.33	99.17	99.17	120400.0
2006-09-08	AIQ	ETF	40.9	41.55	40.25	40.9	53380.0
2006-09-08	AIS	ETF	1.13	1.13	1.03	1.05	133500.0
2006-09-08	ARB	ETF	36.6	36.84	36.44	36.72	100100.0
2006-09-08	BAB	ETF	77.53	77.66	76.89	77.13	62000.0
2006-09-08	BBC	ETF	11.63	11.76	11.52	11.62	154000.0
2006-09-08	BBH	ETF	59.4833	59.9333	59.37	59.7167	244200.0
2006-09-08	BITS	ETF	27.84	28.48	27.16	27.4	7316.0
2006-09-08	BNE	ETF	14.69	14.97	14.6	14.9	79100.0
2006-09-08	BRF	ETF	14.2	14.2	14.17	14.17	7100.0
2006-09-08	BTF	ETF	91.85	92.05	91.75	91.95	1720.0
2006-09-08	CBON	ETF	33.25	33.4	32.69	32.73	8752.0
2006-09-08	CDL	ETF	9.29	9.29	9.06	9.07	397900.0
2006-09-08	CEF	ETF	8.86	8.86	8.73	8.77	329900.0
2006-09-08	CEW	ETF	25.35	25.35	25.35	25.35	500.0
2006-09-08	CFO	ETF	10.15	10.15	9.97	9.97	11700.0
2006-09-08	CGO	ETF	15.43	15.62	15.18	15.3	42600.0
2006-09-08	CHB	ETF	6.32	6.55	6.1	6.3	880100.0
2006-09-08	CHI	ETF	19.64	19.74	19.58	19.66	72800.0
2006-09-08	CHIC	ETF	27.82	28.04	26.36	26.99	1057027.0
2006-09-08	CHY	ETF	16.35	16.42	16.28	16.34	99100.0
2006-09-08	CN	ETF	35.11	35.33	35.02	35.13	29900.0
2006-09-08	CNXT	ETF	1.81	1.88	1.81	1.84	8682972.0
2006-09-08	CPI	ETF	27.26	27.26	27.26	27.26	1000.0
2006-09-08	CPST	ETF	1.83	1.8604	1.75	1.86	1122409.0
2006-09-08	CSA	ETF	20.1	20.23	20.1	20.2	7400.0
2006-09-08	CSB	ETF	27.64	27.83	27.64	27.76	5600.0
2006-09-08	CSQ	ETF	14.33	14.51	14.28	14.48	278200.0
2006-09-08	CTEC	ETF	62.949999999999996	66.39999999999999	62.8	65.1	20632.800000000003
2006-09-08	CYB	ETF	6.7	6.75	6.66	6.74	23600.0
2006-09-08	DBC	ETF	24.63	24.66	24.4	24.5	197400.0
2006-09-08	DDM	ETF	6.2333	6.2875	6.2242	6.2742	364800.0
2006-09-08	DES	ETF	17.41	17.48	17.38	17.4733	97800.0
2006-09-08	DEW	ETF	53.65	53.79	53.6	53.76	24500.0
2006-09-08	DFE	ETF	53.92	54.09	53.89	54.09	16200.0
2006-09-08	DFJ	ETF	50.88	50.92	50.75	50.92	3600.0
2006-09-08	DGT	ETF	70.5	70.52	70.3	70.35	10800.0
2006-09-08	DHS	ETF	53.78	53.92	53.59	53.91	81400.0
2006-09-08	DIM	ETF	54.36	54.59	54.31	54.56	4200.0
2006-09-08	DIV	ETF	12.5	12.6	12.47	12.54	25900.0
2006-09-08	DJP	ETF	48.4	48.49	48.15	48.24	132200.0

> showing 50 of 356 rows — these rows as CSV

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