PREVIEW / etf_daily / 2007-10-29

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-29.parquet
  size:    24 KB
  rows:    521

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-10-29	SPY	ETF	153.93	154.44	153.55	154.13	106841000.0
2007-10-29	QQQ	ETF	54.19	54.33	53.84	54.16	101897569.0
2007-10-29	IWM	ETF	82.22	82.44	81.39	81.92	56217000.0
2007-10-29	DIA	ETF	138.28	138.87	138.16	138.65	8663400.0
2007-10-29	GLD	ETF	78.27	78.32	77.65	78.12	6881000.0
2007-10-29	TLT	ETF	90.5	90.99	90.48	90.85	881000.0
2007-10-29	ADRE	ETF	59.77	59.97	59.22	59.77	452459.0
2007-10-29	AGG	ETF	100.78	100.89	100.6	100.76	261000.0
2007-10-29	AIQ	ETF	47.5	47.85	46.0	46.05	22880.0
2007-10-29	AIS	ETF	1.23	1.23	1.2	1.22	61300.0
2007-10-29	AIVI	ETF	76.95	77.05	76.55	77.03	34300.0
2007-10-29	ARB	ETF	50.41	50.74	49.36	50.14	353100.0
2007-10-29	BBH	ETF	60.27	60.27	59.5233	59.9567	500100.0
2007-10-29	BIL	ETF	91.82	91.86	91.78	91.86	7600.0
2007-10-29	BITS	ETF	25.84	26.64	25.4	26.64	8099.0
2007-10-29	BIV	ETF	76.41	76.58	76.35	76.51	11600.0
2007-10-29	BLV	ETF	76.18	76.65	76.18	76.62	3500.0
2007-10-29	BMVP	ETF	17.6167	17.64	17.53	17.6033	57500.0
2007-10-29	BND	ETF	76.29	76.4	76.25	76.36	54500.0
2007-10-29	BNE	ETF	17.5	17.56	17.32	17.47	144100.0
2007-10-29	BRF	ETF	14.7	14.7	14.65	14.7	4600.0
2007-10-29	BSV	ETF	76.39	76.43	76.35	76.38	37300.0
2007-10-29	BTF	ETF	115.0	116.25	114.94999999999999	115.89999999999999	2620.0
2007-10-29	BWX	ETF	26.55	26.605	26.525	26.59	377600.0
2007-10-29	CBON	ETF	20.6	20.67	20.09	20.12	46635.0
2007-10-29	CDL	ETF	4.37	4.45	4.3	4.38	1417300.0
2007-10-29	CEF	ETF	10.4	10.5	10.4	10.48	556800.0
2007-10-29	CGO	ETF	19.35	19.57	19.22	19.4	17500.0
2007-10-29	CGW	ETF	26.55	26.6	25.4001	26.45	86100.0
2007-10-29	CHB	ETF	12.61	12.61	11.35	11.52	6650600.0
2007-10-29	CHI	ETF	16.92	17.04	16.92	16.92	121300.0
2007-10-29	CHIC	ETF	14.79	15.02	14.66	15.0	334583.0
2007-10-29	CHW	ETF	13.12	13.24	13.01	13.15	163800.0
2007-10-29	CHY	ETF	14.86	15.0	14.85	14.87	105200.0
2007-10-29	CMF	ETF	51.955	52.06	51.94	51.94	13800.0
2007-10-29	CN	ETF	62.9	63.59	62.56	62.79	193200.0
2007-10-29	CNXT	ETF	1.21	1.28	1.21	1.28	7014727.0
2007-10-29	COW	ETF	48.82	48.82	48.82	48.82	100.0
2007-10-29	CPST	ETF	1.08	1.19	1.08	1.15	5131536.0
2007-10-29	CSA	ETF	17.34	17.34	16.98	17.03	55800.0
2007-10-29	CSD	ETF	28.9	28.99	28.73	28.89	185600.0
2007-10-29	CSQ	ETF	14.7	14.8	14.68	14.73	241600.0
2007-10-29	CVY	ETF	25.96	25.96	25.78	25.83	10900.0
2007-10-29	CWI	ETF	29.8333	29.9733	29.76	29.9667	48150.0
2007-10-29	CZA	ETF	26.88	26.88	26.88	26.88	1300.0
2007-10-29	DBA	ETF	29.75	29.81	29.52	29.81	356100.0
2007-10-29	DBB	ETF	26.01	26.04	25.77	25.95	19400.0
2007-10-29	DBC	ETF	30.0	30.34	29.9328	30.34	435700.0
2007-10-29	DBE	ETF	33.66	34.27	33.65	34.27	30300.0
2007-10-29	DBO	ETF	33.27	34.34	32.0	33.9	14700.0

> showing 50 of 521 rows — these rows as CSV

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