PREVIEW / etf_daily / 2006-07-06

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-06.parquet
  size:    18 KB
  rows:    351

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-06	SPY	ETF	127.2	127.85	127.08	127.44	50100300.0
2006-07-06	QQQ	ETF	38.26	38.48	38.01	38.11	70634553.0
2006-07-06	IWM	ETF	71.71	72.2	71.16	71.55	33830700.0
2006-07-06	DIA	ETF	111.65	112.56	111.63	112.19	9406000.0
2006-07-06	GLD	ETF	62.46	63.2	62.05	63.02	5686600.0
2006-07-06	TLT	ETF	83.33	83.79	83.33	83.75	451400.0
2006-07-06	AAA	ETF	56.05	56.41	56.0001	56.2	3200.0
2006-07-06	ADRE	ETF	125.58	126.23	124.33	125.6195	58512.0
2006-07-06	AFK	ETF	24.6	24.68	24.52	24.67	27500.0
2006-07-06	AGG	ETF	97.09	97.09	96.87	97.0	137000.0
2006-07-06	AIQ	ETF	33.75	33.75	32.0	33.45	22040.0
2006-07-06	AIS	ETF	1.15	1.19	1.12	1.17	52700.0
2006-07-06	AOM	ETF	5.75	5.8	5.6501	5.8	27000.0
2006-07-06	ARB	ETF	38.28	38.28	37.58	38.02	285300.0
2006-07-06	BAB	ETF	63.67	64.22	63.55	63.96	17300.0
2006-07-06	BBC	ETF	14.25	14.65	13.9	14.06	398400.0
2006-07-06	BBH	ETF	59.3567	60.0	59.35	59.9167	1224300.0
2006-07-06	BCM	ETF	67.23	68.05	67.22	67.76	52100.0
2006-07-06	BITS	ETF	19.24	20.12	19.0	19.16	14747.0
2006-07-06	BKF	ETF	6.05	6.07	5.91	5.93	41600.0
2006-07-06	BNE	ETF	14.06	14.3	13.94	14.12	137500.0
2006-07-06	BRF	ETF	13.9	13.99	13.89	13.99	7200.0
2006-07-06	BTF	ETF	89.0	89.49999999999999	88.8	88.8	1660.0
2006-07-06	CBON	ETF	32.05	32.35	32.05	32.09	27854.0
2006-07-06	CDL	ETF	8.98	9.05	8.84	8.91	119500.0
2006-07-06	CEF	ETF	8.96	9.09	8.87	9.07	322200.0
2006-07-06	CEW	ETF	26.0	26.0	25.81	25.81	1200.0
2006-07-06	CFO	ETF	10.05	10.05	10.05	10.05	15000.0
2006-07-06	CGO	ETF	14.62	14.7	14.55	14.69	19200.0
2006-07-06	CHB	ETF	10.46	10.71	10.23	10.56	667800.0
2006-07-06	CHI	ETF	19.48	19.55	19.37	19.55	69000.0
2006-07-06	CHIC	ETF	23.87	24.05	23.58	23.82	241060.0
2006-07-06	CHY	ETF	16.11	16.11	16.03	16.06	127700.0
2006-07-06	CIZ	ETF	22.55	22.55	22.55	22.55	200.0
2006-07-06	CN	ETF	36.1	36.49	35.8	36.46	50000.0
2006-07-06	CNXT	ETF	2.36	2.45	2.33	2.35	6666112.0
2006-07-06	CPI	ETF	29.74	29.74	29.74	29.74	600.0
2006-07-06	CPST	ETF	2.44	2.52	2.38	2.39	2480754.0
2006-07-06	CSA	ETF	18.9	18.99	18.75	18.95	97600.0
2006-07-06	CSB	ETF	27.53	27.66	27.48	27.5	11500.0
2006-07-06	CSQ	ETF	13.93	14.0	13.93	14.0	221100.0
2006-07-06	CTEC	ETF	63.89999999999999	64.5	63.45049999999999	63.849999999999994	14911.400000000001
2006-07-06	CYB	ETF	6.28	6.35	6.11	6.14	37100.0
2006-07-06	DBC	ETF	25.77	25.94	25.6	25.94	675800.0
2006-07-06	DDM	ETF	6.0942	6.1575	6.0883	6.1317	1147200.0
2006-07-06	DES	ETF	17.3167	17.35	17.2067	17.27	13500.0
2006-07-06	DEW	ETF	52.19	52.34	52.19	52.34	800.0
2006-07-06	DFJ	ETF	51.52	51.52	51.4	51.4	1300.0
2006-07-06	DGT	ETF	67.59	67.7	67.34	67.61	1300.0
2006-07-06	DHS	ETF	51.01	51.47	51.01	51.29	5600.0

> showing 50 of 351 rows — these rows as CSV

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