PREVIEW / etf_daily / 2010-03-02

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-02.parquet
  size:    32 KB
  rows:    730

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-02	SPY	ETF	112.37	112.74	112.0	112.2	160992400.0
2010-03-02	QQQ	ETF	45.54	45.85	45.45	45.55	76368426.0
2010-03-02	IWM	ETF	64.5	65.15	64.4	64.75	55605300.0
2010-03-02	DIA	ETF	104.43	104.64	103.95	104.01	5673300.0
2010-03-02	GLD	ETF	109.86	111.45	109.86	111.02	20102200.0
2010-03-02	TLT	ETF	90.88	91.28	90.7	91.22	2260600.0
2010-03-02	AAXJ	ETF	54.25	54.25	53.84	53.97	119700.0
2010-03-02	ACWI	ETF	41.83	41.83	41.49	41.64	1173500.0
2010-03-02	ACWX	ETF	39.65	40.03	39.63	39.82	106229.0
2010-03-02	ADRE	ETF	42.0	42.47	42.0	42.19	83268.0
2010-03-02	AFK	ETF	29.4	29.56	29.27	29.53	18550.0
2010-03-02	AGG	ETF	104.29	104.45	104.29	104.4	661200.0
2010-03-02	AGQ	ETF	106.0	111.88	105.96	109.32	455450.0
2010-03-02	AGZ	ETF	108.63	108.718	108.45	108.71	18807.0
2010-03-02	AIA	ETF	38.6	38.86	38.6	38.69	21084.0
2010-03-02	AIQ	ETF	24.75	24.7975	24.4	24.55	22068.0
2010-03-02	AIS	ETF	1.35	1.35	1.3	1.35	439281.0
2010-03-02	AIVI	ETF	40.84	40.98	40.63	40.76	13500.0
2010-03-02	AMJ	ETF	29.9	29.94	29.75	29.94	222747.0
2010-03-02	AOA	ETF	30.12	30.32	30.12	30.24	7300.0
2010-03-02	AOK	ETF	27.455	27.52	27.43	27.474	12231.0
2010-03-02	AOM	ETF	28.23	28.24	28.176	28.22	4488.0
2010-03-02	AOR	ETF	29.0	29.0499	28.99	29.01	4385.0
2010-03-02	ARB	ETF	21.92	22.39	21.8	21.91	488741.0
2010-03-02	BAB	ETF	24.96	25.036	24.85	25.0	153028.0
2010-03-02	BAL	ETF	39.18	39.47	38.89	39.4299	17076.0
2010-03-02	BBH	ETF	34.22	34.4	34.2033	34.3633	79800.0
2010-03-02	BIL	ETF	91.72	91.72	91.68	91.7	82950.0
2010-03-02	BITS	ETF	34.0	36.24	34.0	34.8	4298.0
2010-03-02	BIV	ETF	80.54	80.67	80.44	80.66	166400.0
2010-03-02	BJK	ETF	23.65	23.9	23.6	23.6	10500.0
2010-03-02	BKF	ETF	44.38	44.6862	44.13	44.38	406269.0
2010-03-02	BLV	ETF	77.1	77.26	76.86	77.26	16600.0
2010-03-02	BMVP	ETF	12.75	12.874	12.75	12.81	25349.0
2010-03-02	BND	ETF	79.45	79.54	79.4	79.52	709800.0
2010-03-02	BNE	ETF	11.23	11.25	11.18	11.2	2136438.0
2010-03-02	BRF	ETF	46.98	47.25	46.72	46.75	347894.0
2010-03-02	BSV	ETF	80.26	80.35	80.23	80.35	612200.0
2010-03-02	BTF	ETF	70.0	70.3	69.45	69.6	10800.0
2010-03-02	BWX	ETF	27.8	27.97	27.8	27.95	426440.0
2010-03-02	BWZ	ETF	35.99	35.99	35.585	35.74	8889.0
2010-03-02	BZQ	ETF	3950.4	3966.4	3838.4	3936.0	815.0
2010-03-02	CEF	ETF	13.67	13.9	13.66	13.81	1290500.0
2010-03-02	CEW	ETF	21.84	21.92	21.84	21.85	146529.0
2010-03-02	CGO	ETF	14.27	14.29	14.11	14.29	44572.0
2010-03-02	CGW	ETF	17.78	17.92	17.77	17.83	84179.0
2010-03-02	CHI	ETF	12.49	12.73	12.47	12.69	410534.0
2010-03-02	CHIE	ETF	14.14	14.14	14.1	14.14	1000.0
2010-03-02	CHII	ETF	15.04	15.0825	14.986	15.0355	7674.0
2010-03-02	CHIM	ETF	26.46	26.46	26.02	26.22	1213.0

> showing 50 of 730 rows — these rows as CSV

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