PREVIEW / etf_daily / 2007-09-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-12.parquet
  size:    22 KB
  rows:    494

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-12	SPY	ETF	147.29	148.44	146.98	147.87	149554600.0
2007-09-12	QQQ	ETF	48.84	49.37	48.78	48.94	94012155.0
2007-09-12	IWM	ETF	77.67	78.16	77.38	77.5	62793300.0
2007-09-12	DIA	ETF	132.93	133.69	132.73	133.25	11402900.0
2007-09-12	GLD	ETF	70.5	70.63	69.83	70.46	8032800.0
2007-09-12	TLT	ETF	90.9	90.94	90.42	90.59	4458300.0
2007-09-12	ADRE	ETF	46.75	47.31	46.59	46.96	228185.0
2007-09-12	AGG	ETF	100.21	100.26	100.02	100.12	2039700.0
2007-09-12	AIQ	ETF	44.35	45.1	44.2	44.55	14960.0
2007-09-12	AIS	ETF	1.35	1.4	1.35	1.4	64000.0
2007-09-12	ARB	ETF	46.75	47.1	46.41	46.5	230500.0
2007-09-12	BBH	ETF	57.6667	58.2167	57.4233	57.8733	572100.0
2007-09-12	BIL	ETF	91.68	91.78	91.66	91.78	3450.0
2007-09-12	BITS	ETF	28.04	28.24	27.96	28.24	6473.0
2007-09-12	BIV	ETF	75.98	76.01	75.8	75.87	15000.0
2007-09-12	BLV	ETF	75.87	75.87	75.5	75.6	16500.0
2007-09-12	BMVP	ETF	16.6	16.76	16.59	16.66	45500.0
2007-09-12	BND	ETF	75.83	75.83	75.7	75.73	73900.0
2007-09-12	BNE	ETF	16.11	16.28	15.99	16.1	327900.0
2007-09-12	BRF	ETF	14.56	14.56	14.5401	14.56	16200.0
2007-09-12	BSV	ETF	76.02	76.02	75.93	75.97	52200.0
2007-09-12	BTF	ETF	104.19999999999999	104.94999999999999	103.75	103.75	2120.0
2007-09-12	CBON	ETF	23.91	24.08	23.68	23.9	54734.0
2007-09-12	CDL	ETF	4.13	4.22	4.09	4.2	2911000.0
2007-09-12	CEF	ETF	9.49	9.51	9.33	9.36	1383200.0
2007-09-12	CGO	ETF	16.77	17.0	16.77	16.83	13200.0
2007-09-12	CGW	ETF	24.46	24.75	24.3648	24.7	45800.0
2007-09-12	CHB	ETF	11.03	11.27	10.77	10.88	789900.0
2007-09-12	CHI	ETF	16.8	16.96	16.68	16.7	96900.0
2007-09-12	CHIC	ETF	16.75	17.12	16.61	16.86	264095.0
2007-09-12	CHW	ETF	13.36	13.4	13.03	13.18	110700.0
2007-09-12	CHY	ETF	14.78	14.78	14.5	14.57	118100.0
2007-09-12	CN	ETF	46.76	47.56	46.55	47.14	151500.0
2007-09-12	CNXT	ETF	1.32	1.351	1.28	1.28	8809194.0
2007-09-12	CPST	ETF	1.16	1.18	1.13	1.14	720911.0
2007-09-12	CSA	ETF	17.97	18.22	17.92	18.1	84100.0
2007-09-12	CSD	ETF	28.39	28.53	28.39	28.46	24600.0
2007-09-12	CSM	ETF	1.4425	1.445	1.4425	1.445	40800.0
2007-09-12	CSQ	ETF	14.05	14.17	13.99	14.0	212800.0
2007-09-12	CTEC	ETF	104.0	106.44999999999999	104.0	105.99999999999999	30752.4
2007-09-12	CVY	ETF	25.56	25.74	25.56	25.66	4400.0
2007-09-12	CWI	ETF	26.62	26.8	26.6133	26.7333	15300.0
2007-09-12	CZA	ETF	25.36	25.36	25.36	25.36	100.0
2007-09-12	DBA	ETF	27.24	27.68	27.0	27.37	554200.0
2007-09-12	DBB	ETF	24.76	24.81	24.63	24.74	30800.0
2007-09-12	DBC	ETF	26.33	26.66	26.27	26.62	207600.0
2007-09-12	DBE	ETF	29.39	29.87	29.27	29.69	14100.0
2007-09-12	DBO	ETF	27.85	28.4	27.85	28.16	30500.0
2007-09-12	DBP	ETF	27.22	27.31	27.02	27.29	58200.0
2007-09-12	DBS	ETF	24.81	24.91	24.65	24.82	9900.0

> showing 50 of 494 rows — these rows as CSV

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