PREVIEW / etf_daily / 2007-02-16

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-16.parquet
  size:    20 KB
  rows:    425

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-16	SPY	ETF	145.44	145.76	145.23	145.73	39841800.0
2007-02-16	QQQ	ETF	44.68	44.83	44.57	44.71	72364761.0
2007-02-16	IWM	ETF	80.72	81.27	80.34	81.17	42160800.0
2007-02-16	DIA	ETF	127.41	127.57	127.31	127.57	5813600.0
2007-02-16	GLD	ETF	65.94	66.39	65.76	66.36	3200400.0
2007-02-16	TLT	ETF	88.59	88.72	88.48	88.64	1476700.0
2007-02-16	AAA	ETF	60.81	60.86	60.67	60.83	1000.0
2007-02-16	ADRE	ETF	40.47	40.5	40.2	40.5	179297.0
2007-02-16	AGG	ETF	100.14	100.24	100.09	100.21	309400.0
2007-02-16	AIQ	ETF	37.1	37.5	36.9	37.0	27280.0
2007-02-16	AIS	ETF	1.21	1.24	1.21	1.22	47100.0
2007-02-16	ARB	ETF	46.2	46.44	45.3	45.76	296200.0
2007-02-16	BAB	ETF	112.07	112.87	111.9	112.65	54200.0
2007-02-16	BBC	ETF	4.4	4.4	4.19	4.35	149400.0
2007-02-16	BBH	ETF	63.1	63.1133	62.4967	62.7167	1007700.0
2007-02-16	BITS	ETF	45.2	45.8	43.6	44.36	14202.0
2007-02-16	BNE	ETF	15.8	15.81	15.57	15.77	96200.0
2007-02-16	BOSS	ETF	44.2	44.2	44.01	44.01	300.0
2007-02-16	BRF	ETF	14.44	14.457	14.38	14.457	15900.0
2007-02-16	BTF	ETF	113.6	113.64999999999999	113.49999999999999	113.6	700.0
2007-02-16	CBON	ETF	33.4	33.4	32.63	33.04	26256.0
2007-02-16	CDL	ETF	10.49	10.54	10.35	10.44	436600.0
2007-02-16	CEF	ETF	9.64	9.65	9.52	9.61	375900.0
2007-02-16	CGO	ETF	16.9	16.95	16.89	16.94	12800.0
2007-02-16	CHB	ETF	7.5	7.5	7.25	7.34	2443300.0
2007-02-16	CHI	ETF	20.22	20.3	20.19	20.3	70900.0
2007-02-16	CHIC	ETF	29.57	29.76	29.27	29.49	290969.0
2007-02-16	CHY	ETF	17.02	17.09	17.0	17.08	128800.0
2007-02-16	CIL	ETF	25.42	25.42	25.4	25.4	500.0
2007-02-16	CN	ETF	52.45	52.6	51.96	52.4	77000.0
2007-02-16	CNXT	ETF	2.01	2.02	1.96	2.02	6184360.0
2007-02-16	CPST	ETF	0.88	0.8968	0.8689	0.8888	6076303.0
2007-02-16	CSA	ETF	22.27	22.52	22.0	22.0	92700.0
2007-02-16	CSB	ETF	33.66	34.45	33.66	33.94	14600.0
2007-02-16	CSD	ETF	26.62	26.67	26.5	26.67	14600.0
2007-02-16	CSM	ETF	1.35	1.35	1.35	1.35	16000.0
2007-02-16	CSQ	ETF	15.29	15.32	15.16	15.32	466000.0
2007-02-16	CTEC	ETF	88.45	89.49999999999999	88.45	89.1	9854.0
2007-02-16	CVY	ETF	27.3	27.31	27.21	27.3	28400.0
2007-02-16	CWI	ETF	25.4133	25.4933	25.3933	25.4933	26700.0
2007-02-16	DBA	ETF	26.32	26.78	26.25	26.74	226300.0
2007-02-16	DBB	ETF	23.86	24.0	23.74	23.94	44600.0
2007-02-16	DBC	ETF	24.08	24.5	24.01	24.49	155700.0
2007-02-16	DBE	ETF	24.8	25.29	24.8	25.24	21300.0
2007-02-16	DBO	ETF	24.51	24.89	24.48	24.89	20000.0
2007-02-16	DBP	ETF	26.52	26.71	26.46	26.71	5100.0
2007-02-16	DBS	ETF	27.3	27.51	27.28	27.49	13900.0
2007-02-16	DBV	ETF	26.45	26.4799	26.37	26.42	83800.0
2007-02-16	DDM	ETF	7.1975	7.2058	7.1583	7.2058	1526400.0
2007-02-16	DEF	ETF	26.5	26.52	26.42	26.52	16200.0

> showing 50 of 425 rows — these rows as CSV

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