PREVIEW / etf_daily / 2007-09-10

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-10.parquet
  size:    23 KB
  rows:    492

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-10	SPY	ETF	146.52	146.72	144.33	145.79	192305900.0
2007-09-10	QQQ	ETF	48.62	48.75	47.81	48.2	125209015.0
2007-09-10	IWM	ETF	77.91	77.96	75.62	76.65	99748500.0
2007-09-10	DIA	ETF	131.84	132.07	130.24	131.43	14392100.0
2007-09-10	GLD	ETF	69.96	69.96	68.73	69.62	7598500.0
2007-09-10	TLT	ETF	90.5	91.27	90.5	91.0	2495200.0
2007-09-10	ADRE	ETF	46.46	46.56	45.3	46.0	203039.0
2007-09-10	AGG	ETF	100.29	100.54	100.13	100.44	285900.0
2007-09-10	AIQ	ETF	44.0	44.0	41.25	42.7	18020.0
2007-09-10	AIS	ETF	1.38	1.39	1.34	1.34	124700.0
2007-09-10	ARB	ETF	48.19	48.19	45.78	46.95	516000.0
2007-09-10	BBH	ETF	57.1	57.17	56.2167	56.68	338700.0
2007-09-10	BIL	ETF	91.7	91.74	91.62	91.74	35100.0
2007-09-10	BITS	ETF	26.76	28.08	26.12	27.16	21229.0
2007-09-10	BIV	ETF	76.07	76.31	75.91	76.08	31800.0
2007-09-10	BLV	ETF	75.75	76.13	75.72	75.98	37500.0
2007-09-10	BMVP	ETF	16.64	16.64	16.34	16.48	122700.0
2007-09-10	BND	ETF	75.95	76.14	75.9	76.03	94800.0
2007-09-10	BNE	ETF	16.53	16.61	16.03	16.21	192500.0
2007-09-10	BRF	ETF	14.65	14.71	14.6	14.64	6300.0
2007-09-10	BSV	ETF	76.05	76.17	76.0	76.1	13400.0
2007-09-10	BTF	ETF	104.60000000000001	104.60000000000001	103.45	104.14999999999999	2620.0
2007-09-10	CBON	ETF	24.46	24.48	23.78	24.13	39554.0
2007-09-10	CDL	ETF	4.24	4.24	4.04	4.1	2201100.0
2007-09-10	CEF	ETF	9.59	9.6	9.45	9.55	384600.0
2007-09-10	CGO	ETF	16.95	17.13	16.75	16.8	25500.0
2007-09-10	CGW	ETF	24.34	24.36	23.89	24.21	135400.0
2007-09-10	CHB	ETF	10.25	10.9	10.25	10.66	1527400.0
2007-09-10	CHI	ETF	17.53	17.54	17.09	17.26	148700.0
2007-09-10	CHIC	ETF	16.82	16.94	16.25	16.5	350819.0
2007-09-10	CHW	ETF	13.87	13.92	13.51	13.6	147300.0
2007-09-10	CHY	ETF	14.95	15.02	14.69	14.94	180700.0
2007-09-10	CN	ETF	47.33	47.81	46.73	47.5	115900.0
2007-09-10	CNXT	ETF	1.39	1.42	1.3	1.37	17814706.0
2007-09-10	CPST	ETF	1.2	1.23	1.09	1.1	3432460.0
2007-09-10	CSA	ETF	17.9101	18.12	17.6	18.08	38600.0
2007-09-10	CSD	ETF	28.58	28.58	28.17	28.23	10400.0
2007-09-10	CSQ	ETF	14.15	14.34	14.03	14.17	228200.0
2007-09-10	CTEC	ETF	103.75	103.85	100.0	101.6	6528.0
2007-09-10	CVY	ETF	25.65	25.65	25.29	25.41	35200.0
2007-09-10	CWI	ETF	26.4	26.42	26.1467	26.3267	5250.0
2007-09-10	CZA	ETF	25.21	25.21	25.21	25.21	300.0
2007-09-10	DBA	ETF	27.17	27.17	26.69	26.88	127900.0
2007-09-10	DBB	ETF	24.32	24.37	24.09	24.2	19600.0
2007-09-10	DBC	ETF	26.02	26.32	25.81	26.28	154200.0
2007-09-10	DBE	ETF	28.56	29.28	28.56	29.14	4800.0
2007-09-10	DBO	ETF	27.22	27.59	27.05	27.59	26500.0
2007-09-10	DBP	ETF	27.07	27.07	26.79	26.91	16600.0
2007-09-10	DBS	ETF	24.81	24.81	24.4868	24.73	9600.0
2007-09-10	DBV	ETF	27.17	27.26	27.06	27.26	208600.0

> showing 50 of 492 rows — these rows as CSV

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