PREVIEW / etf_daily / 2009-10-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-21.parquet
  size:    30 KB
  rows:    678

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-21	SPY	ETF	109.04	110.31	108.15	108.23	225379300.0
2009-10-21	QQQ	ETF	43.2	43.82	43.06	43.14	110397326.0
2009-10-21	IWM	ETF	61.24	62.4	60.41	60.5	64591600.0
2009-10-21	DIA	ETF	100.22	101.2	99.41	99.43	12893600.0
2009-10-21	GLD	ETF	103.38	104.46	103.24	103.75	16004800.0
2009-10-21	TLT	ETF	96.16	96.21	95.51	96.14	3355200.0
2009-10-21	AAXJ	ETF	54.76	55.22	54.25	54.5	141400.0
2009-10-21	ACWI	ETF	42.06	42.7	42.02	42.03	102500.0
2009-10-21	ACWX	ETF	41.32	41.8986	41.32	41.35	58406.0
2009-10-21	ADRE	ETF	43.3	44.46	43.3	43.65	188479.0
2009-10-21	AFK	ETF	30.39	30.69	30.28	30.28	35469.0
2009-10-21	AGG	ETF	104.53	104.63	104.28	104.63	460500.0
2009-10-21	AGQ	ETF	125.06	129.96	125.06	127.38	206600.0
2009-10-21	AGZ	ETF	108.63	108.63	108.4401	108.62	8745.0
2009-10-21	AIA	ETF	39.25	39.75	39.1	39.14	17506.0
2009-10-21	AIQ	ETF	30.75	31.55	30.3	30.45	22900.0
2009-10-21	AIS	ETF	1.27	1.27	1.2	1.2	586433.0
2009-10-21	AIVI	ETF	43.85	44.52	43.78	43.86	14700.0
2009-10-21	AMJ	ETF	26.48	26.77	26.441	26.54	215363.0
2009-10-21	AOA	ETF	29.8	29.99	29.55	29.55	18200.0
2009-10-21	AOK	ETF	27.38	27.39	27.2768	27.28	12616.0
2009-10-21	AOM	ETF	28.14	28.26	28.0215	28.05	11205.0
2009-10-21	AOR	ETF	29.0	29.08	28.8	28.8	3452.0
2009-10-21	ARB	ETF	22.96	23.84	22.86	22.96	395927.0
2009-10-21	BAL	ETF	35.03	35.552	35.03	35.384	7760.0
2009-10-21	BBH	ETF	33.0	33.07	32.5967	32.89	339000.0
2009-10-21	BIL	ETF	91.72	91.72	91.7	91.7	83700.0
2009-10-21	BITS	ETF	25.09	25.4	25.04	25.2	1082.0
2009-10-21	BIV	ETF	80.28	80.28	79.86	80.14	135700.0
2009-10-21	BJK	ETF	26.35	26.83	26.35	26.37	20500.0
2009-10-21	BKF	ETF	45.64	46.5	45.52	45.65	283068.0
2009-10-21	BLV	ETF	78.65	78.81	78.27	78.64	50800.0
2009-10-21	BMVP	ETF	12.36	12.47	12.23	12.23	16034.0
2009-10-21	BND	ETF	79.26	79.32	79.07	79.31	453700.0
2009-10-21	BNE	ETF	7.83	8.42	7.7	7.73	120059.0
2009-10-21	BOSS	ETF	22.01	22.36	22.01	22.01	100.0
2009-10-21	BRF	ETF	44.31	46.01	44.22	45.09	672341.0
2009-10-21	BSV	ETF	79.94	79.96	79.85	79.87	253300.0
2009-10-21	BTF	ETF	61.849999999999994	62.599999999999994	61.6	62.24999999999999	5439.0
2009-10-21	BWX	ETF	29.545	29.625	29.485	29.575	354030.0
2009-10-21	BWZ	ETF	37.7	37.7	37.55	37.55	29714.0
2009-10-21	BZQ	ETF	4404.8	4404.8	4115.2	4328.0	392.0
2009-10-21	CEF	ETF	13.58	13.96	13.58	13.87	962400.0
2009-10-21	CEW	ETF	22.11	22.17	22.09	22.13	97712.0
2009-10-21	CGO	ETF	14.21	14.3599	14.21	14.21	18825.0
2009-10-21	CGW	ETF	17.92	18.1785	17.81	17.81	116987.0
2009-10-21	CHB	ETF	0.4	0.41	0.35	0.37	2821145.0
2009-10-21	CHI	ETF	11.99	12.06	11.93	11.93	129405.0
2009-10-21	CHW	ETF	7.91	8.04	7.85	7.85	221252.0
2009-10-21	CHY	ETF	11.62	11.77	11.62	11.69	131634.0

> showing 50 of 678 rows — these rows as CSV

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