PREVIEW / etf_daily / 2011-11-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-07.parquet
  size:    37 KB
  rows:    878

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-07	SPY	ETF	125.39	126.39	124.2	126.26	196617200.0
2011-11-07	QQQ	ETF	57.75	58.25	57.17	58.21	65541094.0
2011-11-07	IWM	ETF	74.5	74.87	72.9	74.45	67136100.0
2011-11-07	DIA	ETF	119.52	120.5	118.55	120.45	8694400.0
2011-11-07	GLD	ETF	172.85	175.0	172.71	174.98	20131900.0
2011-11-07	TLT	ETF	116.64	118.35	116.32	117.22	9279700.0
2011-11-07	AADR	ETF	28.63	28.63	28.63	28.63	200.0
2011-11-07	AAXJ	ETF	54.39	54.76	53.91	54.75	238400.0
2011-11-07	ACTV	ETF	13.27	13.38	12.86	13.04	222723.0
2011-11-07	ACWI	ETF	43.44	43.76	43.17	43.76	165300.0
2011-11-07	ACWV	ETF	50.8	51.02	50.8	51.02	1900.0
2011-11-07	ACWX	ETF	38.72	39.0	38.45	38.95	94431.0
2011-11-07	ADRE	ETF	41.33	41.73	41.252	41.72	35504.0
2011-11-07	AFK	ETF	28.82	29.02	28.716	28.92	11642.0
2011-11-07	AGEM	ETF	23.01	23.17	22.91	22.91	2563.0
2011-11-07	AGG	ETF	109.99	110.34	109.97	110.09	745300.0
2011-11-07	AGQ	ETF	271.84	278.4	271.04	278.08	432750.0
2011-11-07	AGZ	ETF	112.7	112.74	112.27	112.44	37386.0
2011-11-07	AIA	ETF	42.14	42.44	41.8265	42.3754	18798.0
2011-11-07	AIQ	ETF	5.95	6.15	5.75	6.15	9835.0
2011-11-07	AIS	ETF	2.3	2.38	2.25	2.32	483518.0
2011-11-07	AIVI	ETF	41.43	41.66	41.04	41.65	46400.0
2011-11-07	AMJ	ETF	37.59	37.84	37.16	37.44	473613.0
2011-11-07	AMLP	ETF	80.1	80.1	78.75	79.35	312340.0
2011-11-07	AOA	ETF	33.52	33.63	33.16	33.63	16200.0
2011-11-07	AOK	ETF	29.37	29.47	29.37	29.47	25953.0
2011-11-07	AOM	ETF	30.15	30.219	30.0612	30.17	17672.0
2011-11-07	AOR	ETF	31.44	31.52	31.3115	31.52	25808.0
2011-11-07	ARB	ETF	41.78	42.55	41.3907	42.15	135743.0
2011-11-07	ARGT	ETF	23.24	23.24	23.06	23.06	450.0
2011-11-07	ASEA	ETF	15.21	15.31	15.11	15.3	7200.0
2011-11-07	AWAY	ETF	34.06	34.43	33.09	33.55	91966.0
2011-11-07	BAB	ETF	28.27	28.5885	28.19	28.46	144117.0
2011-11-07	BAL	ETF	60.74	60.85	59.6	59.9899	73793.0
2011-11-07	BALT	ETF	5.75	5.8692	5.38	5.45	130603.0
2011-11-07	BBH	ETF	35.3333	35.5833	35.0867	35.5533	37200.0
2011-11-07	BCM	ETF	45.32	45.32	45.32	45.32	248.0
2011-11-07	BIB	ETF	7.39	7.4437	7.1925	7.3788	21520.0
2011-11-07	BICK	ETF	26.3	26.389	26.125	26.3	5869.0
2011-11-07	BIL	ETF	91.68	91.7	91.68	91.7	197600.0
2011-11-07	BIS	ETF	6534.4	6534.4	6534.4	6534.4	1.25
2011-11-07	BITS	ETF	22.68	22.68	21.96	22.2	1000.0
2011-11-07	BIV	ETF	87.82	88.15	87.7	87.93	104800.0
2011-11-07	BJK	ETF	32.9	33.08	32.41	32.84	17100.0
2011-11-07	BKF	ETF	40.55	41.1	40.41	41.01	106914.0
2011-11-07	BKLN	ETF	24.09	24.16	24.05	24.12	27100.0
2011-11-07	BLNG	ETF	55.0	55.0	54.88	54.88	300.0
2011-11-07	BLV	ETF	91.4	92.37	91.07	91.7	30200.0
2011-11-07	BMVP	ETF	13.953	14.005	13.803	14.005	4753.0
2011-11-07	BND	ETF	83.81	84.11	83.77	83.91	2067200.0

> showing 50 of 878 rows — these rows as CSV

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