PREVIEW / etf_daily / 2010-04-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-23.parquet
  size:    33 KB
  rows:    750

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
2010-04-23	SPY	ETF	120.94	121.86	120.63	121.81	177335500.0
2010-04-23	QQQ	ETF	50.29	50.57	50.09	50.52	77205135.0
2010-04-23	IWM	ETF	73.49	74.21	72.64	74.13	66271100.0
2010-04-23	DIA	ETF	111.29	112.04	111.05	111.96	13873100.0
2010-04-23	GLD	ETF	111.26	113.3	111.09	113.19	12505800.0
2010-04-23	TLT	ETF	90.21	90.36	89.87	90.11	4776000.0
2010-04-23	AAXJ	ETF	57.73	58.39	57.7	58.39	151800.0
2010-04-23	ACWI	ETF	44.43	44.93	44.25	44.93	147800.0
2010-04-23	ACWX	ETF	41.87	42.269	41.7144	42.269	39459.0
2010-04-23	ADRE	ETF	44.53	44.958	44.34	44.91	123746.0
2010-04-23	AFK	ETF	32.21	32.89	32.2099	32.48	10694.0
2010-04-23	AGG	ETF	104.2	104.29	104.13	104.24	481000.0
2010-04-23	AGQ	ETF	120.48	125.24	119.68	125.2	143650.0
2010-04-23	AGZ	ETF	108.13	108.13	107.831	107.9	10547.0
2010-04-23	AIA	ETF	41.18	41.66	41.18	41.66	21144.0
2010-04-23	AIQ	ETF	28.5	29.1	28.25	28.8	30258.0
2010-04-23	AIS	ETF	1.6	1.61	1.56	1.58	350714.0
2010-04-23	AIVI	ETF	43.12	43.75	43.12	43.75	12600.0
2010-04-23	AMJ	ETF	31.53	31.74	31.53	31.69	312822.0
2010-04-23	AOA	ETF	32.51	32.69	32.45	32.69	5700.0
2010-04-23	AOK	ETF	28.05	28.2	28.05	28.16	7689.0
2010-04-23	AOM	ETF	29.01	29.195	29.01	29.195	5964.0
2010-04-23	AOR	ETF	30.38	30.55	30.38	30.55	11913.0
2010-04-23	ARB	ETF	30.95	31.8	30.19	31.74	305100.0
2010-04-23	BAB	ETF	25.29	25.3	25.19	25.23	139750.0
2010-04-23	BAL	ETF	40.73	40.75	40.2901	40.75	2383.0
2010-04-23	BALT	ETF	14.06	14.23	13.85	14.2	333935.0
2010-04-23	BBH	ETF	32.6233	33.07	32.6	33.07	236700.0
2010-04-23	BIB	ETF	7.31	7.3125	7.1713	7.2988	28272.0
2010-04-23	BICK	ETF	30.01	30.11	29.835	30.11	24772.0
2010-04-23	BIL	ETF	91.7	91.7	91.68	91.68	103000.0
2010-04-23	BIS	ETF	9974.4	9974.4	9832.0	9832.0	2.64
2010-04-23	BITS	ETF	31.9996	32.0	31.6004	31.8004	316.0
2010-04-23	BIV	ETF	80.4	80.44	80.27	80.37	73400.0
2010-04-23	BJK	ETF	27.08	27.54	27.08	27.41	27900.0
2010-04-23	BKF	ETF	46.67	46.97	46.368	46.88	259785.0
2010-04-23	BLV	ETF	77.65	77.65	77.26	77.48	15400.0
2010-04-23	BMVP	ETF	13.76	13.86	13.76	13.86	10983.0
2010-04-23	BND	ETF	79.34	79.37	79.22	79.34	533300.0
2010-04-23	BNE	ETF	11.2	11.21	11.19	11.2	317667.0
2010-04-23	BRF	ETF	46.03	46.39	45.88	46.3	188310.0
2010-04-23	BSV	ETF	79.88	79.97	79.88	79.94	355700.0
2010-04-23	BTF	ETF	74.3	75.19999999999999	74.3	74.89999999999999	4360.0
2010-04-23	BWX	ETF	27.575	27.96	27.5	27.65	173784.0
2010-04-23	BWZ	ETF	35.28	35.46	35.23	35.46	26271.0
2010-04-23	BZQ	ETF	3619.2	3662.4	3523.2	3552.0	380.0
2010-04-23	CEF	ETF	14.36	14.62	14.29	14.6	795400.0
2010-04-23	CEW	ETF	22.29	22.41	22.28	22.4	166021.0
2010-04-23	CGO	ETF	14.94	15.12	14.88	15.12	58871.0
2010-04-23	CGW	ETF	18.66	18.94	18.66	18.899	63936.0

> showing 50 of 750 rows — these rows as CSV

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