PREVIEW / etf_daily / 2007-02-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-23.parquet
  size:    21 KB
  rows:    436

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-02-23	SPY	ETF	145.74	145.79	145.03	145.3	71966200.0
2007-02-23	QQQ	ETF	45.42	45.46	45.06	45.26	113507050.0
2007-02-23	IWM	ETF	82.26	82.31	81.66	81.95	57987800.0
2007-02-23	DIA	ETF	126.72	126.74	126.27	126.41	5916600.0
2007-02-23	GLD	ETF	67.35	68.29	67.35	67.72	8126200.0
2007-02-23	TLT	ETF	88.53	88.94	88.49	88.84	735700.0
2007-02-23	AAA	ETF	61.16	61.36	61.16	61.22	3100.0
2007-02-23	ADRE	ETF	40.85	40.869	40.16	40.37	247415.0
2007-02-23	AGG	ETF	100.11	100.37	100.11	100.29	360200.0
2007-02-23	AIQ	ETF	39.5	40.15	39.25	39.4	73960.0
2007-02-23	AIS	ETF	1.24	1.25	1.21	1.25	98500.0
2007-02-23	ARB	ETF	45.7	45.7	45.38	45.57	112100.0
2007-02-23	BAB	ETF	110.67	111.26	110.51	111.17	34300.0
2007-02-23	BBC	ETF	4.3499	4.4	4.31	4.35	118300.0
2007-02-23	BBH	ETF	62.3667	62.71	62.0167	62.3333	1160700.0
2007-02-23	BITS	ETF	46.08	48.08	45.6	45.8	41562.0
2007-02-23	BNE	ETF	15.76	15.92	15.7	15.91	420000.0
2007-02-23	BOSS	ETF	44.85	45.0	44.85	45.0	100.0
2007-02-23	BRF	ETF	14.51	14.51	14.51	14.51	1700.0
2007-02-23	BTF	ETF	112.79999999999998	113.49999999999999	112.79999999999998	113.3	3240.0
2007-02-23	CBON	ETF	33.66	33.66	33.33	33.46	30349.0
2007-02-23	CDL	ETF	10.4	10.42	10.25	10.33	373200.0
2007-02-23	CEF	ETF	9.8	9.94	9.74	9.92	576700.0
2007-02-23	CGO	ETF	16.9	17.19	16.87	17.19	14500.0
2007-02-23	CHB	ETF	7.53	7.53	7.32	7.37	2057200.0
2007-02-23	CHI	ETF	20.15	20.2	20.1	20.2	78800.0
2007-02-23	CHIC	ETF	30.76	31.34	30.61	31.08	606016.0
2007-02-23	CHY	ETF	16.88	17.02	16.85	17.01	112900.0
2007-02-23	CIL	ETF	25.5	25.59	25.44	25.59	4200.0
2007-02-23	CN	ETF	50.44	50.46	49.8	49.92	65500.0
2007-02-23	CNXT	ETF	2.08	2.09	2.02	2.05	11612597.0
2007-02-23	CPST	ETF	1.06	1.08	1.0	1.01	3884725.0
2007-02-23	CSA	ETF	22.7	22.71	22.15	22.6	20400.0
2007-02-23	CSB	ETF	33.31	33.38	33.1535	33.31	14500.0
2007-02-23	CSD	ETF	26.79	26.8	26.66	26.78	11200.0
2007-02-23	CSQ	ETF	15.13	15.28	15.09	15.25	368900.0
2007-02-23	CTEC	ETF	79.95	85.35	79.95	83.9	30996.4
2007-02-23	CVY	ETF	27.24	27.26	27.03	27.25	35600.0
2007-02-23	CWI	ETF	25.5467	25.64	25.5333	25.6267	65700.0
2007-02-23	DBA	ETF	27.4	27.45	27.1	27.19	698100.0
2007-02-23	DBB	ETF	25.15	25.38	25.05	25.22	22600.0
2007-02-23	DBC	ETF	25.28	25.42	25.14	25.24	527700.0
2007-02-23	DBE	ETF	26.26	26.41	26.11	26.23	130700.0
2007-02-23	DBO	ETF	25.52	25.9	25.36	25.62	8600.0
2007-02-23	DBP	ETF	27.37	27.53	27.27	27.37	38800.0
2007-02-23	DBS	ETF	28.63	28.75	28.533	28.65	26600.0
2007-02-23	DBV	ETF	26.78	26.8	26.7	26.77	179000.0
2007-02-23	DDM	ETF	7.0942	7.0958	7.0625	7.0925	1281600.0
2007-02-23	DEF	ETF	26.44	26.44	26.31	26.3456	5900.0
2007-02-23	DES	ETF	19.85	19.85	19.73	19.78	27900.0

> showing 50 of 436 rows — these rows as CSV

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