PREVIEW / etf_daily / 2011-10-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-06.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-10-06	SPY	ETF	114.36	116.66	113.51	116.49	257800800.0
2011-10-06	QQQ	ETF	53.47	54.44	53.21	54.43	71939102.0
2011-10-06	IWM	ETF	65.51	67.31	65.15	67.14	85789700.0
2011-10-06	DIA	ETF	109.3	111.21	108.47	111.09	8534300.0
2011-10-06	GLD	ETF	160.02	161.11	158.77	160.49	12389500.0
2011-10-06	TLT	ETF	120.64	121.01	119.12	119.12	9681600.0
2011-10-06	AAXJ	ETF	47.18	48.3	46.97	48.22	211900.0
2011-10-06	ACTV	ETF	15.61	15.85	15.27	15.62	47537.0
2011-10-06	ACWI	ETF	39.58	40.5	39.3	40.44	845600.0
2011-10-06	ACWX	ETF	35.22	36.19	35.15	36.19	69696.0
2011-10-06	ADRE	ETF	36.37	37.27	36.29	37.26	40035.0
2011-10-06	AFK	ETF	25.83	26.4	25.65	26.4	25870.0
2011-10-06	AGEM	ETF	19.97	20.2775	19.97	20.2775	17822.0
2011-10-06	AGG	ETF	109.62	109.73	109.39	109.45	1022500.0
2011-10-06	AGQ	ETF	220.66	241.08	218.74	238.54	1245700.0
2011-10-06	AGZ	ETF	112.7204	112.7204	112.33	112.34	29590.0
2011-10-06	AIA	ETF	36.95	37.46	36.65	37.46	61968.0
2011-10-06	AIQ	ETF	6.0	6.1	5.7	5.9	87270.0
2011-10-06	AIS	ETF	2.27	2.29	2.19	2.22	641890.0
2011-10-06	AIVI	ETF	38.73	39.86	38.59	39.86	91000.0
2011-10-06	AMJ	ETF	33.7	34.36	33.28	34.29	848852.0
2011-10-06	AMLP	ETF	76.05	76.75	74.85	76.5	139800.0
2011-10-06	AOA	ETF	30.46	31.06	30.42	31.06	6100.0
2011-10-06	AOK	ETF	28.64	28.734	28.61	28.734	49969.0
2011-10-06	AOM	ETF	28.88	29.155	28.85	29.155	12628.0
2011-10-06	AOR	ETF	29.53	29.91	29.53	29.91	91829.0
2011-10-06	ARB	ETF	36.25	36.77	36.053	36.55	204272.0
2011-10-06	ASEA	ETF	13.87	13.99	13.83	13.98	8300.0
2011-10-06	AWAY	ETF	34.96	36.0	34.52	35.3	45799.0
2011-10-06	BAB	ETF	28.81	28.87	28.62	28.69	165586.0
2011-10-06	BAL	ETF	63.48	63.93	62.98	63.7	19392.0
2011-10-06	BALT	ETF	4.82	4.919	4.75	4.86	54523.0
2011-10-06	BBH	ETF	32.92	33.5567	32.92	33.5567	23100.0
2011-10-06	BCM	ETF	42.15	42.15	42.15	42.15	200.0
2011-10-06	BIB	ETF	7.1513	7.4	7.125	7.3925	21704.0
2011-10-06	BICK	ETF	21.9	22.63	21.9	22.62	13359.0
2011-10-06	BIL	ETF	91.7	91.7	91.68	91.68	353400.0
2011-10-06	BIS	ETF	6816.0	6873.6	6542.72	6542.72	11.1
2011-10-06	BITS	ETF	21.36	22.72	21.24	21.24	4693.0
2011-10-06	BIV	ETF	87.14	87.22	86.89	86.89	587700.0
2011-10-06	BJK	ETF	28.11	29.09	28.11	29.09	12200.0
2011-10-06	BKF	ETF	34.03	35.0	33.93	34.98	89876.0
2011-10-06	BKLN	ETF	22.63	22.93	22.63	22.85	75000.0
2011-10-06	BLV	ETF	91.45	91.66	90.63	90.69	131000.0
2011-10-06	BMVP	ETF	12.4036	12.6867	12.4036	12.6867	5846.0
2011-10-06	BND	ETF	83.35	83.39	83.21	83.26	1159300.0
2011-10-06	BNO	ETF	34.525	35.745	34.38	35.73	146000.0
2011-10-06	BOIL	ETF	3853450.0	3919000.0	3833000.0	3905000.0	0.05
2011-10-06	BRF	ETF	39.75	41.12	39.75	40.92	666410.0
2011-10-06	BSCE	ETF	20.68	20.72	20.68	20.71	9979.0

> showing 50 of 873 rows — these rows as CSV

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