PREVIEW / etf_daily / 2008-05-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-05-23.parquet
  size:    26 KB
  rows:    591

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-05-23	SPY	ETF	139.05	139.66	137.52	137.64	181376400.0
2008-05-23	QQQ	ETF	48.18	48.3505	47.82	48.2	121708036.0
2008-05-23	IWM	ETF	72.85	73.19	71.73	72.21	64498000.0
2008-05-23	DIA	ETF	125.63	125.81	124.57	124.61	10704000.0
2008-05-23	GLD	ETF	91.33	92.0	90.96	91.23	6062800.0
2008-05-23	TLT	ETF	91.83	92.3	91.7	91.77	1802000.0
2008-05-23	ACWI	ETF	53.88	53.9	52.1	53.04	13800.0
2008-05-23	ACWX	ETF	55.49	55.49	54.808	54.957	9699.0
2008-05-23	ADRE	ETF	56.67	56.67	55.444	55.85	624263.0
2008-05-23	AGG	ETF	101.74	101.95	101.6	101.94	584000.0
2008-05-23	AIA	ETF	45.24	45.54	43.94	45.185	138610.0
2008-05-23	AIQ	ETF	43.9	45.3	43.9	45.2	19880.0
2008-05-23	AIS	ETF	0.82	0.83	0.8	0.83	13540.0
2008-05-23	AIVI	ETF	67.78	67.79	67.13	67.17	15600.0
2008-05-23	ARB	ETF	48.3	48.63	48.0	48.52	134520.0
2008-05-23	BBH	ETF	53.9467	53.98	53.53	53.6367	299100.0
2008-05-23	BIL	ETF	91.64	91.66	91.62	91.64	16600.0
2008-05-23	BITS	ETF	24.48	24.96	22.76	23.08	12749.0
2008-05-23	BIV	ETF	77.74	77.89	77.68	77.89	29900.0
2008-05-23	BJK	ETF	37.55	37.75	37.55	37.75	500.0
2008-05-23	BKF	ETF	58.55	58.55	57.29	57.5	56658.0
2008-05-23	BLV	ETF	75.15	75.8	75.15	75.61	5000.0
2008-05-23	BMVP	ETF	16.313	16.313	16.12	16.158	26666.0
2008-05-23	BND	ETF	77.0	77.49	77.0	77.41	591200.0
2008-05-23	BNE	ETF	15.1	15.2	14.96	15.05	393233.0
2008-05-23	BOSS	ETF	33.55	33.55	33.0	33.0	100.0
2008-05-23	BRF	ETF	14.77	14.81	14.77	14.8	13600.0
2008-05-23	BSV	ETF	77.77	77.89	77.75	77.87	54700.0
2008-05-23	BTF	ETF	99.89999999999999	100.0	99.05049999999999	99.60000000000001	3960.8
2008-05-23	BWX	ETF	28.155	28.365	28.155	28.265	153336.0
2008-05-23	CBON	ETF	8.48	8.69	8.27	8.4	41231.0
2008-05-23	CDL	ETF	1.69	1.71	1.6	1.69	703361.0
2008-05-23	CEF	ETF	12.9	13.02	12.84	12.86	467900.0
2008-05-23	CGO	ETF	16.62	16.678	16.56	16.56	12565.0
2008-05-23	CGW	ETF	25.81	25.81	24.92	25.16	66934.0
2008-05-23	CHB	ETF	8.2	8.3	7.95	8.08	1220081.0
2008-05-23	CHI	ETF	15.46	15.52	15.38	15.41	85339.0
2008-05-23	CHIC	ETF	18.01	18.025	17.64	17.71	160610.0
2008-05-23	CHW	ETF	12.41	12.46	12.29	12.38	116151.0
2008-05-23	CHY	ETF	14.22	14.321	14.17	14.17	110915.0
2008-05-23	CMF	ETF	52.735	52.845	52.45	52.8225	56568.0
2008-05-23	CN	ETF	68.5	68.5	68.5	68.5	5400.0
2008-05-23	CNXT	ETF	0.46	0.47	0.45	0.4524	1327934.0
2008-05-23	COW	ETF	44.1	44.74	44.06	44.69	165858.0
2008-05-23	CPST	ETF	3.8	3.81	3.41	3.56	10592090.0
2008-05-23	CSA	ETF	17.68	17.76	17.42	17.49	20160.0
2008-05-23	CSB	ETF	23.56	23.62	21.2	23.0	90873.0
2008-05-23	CSD	ETF	24.04	24.04	23.91	23.91	13800.0
2008-05-23	CSQ	ETF	13.04	13.1	12.95	12.98	259539.0
2008-05-23	CUT	ETF	21.83	21.83	21.46	21.46	15800.0

> showing 50 of 591 rows — these rows as CSV

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