PREVIEW / etf_daily / 2009-10-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-23.parquet
  size:    30 KB
  rows:    675

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-23	SPY	ETF	109.69	109.76	107.63	108.08	240033200.0
2009-10-23	QQQ	ETF	43.69	43.73	43.02	43.13	117029885.0
2009-10-23	IWM	ETF	61.47	61.68	59.97	60.06	68826500.0
2009-10-23	DIA	ETF	100.98	101.07	99.37	99.83	13214000.0
2009-10-23	GLD	ETF	104.5	104.58	102.96	103.49	11423000.0
2009-10-23	TLT	ETF	94.88	95.42	94.87	94.95	2996200.0
2009-10-23	AAXJ	ETF	55.05	55.05	53.99	54.31	193700.0
2009-10-23	ACWI	ETF	42.56	42.56	41.7	41.73	29800.0
2009-10-23	ACWX	ETF	41.66	41.66	40.897	41.08	51951.0
2009-10-23	ADRE	ETF	43.98	44.21	43.24	43.38	207396.0
2009-10-23	AFK	ETF	30.37	30.5708	30.25	30.25	7834.0
2009-10-23	AGG	ETF	104.33	104.45	104.24	104.34	677300.0
2009-10-23	AGQ	ETF	131.34	131.58	124.66	128.22	195150.0
2009-10-23	AGZ	ETF	108.4	108.45	108.15	108.15	6269.0
2009-10-23	AIA	ETF	39.38	39.52	38.8215	38.934	35064.0
2009-10-23	AIQ	ETF	30.65	30.8	30.2	30.35	30641.0
2009-10-23	AIS	ETF	1.2	1.21	1.15	1.18	832898.0
2009-10-23	AIVI	ETF	44.18	44.18	43.25	43.31	19400.0
2009-10-23	AMJ	ETF	26.84	28.34	26.21	26.33	391618.0
2009-10-23	AOA	ETF	29.98	29.98	29.42	29.5	21000.0
2009-10-23	AOK	ETF	27.31	27.31	27.13	27.13	9783.0
2009-10-23	AOM	ETF	28.19	28.19	27.97	27.98	8593.0
2009-10-23	AOR	ETF	28.97	29.19	28.645	28.71	13902.0
2009-10-23	ARB	ETF	23.5	23.64	22.975	23.0	625784.0
2009-10-23	BAL	ETF	35.38	35.41	34.85	35.0	8092.0
2009-10-23	BBH	ETF	31.6633	32.3067	31.6167	31.6333	305400.0
2009-10-23	BIL	ETF	91.7	91.72	91.7	91.7	161750.0
2009-10-23	BITS	ETF	25.48	25.6	24.7492	25.6	651.0
2009-10-23	BIV	ETF	79.93	80.04	79.62	79.9	155500.0
2009-10-23	BJK	ETF	26.59	26.65	25.81	25.81	10000.0
2009-10-23	BKF	ETF	46.93	46.93	45.558	45.79	259199.0
2009-10-23	BLV	ETF	78.11	78.48	78.0	78.17	37300.0
2009-10-23	BMVP	ETF	12.4	12.4	12.14	12.16	17184.0
2009-10-23	BND	ETF	79.13	79.18	78.94	79.0	552700.0
2009-10-23	BNE	ETF	7.89	8.05	7.02	7.04	375878.0
2009-10-23	BOSS	ETF	23.09	23.09	22.61	23.09	400.0
2009-10-23	BRF	ETF	46.38	46.43	45.19	45.67	413393.0
2009-10-23	BSV	ETF	79.89	79.91	79.75	79.81	579600.0
2009-10-23	BTF	ETF	62.5	62.5	61.199999999999996	61.849999999999994	1871.2
2009-10-23	BWX	ETF	29.5	29.53	29.425	29.465	292586.0
2009-10-23	BWZ	ETF	37.76	37.76	37.68	37.72	18635.0
2009-10-23	BZQ	ETF	4091.2	4342.4	4091.2	4308.8	425.0
2009-10-23	CEF	ETF	13.9	13.98	13.82	13.85	1347000.0
2009-10-23	CEW	ETF	22.2	22.2	22.0701	22.09	82455.0
2009-10-23	CGO	ETF	14.28	14.368	14.0	14.01	29435.0
2009-10-23	CGW	ETF	18.08	18.14	17.7	17.8	72631.0
2009-10-23	CHB	ETF	0.3508	0.37	0.35	0.352	1028525.0
2009-10-23	CHI	ETF	12.07	12.15	11.99	12.08	136744.0
2009-10-23	CHW	ETF	7.96	7.9801	7.82	7.95	185151.0
2009-10-23	CHY	ETF	11.79	11.88	11.7205	11.76	131485.0

> showing 50 of 675 rows — these rows as CSV

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