PREVIEW / etf_daily / 2007-07-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-23.parquet
  size:    22 KB
  rows:    485

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-07-23	SPY	ETF	154.18	154.72	153.3	153.97	121183900.0
2007-07-23	QQQ	ETF	50.21	50.31	49.92	50.07	107464087.0
2007-07-23	IWM	ETF	83.63	83.85	82.94	82.94	67737500.0
2007-07-23	DIA	ETF	139.11	139.62	138.81	139.21	12709000.0
2007-07-23	GLD	ETF	67.8	67.8	67.31	67.47	3892400.0
2007-07-23	TLT	ETF	85.69	85.97	85.69	85.82	777900.0
2007-07-23	ADRE	ETF	49.58	49.8	49.158	49.73	212463.0
2007-07-23	AGG	ETF	98.24	98.48	98.22	98.34	255600.0
2007-07-23	AIQ	ETF	49.45	51.5	49.45	50.2	31320.0
2007-07-23	AIS	ETF	1.8	1.8099	1.73	1.74	135800.0
2007-07-23	ARB	ETF	52.5	52.56	51.58	51.8	526700.0
2007-07-23	BBH	ETF	56.4767	56.4767	55.64	56.0233	609300.0
2007-07-23	BIL	ETF	91.84	91.86	91.82	91.84	6950.0
2007-07-23	BITS	ETF	27.92	28.32	27.76	27.76	8229.0
2007-07-23	BIV	ETF	73.94	73.98	73.92	73.96	7300.0
2007-07-23	BLV	ETF	73.24	73.45	73.21	73.38	8600.0
2007-07-23	BMVP	ETF	18.0167	18.1582	18.0167	18.07	35100.0
2007-07-23	BND	ETF	74.29	74.33	74.17	74.32	36700.0
2007-07-23	BNE	ETF	19.45	20.04	19.45	19.98	236000.0
2007-07-23	BOSS	ETF	48.75	48.75	48.75	48.75	100.0
2007-07-23	BRF	ETF	14.5	14.6	14.5	14.52	9000.0
2007-07-23	BSV	ETF	74.99	75.01	74.94	75.0	11100.0
2007-07-23	BTF	ETF	106.25	107.55	106.25	107.55	1460.0
2007-07-23	CBON	ETF	26.66	26.66	25.56	25.6	175874.0
2007-07-23	CDL	ETF	6.15	6.33	6.1	6.15	3541371.0
2007-07-23	CEF	ETF	9.56	9.58	9.5	9.54	169400.0
2007-07-23	CGO	ETF	18.45	18.55	18.19	18.26	39500.0
2007-07-23	CGW	ETF	26.5	26.5	25.91	26.28	214100.0
2007-07-23	CHB	ETF	12.42	12.69	12.31	12.43	2271061.0
2007-07-23	CHI	ETF	17.52	17.59	16.62	16.8	556400.0
2007-07-23	CHIC	ETF	23.86	24.2	23.31	23.72	953068.0
2007-07-23	CHY	ETF	15.3	15.34	15.04	15.1334	296400.0
2007-07-23	CN	ETF	53.41	54.33	53.41	54.24	87400.0
2007-07-23	CNXT	ETF	1.46	1.46	1.38	1.4	7630006.0
2007-07-23	CPI	ETF	24.5	24.5	24.1	24.3	700.0
2007-07-23	CPST	ETF	1.31	1.35	1.27	1.28	1933233.0
2007-07-23	CSA	ETF	19.03	19.03	18.47	18.65	18600.0
2007-07-23	CSD	ETF	31.14	31.29	31.11	31.15	43900.0
2007-07-23	CSQ	ETF	15.0	15.079	14.83	14.95	384200.0
2007-07-23	CTEC	ETF	108.05	110.99999999999999	108.0	109.64999999999999	13263.800000000001
2007-07-23	CVY	ETF	27.71	27.71	27.52	27.52	9000.0
2007-07-23	CWI	ETF	28.3867	28.4467	28.3267	28.38	26250.0
2007-07-23	DBA	ETF	26.23	26.26	25.58	25.7	344100.0
2007-07-23	DBB	ETF	28.51	28.51	28.3	28.37	30800.0
2007-07-23	DBC	ETF	26.27	26.28	26.06	26.28	220300.0
2007-07-23	DBE	ETF	29.13	29.3	29.04	29.3	29600.0
2007-07-23	DBO	ETF	27.59	27.72	27.49	27.72	19100.0
2007-07-23	DBP	ETF	26.73	26.73	26.62	26.65	6700.0
2007-07-23	DBS	ETF	26.13	26.19	26.05	26.09	4800.0
2007-07-23	DBV	ETF	29.72	29.81	29.65	29.78	170300.0

> showing 50 of 485 rows — these rows as CSV

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