PREVIEW / etf_daily / 2011-02-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-01.parquet
  size:    35 KB
  rows:    828

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
2011-02-01	SPY	ETF	129.46	130.97	129.38	130.74	167194300.0
2011-02-01	QQQ	ETF	56.4194	57.18	56.36	57.05	76952819.0
2011-02-01	IWM	ETF	78.58	80.01	78.37	79.75	57786700.0
2011-02-01	DIA	ETF	119.16	120.23	119.08	120.09	7626900.0
2011-02-01	GLD	ETF	130.52	131.08	129.33	130.8	15363700.0
2011-02-01	TLT	ETF	90.55	90.84	90.14	90.45	11508400.0
2011-02-01	AADR	ETF	30.37	30.37	30.3	30.3	1400.0
2011-02-01	AAXJ	ETF	61.98	62.55	61.75	62.36	2238400.0
2011-02-01	ACWI	ETF	47.65	48.33	47.65	48.27	355000.0
2011-02-01	ACWX	ETF	44.73	45.38	44.73	45.34	154175.0
2011-02-01	ADRE	ETF	46.75	47.45	46.68	47.37	120224.0
2011-02-01	AFK	ETF	32.83	33.36	32.606	33.202	82947.0
2011-02-01	AGG	ETF	105.25	105.26	105.03	105.12	700500.0
2011-02-01	AGQ	ETF	263.18	268.76	254.14	266.82	549800.0
2011-02-01	AGZ	ETF	109.64	109.65	109.48	109.59	21259.0
2011-02-01	AIA	ETF	47.84	48.43	47.78	48.27	65419.0
2011-02-01	AIQ	ETF	21.15	21.75	20.9	21.75	21821.0
2011-02-01	AIS	ETF	1.6	1.62	1.57	1.61	468669.0
2011-02-01	AIVI	ETF	46.22	46.83	46.22	46.79	21500.0
2011-02-01	AMJ	ETF	37.63	37.71	37.47	37.55	585377.0
2011-02-01	AMLP	ETF	81.85	82.45	81.5	81.6	118920.0
2011-02-01	AOA	ETF	34.94	35.32	34.94	35.26	19300.0
2011-02-01	AOK	ETF	28.96	29.0399	28.96	29.006	12870.0
2011-02-01	AOM	ETF	30.24	30.34	30.18	30.29	15217.0
2011-02-01	AOR	ETF	31.94	32.19	31.94	32.16	16213.0
2011-02-01	ARB	ETF	41.95	43.81	41.42	43.77	269521.0
2011-02-01	BAB	ETF	24.9	24.94	24.78	24.86	253598.0
2011-02-01	BAL	ETF	87.13	87.86	86.16	87.86	86868.0
2011-02-01	BALT	ETF	8.31	8.84	8.26	8.81	562725.0
2011-02-01	BBH	ETF	34.03	34.12	33.9867	34.0	42000.0
2011-02-01	BIB	ETF	7.6612	7.6625	7.6338	7.6537	25600.0
2011-02-01	BICK	ETF	31.6	32.095	31.51	32.095	55120.0
2011-02-01	BIL	ETF	91.7	91.72	91.7	91.7	787600.0
2011-02-01	BITS	ETF	28.0	28.32	27.84	28.32	1425.0
2011-02-01	BIV	ETF	82.58	82.62	82.3	82.49	142800.0
2011-02-01	BJK	ETF	32.41	32.89	32.41	32.83	12000.0
2011-02-01	BKF	ETF	47.5	48.0492	47.5	47.795	252095.0
2011-02-01	BLV	ETF	77.34	77.55	77.05	77.27	29000.0
2011-02-01	BMVP	ETF	15.0433	15.22	15.0433	15.2085	13215.0
2011-02-01	BND	ETF	79.99	80.05	79.84	79.96	1186900.0
2011-02-01	BNO	ETF	33.745	33.975	33.625	33.805	34200.0
2011-02-01	BRF	ETF	52.91	54.15	52.76	53.81	583988.0
2011-02-01	BSCE	ETF	20.9	20.91	20.87	20.87	8679.0
2011-02-01	BSV	ETF	80.54	80.55	80.45	80.5	554400.0
2011-02-01	BTF	ETF	80.29999999999998	82.27399999999999	79.95	82.14999999999999	24055.4
2011-02-01	BWX	ETF	29.5	29.745	29.5	29.68	196852.0
2011-02-01	BWZ	ETF	37.94	38.229	37.694	38.09	53414.0
2011-02-01	BZQ	ETF	2604.8	2612.8	2507.2	2561.6	368.0
2011-02-01	CEF	ETF	19.11	19.33	18.92	19.18	1115800.0
2011-02-01	CEW	ETF	22.36	22.46	22.3401	22.45	359118.0

> showing 50 of 828 rows — these rows as CSV

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