PREVIEW / etf_daily / 2011-06-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-21.parquet
  size:    36 KB
  rows:    861

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-06-21	SPY	ETF	128.36	129.7	127.75	129.45	193157300.0
2011-06-21	QQQ	ETF	54.26	55.29	54.03	55.23	55892710.0
2011-06-21	IWM	ETF	79.58	80.77	79.42	80.66	75970200.0
2011-06-21	DIA	ETF	120.98	121.91	120.74	121.59	4744500.0
2011-06-21	GLD	ETF	150.26	150.87	150.18	150.76	12439200.0
2011-06-21	TLT	ETF	96.7	97.03	96.27	96.59	7894900.0
2011-06-21	AADR	ETF	30.51	30.65	30.45	30.65	400.0
2011-06-21	AAXJ	ETF	60.19	60.9	60.11	60.76	867800.0
2011-06-21	ACTV	ETF	18.22	18.43	18.0	18.4	100995.0
2011-06-21	ACWI	ETF	47.28	47.85	47.25	47.74	217400.0
2011-06-21	ACWX	ETF	44.05	44.598	44.05	44.53	61242.0
2011-06-21	ADRE	ETF	44.48	44.99	44.48	44.91	63531.0
2011-06-21	AFK	ETF	31.91	32.25	31.85	32.1783	24080.0
2011-06-21	AGG	ETF	107.25	107.47	107.23	107.45	803600.0
2011-06-21	AGQ	ETF	358.5	367.7	357.7	364.8	555150.0
2011-06-21	AGZ	ETF	110.84	110.87	110.7401	110.84	4523.0
2011-06-21	AIA	ETF	45.51	45.9	45.5	45.78	32001.0
2011-06-21	AIQ	ETF	19.15	19.15	18.4	19.0	25771.0
2011-06-21	AIS	ETF	1.95	2.0	1.94	2.0	764597.0
2011-06-21	AIVI	ETF	46.83	47.29	46.75	47.26	20100.0
2011-06-21	AMJ	ETF	35.77	36.1832	35.64	36.18	774086.0
2011-06-21	AMLP	ETF	78.25	78.85	78.25	78.85	123340.0
2011-06-21	AOA	ETF	35.12	35.43	35.12	35.38	5800.0
2011-06-21	AOK	ETF	29.21	29.29	29.16	29.27	118232.0
2011-06-21	AOM	ETF	30.5701	30.65	30.5701	30.6399	65890.0
2011-06-21	AOR	ETF	32.25	32.47	32.25	32.4434	84444.0
2011-06-21	ARB	ETF	38.72	39.16	38.63	39.08	226036.0
2011-06-21	ARGT	ETF	29.02	29.2	29.02	29.2	100.0
2011-06-21	ASEA	ETF	16.1	16.1	16.1	16.1	400.0
2011-06-21	BAB	ETF	26.53	26.588	26.47	26.54	131279.0
2011-06-21	BAL	ETF	78.39	79.27	76.75	77.1	56590.0
2011-06-21	BALT	ETF	6.13	6.14	6.02	6.1	114364.0
2011-06-21	BBH	ETF	34.8233	34.8233	34.55	34.5733	64200.0
2011-06-21	BCM	ETF	46.82	46.82	46.62	46.67	546.0
2011-06-21	BIB	ETF	8.9537	9.1275	8.9337	9.0625	33760.0
2011-06-21	BICK	ETF	30.31	30.48	30.07	30.4	10205.0
2011-06-21	BIL	ETF	91.72	91.72	91.7	91.7	433350.0
2011-06-21	BIS	ETF	6342.4	6364.8	6305.6	6337.6	37.1
2011-06-21	BITS	ETF	21.28	21.8	21.08	21.36	1050.0
2011-06-21	BIV	ETF	84.85	84.95	84.69	84.78	220800.0
2011-06-21	BJK	ETF	32.4	32.96	32.4	32.83	26800.0
2011-06-21	BKF	ETF	46.24	46.66	46.23	46.57	90691.0
2011-06-21	BKLN	ETF	24.76	24.79	24.7	24.76	1582000.0
2011-06-21	BLNG	ETF	49.125	49.125	49.125	49.125	102.0
2011-06-21	BLV	ETF	81.61	81.73	81.21	81.58	15200.0
2011-06-21	BMVP	ETF	15.2142	15.3033	15.2142	15.2796	5404.0
2011-06-21	BND	ETF	81.64	81.83	81.64	81.75	700300.0
2011-06-21	BNO	ETF	37.24	37.475	36.73	36.825	382600.0
2011-06-21	BRF	ETF	55.75	56.09	55.42	56.02	121827.0
2011-06-21	BSCE	ETF	21.3	21.3	21.13	21.1984	18493.0

> showing 50 of 861 rows — these rows as CSV

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