PREVIEW / etf_daily / 2011-09-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-26.parquet
  size:    37 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-09-26	SPY	ETF	114.61	116.4	112.98	116.24	260673700.0
2011-09-26	QQQ	ETF	54.42	54.88	53.21	54.78	96260950.0
2011-09-26	IWM	ETF	65.84	66.48	64.28	66.37	75555800.0
2011-09-26	DIA	ETF	108.41	110.33	107.48	110.24	11476000.0
2011-09-26	GLD	ETF	157.12	158.8	154.19	157.58	42373800.0
2011-09-26	TLT	ETF	120.12	120.57	118.58	118.89	15110100.0
2011-09-26	AADR	ETF	26.01	26.18	26.01	26.18	1400.0
2011-09-26	AAXJ	ETF	47.07	48.05	46.56	48.05	458600.0
2011-09-26	ACTV	ETF	14.6	15.33	14.16	15.18	61483.0
2011-09-26	ACWI	ETF	39.39	40.05	38.89	40.02	437300.0
2011-09-26	ACWX	ETF	34.97	35.46	34.41	35.44	134861.0
2011-09-26	ADRE	ETF	36.2	36.87	35.5	36.8329	64070.0
2011-09-26	AFK	ETF	26.14	26.65	25.831	26.65	21690.0
2011-09-26	AGEM	ETF	19.92	20.36	19.83	20.36	20225.0
2011-09-26	AGG	ETF	110.14	110.28	109.91	109.98	1158800.0
2011-09-26	AGQ	ETF	195.52	229.84	193.5	226.72	2084600.0
2011-09-26	AGZ	ETF	113.07	113.15	112.617	112.7	13890.0
2011-09-26	AIA	ETF	36.62	37.46	36.3	37.44	27497.0
2011-09-26	AIQ	ETF	6.15	6.35	5.9	6.25	14141.0
2011-09-26	AIS	ETF	2.26	2.44	2.21	2.4	852329.0
2011-09-26	AIVI	ETF	37.81	38.48	37.24	38.48	658900.0
2011-09-26	AMJ	ETF	34.39	34.76	33.8935	34.3	766657.0
2011-09-26	AMLP	ETF	76.8	77.6	75.6	76.45	99360.0
2011-09-26	AOA	ETF	30.75	30.99	30.26	30.99	23600.0
2011-09-26	AOK	ETF	28.77	28.79	28.6644	28.79	27915.0
2011-09-26	AOM	ETF	29.14	29.24	28.986	29.24	14412.0
2011-09-26	AOR	ETF	29.81	29.95	29.451	29.9	11295.0
2011-09-26	ARB	ETF	35.21	36.17	34.13	36.07	110459.0
2011-09-26	ARGT	ETF	20.4	20.52	20.32	20.52	5250.0
2011-09-26	ASEA	ETF	13.58	13.78	13.46	13.78	4900.0
2011-09-26	AWAY	ETF	34.21	35.69	33.665	35.59	115374.0
2011-09-26	BAB	ETF	28.71	28.8	28.62	28.78	398577.0
2011-09-26	BAL	ETF	62.71	62.83	61.46	61.68	161666.0
2011-09-26	BALT	ETF	4.79	4.95	4.69	4.91	98824.0
2011-09-26	BBH	ETF	32.4767	33.0167	32.3	32.9267	16500.0
2011-09-26	BCM	ETF	42.55	42.55	42.55	42.55	330.0
2011-09-26	BIB	ETF	7.3525	7.3587	6.9287	7.3487	16872.0
2011-09-26	BICK	ETF	22.24	22.5	21.84	22.5	17764.0
2011-09-26	BIL	ETF	91.7	91.7	91.68	91.7	497400.0
2011-09-26	BIS	ETF	6734.4	6734.4	6734.4	6734.4	2.475
2011-09-26	BITS	ETF	22.2	22.28	21.16	21.4	900.0
2011-09-26	BIV	ETF	88.05	88.06	87.72	87.81	220300.0
2011-09-26	BJK	ETF	28.91	29.72	28.77	29.72	64400.0
2011-09-26	BKF	ETF	34.61	35.22	34.11	35.17	227976.0
2011-09-26	BKLN	ETF	23.15	23.27	23.15	23.18	29500.0
2011-09-26	BLNG	ETF	49.01	49.41	48.46	49.41	1810.0
2011-09-26	BLV	ETF	91.87	92.15	90.93	91.06	42100.0
2011-09-26	BMVP	ETF	12.5	12.727	12.39	12.7267	2143.0
2011-09-26	BND	ETF	83.96	84.07	83.75	83.79	986600.0
2011-09-26	BNO	ETF	35.015	35.335	34.675	35.3	94200.0

> showing 50 of 873 rows — these rows as CSV

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