PREVIEW / etf_daily / 2009-10-26

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-26.parquet
  size:    30 KB
  rows:    681

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-10-26	SPY	ETF	108.2	109.31	106.61	106.91	242028200.0
2009-10-26	QQQ	ETF	43.17	43.76	42.79	42.99	107068518.0
2009-10-26	IWM	ETF	60.24	61.17	59.22	59.52	69899500.0
2009-10-26	DIA	ETF	99.9	100.77	98.52	98.81	16109800.0
2009-10-26	GLD	ETF	103.41	103.97	101.74	101.86	21519400.0
2009-10-26	TLT	ETF	94.44	94.51	93.55	93.72	4127400.0
2009-10-26	AAXJ	ETF	54.8	55.08	53.85	54.03	119700.0
2009-10-26	ACWI	ETF	41.85	42.31	41.19	41.27	143700.0
2009-10-26	ACWX	ETF	41.23	41.49	40.29	40.47	119792.0
2009-10-26	ADRE	ETF	43.78	44.22	42.778	42.96	234157.0
2009-10-26	AFK	ETF	30.49	30.65	29.57	29.57	26714.0
2009-10-26	AGG	ETF	104.28	104.47	104.03	104.06	470500.0
2009-10-26	AGQ	ETF	127.58	129.42	118.06	119.74	416400.0
2009-10-26	AGZ	ETF	108.33	108.49	108.1	108.131	19033.0
2009-10-26	AIA	ETF	39.58	39.832	38.906	39.0	39484.0
2009-10-26	AIQ	ETF	30.45	31.35	29.75	29.9	68750.0
2009-10-26	AIS	ETF	1.21	1.22	1.1492	1.16	578258.0
2009-10-26	AIVI	ETF	43.86	43.97	42.5	42.72	16500.0
2009-10-26	AMJ	ETF	26.54	26.72	26.0	26.03	960272.0
2009-10-26	AOA	ETF	29.48	29.7	29.1	29.1	10100.0
2009-10-26	AOK	ETF	27.19	27.27	27.0224	27.1	3489.0
2009-10-26	AOM	ETF	28.1	28.1	27.79	27.81	9805.0
2009-10-26	AOR	ETF	28.76	28.9	28.4	28.4	4933.0
2009-10-26	ARB	ETF	22.94	23.5	22.9	23.0	400165.0
2009-10-26	BAL	ETF	35.458	35.54	34.5201	34.68	5601.0
2009-10-26	BBH	ETF	31.7333	31.9067	30.9967	31.1467	781500.0
2009-10-26	BIL	ETF	91.7	91.72	91.7	91.7	82950.0
2009-10-26	BITS	ETF	25.6	25.6	24.57	25.52	681.0
2009-10-26	BIV	ETF	79.73	79.85	79.36	79.36	147400.0
2009-10-26	BJK	ETF	25.89	26.35	25.41	25.56	31000.0
2009-10-26	BKF	ETF	46.04	46.7	44.82	45.16	227667.0
2009-10-26	BLV	ETF	77.83	77.91	77.3	77.3	44400.0
2009-10-26	BMVP	ETF	12.2404	12.3367	12.0467	12.0667	15494.0
2009-10-26	BND	ETF	79.0	79.07	78.83	78.9	390700.0
2009-10-26	BNE	ETF	7.09	7.2	6.49	6.57	471194.0
2009-10-26	BOSS	ETF	22.83	22.87	22.83	22.83	200.0
2009-10-26	BRF	ETF	45.93	46.2	44.4	44.81	643265.0
2009-10-26	BSV	ETF	79.78	79.78	79.64	79.69	374300.0
2009-10-26	BTF	ETF	62.15	62.15	60.8	60.99999999999999	2071.0
2009-10-26	BWX	ETF	29.465	29.465	29.095	29.2	444290.0
2009-10-26	BWZ	ETF	37.72	37.73	37.34	37.47	46530.0
2009-10-26	BZQ	ETF	4227.2	4513.6	4145.6	4400.0	261.0
2009-10-26	CEF	ETF	13.78	13.9	13.3	13.37	1252200.0
2009-10-26	CEW	ETF	22.12	22.12	21.85	21.91	117756.0
2009-10-26	CGO	ETF	14.13	14.25	13.9	14.035	20144.0
2009-10-26	CGW	ETF	17.85	17.98	17.5218	17.613	44392.0
2009-10-26	CHB	ETF	0.36	0.37	0.32	0.3201	2784487.0
2009-10-26	CHI	ETF	12.09	12.25	11.95	12.0	159955.0
2009-10-26	CHW	ETF	7.96	7.9974	7.82	7.934	145183.0
2009-10-26	CHY	ETF	11.86	11.9	11.65	11.71	186751.0

> showing 50 of 681 rows — these rows as CSV

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