PREVIEW / etf_daily / 2007-03-16

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-16.parquet
  size:    21 KB
  rows:    436

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-03-16	SPY	ETF	139.31	139.63	138.12	138.53	121531600.0
2007-03-16	QQQ	ETF	42.94	43.04	42.61	42.83	108365384.0
2007-03-16	IWM	ETF	77.81	78.06	76.54	77.27	77107100.0
2007-03-16	DIA	ETF	121.69	121.78	120.25	121.05	8491600.0
2007-03-16	GLD	ETF	64.54	64.99	64.38	64.62	5040100.0
2007-03-16	TLT	ETF	89.67	89.92	89.65	89.85	623800.0
2007-03-16	AAA	ETF	61.8	62.07	61.73	61.89	60600.0
2007-03-16	ADRE	ETF	37.75	38.01	37.35	37.35	111666.0
2007-03-16	AGG	ETF	100.55	100.64	100.45	100.58	264100.0
2007-03-16	AIQ	ETF	36.15	36.45	35.75	36.1	33620.0
2007-03-16	AIS	ETF	1.16	1.2199	1.13	1.17	138600.0
2007-03-16	ARB	ETF	46.39	46.39	45.81	45.95	247000.0
2007-03-16	BAB	ETF	97.2	97.44	96.65	96.85	88700.0
2007-03-16	BBC	ETF	3.72	3.7501	3.23	3.31	929800.0
2007-03-16	BBH	ETF	58.2	58.44	58.06	58.14	501900.0
2007-03-16	BITS	ETF	32.84	32.84	31.8	32.48	36681.0
2007-03-16	BNE	ETF	15.62	15.7	15.37	15.47	278600.0
2007-03-16	BRF	ETF	14.51	14.5101	14.51	14.51	700.0
2007-03-16	BTF	ETF	106.99999999999999	107.69999999999999	106.69999999999999	107.69999999999999	1340.0
2007-03-16	CBON	ETF	30.59	31.44	30.59	30.89	110783.0
2007-03-16	CDL	ETF	9.71	9.8	9.64	9.67	344800.0
2007-03-16	CEF	ETF	9.35	9.45	9.3	9.33	285500.0
2007-03-16	CGO	ETF	16.64	16.84	16.62	16.84	14000.0
2007-03-16	CHB	ETF	9.3	9.52	9.12	9.48	2946400.0
2007-03-16	CHI	ETF	20.13	20.14	19.89	19.97	62400.0
2007-03-16	CHIC	ETF	27.19	27.5	27.08	27.27	378041.0
2007-03-16	CHY	ETF	16.47	16.55	16.33	16.35	106200.0
2007-03-16	CN	ETF	43.34	43.73	43.1	43.3	75100.0
2007-03-16	CNXT	ETF	1.64	1.69	1.6299	1.66	8600874.0
2007-03-16	CPST	ETF	0.85	0.8795	0.83	0.83	2101532.0
2007-03-16	CSA	ETF	21.26	21.51	21.26	21.36	34200.0
2007-03-16	CSB	ETF	31.84	32.02	31.75	31.89	9200.0
2007-03-16	CSD	ETF	26.22	26.22	26.0	26.02	3900.0
2007-03-16	CSQ	ETF	14.86	14.93	14.82	14.86	285900.0
2007-03-16	CTEC	ETF	81.1	81.54999999999998	80.44999999999999	81.54999999999998	4945.6
2007-03-16	CVY	ETF	26.3	26.4	26.17	26.22	16400.0
2007-03-16	CWI	ETF	24.4333	24.5133	24.3	24.3933	8250.0
2007-03-16	DBA	ETF	25.53	26.09	25.5	25.92	83000.0
2007-03-16	DBB	ETF	24.36	24.7	24.24	24.66	3500.0
2007-03-16	DBC	ETF	24.25	24.57	24.04	24.25	242300.0
2007-03-16	DBE	ETF	25.61	25.78	25.17	25.4	18700.0
2007-03-16	DBO	ETF	24.93	25.17	24.21	24.74	4700.0
2007-03-16	DBP	ETF	25.81	25.84	25.69	25.8	6400.0
2007-03-16	DBS	ETF	25.74	25.8699	25.7296	25.84	9300.0
2007-03-16	DBV	ETF	26.29	26.3	26.19	26.27	63300.0
2007-03-16	DDM	ETF	6.5367	6.5542	6.4542	6.4792	1282800.0
2007-03-16	DEF	ETF	25.46	25.46	25.28	25.28	8200.0
2007-03-16	DES	ETF	18.95	18.97	18.81	18.83	54600.0
2007-03-16	DEW	ETF	60.71	60.82	60.5	60.55	3200.0
2007-03-16	DFE	ETF	67.22	67.28	66.9	67.04	15200.0

> showing 50 of 436 rows — these rows as CSV

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