PREVIEW / etf_daily / 2007-04-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-26.parquet
  size:    21 KB
  rows:    451

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
2007-04-26	SPY	ETF	149.49	149.8	149.1	149.65	88741600.0
2007-04-26	QQQ	ETF	46.42	46.65	46.33	46.55	99409986.0
2007-04-26	IWM	ETF	82.45	83.17	81.97	82.87	47381600.0
2007-04-26	DIA	ETF	130.8	131.22	130.62	131.2	9708800.0
2007-04-26	GLD	ETF	67.43	67.43	66.5	66.87	4668000.0
2007-04-26	TLT	ETF	88.43	88.43	87.85	87.85	2048400.0
2007-04-26	AAA	ETF	71.67	72.3	71.47	72.26	22300.0
2007-04-26	ADRE	ETF	42.15	42.2	41.67	41.79	117760.0
2007-04-26	AGG	ETF	100.31	100.31	100.06	100.14	251900.0
2007-04-26	AIQ	ETF	45.3	45.7	44.75	45.5	27240.0
2007-04-26	AIS	ETF	1.58	1.58	1.52	1.58	227700.0
2007-04-26	ARB	ETF	49.47	49.65	49.04	49.47	110300.0
2007-04-26	BAB	ETF	102.2	102.48	100.99	101.85	55300.0
2007-04-26	BBH	ETF	62.3333	62.7	62.3333	62.6333	140400.0
2007-04-26	BITS	ETF	32.44	36.08	32.24	35.8	44665.0
2007-04-26	BIV	ETF	75.44	75.44	75.28	75.28	3300.0
2007-04-26	BLV	ETF	75.67	75.67	75.4	75.44	37100.0
2007-04-26	BMVP	ETF	17.9833	17.9839	17.9167	17.9533	27800.0
2007-04-26	BND	ETF	75.38	75.38	75.25	75.26	68400.0
2007-04-26	BNE	ETF	16.87	16.97	16.72	16.85	289300.0
2007-04-26	BRF	ETF	14.54	14.55	14.517	14.54	9300.0
2007-04-26	BSV	ETF	75.3	75.3	75.22	75.22	16400.0
2007-04-26	BTF	ETF	111.95	112.44999999999999	111.95	112.39999999999999	2220.0
2007-04-26	CBON	ETF	31.31	31.35	30.89	31.05	63063.0
2007-04-26	CDL	ETF	10.12	10.12	9.79	9.81	159000.0
2007-04-26	CEF	ETF	9.56	9.56	9.36	9.44	603400.0
2007-04-26	CGO	ETF	17.75	17.88	17.62	17.78	27500.0
2007-04-26	CHB	ETF	10.61	11.25	10.58	11.16	2529100.0
2007-04-26	CHI	ETF	20.24	20.29	20.21	20.24	55600.0
2007-04-26	CHIC	ETF	29.28	30.46	28.53	29.37	1786705.0
2007-04-26	CHY	ETF	17.04	17.1	17.03	17.07	59300.0
2007-04-26	CIL	ETF	25.82	25.82	25.81	25.82	1600.0
2007-04-26	CN	ETF	51.0	51.19	50.5	51.02	47400.0
2007-04-26	CNXT	ETF	1.56	1.58	1.47	1.51	10379171.0
2007-04-26	CPI	ETF	21.3	21.75	21.3	21.75	12100.0
2007-04-26	CPST	ETF	1.15	1.16	1.11	1.11	2401949.0
2007-04-26	CSA	ETF	21.0	21.18	20.95	21.16	33300.0
2007-04-26	CSB	ETF	33.67	33.84	33.36	33.69	21400.0
2007-04-26	CSD	ETF	29.06	29.11	28.82	28.98	18800.0
2007-04-26	CSM	ETF	1.385	1.385	1.3825	1.3825	8000.0
2007-04-26	CSQ	ETF	15.5	15.54	15.48	15.52	285300.0
2007-04-26	CTEC	ETF	89.35	90.0	88.14999999999999	89.39999999999999	11532.0
2007-04-26	CVY	ETF	27.67	27.8	27.67	27.79	19500.0
2007-04-26	CWI	ETF	26.66	26.7	26.5667	26.6333	34950.0
2007-04-26	CZA	ETF	26.3	26.3	26.3	26.3	400.0
2007-04-26	DBA	ETF	25.85	25.9	25.32	25.44	185600.0
2007-04-26	DBB	ETF	27.25	27.47	26.83	27.47	30600.0
2007-04-26	DBC	ETF	25.68	25.89	25.48	25.67	635300.0
2007-04-26	DBE	ETF	27.88	28.21	27.88	28.04	42300.0
2007-04-26	DBO	ETF	26.47	26.68	26.31	26.33	6600.0

> showing 50 of 451 rows — these rows as CSV

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