PREVIEW / etf_daily / 2011-11-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-01.parquet
  size:    37 KB
  rows:    891

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-11-01	SPY	ETF	122.03	123.51	121.52	122.0	416565800.0
2011-11-01	QQQ	ETF	56.56	57.9064	56.12	56.44	99932826.0
2011-11-01	IWM	ETF	71.18	72.97	70.96	71.39	110064900.0
2011-11-01	DIA	ETF	116.9	117.67	116.03	116.38	15120600.0
2011-11-01	GLD	ETF	164.03	167.41	163.61	167.38	15335400.0
2011-11-01	TLT	ETF	118.71	119.49	117.17	119.45	24400600.0
2011-11-01	AADR	ETF	28.25	28.25	28.21	28.21	1900.0
2011-11-01	AAXJ	ETF	52.31	53.26	52.0	52.8	509600.0
2011-11-01	ACTV	ETF	12.96	13.15	12.6	12.76	258691.0
2011-11-01	ACWI	ETF	41.99	42.75	41.4	42.23	856500.0
2011-11-01	ACWV	ETF	50.34	54.12	49.98	49.98	53100.0
2011-11-01	ACWX	ETF	37.47	38.1175	37.31	37.66	156223.0
2011-11-01	ADRE	ETF	39.34	40.32	39.17	39.91	69630.0
2011-11-01	AFK	ETF	27.8	28.104	27.5665	27.98	18122.0
2011-11-01	AGEM	ETF	21.74	22.15	21.74	22.15	5640.0
2011-11-01	AGG	ETF	109.9	110.29	109.85	110.27	1443700.0
2011-11-01	AGQ	ETF	241.96	257.96	238.88	251.76	890325.0
2011-11-01	AGZ	ETF	112.29	112.8	112.29	112.61	81133.0
2011-11-01	AIA	ETF	40.73	41.17	40.19	40.95	52230.0
2011-11-01	AIQ	ETF	5.8	5.95	5.45	5.7	93315.0
2011-11-01	AIS	ETF	2.22	2.26	2.2	2.2	681535.0
2011-11-01	AIVI	ETF	40.17	40.78	40.0	40.33	87000.0
2011-11-01	AMJ	ETF	36.99	37.67	36.6	36.84	748406.0
2011-11-01	AMLP	ETF	80.2	80.5	79.7	80.15	210320.0
2011-11-01	AOA	ETF	32.48	32.83	32.46	32.83	7900.0
2011-11-01	AOK	ETF	29.22	29.3	29.22	29.28	29713.0
2011-11-01	AOM	ETF	29.71	29.9125	29.71	29.86	94429.0
2011-11-01	AOR	ETF	30.76	31.42	30.76	30.88	47146.0
2011-11-01	ARB	ETF	37.72	39.43	37.22	38.67	176804.0
2011-11-01	ARGT	ETF	20.66	21.28	20.66	21.28	650.0
2011-11-01	ASEA	ETF	14.87	14.95	14.8	14.81	7900.0
2011-11-01	AWAY	ETF	32.09	34.82	32.09	34.34	209961.0
2011-11-01	BAB	ETF	28.6	28.81	28.4	28.81	141148.0
2011-11-01	BAL	ETF	62.05	62.77	61.09	61.31	46496.0
2011-11-01	BALT	ETF	5.44	5.58	5.38	5.43	78137.0
2011-11-01	BBH	ETF	35.0933	35.1467	34.5833	34.8833	34500.0
2011-11-01	BCM	ETF	44.1346	44.1346	44.1346	44.1346	5000.0
2011-11-01	BIB	ETF	7.3262	7.5637	7.3262	7.425	27600.0
2011-11-01	BICK	ETF	25.57	25.63	25.313	25.519	8080.0
2011-11-01	BIL	ETF	91.7	91.7	91.68	91.7	1423150.0
2011-11-01	BIS	ETF	6315.2	6428.8	6313.6	6404.8	5.6
2011-11-01	BITS	ETF	22.84	23.8	22.572	23.4	875.0
2011-11-01	BIV	ETF	87.76	87.95	87.51	87.89	241400.0
2011-11-01	BJK	ETF	31.21	32.23	31.21	31.88	3200.0
2011-11-01	BKF	ETF	38.21	39.52	37.97	39.21	1316142.0
2011-11-01	BKLN	ETF	24.0	24.0	23.68	23.86	99400.0
2011-11-01	BLNG	ETF	51.57	51.57	51.57	51.57	200.0
2011-11-01	BLV	ETF	92.22	92.44	91.08	92.27	77400.0
2011-11-01	BMVP	ETF	13.4267	13.6	13.37	13.4299	5928.0
2011-11-01	BND	ETF	83.8	84.04	83.62	84.03	2003400.0

> showing 50 of 891 rows — these rows as CSV

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