PREVIEW / etf_daily / 2011-04-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-13.parquet
  size:    36 KB
  rows:    837

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-04-13	SPY	ETF	132.08	132.18	130.96	131.46	162059000.0
2011-04-13	QQQ	ETF	56.77	57.0	56.4	56.85	49979733.0
2011-04-13	IWM	ETF	82.65	82.81	81.67	82.25	80424900.0
2011-04-13	DIA	ETF	123.17	123.21	122.08	122.55	4278200.0
2011-04-13	GLD	ETF	142.39	142.53	141.48	141.9	13884200.0
2011-04-13	TLT	ETF	90.54	91.5	90.44	91.5	7959300.0
2011-04-13	AADR	ETF	30.9	30.94	30.9	30.94	600.0
2011-04-13	AAXJ	ETF	64.38	64.38	63.61	63.8	314200.0
2011-04-13	ACWI	ETF	48.79	48.87	48.32	48.56	523100.0
2011-04-13	ACWX	ETF	46.07	46.1599	45.58	45.8	77583.0
2011-04-13	ADRE	ETF	48.54	48.575	47.886	48.1	31251.0
2011-04-13	AFK	ETF	33.22	33.37	33.09	33.37	17333.0
2011-04-13	AGG	ETF	104.89	105.23	104.89	105.17	531500.0
2011-04-13	AGQ	ETF	516.94	523.4	506.18	517.96	726450.0
2011-04-13	AGZ	ETF	109.29	109.57	109.21	109.4	7374.0
2011-04-13	AIA	ETF	48.53	48.71	48.111	48.31	13106.0
2011-04-13	AIQ	ETF	22.7	23.225	22.45	22.9	58337.0
2011-04-13	AIS	ETF	1.61	1.64	1.57	1.61	431459.0
2011-04-13	AIVI	ETF	48.45	48.45	47.93	48.17	6700.0
2011-04-13	AMJ	ETF	37.88	37.93	37.67	37.79	493298.0
2011-04-13	AMLP	ETF	81.8	82.0	81.55	81.7	80460.0
2011-04-13	AOA	ETF	35.83	35.85	35.67	35.84	4100.0
2011-04-13	AOK	ETF	29.2	29.2	29.16	29.19	2387.0
2011-04-13	AOM	ETF	30.59	30.59	30.49	30.56	4221.0
2011-04-13	AOR	ETF	32.5292	32.55	32.4	32.503	7908.0
2011-04-13	ARB	ETF	37.39	37.51	36.48	36.99	87015.0
2011-04-13	ARGT	ETF	30.52	30.64	30.4	30.64	6900.0
2011-04-13	ASEA	ETF	16.15	16.18	16.15	16.16	1300.0
2011-04-13	BAB	ETF	25.26	25.44	25.254	25.4	125349.0
2011-04-13	BAL	ETF	102.88	105.62	99.3	100.34	96839.0
2011-04-13	BALT	ETF	8.72	8.81	8.62	8.67	126232.0
2011-04-13	BBH	ETF	36.13	36.38	36.13	36.3667	28500.0
2011-04-13	BIB	ETF	8.7812	9.0344	8.7812	9.0175	127296.0
2011-04-13	BICK	ETF	34.14	34.35	33.82	34.01	18737.0
2011-04-13	BIL	ETF	91.72	91.74	91.7	91.72	79200.0
2011-04-13	BIS	ETF	6585.6	6636.8	6585.6	6595.2	4.155
2011-04-13	BITS	ETF	24.92	25.52	24.92	25.2	225.0
2011-04-13	BIV	ETF	81.8	82.13	81.75	82.04	121900.0
2011-04-13	BJK	ETF	32.66	33.09	32.66	32.92	14700.0
2011-04-13	BKF	ETF	51.16	51.319	50.3529	50.47	89716.0
2011-04-13	BKLN	ETF	25.3	25.31	25.26	25.31	240700.0
2011-04-13	BLV	ETF	77.43	78.1	77.43	78.1	19600.0
2011-04-13	BMVP	ETF	15.54	15.58	15.4733	15.5733	4848.0
2011-04-13	BND	ETF	79.86	80.09	79.84	80.06	514500.0
2011-04-13	BNO	ETF	40.485	40.8	40.035	40.675	83600.0
2011-04-13	BRF	ETF	58.1	58.14	57.01	57.67	351278.0
2011-04-13	BSCE	ETF	20.8601	20.93	20.86	20.895	601490.0
2011-04-13	BSV	ETF	80.18	80.29	80.15	80.26	702700.0
2011-04-13	BTF	ETF	81.85	81.85	80.99999999999999	81.5	1308.0
2011-04-13	BWX	ETF	30.195	30.22	30.12	30.18	148794.0

> showing 50 of 837 rows — these rows as CSV

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