PREVIEW / etf_daily / 2007-04-17

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-17.parquet
  size:    21 KB
  rows:    450

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-17	SPY	ETF	146.97	147.4	146.65	147.09	108424100.0
2007-04-17	QQQ	ETF	45.14	45.2	44.96	45.16	81881486.0
2007-04-17	IWM	ETF	82.61	82.63	81.94	82.23	51536000.0
2007-04-17	DIA	ETF	127.28	127.87	127.04	127.75	7932200.0
2007-04-17	GLD	ETF	68.31	68.48	67.98	68.0	4159000.0
2007-04-17	TLT	ETF	87.89	88.16	87.84	88.09	1254200.0
2007-04-17	AAA	ETF	68.61	68.98	68.57	68.92	10600.0
2007-04-17	ADRE	ETF	42.39	42.39	41.45	41.72	245175.0
2007-04-17	AGG	ETF	99.91	100.08	99.84	100.08	368200.0
2007-04-17	AIQ	ETF	45.75	46.5	43.9	43.9	42820.0
2007-04-17	AIS	ETF	1.45	1.5	1.4499	1.47	358500.0
2007-04-17	ARB	ETF	49.14	49.19	48.13	48.74	235800.0
2007-04-17	BAB	ETF	104.02	104.14	103.56	103.56	28100.0
2007-04-17	BBH	ETF	60.74	61.0	60.6733	60.9667	877500.0
2007-04-17	BITS	ETF	32.16	33.44	32.0	33.16	22933.0
2007-04-17	BIV	ETF	75.15	75.19	75.15	75.17	5300.0
2007-04-17	BLV	ETF	75.36	75.43	75.31	75.41	17900.0
2007-04-17	BND	ETF	75.16	75.17	75.1	75.17	25600.0
2007-04-17	BNE	ETF	16.95	17.15	16.87	16.94	178600.0
2007-04-17	BRF	ETF	14.5	14.51	14.5	14.51	1900.0
2007-04-17	BSV	ETF	75.01	75.12	75.01	75.09	83700.0
2007-04-17	BTF	ETF	110.85000000000001	111.85	110.85000000000001	111.35	560.0
2007-04-17	CBON	ETF	29.41	29.92	29.41	29.51	39042.0
2007-04-17	CDL	ETF	9.73	9.73	9.63	9.69	163400.0
2007-04-17	CEF	ETF	9.77	9.8	9.68	9.68	262300.0
2007-04-17	CGO	ETF	17.48	17.95	17.48	17.88	24500.0
2007-04-17	CHB	ETF	10.25	10.46	9.85	9.89	2501100.0
2007-04-17	CHI	ETF	20.16	20.27	20.03	20.13	125700.0
2007-04-17	CHIC	ETF	29.17	29.85	28.83	29.63	535289.0
2007-04-17	CHY	ETF	17.05	17.13	17.01	17.1	127100.0
2007-04-17	CIL	ETF	25.77	25.77	25.75	25.75	600.0
2007-04-17	CN	ETF	53.4	54.24	53.4	53.75	66200.0
2007-04-17	CNXT	ETF	1.48	1.48	1.43	1.44	5331644.0
2007-04-17	CPI	ETF	21.58	21.58	21.2465	21.27	1700.0
2007-04-17	CPST	ETF	1.21	1.27	1.16	1.18	5678138.0
2007-04-17	CSA	ETF	21.0	21.21	21.0	21.08	15700.0
2007-04-17	CSB	ETF	33.54	33.74	33.45	33.62	13100.0
2007-04-17	CSD	ETF	28.59	28.65	28.53	28.59	25000.0
2007-04-17	CSQ	ETF	15.36	15.42	15.32	15.4	348000.0
2007-04-17	CTEC	ETF	88.0	92.14999999999999	88.0	89.64999999999999	17391.0
2007-04-17	CVY	ETF	27.45	27.45	27.35	27.42	10500.0
2007-04-17	CWI	ETF	26.62	26.66	26.5	26.6	64800.0
2007-04-17	CZA	ETF	25.8	25.8	25.78	25.78	700.0
2007-04-17	DBA	ETF	25.65	25.81	25.24	25.27	169600.0
2007-04-17	DBB	ETF	27.18	27.96	27.07	27.87	31700.0
2007-04-17	DBC	ETF	25.57	25.68	25.12	25.24	196900.0
2007-04-17	DBE	ETF	27.7	27.72	27.04	27.13	9300.0
2007-04-17	DBO	ETF	26.38	26.38	25.97	25.97	3100.0
2007-04-17	DBP	ETF	27.27	27.28	27.14	27.16	4500.0
2007-04-17	DBS	ETF	27.56	27.57	27.4	27.4	3200.0

> showing 50 of 450 rows — these rows as CSV

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