PREVIEW / etf_daily / 2010-03-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-23.parquet
  size:    32 KB
  rows:    732

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-03-23	SPY	ETF	116.76	117.51	116.38	117.41	182941600.0
2010-03-23	QQQ	ETF	48.0	48.3	47.77	48.2525	59182586.0
2010-03-23	IWM	ETF	68.42	69.25	68.11	69.23	61187700.0
2010-03-23	DIA	ETF	108.03	108.92	107.83	108.87	9105900.0
2010-03-23	GLD	ETF	107.5	108.5	107.34	108.32	11274400.0
2010-03-23	TLT	ETF	91.07	91.32	90.91	90.93	2910000.0
2010-03-23	AAXJ	ETF	56.07	56.37	55.75	56.21	419500.0
2010-03-23	ACWI	ETF	43.37	43.5	43.17	43.5	484100.0
2010-03-23	ACWX	ETF	41.32	41.6	41.1701	41.6	18388.0
2010-03-23	ADRE	ETF	43.26	43.63	43.25	43.6001	73992.0
2010-03-23	AFK	ETF	30.87	31.19	30.8	31.0	44607.0
2010-03-23	AGG	ETF	104.79	104.94	104.79	104.85	725700.0
2010-03-23	AGQ	ETF	107.78	111.36	106.78	110.18	248050.0
2010-03-23	AGZ	ETF	108.3916	108.47	108.3516	108.38	11370.0
2010-03-23	AIA	ETF	39.92	39.96	39.6	39.92	12612.0
2010-03-23	AIQ	ETF	29.05	29.2	28.25	28.35	18368.0
2010-03-23	AIS	ETF	1.49	1.52	1.4681	1.52	324400.0
2010-03-23	AIVI	ETF	42.41	42.55	42.17	42.47	70600.0
2010-03-23	AMJ	ETF	30.03	30.04	29.9119	29.97	663665.0
2010-03-23	AOA	ETF	31.51	31.67	31.39	31.65	14600.0
2010-03-23	AOK	ETF	27.81	27.9299	27.81	27.894	35265.0
2010-03-23	AOM	ETF	28.7554	28.88	28.747	28.864	195438.0
2010-03-23	AOR	ETF	29.8008	29.929	29.7999	29.929	7373.0
2010-03-23	ARB	ETF	25.47	26.19	25.42	25.96	213492.0
2010-03-23	BAB	ETF	25.1	25.14	25.03	25.06	380694.0
2010-03-23	BAL	ETF	39.8	39.82	39.73	39.82	3200.0
2010-03-23	BALT	ETF	13.11	13.4	13.11	13.4	284448.0
2010-03-23	BBH	ETF	35.76	35.76	35.41	35.6067	83700.0
2010-03-23	BIL	ETF	91.68	91.7	91.68	91.7	148450.0
2010-03-23	BITS	ETF	33.54	33.72	31.68	33.0	6712.0
2010-03-23	BIV	ETF	80.93	80.94	80.77	80.85	198700.0
2010-03-23	BJK	ETF	25.38	25.58	25.25	25.58	22600.0
2010-03-23	BKF	ETF	45.72	46.08	45.45	45.88	202814.0
2010-03-23	BLV	ETF	77.72	77.84	77.51	77.62	27700.0
2010-03-23	BMVP	ETF	13.22	13.33	13.15	13.33	104247.0
2010-03-23	BND	ETF	79.65	79.7	79.58	79.62	538700.0
2010-03-23	BNE	ETF	11.28	11.3	11.24	11.26	590454.0
2010-03-23	BRF	ETF	46.18	46.47	45.9	46.23	387809.0
2010-03-23	BSV	ETF	80.19	80.2	80.11	80.17	464900.0
2010-03-23	BTF	ETF	73.49999999999999	74.05	73.35	73.95649999999999	5738.0
2010-03-23	BWX	ETF	28.265	28.315	28.175	28.25	252820.0
2010-03-23	BWZ	ETF	35.7	35.729	35.61	35.68	10083.0
2010-03-23	BZQ	ETF	3684.8	3758.4	3656.0	3678.4	417.5
2010-03-23	CEF	ETF	13.75	13.95	13.68	13.68	660900.0
2010-03-23	CEW	ETF	22.05	22.09	22.008	22.09	95638.0
2010-03-23	CGO	ETF	14.75	14.75	14.55	14.6	35692.0
2010-03-23	CGW	ETF	18.33	18.46	18.25	18.45	73101.0
2010-03-23	CHI	ETF	12.52	12.58	12.5	12.51	91462.0
2010-03-23	CHIE	ETF	14.15	14.171	14.1	14.171	700.0
2010-03-23	CHII	ETF	15.07	15.16	15.0	15.15	4310.0

> showing 50 of 732 rows — these rows as CSV

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