PREVIEW / etf_daily / 2011-08-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-18.parquet
  size:    36 KB
  rows:    873

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-08-18	SPY	ETF	116.5	119.71	113.39	114.51	512956300.0
2011-08-18	QQQ	ETF	52.13	52.14	50.48	50.95	130016464.0
2011-08-18	IWM	ETF	68.06	70.4	65.82	66.45	110692200.0
2011-08-18	DIA	ETF	111.6	111.7	109.01	110.07	18143700.0
2011-08-18	GLD	ETF	177.15	178.1	176.41	177.72	25512800.0
2011-08-18	TLT	ETF	110.09	112.14	109.28	110.31	27274600.0
2011-08-18	AAXJ	ETF	54.35	54.56	53.2	53.72	675600.0
2011-08-18	ACTV	ETF	16.35	16.59	16.01	16.16	253119.0
2011-08-18	ACWI	ETF	41.84	41.92	40.98	41.35	679800.0
2011-08-18	ACWX	ETF	38.53	38.53	37.69	38.13	430203.0
2011-08-18	ADRE	ETF	40.17	40.18	39.17	39.69	92634.0
2011-08-18	AFK	ETF	29.01	29.01	28.5101	28.59	10961.0
2011-08-18	AGEM	ETF	22.45	22.45	21.98	22.0326	6457.0
2011-08-18	AGG	ETF	110.24	110.5	109.9	109.98	954300.0
2011-08-18	AGQ	ETF	440.22	443.12	431.24	438.5	488000.0
2011-08-18	AGZ	ETF	112.96	112.96	112.56	112.67	21838.0
2011-08-18	AIA	ETF	39.98	39.98	38.93	39.18	30976.0
2011-08-18	AIQ	ETF	7.3	7.3	6.35	7.0	54632.0
2011-08-18	AIS	ETF	2.18	2.24	2.06	2.16	954140.0
2011-08-18	AIVI	ETF	40.76	40.79	39.83	40.22	42000.0
2011-08-18	AMJ	ETF	35.33	35.97	34.69	34.89	2202992.0
2011-08-18	AMLP	ETF	76.5	77.05	76.0	76.45	183900.0
2011-08-18	AOA	ETF	31.59	31.59	30.95	31.09	25600.0
2011-08-18	AOK	ETF	29.0	29.0	28.7644	28.79	50346.0
2011-08-18	AOM	ETF	29.59	29.59	29.31	29.31	13882.0
2011-08-18	AOR	ETF	30.29	30.29	29.84	29.97	28121.0
2011-08-18	ARB	ETF	32.97	33.03	31.34	31.73	197653.0
2011-08-18	ARGT	ETF	25.0	25.0	24.6	24.7	2800.0
2011-08-18	ASEA	ETF	16.13	16.13	15.78	15.86	5100.0
2011-08-18	AWAY	ETF	35.9	35.9	33.8	35.13	217077.0
2011-08-18	BAB	ETF	27.65	27.78	27.56	27.71	204318.0
2011-08-18	BAL	ETF	65.86	66.89	64.26	66.51	143626.0
2011-08-18	BALT	ETF	4.28	4.37	4.085	4.16	157004.0
2011-08-18	BBH	ETF	30.9433	31.0333	30.66	30.89	29400.0
2011-08-18	BIB	ETF	6.6238	6.75	6.2962	6.42	104192.0
2011-08-18	BICK	ETF	26.44	26.44	25.8	25.902	8642.0
2011-08-18	BIL	ETF	91.72	91.72	91.68	91.68	525450.0
2011-08-18	BIS	ETF	8048.0	8048.0	7896.0	8020.16	7.2
2011-08-18	BITS	ETF	21.28	21.76	20.28	21.4	13605.0
2011-08-18	BIV	ETF	88.51	88.77	88.05	88.21	215300.0
2011-08-18	BJK	ETF	32.16	32.19	31.6	31.78	22200.0
2011-08-18	BKF	ETF	40.15	40.2	39.16	39.57	382050.0
2011-08-18	BKLN	ETF	23.3	23.46	23.1	23.15	206800.0
2011-08-18	BLNG	ETF	57.23	57.23	57.03	57.03	1540.0
2011-08-18	BLV	ETF	88.85	89.66	88.21	88.57	44400.0
2011-08-18	BMVP	ETF	13.0733	13.0733	12.6228	12.7633	13610.0
2011-08-18	BND	ETF	84.03	84.25	83.89	83.91	2431000.0
2011-08-18	BNO	ETF	36.34	36.4	35.565	35.625	441800.0
2011-08-18	BRF	ETF	47.37	47.56	46.65	47.35	261055.0
2011-08-18	BSCE	ETF	21.07	21.1	21.05	21.05	13620.0

> showing 50 of 873 rows — these rows as CSV

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