PREVIEW / etf_daily / 2007-01-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-09.parquet
  size:    19 KB
  rows:    394

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-01-09	SPY	ETF	141.31	141.6	140.4	141.07	75680100.0
2007-01-09	QQQ	ETF	44.0	44.29	43.63	44.1	121760832.0
2007-01-09	IWM	ETF	77.12	77.31	76.19	77.15	62791800.0
2007-01-09	DIA	ETF	124.34	124.57	123.42	124.07	7438700.0
2007-01-09	GLD	ETF	60.14	61.09	60.06	60.85	4170400.0
2007-01-09	TLT	ETF	89.48	89.48	89.22	89.37	481500.0
2007-01-09	AAA	ETF	61.7	62.0	61.65	61.97	5300.0
2007-01-09	ADRE	ETF	38.07	38.49	36.88	37.086	387816.0
2007-01-09	AGG	ETF	100.17	100.17	100.04	100.11	361300.0
2007-01-09	AIQ	ETF	32.85	33.5	31.85	33.25	29960.0
2007-01-09	AIS	ETF	1.22	1.29	1.22	1.28	308600.0
2007-01-09	ARB	ETF	43.43	44.01	43.1	43.98	122500.0
2007-01-09	BAB	ETF	108.55	109.54	108.38	108.9	87300.0
2007-01-09	BBC	ETF	5.5	5.65	5.08	5.1	634800.0
2007-01-09	BBH	ETF	63.0	63.5167	62.9833	63.4333	1059000.0
2007-01-09	BITS	ETF	34.0	34.64	33.68	33.88	11562.0
2007-01-09	BNE	ETF	15.57	15.6	15.38	15.45	257900.0
2007-01-09	BRF	ETF	14.65	14.73	14.5215	14.65	25800.0
2007-01-09	BTF	ETF	105.99999999999999	105.99999999999999	105.1	105.25	3000.0
2007-01-09	CBON	ETF	29.81	29.98	29.77	29.83	75257.0
2007-01-09	CDL	ETF	9.79	9.79	9.59	9.72	199600.0
2007-01-09	CEF	ETF	8.82	8.89	8.7	8.86	413200.0
2007-01-09	CEW	ETF	26.2	26.2	25.73	25.76	1800.0
2007-01-09	CGO	ETF	16.89	17.03	16.71	16.92	21400.0
2007-01-09	CHB	ETF	8.1	8.14	7.92	8.09	1160600.0
2007-01-09	CHI	ETF	19.9	19.99	19.8	19.9399	110500.0
2007-01-09	CHIC	ETF	30.6	31.57	30.58	31.4	340034.0
2007-01-09	CHY	ETF	17.04	17.3	17.0	17.11	175200.0
2007-01-09	CIL	ETF	25.54	25.54	25.31	25.31	2400.0
2007-01-09	CN	ETF	52.2	52.4	50.61	51.09	224700.0
2007-01-09	CNXT	ETF	2.15	2.16	2.05	2.08	17428747.0
2007-01-09	CPST	ETF	1.1	1.1192	1.05	1.09	2831689.0
2007-01-09	CSA	ETF	20.85	20.95	20.8	20.89	2600.0
2007-01-09	CSB	ETF	32.74	32.9	32.53	32.78	13500.0
2007-01-09	CSD	ETF	25.0	25.0	24.71	24.94	14200.0
2007-01-09	CSQ	ETF	15.56	15.65	15.44	15.61	415600.0
2007-01-09	CTEC	ETF	92.05	92.75	91.44999999999999	91.85	19085.4
2007-01-09	CVY	ETF	26.23	26.23	25.98	26.18	70700.0
2007-01-09	DBA	ETF	24.8	24.82	24.6	24.66	136700.0
2007-01-09	DBB	ETF	22.9	23.39	22.9	23.27	4700.0
2007-01-09	DBC	ETF	22.65	23.14	22.48	23.02	675600.0
2007-01-09	DBE	ETF	24.07	24.48	24.02	24.48	6500.0
2007-01-09	DBO	ETF	23.7	24.16	23.6	24.1	12900.0
2007-01-09	DBP	ETF	24.25	24.52	24.25	24.49	1000.0
2007-01-09	DBS	ETF	24.37	24.76	24.37	24.7299	700.0
2007-01-09	DBV	ETF	26.15	26.19	26.0	26.14	186900.0
2007-01-09	DDM	ETF	6.8675	6.8917	6.7992	6.8533	610800.0
2007-01-09	DEF	ETF	24.93	24.95	24.7801	24.9399	5800.0
2007-01-09	DES	ETF	18.86	18.9267	18.6633	18.9267	95700.0
2007-01-09	DEW	ETF	61.67	61.74	61.35	61.69	32000.0

> showing 50 of 394 rows — these rows as CSV

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