PREVIEW / etf_daily / 2011-10-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-20.parquet
  size:    37 KB
  rows:    882

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-10-20	SPY	ETF	121.43	122.1	119.82	121.66	262075600.0
2011-10-20	QQQ	ETF	56.81	56.92	55.79	56.59	80378270.0
2011-10-20	IWM	ETF	69.56	69.73	67.75	69.62	90998600.0
2011-10-20	DIA	ETF	115.07	115.77	113.84	115.33	7944500.0
2011-10-20	GLD	ETF	157.62	158.42	156.05	157.77	17367500.0
2011-10-20	TLT	ETF	114.46	115.67	114.07	114.34	7832100.0
2011-10-20	AADR	ETF	27.21	27.21	27.21	27.21	200.0
2011-10-20	AAXJ	ETF	50.38	50.4	49.32	50.02	1180300.0
2011-10-20	ACTV	ETF	14.43	14.48	13.85	14.27	126218.0
2011-10-20	ACWI	ETF	42.06	42.23	41.49	42.07	229800.0
2011-10-20	ACWV	ETF	49.99	52.0	49.84	52.0	5000.0
2011-10-20	ACWX	ETF	37.39	37.49	36.85	37.37	78445.0
2011-10-20	ADRE	ETF	37.82	38.03	37.15	37.57	47094.0
2011-10-20	AFK	ETF	27.35	27.35	26.85	27.08	19612.0
2011-10-20	AGEM	ETF	20.94	20.9541	20.62	20.9	3621.0
2011-10-20	AGG	ETF	109.38	109.63	109.21	109.35	860800.0
2011-10-20	AGQ	ETF	217.88	226.4	206.16	214.88	549275.0
2011-10-20	AGZ	ETF	112.21	112.278	108.46	112.18	17775.0
2011-10-20	AIA	ETF	38.75	38.85	38.126	38.77	51347.0
2011-10-20	AIQ	ETF	5.65	5.7	5.4	5.65	28172.0
2011-10-20	AIS	ETF	2.21	2.23	2.17	2.19	366603.0
2011-10-20	AIVI	ETF	41.33	41.33	40.51	41.16	44600.0
2011-10-20	AMJ	ETF	36.08	36.39	35.89	36.32	1197353.0
2011-10-20	AMLP	ETF	79.4	79.4	78.55	79.2	105140.0
2011-10-20	AOA	ETF	32.13	32.22	31.71	32.22	4300.0
2011-10-20	AOK	ETF	28.98	29.03	28.91	29.0	16167.0
2011-10-20	AOM	ETF	29.53	29.57	29.409	29.56	34170.0
2011-10-20	AOR	ETF	30.44	30.59	30.28	30.55	5713.0
2011-10-20	ARB	ETF	36.73	36.86	35.34	36.6	74388.0
2011-10-20	ARGT	ETF	20.82	20.82	20.82	20.82	850.0
2011-10-20	ASEA	ETF	14.58	14.58	14.33	14.44	3200.0
2011-10-20	AWAY	ETF	35.84	37.82	35.09	36.03	45238.0
2011-10-20	BAB	ETF	27.63	27.85	27.611	27.7332	106545.0
2011-10-20	BAL	ETF	61.5	61.5	59.71	60.21	126474.0
2011-10-20	BALT	ETF	5.48	5.68	5.47	5.54	170299.0
2011-10-20	BBH	ETF	34.2033	34.46	33.8	34.1867	9600.0
2011-10-20	BCM	ETF	42.7001	42.8399	42.7	42.7899	705.0
2011-10-20	BIB	ETF	7.3712	7.3875	7.3563	7.3875	8680.0
2011-10-20	BICK	ETF	23.9	23.93	23.5299	23.8	4275.0
2011-10-20	BIL	ETF	91.68	91.7	91.68	91.7	1126100.0
2011-10-20	BIS	ETF	6702.4	6702.4	6502.4	6502.4	5.0
2011-10-20	BITS	ETF	22.0	23.52	21.28	23.12	4226.0
2011-10-20	BIV	ETF	86.75	87.1	86.62	86.85	316500.0
2011-10-20	BJK	ETF	30.31	30.31	29.34	29.77	43000.0
2011-10-20	BKF	ETF	36.4	36.44	35.49	36.11	86271.0
2011-10-20	BKLN	ETF	23.49	23.54	23.4	23.52	63400.0
2011-10-20	BLNG	ETF	49.51	49.55	49.51	49.55	400.0
2011-10-20	BLV	ETF	89.59	90.2	89.5	89.5	33400.0
2011-10-20	BMVP	ETF	13.14	13.23	13.01	13.23	2980.0
2011-10-20	BND	ETF	83.23	83.41	83.12	83.23	1844200.0

> showing 50 of 882 rows — these rows as CSV

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