PREVIEW / etf_daily / 2008-09-22

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-22.parquet
  size:    27 KB
  rows:    617

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-09-22	SPY	ETF	124.45	124.75	120.36	121.31	249966500.0
2008-09-22	QQQ	ETF	42.75	42.84	40.8	40.88	164698164.0
2008-09-22	IWM	ETF	75.2	75.36	70.22	71.95	98340700.0
2008-09-22	DIA	ETF	113.82	113.98	109.86	110.5	21955600.0
2008-09-22	GLD	ETF	86.85	89.54	86.81	89.18	35324400.0
2008-09-22	TLT	ETF	92.93	93.96	92.6	93.96	4726300.0
2008-09-22	AAXJ	ETF	45.06	45.06	44.71	45.02	3900.0
2008-09-22	ACWI	ETF	45.52	45.52	44.12	44.12	49500.0
2008-09-22	ACWX	ETF	43.7	43.99	42.93	42.93	67022.0
2008-09-22	ADRE	ETF	39.8501	41.64	39.8501	40.093	298245.0
2008-09-22	AFK	ETF	36.49	36.49	34.0	35.56	2839.0
2008-09-22	AGG	ETF	99.88	100.72	99.0	99.42	1719500.0
2008-09-22	AIA	ETF	39.25	39.25	35.4	35.4	15182.0
2008-09-22	AIQ	ETF	56.45	57.65	56.3	56.9	112898.0
2008-09-22	AIS	ETF	0.56	0.73	0.56	0.7	29590.0
2008-09-22	AIVI	ETF	56.69	56.69	54.53	54.54	25700.0
2008-09-22	ARB	ETF	47.75	48.72	46.75	46.88	734376.0
2008-09-22	BAL	ETF	39.81	39.92	39.81	39.896	500.0
2008-09-22	BBH	ETF	61.8967	62.6633	61.2333	61.3167	216000.0
2008-09-22	BIL	ETF	91.66	91.9	91.66	91.8	760150.0
2008-09-22	BITS	ETF	22.08	23.52	22.0	23.16	2000.0
2008-09-22	BIV	ETF	74.85	76.67	74.68	75.25	43200.0
2008-09-22	BJK	ETF	27.65	27.65	27.65	27.65	400.0
2008-09-22	BKF	ETF	40.05	40.05	38.27	38.34	72891.0
2008-09-22	BLV	ETF	72.65	73.0	71.23	73.0	19600.0
2008-09-22	BMVP	ETF	14.32	14.59	14.167	14.182	49851.0
2008-09-22	BND	ETF	75.75	76.45	75.5	76.41	171800.0
2008-09-22	BNE	ETF	12.31	12.71	11.6	11.79	284000.0
2008-09-22	BRF	ETF	14.61	14.75	14.61	14.68	7366.0
2008-09-22	BSV	ETF	76.71	77.67	76.55	77.38	180200.0
2008-09-22	BTF	ETF	81.25	82.2	79.95	80.03	10867.0
2008-09-22	BWX	ETF	26.625	26.69	25.995	26.4344	189178.0
2008-09-22	CBON	ETF	6.3	6.82	6.11	6.69	53516.0
2008-09-22	CDL	ETF	0.75	0.9095	0.75	0.78	655878.0
2008-09-22	CEF	ETF	12.21	12.7	11.91	12.5	3118000.0
2008-09-22	CGO	ETF	12.73	12.75	12.0301	12.1	17075.0
2008-09-22	CGW	ETF	21.59	22.154	21.01	21.69	77971.0
2008-09-22	CHB	ETF	6.87	7.0	5.85	6.18	2677450.0
2008-09-22	CHI	ETF	11.15	11.2	10.48	10.58	223755.0
2008-09-22	CHIC	ETF	11.68	11.81	11.37	11.47	423727.0
2008-09-22	CHW	ETF	8.95	8.993	8.3	8.66	194925.0
2008-09-22	CHY	ETF	11.48	11.48	10.28	10.5	255759.0
2008-09-22	CMF	ETF	50.73	50.87	50.664	50.87	6500.0
2008-09-22	CN	ETF	46.91	47.49	44.54	44.6	458203.0
2008-09-22	CNXT	ETF	3.86	3.9	3.7	3.77	318614.0
2008-09-22	COW	ETF	40.5	41.56	40.0	41.33	208265.0
2008-09-22	CPI	ETF	23.1	23.1	23.1	23.1	200.0
2008-09-22	CPST	ETF	1.49	1.49	1.35	1.35	4351728.0
2008-09-22	CSA	ETF	17.33	17.82	17.05	17.5	94671.0
2008-09-22	CSB	ETF	16.52	17.0	16.0501	16.0501	19900.0

> showing 50 of 617 rows — these rows as CSV

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