PREVIEW / etf_daily / 2006-09-11

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-11.parquet
  size:    18 KB
  rows:    359

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-11	SPY	ETF	129.86	130.69	129.48	130.41	68496600.0
2006-09-11	QQQ	ETF	38.41	39.15	38.3199	38.96	142377744.0
2006-09-11	IWM	ETF	70.13	70.84	69.65	70.48	49544600.0
2006-09-11	DIA	ETF	113.65	114.25	113.42	113.96	5681400.0
2006-09-11	GLD	ETF	58.85	59.25	57.91	58.5	10580700.0
2006-09-11	TLT	ETF	87.49	87.49	86.95	87.25	557600.0
2006-09-11	AAA	ETF	57.17	57.28	56.78	57.1301	2800.0
2006-09-11	ADRE	ETF	31.11	31.62	31.02	31.19	319977.0
2006-09-11	AFK	ETF	25.34	25.39	25.34	25.34	7900.0
2006-09-11	AGG	ETF	99.26	99.3	99.06	99.1	190800.0
2006-09-11	AIQ	ETF	41.25	42.3995	40.3	41.35	33420.0
2006-09-11	AIS	ETF	1.05	1.05	0.98	0.98	234900.0
2006-09-11	ARB	ETF	36.6	37.04	36.58	36.76	67300.0
2006-09-11	BAB	ETF	77.72	78.39	77.16	78.39	46200.0
2006-09-11	BBC	ETF	11.35	11.55	11.25	11.49	250900.0
2006-09-11	BBH	ETF	58.9967	58.9967	57.9	58.7733	1451400.0
2006-09-11	BITS	ETF	26.96	29.68	26.44	28.32	26378.0
2006-09-11	BNE	ETF	14.8	14.85	14.44	14.51	86900.0
2006-09-11	BRF	ETF	14.2	14.24	14.16	14.2	20500.0
2006-09-11	BTF	ETF	91.85	92.14999999999999	91.4005	92.14999999999999	1240.0
2006-09-11	CBON	ETF	32.63	32.9	32.5	32.58	41897.0
2006-09-11	CDL	ETF	9.55	9.55	8.98	9.0	304000.0
2006-09-11	CEF	ETF	8.61	8.61	8.16	8.2	1303700.0
2006-09-11	CEW	ETF	25.28	25.28	25.2	25.2	4200.0
2006-09-11	CFO	ETF	9.98	9.98	9.82	9.82	11300.0
2006-09-11	CGO	ETF	15.3	15.65	15.3	15.49	25400.0
2006-09-11	CHB	ETF	6.25	6.59	6.15	6.39	1096100.0
2006-09-11	CHI	ETF	19.7	19.75	19.53	19.6799	110600.0
2006-09-11	CHIC	ETF	26.26	26.91	26.0	26.17	628338.0
2006-09-11	CHY	ETF	16.4	16.52	16.31	16.48	116900.0
2006-09-11	CIL	ETF	25.5	25.5	25.5	25.5	200.0
2006-09-11	CN	ETF	35.13	35.17	34.85	35.03	29800.0
2006-09-11	CNXT	ETF	1.82	1.9	1.78	1.82	8954760.0
2006-09-11	COMB	ETF	10.01	10.05	9.96	9.96	27210.0
2006-09-11	CPI	ETF	27.1	27.1	26.51	26.52	4800.0
2006-09-11	CPST	ETF	1.86	1.86	1.78	1.8	1150910.0
2006-09-11	CSA	ETF	20.05	20.2	20.01	20.14	5000.0
2006-09-11	CSB	ETF	27.82	27.82	27.48	27.67	8900.0
2006-09-11	CSQ	ETF	14.48	14.48	14.35	14.47	328100.0
2006-09-11	CTEC	ETF	65.25	65.3	62.5	64.95	12823.400000000001
2006-09-11	CYB	ETF	6.75	6.95	6.72	6.78	159000.0
2006-09-11	DBC	ETF	24.02	24.13	23.8	23.93	541600.0
2006-09-11	DDM	ETF	6.2542	6.3058	6.2225	6.2717	248400.0
2006-09-11	DES	ETF	17.4267	17.5067	17.32	17.48	46800.0
2006-09-11	DEW	ETF	53.78	53.92	53.6	53.92	3500.0
2006-09-11	DFE	ETF	53.82	53.9	53.82	53.87	5700.0
2006-09-11	DFJ	ETF	50.1	50.29	49.84	50.29	3400.0
2006-09-11	DGT	ETF	70.25	70.38	69.95	70.28	7500.0
2006-09-11	DHS	ETF	53.85	53.91	53.73	53.9	13200.0
2006-09-11	DIM	ETF	54.39	54.4	54.07	54.34	14900.0

> showing 50 of 359 rows — these rows as CSV

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