PREVIEW / etf_daily / 2008-05-20

all etf daily files

  file:    by_date/etf_daily/2008/2008-05-20.parquet
  size:    26 KB
  rows:    588

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-20	SPY	ETF	142.27	142.34	141.0	141.89	178552100.0
2008-05-20	QQQ	ETF	49.45	49.47	48.89	49.27	137163640.0
2008-05-20	IWM	ETF	73.44	73.73	72.8	73.7	82109000.0
2008-05-20	DIA	ETF	129.52	129.56	127.69	128.31	12598800.0
2008-05-20	GLD	ETF	89.61	91.17	89.56	90.9	10683000.0
2008-05-20	TLT	ETF	92.44	92.5	91.9	92.44	1466000.0
2008-05-20	ACWI	ETF	54.63	54.63	54.17	54.17	296200.0
2008-05-20	ACWX	ETF	55.7301	55.9	55.63	55.7	41850.0
2008-05-20	ADRE	ETF	57.32	57.32	56.6	57.32	546955.0
2008-05-20	AGG	ETF	102.3	102.33	102.1	102.3	670700.0
2008-05-20	AIA	ETF	47.7	47.7	46.1	46.435	42404.0
2008-05-20	AIQ	ETF	44.0	44.55	43.4	44.15	18101.0
2008-05-20	AIS	ETF	0.78	0.82	0.78	0.8	51792.0
2008-05-20	AIVI	ETF	68.35	68.45	67.82	68.14	26500.0
2008-05-20	ARB	ETF	48.37	48.93	47.91	48.11	179276.0
2008-05-20	BBH	ETF	55.63	55.67	55.0833	55.31	522300.0
2008-05-20	BIL	ETF	91.58	91.64	91.58	91.58	11750.0
2008-05-20	BITS	ETF	25.52	25.52	24.44	24.6	5600.0
2008-05-20	BIV	ETF	78.38	78.38	78.05	78.32	40100.0
2008-05-20	BJK	ETF	38.75	38.8	38.1	38.7	2700.0
2008-05-20	BKF	ETF	59.5	59.5	58.62	59.25	37944.0
2008-05-20	BLV	ETF	76.57	76.57	75.98	76.31	5500.0
2008-05-20	BMVP	ETF	16.52	16.5367	16.45	16.5367	24202.0
2008-05-20	BND	ETF	77.63	77.65	77.4	77.41	155100.0
2008-05-20	BNE	ETF	15.61	15.64	14.93	15.17	555233.0
2008-05-20	BRF	ETF	14.74	14.74	14.74	14.74	1600.0
2008-05-20	BSV	ETF	78.1	78.15	78.01	78.04	142400.0
2008-05-20	BTF	ETF	103.05	103.9995	102.15999999999998	102.39999999999999	10534.400000000001
2008-05-20	BWX	ETF	28.09	28.22	28.085	28.22	218334.0
2008-05-20	CBON	ETF	8.35	8.6	8.21	8.59	122343.0
2008-05-20	CDL	ETF	1.69	1.69	1.59	1.68	745339.0
2008-05-20	CEF	ETF	12.52	12.93	12.5	12.93	717800.0
2008-05-20	CGO	ETF	16.97	17.31	16.7301	17.05	34923.0
2008-05-20	CGW	ETF	25.55	25.55	25.1	25.1	64566.0
2008-05-20	CHB	ETF	8.82	8.89	8.51	8.73	1232916.0
2008-05-20	CHI	ETF	15.45	15.57	15.3	15.3	85897.0
2008-05-20	CHIC	ETF	17.89	18.27	17.89	18.06	373848.0
2008-05-20	CHW	ETF	12.58	13.03	12.35	12.4801	423894.0
2008-05-20	CHY	ETF	14.16	14.26	14.05	14.07	140225.0
2008-05-20	CMF	ETF	52.83	52.83	52.645	52.645	13702.0
2008-05-20	CN	ETF	58.37	60.02	58.37	59.44	200594.0
2008-05-20	CNXT	ETF	0.47	0.48	0.46	0.46	3376831.0
2008-05-20	COW	ETF	43.54	43.81	43.42	43.79	83175.0
2008-05-20	CPI	ETF	20.7661	20.7661	20.7661	20.7661	100.0
2008-05-20	CPST	ETF	3.74	3.95	3.64	3.95	7216855.0
2008-05-20	CSA	ETF	18.08	18.45	17.79	17.85	63819.0
2008-05-20	CSB	ETF	23.51	23.7499	23.07	23.45	29300.0
2008-05-20	CSD	ETF	24.92	24.92	24.56	24.68	23300.0
2008-05-20	CSQ	ETF	13.03	13.09	12.98	13.06	288927.0
2008-05-20	CUT	ETF	22.61	22.61	21.92	22.02	17500.0

> showing 50 of 588 rows — these rows as CSV

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