PREVIEW / etf_daily / 2006-08-31

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-31.parquet
  size:    18 KB
  rows:    356

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-08-31	SPY	ETF	130.85	130.99	130.58	130.64	37510300.0
2006-08-31	QQQ	ETF	38.94	39.03	38.76	38.87	61215492.0
2006-08-31	IWM	ETF	71.96	72.24	71.57	71.77	33830000.0
2006-08-31	DIA	ETF	113.86	114.08	113.68	113.81	3894800.0
2006-08-31	GLD	ETF	62.0	62.3	61.73	62.29	4842300.0
2006-08-31	TLT	ETF	87.74	88.2	87.74	88.08	1272400.0
2006-08-31	AAA	ETF	58.71	59.21	58.7	59.0	6200.0
2006-08-31	ADRE	ETF	32.35	32.7101	32.19	32.21	84488.0
2006-08-31	AFK	ETF	25.35	25.38	25.35	25.37	2100.0
2006-08-31	AGG	ETF	99.49	99.72	99.46	99.55	169200.0
2006-08-31	AIQ	ETF	32.5	32.6	32.1	32.4	27820.0
2006-08-31	AIS	ETF	1.08	1.35	1.05	1.35	293000.0
2006-08-31	AOM	ETF	9.91	10.5	9.89	9.99	1586100.0
2006-08-31	ARB	ETF	37.45	37.71	37.31	37.52	153800.0
2006-08-31	BAB	ETF	78.25	78.45	77.82	78.32	125500.0
2006-08-31	BBC	ETF	11.74	11.92	11.61	11.8	90400.0
2006-08-31	BBH	ETF	59.9967	59.9967	59.5833	59.8533	997800.0
2006-08-31	BITS	ETF	29.6	29.96	28.6	29.08	25254.0
2006-08-31	BKF	ETF	3.98	4.06	3.95	4.04	40000.0
2006-08-31	BNE	ETF	15.24	15.43	15.11	15.42	227000.0
2006-08-31	BRF	ETF	14.12	14.17	14.11	14.11	11700.0
2006-08-31	BTF	ETF	91.99999999999999	92.05	91.75	92.05	6100.0
2006-08-31	CBON	ETF	34.0	34.13	33.86	33.9	26576.0
2006-08-31	CDL	ETF	8.92	9.24	8.92	9.19	449100.0
2006-08-31	CEF	ETF	8.88	9.05	8.88	9.03	281400.0
2006-08-31	CEW	ETF	25.37	25.48	25.37	25.48	700.0
2006-08-31	CFO	ETF	10.1	10.1	10.1	10.1	10400.0
2006-08-31	CGO	ETF	15.58	15.59	15.3732	15.43	16400.0
2006-08-31	CHB	ETF	6.22	6.87	6.16	6.82	2089100.0
2006-08-31	CHI	ETF	20.35	20.42	20.2801	20.34	122000.0
2006-08-31	CHIC	ETF	27.02	27.1	26.57	26.7	365049.0
2006-08-31	CHY	ETF	16.69	16.69	16.62	16.67	125300.0
2006-08-31	CN	ETF	35.2	35.43	35.0	35.35	33100.0
2006-08-31	CNXT	ETF	2.13	2.15	2.04	2.05	9710564.0
2006-08-31	COMB	ETF	9.91	10.2	9.87	10.2	1939.0
2006-08-31	CPST	ETF	1.98	1.98	1.9	1.91	782010.0
2006-08-31	CSA	ETF	19.69	19.74	19.5	19.74	4800.0
2006-08-31	CSB	ETF	28.11	28.15	27.85	28.06	17400.0
2006-08-31	CSQ	ETF	14.5	14.56	14.46	14.56	319700.0
2006-08-31	CTEC	ETF	55.599999999999994	55.9	54.949999999999996	55.199999999999996	15324.400000000001
2006-08-31	CYB	ETF	6.44	6.6	6.3	6.6	74600.0
2006-08-31	DBC	ETF	24.98	25.1	24.75	25.0	158200.0
2006-08-31	DDM	ETF	6.2792	6.295	6.2658	6.2783	292800.0
2006-08-31	DES	ETF	17.6833	17.73	17.65	17.65	42600.0
2006-08-31	DEW	ETF	56.0	56.05	55.05	55.14	9400.0
2006-08-31	DFE	ETF	54.92	54.92	54.78	54.78	700.0
2006-08-31	DFJ	ETF	51.87	51.87	51.09	51.12	1400.0
2006-08-31	DGT	ETF	71.5	71.67	71.29	71.3	5800.0
2006-08-31	DHS	ETF	54.12	54.12	53.98	54.01	18700.0
2006-08-31	DIM	ETF	55.31	55.31	55.01	55.13	27900.0

> showing 50 of 356 rows — these rows as CSV

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