PREVIEW / etf_daily / 2008-09-03

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-03.parquet
  size:    27 KB
  rows:    608

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-03	SPY	ETF	127.88	128.5	126.93	127.88	251947000.0
2008-09-03	QQQ	ETF	45.445	45.6381	44.79	45.12	161682806.0
2008-09-03	IWM	ETF	73.65	74.7	73.39	74.15	96282200.0
2008-09-03	DIA	ETF	115.25	115.74	114.33	115.51	17846600.0
2008-09-03	GLD	ETF	79.19	79.69	78.34	78.89	10707700.0
2008-09-03	TLT	ETF	94.27	94.89	94.26	94.77	2105000.0
2008-09-03	AAXJ	ETF	47.22	47.35	47.1	47.17	3900.0
2008-09-03	ACWI	ETF	46.33	46.37	45.73	45.78	26700.0
2008-09-03	ACWX	ETF	44.78	44.81	44.44	44.712	24850.0
2008-09-03	ADRE	ETF	43.01	43.4	42.27	42.53	350422.0
2008-09-03	AFK	ETF	37.7	37.7	36.8	37.07	5750.0
2008-09-03	AGG	ETF	100.7	100.87	100.5	100.67	419800.0
2008-09-03	AIA	ETF	36.59	36.76	36.27	36.34	30242.0
2008-09-03	AIQ	ETF	58.55	59.6	57.95	58.65	166125.0
2008-09-03	AIS	ETF	0.74	0.76	0.74	0.76	25427.0
2008-09-03	AIVI	ETF	56.17	56.43	55.81	56.24	14900.0
2008-09-03	ARB	ETF	48.39	49.04	47.96	48.25	215556.0
2008-09-03	BAL	ETF	43.21	43.24	43.16	43.24	1575.0
2008-09-03	BBH	ETF	65.57	66.1667	65.57	65.9833	262800.0
2008-09-03	BIL	ETF	91.7	91.74	91.7	91.74	49900.0
2008-09-03	BITS	ETF	23.92	23.92	22.6	22.6	778.0
2008-09-03	BIV	ETF	76.82	77.08	76.79	76.99	70600.0
2008-09-03	BJK	ETF	29.49	29.49	28.95	29.3	600.0
2008-09-03	BKF	ETF	43.5	43.5	42.0	42.25	30557.0
2008-09-03	BLV	ETF	75.09	75.17	75.07	75.15	3600.0
2008-09-03	BMVP	ETF	15.057	15.115	14.913	14.967	23228.0
2008-09-03	BND	ETF	76.27	76.42	76.15	76.36	171600.0
2008-09-03	BNE	ETF	12.06	12.39	11.86	12.2	184097.0
2008-09-03	BRF	ETF	14.75	14.75	14.73	14.74	10738.0
2008-09-03	BSV	ETF	77.57	77.63	77.44	77.59	60400.0
2008-09-03	BTF	ETF	84.85	85.99999999999999	84.0	84.25	10301.400000000001
2008-09-03	BWX	ETF	26.335	26.5	26.32	26.5	120620.0
2008-09-03	CBON	ETF	5.5	5.7	5.43	5.67	52910.0
2008-09-03	CDL	ETF	0.9	1.09	0.89	0.91	475398.0
2008-09-03	CEF	ETF	10.15	10.34	10.04	10.11	571200.0
2008-09-03	CGO	ETF	14.6	14.6	14.25	14.37	13254.0
2008-09-03	CGW	ETF	23.17	23.17	22.76	23.11	35463.0
2008-09-03	CHB	ETF	5.0	5.37	4.9	5.3	1270253.0
2008-09-03	CHI	ETF	13.41	13.424	13.31	13.4	98114.0
2008-09-03	CHIC	ETF	12.05	12.65	11.85	12.46	443131.0
2008-09-03	CHW	ETF	10.62	10.68	10.5	10.68	112635.0
2008-09-03	CHY	ETF	13.21	13.21	13.07	13.13	128807.0
2008-09-03	CMF	ETF	51.72	51.945	51.72	51.945	2976.0
2008-09-03	CN	ETF	47.04	47.88	46.6	47.0	322509.0
2008-09-03	CNXT	ETF	5.92	5.97	5.82	5.82	349159.0
2008-09-03	COW	ETF	41.98	42.0699	41.57	41.61	121751.0
2008-09-03	CPI	ETF	24.88	24.88	24.88	24.88	400.0
2008-09-03	CPST	ETF	2.54	2.63	2.43	2.46	2653984.0
2008-09-03	CSA	ETF	19.27	19.74	18.98	18.98	109318.0
2008-09-03	CSB	ETF	18.79	19.5	18.35	18.92	15920.0

> showing 50 of 608 rows — these rows as CSV

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