PREVIEW / etf_daily / 2009-12-22

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-22.parquet
  size:    31 KB
  rows:    706

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-12-22	SPY	ETF	111.57	111.97	111.43	111.73	91707500.0
2009-12-22	QQQ	ETF	45.08	45.29	45.03	45.23	51569042.0
2009-12-22	IWM	ETF	62.05	62.65	61.92	62.57	38750700.0
2009-12-22	DIA	ETF	104.22	104.61	104.05	104.45	6849400.0
2009-12-22	GLD	ETF	106.79	107.09	105.31	106.17	28702900.0
2009-12-22	TLT	ETF	90.8	90.87	90.42	90.63	3078800.0
2009-12-22	AAXJ	ETF	54.35	54.42	54.0	54.18	129500.0
2009-12-22	ACWI	ETF	42.17	42.17	41.85	42.08	527700.0
2009-12-22	ACWX	ETF	40.48	40.48	40.19	40.46	130586.0
2009-12-22	ADRE	ETF	42.63	43.02	42.63	42.97	114243.0
2009-12-22	AFK	ETF	27.95	28.15	27.8	28.0	11437.0
2009-12-22	AGG	ETF	104.13	104.17	103.88	104.01	609400.0
2009-12-22	AGQ	ETF	114.0	116.8	111.4	114.18	187600.0
2009-12-22	AGZ	ETF	108.2	108.28	108.105	108.22	9897.0
2009-12-22	AIA	ETF	38.93	38.93	38.55	38.7588	21507.0
2009-12-22	AIQ	ETF	27.4	28.65	27.4	28.3	101347.0
2009-12-22	AIS	ETF	1.09	1.0901	1.06	1.08	94940.0
2009-12-22	AIVI	ETF	43.03	43.5	43.03	43.4	35400.0
2009-12-22	AMJ	ETF	28.2	28.27	28.09	28.25	262832.0
2009-12-22	AOA	ETF	30.07	30.14	30.05	30.14	4600.0
2009-12-22	AOK	ETF	27.5	27.5	27.41	27.5	6196.0
2009-12-22	AOM	ETF	28.38	28.41	28.3	28.33	18170.0
2009-12-22	AOR	ETF	29.05	29.14	29.04	29.1299	13030.0
2009-12-22	ARB	ETF	23.91	24.4	23.75	23.95	222116.0
2009-12-22	BAB	ETF	24.37	24.44	24.29	24.385	207327.0
2009-12-22	BAL	ETF	37.41	37.41	36.0	36.23	4037.0
2009-12-22	BBH	ETF	32.3	32.5967	32.1933	32.48	262500.0
2009-12-22	BIL	ETF	91.72	91.74	91.7	91.7	90650.0
2009-12-22	BITS	ETF	30.2	30.2	29.4	29.56	1011.0
2009-12-22	BIV	ETF	79.8	79.9	79.61	79.77	187300.0
2009-12-22	BJK	ETF	23.81	23.85	23.66	23.7	37400.0
2009-12-22	BKF	ETF	44.6	44.64	44.18	44.56	283390.0
2009-12-22	BLV	ETF	76.42	76.54	76.03	76.17	45900.0
2009-12-22	BMVP	ETF	12.63	12.7009	12.6267	12.69	20465.0
2009-12-22	BND	ETF	79.09	79.1	78.9	78.99	603200.0
2009-12-22	BNE	ETF	7.1	7.25	7.09	7.18	182134.0
2009-12-22	BOSS	ETF	19.83	19.91	19.81	19.85	100.0
2009-12-22	BRF	ETF	46.99	47.39	46.79	47.08	259806.0
2009-12-22	BSV	ETF	80.04	80.13	79.88	79.99	624400.0
2009-12-22	BTF	ETF	63.2	63.49999999999999	62.99999999999999	63.05	5646.0
2009-12-22	BWX	ETF	28.335	28.6005	27.25	28.545	973396.0
2009-12-22	BWZ	ETF	36.48	36.48	36.1575	36.3	33762.0
2009-12-22	BZQ	ETF	4011.2	4104.0	3998.4	4024.0	136.0
2009-12-22	CEF	ETF	13.43	13.62	13.25	13.43	1692900.0
2009-12-22	CEW	ETF	21.71	21.73	21.65	21.72	85941.0
2009-12-22	CGO	ETF	14.38	14.38	14.01	14.21	23536.0
2009-12-22	CGW	ETF	18.61	18.61	18.4	18.55	127711.0
2009-12-22	CHI	ETF	12.45	12.48	12.38	12.4305	139541.0
2009-12-22	CHIE	ETF	14.69	14.7	14.58	14.59	6620.0
2009-12-22	CHII	ETF	15.15	15.15	14.985	15.03	7543.0

> showing 50 of 706 rows — these rows as CSV

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