PREVIEW / etf_daily / 2008-02-22

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-22.parquet
  size:    26 KB
  rows:    575

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
2008-02-22	SPY	ETF	134.97	135.85	132.86	135.62	205491000.0
2008-02-22	QQQ	ETF	43.67	43.69	42.6	43.68	157364607.0
2008-02-22	IWM	ETF	69.51	69.51	68.04	69.42	84228000.0
2008-02-22	DIA	ETF	123.21	124.05	121.56	123.8	13727300.0
2008-02-22	GLD	ETF	93.56	93.72	92.35	93.39	7576900.0
2008-02-22	TLT	ETF	92.49	92.85	91.87	92.02	1959700.0
2008-02-22	ADRE	ETF	52.4	52.61	51.31	52.61	763666.0
2008-02-22	AGG	ETF	101.86	102.25	101.55	101.59	987700.0
2008-02-22	AIA	ETF	43.69	43.69	42.97	43.46	6200.0
2008-02-22	AIQ	ETF	49.8	50.15	48.65	49.25	136200.0
2008-02-22	AIS	ETF	1.0	1.02	0.99	1.01	171000.0
2008-02-22	AIVI	ETF	63.06	63.06	61.83	62.99	138400.0
2008-02-22	ARB	ETF	41.42	42.44	41.23	41.99	254300.0
2008-02-22	BBH	ETF	54.4867	54.6333	53.53	53.7767	517500.0
2008-02-22	BIL	ETF	91.72	91.84	91.72	91.8	90750.0
2008-02-22	BITS	ETF	21.04	21.16	20.6	20.92	6346.0
2008-02-22	BIV	ETF	78.45	78.7	78.22	78.28	25600.0
2008-02-22	BJK	ETF	42.2	42.2	42.05	42.05	900.0
2008-02-22	BKF	ETF	54.32	54.32	52.884	53.88	14600.0
2008-02-22	BLV	ETF	76.24	76.3	75.6	75.73	29600.0
2008-02-22	BMVP	ETF	15.9333	16.1	15.8167	16.0933	40190.0
2008-02-22	BND	ETF	77.18	77.42	76.98	77.01	175400.0
2008-02-22	BNE	ETF	13.22	13.28	13.02	13.11	179100.0
2008-02-22	BRF	ETF	14.66	14.66	14.65	14.65	4200.0
2008-02-22	BSV	ETF	78.51	78.63	78.42	78.42	61100.0
2008-02-22	BTF	ETF	108.55	108.55	106.54999999999998	107.75	3320.0
2008-02-22	BWX	ETF	27.36	27.485	27.265	27.485	361672.0
2008-02-22	CBON	ETF	13.07	13.24	12.27	12.62	106801.0
2008-02-22	CDL	ETF	1.33	1.45	1.31	1.42	2292401.0
2008-02-22	CEF	ETF	13.18	13.29	12.91	13.28	607200.0
2008-02-22	CGO	ETF	16.57	16.57	16.1	16.4	31100.0
2008-02-22	CGW	ETF	23.88	23.88	23.22	23.45	129146.0
2008-02-22	CHB	ETF	7.96	8.26	7.79	8.23	1221316.0
2008-02-22	CHI	ETF	14.27	14.86	14.27	14.86	124200.0
2008-02-22	CHIC	ETF	19.46	19.68	19.36	19.49	744103.0
2008-02-22	CHW	ETF	11.7	11.85	11.58	11.6682	156470.0
2008-02-22	CHY	ETF	13.29	13.67	13.2	13.62	132216.0
2008-02-22	CMF	ETF	51.975	52.215	51.8499	51.85	11200.0
2008-02-22	CN	ETF	62.2	63.23	61.23	63.16	251700.0
2008-02-22	CNXT	ETF	0.57	0.5769	0.55	0.553	1931624.0
2008-02-22	COW	ETF	45.9	45.93	45.4	45.64	24700.0
2008-02-22	CPI	ETF	19.5	19.5	19.3	19.45	900.0
2008-02-22	CPST	ETF	1.58	1.63	1.57	1.58	1885615.0
2008-02-22	CSA	ETF	14.7	14.88	14.39	14.66	183600.0
2008-02-22	CSD	ETF	23.62	23.62	23.2	23.51	12400.0
2008-02-22	CSQ	ETF	12.77	12.98	12.77	12.94	246009.0
2008-02-22	CUT	ETF	21.98	22.0	21.5	21.5	47400.0
2008-02-22	CVY	ETF	22.75	22.91	22.45	22.91	21300.0
2008-02-22	CWI	ETF	25.0667	25.34	24.8533	25.34	82200.0
2008-02-22	DBA	ETF	40.59	40.95	40.08	40.95	2120000.0

> showing 50 of 575 rows — these rows as CSV

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