PREVIEW / etf_daily / 2006-07-12

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-12.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-12	SPY	ETF	127.15	127.4	125.72	126.05	82561300.0
2006-07-12	QQQ	ETF	37.56	37.64	36.84	36.93	154458865.0
2006-07-12	IWM	ETF	70.78	71.08	69.59	69.65	50664800.0
2006-07-12	DIA	ETF	111.34	111.52	109.98	110.33	4850200.0
2006-07-12	GLD	ETF	64.65	65.19	63.01	64.92	9450300.0
2006-07-12	TLT	ETF	84.33	84.82	84.27	84.66	641000.0
2006-07-12	AAA	ETF	55.79	56.18	55.66	55.92	2800.0
2006-07-12	ADRE	ETF	31.3	31.44	30.95	30.95	301159.0
2006-07-12	AFK	ETF	25.0	25.1	24.98	25.0	91200.0
2006-07-12	AGG	ETF	97.5	97.67	97.4	97.67	173100.0
2006-07-12	AIQ	ETF	32.75	32.75	30.45	31.3	46220.0
2006-07-12	AIS	ETF	1.04	1.1	1.02	1.1	157700.0
2006-07-12	AOM	ETF	5.95	6.51	5.95	6.38	72600.0
2006-07-12	ARB	ETF	37.8	37.87	36.8	36.94	233400.0
2006-07-12	BAB	ETF	66.89	66.89	65.71	66.03	23500.0
2006-07-12	BBC	ETF	13.42	13.46	12.9	13.07	142700.0
2006-07-12	BBH	ETF	59.4633	59.4633	58.7333	58.8467	1879200.0
2006-07-12	BITS	ETF	18.2	18.892	18.2	18.56	5926.0
2006-07-12	BKF	ETF	5.75	6.0	5.73	5.98	18400.0
2006-07-12	BNE	ETF	14.05	14.08	13.45	13.49	154800.0
2006-07-12	BRF	ETF	13.95	13.95	13.86	13.89	3400.0
2006-07-12	BTF	ETF	89.49999999999999	89.49999999999999	88.55	88.55	1100.0
2006-07-12	CBON	ETF	32.42	32.6	31.91	31.92	53540.0
2006-07-12	CDL	ETF	9.03	9.04	8.8	8.83	147400.0
2006-07-12	CEF	ETF	9.05	9.14	8.88	9.07	391800.0
2006-07-12	CFO	ETF	10.0	10.15	9.96	10.0	40200.0
2006-07-12	CGO	ETF	14.55	14.8	14.55	14.76	18000.0
2006-07-12	CHB	ETF	10.07	10.14	9.81	9.83	922800.0
2006-07-12	CHI	ETF	19.34	19.62	19.34	19.6	71400.0
2006-07-12	CHIC	ETF	22.92	23.29	22.37	22.41	148178.0
2006-07-12	CHY	ETF	16.1	16.1	16.01	16.09	98700.0
2006-07-12	CIL	ETF	25.16	25.16	25.16	25.16	100.0
2006-07-12	CN	ETF	36.2	36.39	36.18	36.28	55200.0
2006-07-12	CNXT	ETF	2.21	2.2501	2.1	2.14	7714929.0
2006-07-12	COMB	ETF	9.9	9.9	9.68	9.9	8100.0
2006-07-12	CPI	ETF	29.55	29.55	29.55	29.55	200.0
2006-07-12	CPST	ETF	2.29	2.33	2.24	2.26	657449.0
2006-07-12	CSA	ETF	18.75	18.92	18.75	18.75	1500.0
2006-07-12	CSB	ETF	27.78	27.78	27.5	27.61	2200.0
2006-07-12	CSQ	ETF	14.04	14.04	13.92	13.96	264200.0
2006-07-12	CTEC	ETF	64.89999999999999	65.39999999999999	64.0	64.4	10878.6
2006-07-12	CYB	ETF	6.15	6.15	5.95	6.06	50400.0
2006-07-12	DBC	ETF	26.3	26.4	25.95	26.39	395000.0
2006-07-12	DDM	ETF	6.0292	6.03	5.8792	5.88	1320000.0
2006-07-12	DES	ETF	17.3267	17.33	17.0967	17.1	21000.0
2006-07-12	DEW	ETF	51.7	51.7	51.6	51.6	1400.0
2006-07-12	DFE	ETF	53.08	53.08	52.82	52.82	400.0
2006-07-12	DFJ	ETF	50.3	50.3	49.51	49.51	4500.0
2006-07-12	DGT	ETF	67.8	67.8	67.0	67.0	3400.0
2006-07-12	DHS	ETF	51.57	51.66	51.1	51.16	10900.0

> showing 50 of 351 rows — these rows as CSV

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