PREVIEW / etf_daily / 2006-09-12

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-12.parquet
  size:    18 KB
  rows:    363

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-12	SPY	ETF	130.56	131.84	130.37	131.69	69875600.0
2006-09-12	QQQ	ETF	38.95	39.8	38.95	39.68	124108425.0
2006-09-12	IWM	ETF	70.64	72.29	70.58	72.14	43200800.0
2006-09-12	DIA	ETF	114.1	115.18	114.0	114.98	9111200.0
2006-09-12	GLD	ETF	58.65	59.09	58.18	58.32	5836200.0
2006-09-12	TLT	ETF	87.15	87.71	87.0	87.69	820800.0
2006-09-12	AAA	ETF	57.06	57.5	57.0	57.5	16900.0
2006-09-12	ADRE	ETF	31.2	31.78	31.0	31.75	72306.0
2006-09-12	AFK	ETF	25.34	25.39	25.34	25.39	4600.0
2006-09-12	AGG	ETF	99.17	99.37	99.09	99.34	126600.0
2006-09-12	AIQ	ETF	41.55	42.15	41.0	41.4	41260.0
2006-09-12	AIS	ETF	1.0	1.04	0.97	1.04	284900.0
2006-09-12	ARB	ETF	36.76	37.99	36.74	37.65	90600.0
2006-09-12	BAB	ETF	78.61	80.75	78.36	80.45	65500.0
2006-09-12	BBC	ETF	11.35	11.4499	11.25	11.31	309500.0
2006-09-12	BBH	ETF	58.5667	59.1533	58.38	59.03	762600.0
2006-09-12	BITS	ETF	28.16	29.84	26.64	27.84	29031.0
2006-09-12	BNE	ETF	14.5	14.79	14.35	14.68	90100.0
2006-09-12	BRF	ETF	14.2	14.2	14.17	14.17	10600.0
2006-09-12	BTF	ETF	92.3	93.14999999999999	92.14999999999999	93.0	10520.0
2006-09-12	CBON	ETF	32.5	33.0	32.5	32.99	11590.0
2006-09-12	CDL	ETF	9.0	9.42	8.94	9.31	406800.0
2006-09-12	CEF	ETF	8.25	8.36	8.11	8.18	466700.0
2006-09-12	CEW	ETF	25.2	25.2	25.2	25.2	900.0
2006-09-12	CFO	ETF	9.95	9.95	9.9	9.9	11000.0
2006-09-12	CGO	ETF	15.51	15.51	15.4	15.43	13600.0
2006-09-12	CHB	ETF	6.38	6.9	6.3	6.69	3349500.0
2006-09-12	CHI	ETF	19.69	19.7	19.6	19.61	77400.0
2006-09-12	CHIC	ETF	26.32	26.65	25.95	26.45	693375.0
2006-09-12	CHY	ETF	16.53	16.57	16.48	16.48	181300.0
2006-09-12	CIZ	ETF	21.65	22.1	21.65	22.1	3300.0
2006-09-12	CN	ETF	35.04	35.28	35.04	35.1	43600.0
2006-09-12	CNXT	ETF	1.85	1.94	1.8302	1.93	15760378.0
2006-09-12	COMB	ETF	9.96	10.06	9.96	10.06	3050.0
2006-09-12	CPI	ETF	26.4	26.4	26.4	26.4	700.0
2006-09-12	CPST	ETF	1.79	1.82	1.75	1.77	2064426.0
2006-09-12	CSA	ETF	20.14	20.25	20.14	20.17	1900.0
2006-09-12	CSB	ETF	27.75	27.79	27.61	27.66	4200.0
2006-09-12	CSQ	ETF	14.47	14.57	14.46	14.55	375300.0
2006-09-12	CTEC	ETF	63.449999999999996	64.74999999999999	62.85	63.75	11631.6
2006-09-12	CYB	ETF	6.8	6.8	6.25	6.52	87600.0
2006-09-12	DBC	ETF	23.8	23.9	23.34	23.55	318300.0
2006-09-12	DDM	ETF	6.2967	6.4583	6.295	6.3833	543600.0
2006-09-12	DES	ETF	17.5267	17.8333	17.5267	17.81	74400.0
2006-09-12	DEW	ETF	54.14	54.5	54.14	54.5	15300.0
2006-09-12	DFE	ETF	54.14	54.44	54.14	54.37	6600.0
2006-09-12	DFJ	ETF	49.5	49.8	49.5	49.8	1400.0
2006-09-12	DGT	ETF	70.62	70.92	70.44	70.67	9300.0
2006-09-12	DHS	ETF	54.1	54.38	53.96	54.37	26200.0
2006-09-12	DIM	ETF	54.38	54.94	54.38	54.82	18700.0

> showing 50 of 363 rows — these rows as CSV

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