PREVIEW / etf_daily / 2007-02-28

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-28.parquet
  size:    21 KB
  rows:    444

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-28	SPY	ETF	140.39	141.98	139.8	140.93	177536300.0
2007-02-28	QQQ	ETF	43.16	43.76	42.93	43.33	217539443.0
2007-02-28	IWM	ETF	78.37	79.22	77.51	78.83	97620200.0
2007-02-28	DIA	ETF	122.41	123.47	121.5	122.66	19617800.0
2007-02-28	GLD	ETF	66.73	66.93	65.54	66.48	8924200.0
2007-02-28	TLT	ETF	90.16	90.47	89.89	90.15	1701900.0
2007-02-28	AAA	ETF	60.57	60.6482	60.32	60.63	6600.0
2007-02-28	ADRE	ETF	37.5	38.19	37.29	37.92	605734.0
2007-02-28	AGG	ETF	100.92	100.96	100.62	100.85	533700.0
2007-02-28	AIQ	ETF	36.1	36.4	35.25	35.75	54220.0
2007-02-28	AIS	ETF	1.17	1.2	1.13	1.17	129600.0
2007-02-28	ARB	ETF	44.71	45.16	44.08	44.8	279700.0
2007-02-28	BAB	ETF	104.9	106.82	104.29	105.8	186000.0
2007-02-28	BBC	ETF	4.1	4.27	4.1	4.22	130400.0
2007-02-28	BBH	ETF	60.3333	61.4567	60.3333	60.7767	2255700.0
2007-02-28	BITS	ETF	28.0	29.36	27.0	28.32	657392.0
2007-02-28	BNE	ETF	15.45	15.61	15.37	15.53	182400.0
2007-02-28	BOSS	ETF	38.48	41.3	38.48	41.3	100.0
2007-02-28	BRF	ETF	14.54	14.54	14.53	14.53	4500.0
2007-02-28	BTF	ETF	110.74999999999999	111.25	110.05	110.5	2020.0
2007-02-28	CBON	ETF	30.87	31.22	30.55	31.07	71022.0
2007-02-28	CDL	ETF	10.31	10.35	10.15	10.16	300500.0
2007-02-28	CEF	ETF	9.53	9.72	9.5	9.66	396900.0
2007-02-28	CGO	ETF	16.16	16.44	16.1	16.3	24100.0
2007-02-28	CHB	ETF	8.34	8.4	7.9	7.93	2479500.0
2007-02-28	CHI	ETF	20.06	20.4	20.01	20.28	96200.0
2007-02-28	CHIC	ETF	29.49	29.54	28.79	29.19	485053.0
2007-02-28	CHY	ETF	16.82	17.0	16.81	16.98	117300.0
2007-02-28	CIL	ETF	25.47	25.47	25.47	25.47	500.0
2007-02-28	CN	ETF	46.75	48.1599	46.63	47.43	141000.0
2007-02-28	CNXT	ETF	1.99	2.02	1.94	1.99	7346521.0
2007-02-28	CPI	ETF	23.05	23.05	22.95	22.95	300.0
2007-02-28	CPST	ETF	0.91	0.93	0.88	0.88	4791199.0
2007-02-28	CSA	ETF	21.58	22.1	21.58	21.92	42200.0
2007-02-28	CSB	ETF	32.18	32.18	31.68	31.81	14200.0
2007-02-28	CSD	ETF	25.85	26.0	25.75	25.95	13900.0
2007-02-28	CSM	ETF	1.3175	1.33	1.315	1.33	27200.0
2007-02-28	CSQ	ETF	14.86	15.0	14.8	14.99	437600.0
2007-02-28	CTEC	ETF	81.62499999999999	83.64999999999999	80.95	81.64999999999999	17660.0
2007-02-28	CVY	ETF	26.65	26.82	26.44	26.74	35700.0
2007-02-28	CWI	ETF	24.7133	24.7867	24.5	24.6867	79950.0
2007-02-28	DBA	ETF	26.69	27.0	26.48	27.0	196200.0
2007-02-28	DBB	ETF	24.6	24.7	24.24	24.65	12700.0
2007-02-28	DBC	ETF	25.01	25.3	24.77	25.29	324900.0
2007-02-28	DBE	ETF	26.2	26.48	26.07	26.45	18700.0
2007-02-28	DBO	ETF	25.4	26.23	25.39	26.1	27400.0
2007-02-28	DBP	ETF	26.73	26.83	26.37	26.79	16600.0
2007-02-28	DBS	ETF	27.87	27.97	27.5	27.88	12300.0
2007-02-28	DBV	ETF	26.25	26.38	26.25	26.36	103000.0
2007-02-28	DDM	ETF	6.6108	6.7467	6.5458	6.6517	5778000.0

> showing 50 of 444 rows — these rows as CSV

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