PREVIEW / etf_daily / 2010-03-31

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-31.parquet
  size:    32 KB
  rows:    735

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-31	SPY	ETF	116.95	117.52	116.61	117.0	161078700.0
2010-03-31	QQQ	ETF	48.23	48.45	48.07	48.16	59947394.0
2010-03-31	IWM	ETF	68.13	68.81	67.79	67.8	59821600.0
2010-03-31	DIA	ETF	108.82	109.04	108.32	108.61	6078200.0
2010-03-31	GLD	ETF	109.44	109.5	108.85	108.95	14006800.0
2010-03-31	TLT	ETF	89.22	89.52	88.95	89.5	4263900.0
2010-03-31	AAXJ	ETF	56.49	56.95	56.28	56.72	175600.0
2010-03-31	ACWI	ETF	43.6	43.72	43.38	43.51	50000.0
2010-03-31	ACWX	ETF	41.64	41.82	41.48	41.69	33098.0
2010-03-31	ADRE	ETF	43.83	44.16	43.75	44.0	115795.0
2010-03-31	AFK	ETF	31.59	31.62	31.37	31.5	3135.0
2010-03-31	AGG	ETF	104.17	104.34	104.15	104.2	808300.0
2010-03-31	AGQ	ETF	116.86	117.82	115.1	115.54	257900.0
2010-03-31	AGZ	ETF	108.22	108.28	108.1	108.19	15853.0
2010-03-31	AIA	ETF	40.28	40.5	40.19	40.33	21928.0
2010-03-31	AIQ	ETF	29.05	29.1005	27.975	28.1	30419.0
2010-03-31	AIS	ETF	1.36	1.38	1.34	1.37	302082.0
2010-03-31	AIVI	ETF	42.43	42.81	42.43	42.66	24700.0
2010-03-31	AMJ	ETF	30.37	30.53	30.14	30.53	610395.0
2010-03-31	AOA	ETF	31.37	31.61	31.37	31.48	25300.0
2010-03-31	AOK	ETF	27.86	27.89	27.77	27.86	31318.0
2010-03-31	AOM	ETF	28.71	28.77	28.672	28.6828	8077.0
2010-03-31	AOR	ETF	29.74	29.9	29.67	29.73	6392.0
2010-03-31	ARB	ETF	26.55	26.99	26.17	26.66	169873.0
2010-03-31	BAB	ETF	24.94	24.96	24.856	24.95	294109.0
2010-03-31	BAL	ETF	38.46	38.9	38.46	38.82	1200.0
2010-03-31	BALT	ETF	13.51	13.76	13.5	13.55	423397.0
2010-03-31	BBH	ETF	34.6233	34.6233	34.3633	34.4033	44400.0
2010-03-31	BIL	ETF	91.72	91.72	91.68	91.72	248100.0
2010-03-31	BITS	ETF	31.48	32.56	31.48	32.56	825.0
2010-03-31	BIV	ETF	80.35	80.36	80.17	80.28	80900.0
2010-03-31	BJK	ETF	25.77	25.98	25.7	25.89	10500.0
2010-03-31	BKF	ETF	46.14	46.69	46.08	46.38	98680.0
2010-03-31	BLV	ETF	76.59	76.93	76.59	76.93	20000.0
2010-03-31	BMVP	ETF	13.1867	13.2327	13.1533	13.2233	21219.0
2010-03-31	BND	ETF	79.23	79.28	79.13	79.2	463000.0
2010-03-31	BNE	ETF	11.2	11.22	11.16	11.16	1537980.0
2010-03-31	BRF	ETF	45.08	45.7	45.08	45.7	227163.0
2010-03-31	BSV	ETF	80.0	80.06	79.93	80.0	440100.0
2010-03-31	BTF	ETF	74.05	74.6	73.7	74.25	3254.2000000000003
2010-03-31	BWX	ETF	27.905	28.015	27.905	27.98	330204.0
2010-03-31	BWZ	ETF	35.45	35.55	35.41	35.41	23702.0
2010-03-31	BZQ	ETF	3664.0	3668.8	3560.0	3572.8	435.0
2010-03-31	CEF	ETF	14.01	14.06	13.95	14.0	886800.0
2010-03-31	CEW	ETF	22.19	22.24	22.16	22.23	68327.0
2010-03-31	CGO	ETF	14.83	14.92	14.7225	14.79	36180.0
2010-03-31	CGW	ETF	18.52	18.54	18.3319	18.43	51646.0
2010-03-31	CHI	ETF	12.63	12.75	12.59	12.7	130249.0
2010-03-31	CHIE	ETF	14.55	14.67	14.55	14.65	4643.0
2010-03-31	CHII	ETF	15.19	15.31	15.17	15.25	6240.0

> showing 50 of 735 rows — these rows as CSV

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