PREVIEW / etf_daily / 2009-06-18

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-18.parquet
  size:    29 KB
  rows:    660

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
2009-06-18	SPY	ETF	91.69	92.67	91.25	92.22	211725100.0
2009-06-18	QQQ	ETF	35.83	36.06	35.57	35.82	126266695.0
2009-06-18	IWM	ETF	50.77	51.32	50.3	51.0	34317000.0
2009-06-18	DIA	ETF	85.28	86.15	84.98	85.62	13378600.0
2009-06-18	GLD	ETF	92.24	92.5	91.3	91.61	16239200.0
2009-06-18	TLT	ETF	91.25	91.58	90.11	90.45	6794000.0
2009-06-18	AAXJ	ETF	42.92	43.19	42.5	43.05	983000.0
2009-06-18	ACWI	ETF	34.5	34.82	34.3	34.57	83000.0
2009-06-18	ACWX	ETF	33.38	33.59	33.09	33.21	286888.0
2009-06-18	ADRE	ETF	34.37	34.64	34.06	34.34	253460.0
2009-06-18	AFK	ETF	27.4	27.96	27.0	27.55	16640.0
2009-06-18	AGG	ETF	101.35	101.36	100.85	100.87	550300.0
2009-06-18	AGQ	ETF	89.46	90.56	88.4	89.02	74250.0
2009-06-18	AGZ	ETF	106.83	106.83	106.0342	106.21	17606.0
2009-06-18	AIA	ETF	31.57	31.57	31.02	31.37	10893.0
2009-06-18	AIQ	ETF	35.4	36.85	34.9	36.6	43185.0
2009-06-18	AIS	ETF	0.7	0.72	0.67	0.715	28732.0
2009-06-18	AIVI	ETF	35.17	35.63	35.17	35.37	106900.0
2009-06-18	AMJ	ETF	21.8287	21.97	21.78	21.96	105212.0
2009-06-18	AOA	ETF	25.17	25.21	25.09	25.15	6500.0
2009-06-18	AOK	ETF	25.6101	25.65	25.5699	25.65	3846.0
2009-06-18	AOM	ETF	26.09	26.09	25.4184	25.4184	11919.0
2009-06-18	AOR	ETF	25.5	25.5	25.42	25.46	2385.0
2009-06-18	ARB	ETF	18.3	18.42	17.74	17.84	182946.0
2009-06-18	BAL	ETF	29.76	30.84	29.59	30.55	6421.0
2009-06-18	BBH	ETF	31.2833	31.5567	30.9033	31.4033	521100.0
2009-06-18	BIL	ETF	91.76	91.76	91.72	91.74	330100.0
2009-06-18	BITS	ETF	18.72	19.12	18.3204	19.12	2025.0
2009-06-18	BIV	ETF	75.94	76.31	75.36	75.52	104900.0
2009-06-18	BJK	ETF	21.2	21.25	20.55	20.57	14500.0
2009-06-18	BKF	ETF	34.78	35.193	34.5	35.0	140800.0
2009-06-18	BLV	ETF	73.06	73.07	71.89	72.0	40700.0
2009-06-18	BMVP	ETF	10.8133	10.9433	10.8089	10.91	13332.0
2009-06-18	BND	ETF	77.0	77.02	76.51	76.57	502600.0
2009-06-18	BNE	ETF	6.98	7.23	6.85	6.92	89957.0
2009-06-18	BOSS	ETF	15.31	15.52	15.31	15.31	1000.0
2009-06-18	BRF	ETF	27.22	27.46	26.847	27.114	30868.0
2009-06-18	BSV	ETF	78.69	78.8	78.5	78.69	223600.0
2009-06-18	BTF	ETF	47.699999999999996	48.15	47.24999999999999	47.24999999999999	4617.400000000001
2009-06-18	BWX	ETF	26.96	26.995	26.715	26.815	234594.0
2009-06-18	BWZ	ETF	34.93	35.03	34.8	34.82	3557.0
2009-06-18	CBON	ETF	1.45	1.45	1.37	1.43	19845.0
2009-06-18	CEF	ETF	12.0	12.1	11.85	11.85	816200.0
2009-06-18	CEW	ETF	20.62	20.692	20.5999	20.644	8351.0
2009-06-18	CGO	ETF	11.31	11.6	11.27	11.45	37536.0
2009-06-18	CGW	ETF	15.26	15.32	15.1	15.17	46841.0
2009-06-18	CHB	ETF	0.41	0.42	0.38	0.39	375457.0
2009-06-18	CHI	ETF	10.53	10.62	10.4832	10.55	100772.0
2009-06-18	CHIC	ETF	11.91	12.03	11.5525	11.81	140826.0
2009-06-18	CHW	ETF	6.94	6.96	6.76	6.93	180028.0

> showing 50 of 660 rows — these rows as CSV

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