PREVIEW / etf_daily / 2008-09-11

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-11.parquet
  size:    27 KB
  rows:    616

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-11	SPY	ETF	122.12	125.74	121.6	125.51	375369400.0
2008-09-11	QQQ	ETF	42.17	43.69	42.17	43.6	203440964.0
2008-09-11	IWM	ETF	70.52	72.0	69.9	71.92	144283600.0
2008-09-11	DIA	ETF	111.78	114.86	111.22	114.86	39238000.0
2008-09-11	GLD	ETF	73.61	73.93	72.51	73.08	23774700.0
2008-09-11	TLT	ETF	96.79	96.86	96.0	96.18	3592000.0
2008-09-11	AAXJ	ETF	44.16	44.65	43.98	44.45	3300.0
2008-09-11	ACWI	ETF	43.67	44.21	43.0	44.21	22100.0
2008-09-11	ACWX	ETF	41.38	41.71	41.11	41.642	128585.0
2008-09-11	ADRE	ETF	38.29	39.57	37.97	39.52	637252.0
2008-09-11	AFK	ETF	33.97	34.5	33.94	33.94	1590.0
2008-09-11	AGG	ETF	101.9	101.9	101.5	101.62	371800.0
2008-09-11	AIA	ETF	34.59	35.31	34.59	34.97	15590.0
2008-09-11	AIQ	ETF	58.5	59.35	57.9	59.0	45504.0
2008-09-11	AIS	ETF	0.7205	0.74	0.7	0.72	98300.0
2008-09-11	AIVI	ETF	51.72	53.18	51.68	53.07	24700.0
2008-09-11	ARB	ETF	47.57	48.5	47.25	48.2	191113.0
2008-09-11	BAL	ETF	39.71	39.71	39.71	39.71	100.0
2008-09-11	BBH	ETF	63.4567	65.22	63.4567	65.1	612300.0
2008-09-11	BIL	ETF	91.78	91.8	91.74	91.76	112750.0
2008-09-11	BITS	ETF	22.12	23.08	21.48	22.6	2757.0
2008-09-11	BIV	ETF	77.63	77.63	77.21	77.25	175900.0
2008-09-11	BJK	ETF	27.63	27.63	27.09	27.09	1500.0
2008-09-11	BKF	ETF	36.5	37.5	36.05	37.5	41752.0
2008-09-11	BLV	ETF	76.14	76.14	75.39	75.94	4800.0
2008-09-11	BMVP	ETF	14.24	14.51	14.11	14.51	28000.0
2008-09-11	BND	ETF	77.27	77.31	76.98	77.09	183500.0
2008-09-11	BNE	ETF	12.14	12.4499	12.0	12.25	98874.0
2008-09-11	BRF	ETF	14.82	14.85	14.65	14.8	35425.0
2008-09-11	BSV	ETF	77.95	77.96	77.72	77.78	109700.0
2008-09-11	BTF	ETF	83.75	85.44999999999999	82.5505	83.55	8550.4
2008-09-11	BWX	ETF	25.765	25.9	25.755	25.8	167372.0
2008-09-11	CBON	ETF	5.33	5.38	4.82	4.88	93132.0
2008-09-11	CDL	ETF	0.86	0.91	0.86	0.87	899903.0
2008-09-11	CEF	ETF	8.89	8.92	8.57	8.7	1708100.0
2008-09-11	CGO	ETF	12.98	12.98	12.78	12.85	28144.0
2008-09-11	CGW	ETF	21.17	21.19	20.72	21.08	1200469.0
2008-09-11	CHB	ETF	5.38	5.49	5.0	5.47	1195556.0
2008-09-11	CHI	ETF	12.5	12.5	12.02	12.15	140015.0
2008-09-11	CHIC	ETF	12.32	12.77	12.12	12.75	315220.0
2008-09-11	CHW	ETF	9.61	9.61	9.32	9.5	174304.0
2008-09-11	CHY	ETF	12.33	12.33	12.0	12.19	151511.0
2008-09-11	CMF	ETF	52.0	52.21	51.985	52.16	15600.0
2008-09-11	CN	ETF	43.75	44.75	43.27	44.67	265668.0
2008-09-11	CNXT	ETF	5.02	5.08	4.89	4.95	606613.0
2008-09-11	COW	ETF	40.79	41.323	40.75	41.21	76730.0
2008-09-11	CPI	ETF	23.2	23.2	23.1	23.1	400.0
2008-09-11	CPST	ETF	1.75	1.85	1.69	1.77	2532109.0
2008-09-11	CSA	ETF	18.25	18.55	18.0	18.13	639680.0
2008-09-11	CSB	ETF	17.5	18.13	16.02	18.01	47163.0

> showing 50 of 616 rows — these rows as CSV

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