PREVIEW / etf_daily / 2007-10-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-26.parquet
  size:    24 KB
  rows:    527

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-10-26	SPY	ETF	153.06	153.62	151.9	153.62	176484000.0
2007-10-26	QQQ	ETF	54.08	54.2	53.44	53.93	146690241.0
2007-10-26	IWM	ETF	81.37	82.01	80.47	82.01	79290000.0
2007-10-26	DIA	ETF	137.61	138.06	136.84	137.95	9929800.0
2007-10-26	GLD	ETF	76.87	77.74	76.67	77.69	8544200.0
2007-10-26	TLT	ETF	90.37	91.0	90.34	90.5	1366500.0
2007-10-26	ADRE	ETF	57.95	58.39	57.38	58.29	353107.0
2007-10-26	AGG	ETF	100.76	101.0	100.61	100.76	348000.0
2007-10-26	AIQ	ETF	46.3	47.45	45.95	47.45	73020.0
2007-10-26	AIS	ETF	1.23	1.25	1.2	1.23	108200.0
2007-10-26	AIVI	ETF	76.0	76.48	75.71	76.4	41400.0
2007-10-26	ARB	ETF	50.25	50.38	49.59	50.25	175600.0
2007-10-26	BBH	ETF	60.6533	60.6533	60.03	60.2667	147300.0
2007-10-26	BIL	ETF	91.82	91.86	91.78	91.78	15900.0
2007-10-26	BITS	ETF	26.16	26.16	25.44	25.84	7909.0
2007-10-26	BIV	ETF	76.44	76.63	76.38	76.45	17300.0
2007-10-26	BLV	ETF	76.41	76.77	76.4	76.4	8400.0
2007-10-26	BMVP	ETF	17.53	17.5305	17.3867	17.53	127600.0
2007-10-26	BND	ETF	76.32	76.47	76.22	76.35	154300.0
2007-10-26	BNE	ETF	17.37	17.49	17.21	17.46	100800.0
2007-10-26	BRF	ETF	14.61	14.7	14.61	14.69	8200.0
2007-10-26	BSV	ETF	76.36	76.5	76.33	76.44	24700.0
2007-10-26	BTF	ETF	115.95	116.05	113.64999999999999	114.74999999999999	5540.0
2007-10-26	BWX	ETF	26.4	26.535	26.4	26.53	76200.0
2007-10-26	CBON	ETF	20.3	20.9	20.13	20.56	67119.0
2007-10-26	CDL	ETF	4.42	4.42	4.24	4.36	1240400.0
2007-10-26	CEF	ETF	10.2	10.37	10.19	10.33	488600.0
2007-10-26	CGO	ETF	19.02	19.31	19.02	19.29	28800.0
2007-10-26	CGW	ETF	26.1	26.4	26.1	26.4	56900.0
2007-10-26	CHB	ETF	12.94	13.3	12.66	13.04	1434100.0
2007-10-26	CHI	ETF	16.94	16.98	16.87	16.92	109100.0
2007-10-26	CHIC	ETF	14.66	14.83	14.33	14.78	240819.0
2007-10-26	CHW	ETF	13.11	13.31	13.0	13.07	210800.0
2007-10-26	CHY	ETF	14.9	14.96	14.77	14.87	136500.0
2007-10-26	CMF	ETF	51.925	52.075	51.925	52.05	11200.0
2007-10-26	CN	ETF	60.3	61.19	60.3	60.79	128100.0
2007-10-26	CNXT	ETF	1.21	1.23	1.19	1.21	6748947.0
2007-10-26	COW	ETF	49.3	49.3	49.3	49.3	100.0
2007-10-26	CPI	ETF	23.9999	23.9999	23.9999	23.9999	200.0
2007-10-26	CPST	ETF	1.07	1.08	1.06	1.07	1286450.0
2007-10-26	CSA	ETF	17.41	17.47	16.98	17.27	70900.0
2007-10-26	CSD	ETF	28.67	28.9	28.64	28.86	7100.0
2007-10-26	CSM	ETF	1.47	1.47	1.47	1.47	4000.0
2007-10-26	CSQ	ETF	14.63	14.77	14.62	14.74	217500.0
2007-10-26	CVY	ETF	25.73	25.82	25.57	25.81	12300.0
2007-10-26	CWI	ETF	29.4133	29.6267	29.3867	29.6267	36900.0
2007-10-26	DBA	ETF	29.47	29.47	29.28	29.28	321800.0
2007-10-26	DBB	ETF	25.89	26.15	25.83	26.08	23800.0
2007-10-26	DBC	ETF	29.7	29.87	29.5601	29.85	633700.0
2007-10-26	DBE	ETF	33.43	33.55	33.11	33.51	36900.0

> showing 50 of 527 rows — these rows as CSV

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