PREVIEW / etf_daily / 2007-02-15

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-15.parquet
  size:    21 KB
  rows:    434

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-15	SPY	ETF	145.67	145.95	145.43	145.8	38715200.0
2007-02-15	QQQ	ETF	44.63	44.86	44.55	44.86	110500582.0
2007-02-15	IWM	ETF	80.71	81.19	80.56	80.86	44086000.0
2007-02-15	DIA	ETF	127.61	127.9	127.49	127.77	6077800.0
2007-02-15	GLD	ETF	66.22	66.53	65.71	66.41	7673400.0
2007-02-15	TLT	ETF	88.53	88.58	88.33	88.33	893800.0
2007-02-15	AAA	ETF	61.28	61.28	60.95	61.27	5100.0
2007-02-15	ADRE	ETF	40.49	40.6	40.41	40.47	116925.0
2007-02-15	AGG	ETF	100.16	100.22	100.06	100.14	438500.0
2007-02-15	AIQ	ETF	36.3	37.3	36.25	37.05	25320.0
2007-02-15	AIS	ETF	1.24	1.24	1.2	1.23	110500.0
2007-02-15	ARB	ETF	46.38	46.78	44.5	46.2	597500.0
2007-02-15	BAB	ETF	112.67	113.26	112.38	112.63	56700.0
2007-02-15	BBC	ETF	4.35	4.45	4.35	4.35	44400.0
2007-02-15	BBH	ETF	63.0667	63.51	62.8933	63.1667	549300.0
2007-02-15	BITS	ETF	45.88	46.6	43.76	45.04	25471.0
2007-02-15	BNE	ETF	15.79	15.9	15.71	15.8	191400.0
2007-02-15	BRF	ETF	14.42	14.44	14.42	14.44	3000.0
2007-02-15	BTF	ETF	113.24999999999999	113.6	113.14999999999999	113.49999999999999	2140.0
2007-02-15	CBON	ETF	32.91	33.4	32.81	33.4	26098.0
2007-02-15	CDL	ETF	10.59	10.6	10.41	10.46	345100.0
2007-02-15	CEF	ETF	9.65	9.66	9.57	9.65	342800.0
2007-02-15	CGO	ETF	16.91	16.92	16.82	16.89	10200.0
2007-02-15	CHB	ETF	7.65	7.74	7.44	7.5	2492900.0
2007-02-15	CHI	ETF	20.39	20.39	20.19	20.26	73600.0
2007-02-15	CHIC	ETF	29.77	29.94	29.51	29.58	309615.0
2007-02-15	CHY	ETF	17.09	17.09	17.03	17.07	150700.0
2007-02-15	CIL	ETF	25.6	25.61	25.4	25.4	1100.0
2007-02-15	CN	ETF	50.9	51.77	50.65	51.71	69800.0
2007-02-15	CNXT	ETF	2.0	2.0301	1.99	2.01	3230830.0
2007-02-15	CPI	ETF	24.1	24.1	24.0	24.01	1300.0
2007-02-15	CPST	ETF	0.89	0.901	0.8701	0.88	7900097.0
2007-02-15	CSA	ETF	22.05	22.12	21.91	22.08	6100.0
2007-02-15	CSB	ETF	33.04	33.31	32.99	33.23	26600.0
2007-02-15	CSD	ETF	26.58	26.58	26.5	26.52	70300.0
2007-02-15	CSM	ETF	1.3475	1.35	1.3475	1.35	2400.0
2007-02-15	CSQ	ETF	15.26	15.35	15.21	15.29	352700.0
2007-02-15	CTEC	ETF	88.85	89.19999999999999	87.89999999999999	88.49999999999999	17797.2
2007-02-15	CVY	ETF	27.31	27.31	27.23	27.29	46100.0
2007-02-15	CWI	ETF	25.4667	25.5	25.4067	25.4933	76800.0
2007-02-15	DBA	ETF	26.1	26.36	26.1	26.32	176600.0
2007-02-15	DBB	ETF	24.25	24.25	23.73	24.02	15200.0
2007-02-15	DBC	ETF	24.13	24.13	23.8	24.07	191400.0
2007-02-15	DBE	ETF	24.75	24.77	24.12	24.77	7500.0
2007-02-15	DBO	ETF	24.44	24.44	23.75	24.3	4000.0
2007-02-15	DBP	ETF	26.66	26.75	26.5	26.75	8700.0
2007-02-15	DBS	ETF	27.52	27.5644	27.33	27.5644	3900.0
2007-02-15	DBV	ETF	26.4	26.48	26.27	26.32	211300.0
2007-02-15	DDM	ETF	7.1967	7.2242	7.175	7.2092	624000.0
2007-02-15	DEF	ETF	26.43	26.5	26.41	26.5	8800.0

> showing 50 of 434 rows — these rows as CSV

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