PREVIEW / etf_daily / 2007-09-11

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-11.parquet
  size:    23 KB
  rows:    494

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-09-11	SPY	ETF	146.24	147.7	146.13	147.49	162081900.0
2007-09-11	QQQ	ETF	48.51	48.9885	48.43	48.93	103064420.0
2007-09-11	IWM	ETF	77.18	78.06	77.04	77.99	84890600.0
2007-09-11	DIA	ETF	131.9	133.27	131.81	133.08	11502400.0
2007-09-11	GLD	ETF	69.86	70.7	69.52	70.52	11182400.0
2007-09-11	TLT	ETF	90.88	91.27	90.7	90.93	3925400.0
2007-09-11	ADRE	ETF	46.66	47.0	46.5	46.91	114242.0
2007-09-11	AGG	ETF	100.03	100.41	100.03	100.26	687000.0
2007-09-11	AIQ	ETF	43.0	44.7	42.7	44.35	16360.0
2007-09-11	AIS	ETF	1.38	1.38	1.35	1.35	40100.0
2007-09-11	ARB	ETF	47.35	47.49	46.55	46.82	344000.0
2007-09-11	BBH	ETF	56.3467	57.42	56.1833	57.42	751800.0
2007-09-11	BIL	ETF	91.64	91.74	91.62	91.64	10300.0
2007-09-11	BITS	ETF	27.48	28.2	27.48	28.08	12468.0
2007-09-11	BIV	ETF	76.06	76.13	75.85	75.85	24400.0
2007-09-11	BLV	ETF	75.9	75.9	75.76	75.76	700.0
2007-09-11	BMVP	ETF	16.53	16.6537	16.53	16.6267	49800.0
2007-09-11	BND	ETF	75.97	76.02	75.85	75.85	36400.0
2007-09-11	BNE	ETF	16.22	16.3	16.13	16.18	193500.0
2007-09-11	BRF	ETF	14.6	14.6101	14.59	14.59	14900.0
2007-09-11	BSV	ETF	76.05	76.08	75.97	75.97	33300.0
2007-09-11	BTF	ETF	104.35	104.55	104.19999999999999	104.49999999999999	7620.0
2007-09-11	CBON	ETF	23.78	24.18	23.78	24.18	20167.0
2007-09-11	CDL	ETF	4.11	4.17	4.04	4.15	2746600.0
2007-09-11	CEF	ETF	9.59	9.72	9.55	9.66	646900.0
2007-09-11	CGO	ETF	16.74	16.93	16.65	16.81	31000.0
2007-09-11	CGW	ETF	24.4	24.53	24.3	24.53	30500.0
2007-09-11	CHB	ETF	10.74	11.13	10.57	11.07	1206800.0
2007-09-11	CHI	ETF	17.1	17.2	16.88	16.98	97800.0
2007-09-11	CHIC	ETF	16.51	16.82	16.39	16.72	371360.0
2007-09-11	CHW	ETF	13.62	13.64	13.15	13.46	119100.0
2007-09-11	CHY	ETF	14.78	14.86	14.6	14.65	165700.0
2007-09-11	CN	ETF	47.36	47.99	47.29	47.8	85200.0
2007-09-11	CNXT	ETF	1.4	1.42	1.31	1.32	11043955.0
2007-09-11	CPI	ETF	24.4	24.65	24.4	24.65	600.0
2007-09-11	CPST	ETF	1.11	1.16	1.1	1.16	1492652.0
2007-09-11	CSA	ETF	17.96	18.12	17.07	18.03	59700.0
2007-09-11	CSD	ETF	28.46	28.52	28.31	28.49	21200.0
2007-09-11	CSM	ETF	1.4575	1.4575	1.4475	1.4475	4000.0
2007-09-11	CSQ	ETF	14.06	14.16	14.03	14.13	276500.0
2007-09-11	CTEC	ETF	102.05	103.05	100.99999999999999	102.69999999999999	10268.400000000001
2007-09-11	CVY	ETF	25.48	25.69	25.48	25.66	9100.0
2007-09-11	CWI	ETF	26.5467	26.8667	26.5	26.7533	48450.0
2007-09-11	DBA	ETF	27.01	27.05	26.76	26.99	178600.0
2007-09-11	DBB	ETF	24.67	25.02	24.57	25.02	15700.0
2007-09-11	DBC	ETF	26.16	26.36	25.98	26.34	117200.0
2007-09-11	DBE	ETF	29.02	29.2	28.8	29.2	9400.0
2007-09-11	DBO	ETF	27.42	27.75	27.38	27.75	10800.0
2007-09-11	DBP	ETF	27.09	27.37	27.01	27.25	39100.0
2007-09-11	DBS	ETF	24.8101	25.07	24.75	25.0	8500.0

> showing 50 of 494 rows — these rows as CSV

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