PREVIEW / etf_daily / 2006-07-28

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-28.parquet
  size:    18 KB
  rows:    357

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-07-28	SPY	ETF	127.04	128.14	126.86	127.98	82137000.0
2006-07-28	QQQ	ETF	36.56	37.14	36.5	37.11	93570326.0
2006-07-28	IWM	ETF	68.75	69.7	68.48	69.67	62209800.0
2006-07-28	DIA	ETF	111.46	112.33	111.15	112.07	11306000.0
2006-07-28	GLD	ETF	62.78	63.34	62.75	63.11	3156400.0
2006-07-28	TLT	ETF	85.65	85.89	85.6	85.7	769800.0
2006-07-28	AAA	ETF	55.64	56.3	55.64	56.13	3900.0
2006-07-28	ADRE	ETF	31.73	32.26	31.61	32.22	157086.0
2006-07-28	AFK	ETF	25.0	25.15	24.99	25.1	11800.0
2006-07-28	AGG	ETF	98.53	98.59	98.36	98.52	105400.0
2006-07-28	AIQ	ETF	31.25	32.35	30.55	31.4	15880.0
2006-07-28	AIS	ETF	1.11	1.1199	1.07	1.1199	43300.0
2006-07-28	AOM	ETF	6.44	6.4799	6.34	6.41	52500.0
2006-07-28	ARB	ETF	36.1	36.74	36.08	36.74	129700.0
2006-07-28	BAB	ETF	72.27	72.74	72.17	72.74	36200.0
2006-07-28	BBC	ETF	13.32	13.73	13.32	13.52	103900.0
2006-07-28	BBH	ETF	59.1833	59.71	58.9167	59.09	1137000.0
2006-07-28	BITS	ETF	17.52	18.08	17.0	17.04	10138.0
2006-07-28	BKF	ETF	4.18	4.18	4.01	4.01	63500.0
2006-07-28	BNE	ETF	13.39	13.69	13.33	13.64	82600.0
2006-07-28	BRF	ETF	14.04	14.06	14.02	14.02	6900.0
2006-07-28	BTF	ETF	87.14999999999999	87.39999999999999	87.14999999999999	87.39999999999999	40.0
2006-07-28	CBON	ETF	33.05	33.41	33.05	33.38	30998.0
2006-07-28	CDL	ETF	9.02	9.26	8.96	9.17	360400.0
2006-07-28	CEF	ETF	8.77	8.79	8.71	8.74	304000.0
2006-07-28	CEW	ETF	25.91	25.95	25.91	25.95	1000.0
2006-07-28	CFO	ETF	10.0	10.0	10.0	10.0	1500.0
2006-07-28	CGO	ETF	14.94	15.04	14.78	14.99	22900.0
2006-07-28	CHB	ETF	6.59	6.67	6.46	6.65	1734400.0
2006-07-28	CHI	ETF	19.85	19.97	19.8136	19.9	44800.0
2006-07-28	CHIC	ETF	25.55	25.76	24.85	25.42	407243.0
2006-07-28	CHY	ETF	16.1	16.1	16.05	16.09	103400.0
2006-07-28	CIZ	ETF	21.95	21.95	21.95	21.95	200.0
2006-07-28	CN	ETF	36.27	37.39	36.27	37.27	86400.0
2006-07-28	CNXT	ETF	1.8	1.83	1.65	1.73	48102333.0
2006-07-28	COMB	ETF	9.79	9.79	9.75	9.77	6623.0
2006-07-28	CPI	ETF	29.15	29.15	29.15	29.15	200.0
2006-07-28	CPST	ETF	1.77	1.83	1.77	1.81	1028237.0
2006-07-28	CSA	ETF	18.75	18.76	18.44	18.44	10800.0
2006-07-28	CSB	ETF	27.37	27.66	27.37	27.58	7200.0
2006-07-28	CSQ	ETF	14.15	14.17	14.1	14.16	238100.0
2006-07-28	CTEC	ETF	59.3	60.099999999999994	57.05	57.949999999999996	22572.2
2006-07-28	CYB	ETF	5.28	5.45	5.2	5.41	25900.0
2006-07-28	DBC	ETF	25.7	25.75	25.25	25.61	180700.0
2006-07-28	DDM	ETF	6.05	6.1167	6.0267	6.0867	1186800.0
2006-07-28	DES	ETF	17.2133	17.3367	17.1467	17.3367	35400.0
2006-07-28	DEW	ETF	53.5	53.51	53.4	53.4	400.0
2006-07-28	DFE	ETF	53.39	53.39	53.39	53.39	200.0
2006-07-28	DFJ	ETF	49.24	49.62	49.24	49.62	400.0
2006-07-28	DGT	ETF	68.6	69.39	68.6	69.2	20100.0

> showing 50 of 357 rows — these rows as CSV

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