PREVIEW / etf_daily / 2007-09-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-05.parquet
  size:    23 KB
  rows:    505

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-09-05	SPY	ETF	148.2	148.36	147.0	147.79	166261800.0
2007-09-05	QQQ	ETF	49.55	49.65	48.87	49.18	114049217.0
2007-09-05	IWM	ETF	79.28	79.8	78.46	79.01	67145300.0
2007-09-05	DIA	ETF	133.77	133.82	132.49	133.22	11230800.0
2007-09-05	GLD	ETF	67.35	67.62	67.18	67.56	6268300.0
2007-09-05	TLT	ETF	88.76	89.35	88.72	89.27	1271500.0
2007-09-05	ADRE	ETF	47.0	47.29	46.33	46.57	167528.0
2007-09-05	AGG	ETF	99.09	99.74	99.09	99.6	294600.0
2007-09-05	AIQ	ETF	44.8	45.45	44.3	45.05	19420.0
2007-09-05	AIS	ETF	1.46	1.48	1.42	1.44	96800.0
2007-09-05	ARB	ETF	50.0	50.05	48.22	48.53	699500.0
2007-09-05	BBH	ETF	56.09	56.6433	55.7733	56.2867	1360200.0
2007-09-05	BIL	ETF	91.66	91.68	91.6	91.66	21400.0
2007-09-05	BITS	ETF	27.52	27.8	27.04	27.2	5056.0
2007-09-05	BIV	ETF	75.45	75.67	75.45	75.63	15000.0
2007-09-05	BLV	ETF	74.66	75.1	74.66	74.98	9600.0
2007-09-05	BMVP	ETF	16.9033	16.9033	16.7767	16.8233	152500.0
2007-09-05	BND	ETF	75.34	75.49	75.23	75.48	56800.0
2007-09-05	BNE	ETF	16.91	17.13	16.85	17.07	242100.0
2007-09-05	BRF	ETF	14.62	14.62	14.57	14.57	3200.0
2007-09-05	BSV	ETF	75.73	75.87	75.73	75.85	29100.0
2007-09-05	BTF	ETF	107.2	107.2	105.99999999999999	106.4	1100.0
2007-09-05	CBON	ETF	24.42	24.74	23.91	24.11	47137.0
2007-09-05	CDL	ETF	4.1	4.17	4.07	4.16	2767300.0
2007-09-05	CEF	ETF	9.26	9.28	9.15	9.23	191800.0
2007-09-05	CGO	ETF	17.0	17.1	16.82	17.0	25000.0
2007-09-05	CGW	ETF	24.74	24.74	24.39	24.65	128100.0
2007-09-05	CHB	ETF	11.94	12.05	10.92	11.03	1418900.0
2007-09-05	CHI	ETF	16.99	17.38	16.82	17.3699	127200.0
2007-09-05	CHIC	ETF	16.83	16.85	16.44	16.7	544395.0
2007-09-05	CHW	ETF	13.99	14.05	13.7	14.05	121400.0
2007-09-05	CHY	ETF	14.66	14.98	14.65	14.944	157800.0
2007-09-05	CN	ETF	48.42	49.0	47.71	47.96	109800.0
2007-09-05	CNXT	ETF	1.13	1.16	1.12	1.14	5084796.0
2007-09-05	CPST	ETF	1.17	1.3	1.16	1.234	4948351.0
2007-09-05	CSA	ETF	18.06	18.41	18.01	18.08	34000.0
2007-09-05	CSD	ETF	29.07	29.1	28.93	28.95	21200.0
2007-09-05	CSQ	ETF	14.35	14.39	14.09	14.09	331600.0
2007-09-05	CTEC	ETF	104.04999999999998	104.94999999999999	103.75	103.94999999999999	7391.8
2007-09-05	CVY	ETF	26.14	26.14	25.96	26.03	2519400.0
2007-09-05	CWI	ETF	26.5667	26.6	26.4667	26.5267	4200.0
2007-09-05	CZA	ETF	25.5	25.5	25.5	25.5	400.0
2007-09-05	DBA	ETF	27.57	27.65	27.14	27.32	162700.0
2007-09-05	DBB	ETF	24.9	24.9	24.42	24.46	38800.0
2007-09-05	DBC	ETF	25.98	26.1	25.8	26.03	222100.0
2007-09-05	DBE	ETF	28.56	28.6	28.39	28.58	7000.0
2007-09-05	DBO	ETF	26.89	26.91	26.76	26.91	5900.0
2007-09-05	DBP	ETF	26.04	26.22	26.04	26.22	2800.0
2007-09-05	DBS	ETF	23.96	24.0	23.93	23.95	1800.0
2007-09-05	DBV	ETF	27.48	27.6	27.31	27.43	170700.0

> showing 50 of 505 rows — these rows as CSV

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