PREVIEW / etf_daily / 2007-04-30

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-30.parquet
  size:    21 KB
  rows:    455

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-30	SPY	ETF	149.64	149.74	148.21	148.29	100874100.0
2007-04-30	QQQ	ETF	46.5	46.53	45.92	45.96	93469692.0
2007-04-30	IWM	ETF	82.47	82.52	80.72	80.74	86447400.0
2007-04-30	DIA	ETF	131.17	131.98	130.54	130.67	10288000.0
2007-04-30	GLD	ETF	67.2	67.52	67.04	67.09	2605400.0
2007-04-30	TLT	ETF	88.33	88.75	88.25	88.75	485700.0
2007-04-30	AAA	ETF	74.35	75.5	73.75	75.13	45800.0
2007-04-30	ADRE	ETF	41.6	41.64	40.72	40.78	172929.0
2007-04-30	AGG	ETF	100.3	100.46	100.24	100.46	298600.0
2007-04-30	AIQ	ETF	44.5	45.8	44.45	45.0	59928.0
2007-04-30	AIS	ETF	1.53	1.53	1.48	1.5	283600.0
2007-04-30	ARB	ETF	49.25	49.48	49.06	49.28	194100.0
2007-04-30	BAB	ETF	101.56	102.65	101.18	101.18	59100.0
2007-04-30	BBH	ETF	62.68	62.68	62.3033	62.3833	418500.0
2007-04-30	BITS	ETF	34.76	35.92	34.68	34.88	11545.0
2007-04-30	BIV	ETF	75.44	75.6	75.44	75.6	11300.0
2007-04-30	BLV	ETF	75.56	75.92	75.56	75.92	13000.0
2007-04-30	BMVP	ETF	17.9367	17.9723	17.7733	17.7733	38900.0
2007-04-30	BND	ETF	75.42	75.49	75.39	75.49	35900.0
2007-04-30	BNE	ETF	16.7	16.74	16.64	16.68	242000.0
2007-04-30	BOSS	ETF	48.29	49.09	48.29	49.09	100.0
2007-04-30	BRF	ETF	14.52	14.52	14.51	14.51	2700.0
2007-04-30	BSV	ETF	75.29	75.37	75.29	75.35	57600.0
2007-04-30	BTF	ETF	112.05	112.5	110.99999999999999	110.99999999999999	1800.0
2007-04-30	CBON	ETF	30.8	31.45	30.71	30.71	134698.0
2007-04-30	CDL	ETF	9.37	9.41	9.15	9.18	411300.0
2007-04-30	CEF	ETF	9.6	9.64	9.37	9.43	420100.0
2007-04-30	CGO	ETF	17.75	17.75	17.53	17.64	9400.0
2007-04-30	CHB	ETF	10.8	10.87	10.17	10.28	1767002.0
2007-04-30	CHI	ETF	20.17	20.22	20.15	20.17	83000.0
2007-04-30	CHIC	ETF	28.75	28.79	27.03	27.33	970039.0
2007-04-30	CHY	ETF	17.01	17.08	16.93	17.04	107700.0
2007-04-30	CIL	ETF	25.82	25.82	25.81	25.81	1900.0
2007-04-30	CN	ETF	48.8	49.75	48.8	49.06	62600.0
2007-04-30	CNXT	ETF	1.45	1.57	1.45	1.55	22841103.0
2007-04-30	CPI	ETF	21.85	21.85	21.85	21.85	200.0
2007-04-30	CPST	ETF	1.04	1.07	0.99	1.0	2343349.0
2007-04-30	CSA	ETF	20.63	20.81	20.53	20.69	26800.0
2007-04-30	CSB	ETF	33.46	33.52	33.18	33.25	39900.0
2007-04-30	CSD	ETF	28.82	28.89	28.53	28.58	21700.0
2007-04-30	CSM	ETF	1.3575	1.3575	1.345	1.345	36400.0
2007-04-30	CSQ	ETF	15.5	15.59	15.37	15.47	280600.0
2007-04-30	CTEC	ETF	91.35	97.2	90.1	96.89999999999999	40200.200000000004
2007-04-30	CVY	ETF	27.87	27.87	27.53	27.53	23700.0
2007-04-30	CWI	ETF	26.5333	26.66	26.3733	26.4133	12900.0
2007-04-30	CZA	ETF	26.31	26.32	26.31	26.32	300.0
2007-04-30	DBA	ETF	24.92	25.19	24.82	24.85	281700.0
2007-04-30	DBB	ETF	27.6	27.81	27.51	27.57	29600.0
2007-04-30	DBC	ETF	25.65	25.8	25.5	25.57	172200.0
2007-04-30	DBE	ETF	28.21	28.43	28.08	28.1	104400.0

> showing 50 of 455 rows — these rows as CSV

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