PREVIEW / etf_daily / 2007-02-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-09.parquet
  size:    21 KB
  rows:    432

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-09	SPY	ETF	145.06	145.33	143.39	143.94	79084400.0
2007-02-09	QQQ	ETF	44.57	44.72	43.73	43.84	133504763.0
2007-02-09	IWM	ETF	80.98	81.15	79.7	80.31	52164700.0
2007-02-09	DIA	ETF	126.52	126.79	125.48	125.88	6601100.0
2007-02-09	GLD	ETF	65.27	66.38	65.22	66.12	6816500.0
2007-02-09	TLT	ETF	87.89	87.92	87.55	87.63	878300.0
2007-02-09	AAA	ETF	60.59	60.8	60.35	60.37	1800.0
2007-02-09	ADRE	ETF	40.18	40.25	39.42	39.53	250810.0
2007-02-09	AGG	ETF	99.8	99.83	99.52	99.73	419600.0
2007-02-09	AIQ	ETF	35.8	36.05	34.95	35.6	56680.0
2007-02-09	AIS	ETF	1.27	1.28	1.23	1.24	175200.0
2007-02-09	ARB	ETF	47.12	47.38	45.85	46.0	304200.0
2007-02-09	BAB	ETF	110.65	111.24	110.35	110.6	106400.0
2007-02-09	BBC	ETF	4.54	4.5793	4.15	4.3	523600.0
2007-02-09	BBH	ETF	63.7167	63.9267	63.1333	63.2667	290100.0
2007-02-09	BITS	ETF	39.68	39.96	38.28	39.28	17282.0
2007-02-09	BNE	ETF	15.49	15.6	15.2	15.27	76100.0
2007-02-09	BRF	ETF	14.46	14.46	14.45	14.45	400.0
2007-02-09	BTF	ETF	113.7495	114.3	112.5	113.0	2080.0
2007-02-09	CBON	ETF	33.38	33.38	32.76	32.89	47545.0
2007-02-09	CDL	ETF	10.71	10.96	10.57	10.72	689700.0
2007-02-09	CEF	ETF	9.68	9.74	9.61	9.69	435500.0
2007-02-09	CGO	ETF	17.12	17.33	17.1	17.2	13700.0
2007-02-09	CHB	ETF	7.92	7.9799	7.75	7.82	1624400.0
2007-02-09	CHI	ETF	20.25	20.32	20.15	20.21	70700.0
2007-02-09	CHIC	ETF	30.19	30.45	29.72	30.01	1185854.0
2007-02-09	CHY	ETF	17.1	17.22	17.0901	17.2	120300.0
2007-02-09	CN	ETF	50.25	50.42	49.26	49.55	91000.0
2007-02-09	CNXT	ETF	1.99	2.0501	1.9899	2.0	12887147.0
2007-02-09	CPI	ETF	24.08	24.08	24.05	24.05	400.0
2007-02-09	CPST	ETF	0.8993	0.95	0.89	0.89	7081532.0
2007-02-09	CSA	ETF	22.53	23.07	20.5	21.9	19900.0
2007-02-09	CSB	ETF	33.6	33.65	33.45	33.55	10600.0
2007-02-09	CSD	ETF	26.15	26.19	25.84	25.84	6600.0
2007-02-09	CSM	ETF	1.355	1.355	1.345	1.345	20400.0
2007-02-09	CSQ	ETF	15.46	15.47	15.32	15.38	267600.0
2007-02-09	CTEC	ETF	87.55	87.89999999999999	85.25	87.85	19524.600000000002
2007-02-09	CVY	ETF	27.11	27.11	26.79	26.92	36200.0
2007-02-09	CWI	ETF	25.0067	25.0467	24.8333	24.8933	19350.0
2007-02-09	DBA	ETF	26.0	26.25	25.75	26.16	174200.0
2007-02-09	DBB	ETF	22.64	22.73	22.56	22.69	12800.0
2007-02-09	DBC	ETF	24.4	24.54	24.24	24.42	164000.0
2007-02-09	DBE	ETF	25.7	25.9	25.57	25.75	42300.0
2007-02-09	DBO	ETF	25.31	25.5	25.01	25.08	12100.0
2007-02-09	DBP	ETF	26.6	26.69	26.42	26.61	10400.0
2007-02-09	DBS	ETF	27.4	27.45	27.2201	27.29	7000.0
2007-02-09	DBV	ETF	26.35	26.35	26.21	26.29	133500.0
2007-02-09	DDM	ETF	7.0833	7.0983	6.96	7.0042	634800.0
2007-02-09	DEF	ETF	26.33	26.33	25.95	26.099	27800.0
2007-02-09	DES	ETF	19.79	19.79	19.4733	19.5667	58500.0

> showing 50 of 432 rows — these rows as CSV

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