PREVIEW / etf_daily / 2013-03-07

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-07.parquet
  size:    40 KB
  rows:    970

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
2013-03-07	SPY	ETF	154.7	154.98	154.52	154.78	86101400.0
2013-03-07	QQQ	ETF	68.57	68.8	68.45	68.69	21775877.0
2013-03-07	IWM	ETF	92.48	92.94	92.32	92.87	27907700.0
2013-03-07	DIA	ETF	142.98	143.39	142.9	143.14	3689100.0
2013-03-07	GLD	ETF	153.02	153.21	152.4	152.69	6586700.0
2013-03-07	TLT	ETF	116.41	116.51	115.91	115.96	8526700.0
2013-03-07	AADR	ETF	33.41	33.41	32.97	33.13	1500.0
2013-03-07	AAXJ	ETF	60.29	60.4	60.2	60.39	620200.0
2013-03-07	ACTV	ETF	4.63	4.69	4.5336	4.66	426606.0
2013-03-07	ACWI	ETF	50.72	50.77	50.64	50.73	356300.0
2013-03-07	ACWV	ETF	60.35	60.35	60.14	60.26	16300.0
2013-03-07	ACWX	ETF	43.19	43.24	43.14	43.21	114629.0
2013-03-07	ADRE	ETF	39.8	40.05	39.65	39.88	87542.0
2013-03-07	AFK	ETF	30.47	30.6099	30.36	30.52	18099.0
2013-03-07	AGEM	ETF	22.8857	23.13	22.8857	22.9575	1307.0
2013-03-07	AGG	ETF	110.26	110.26	109.97	110.14	1047000.0
2013-03-07	AGQ	ETF	158.48	158.96	155.68	156.92	241875.0
2013-03-07	AGZ	ETF	113.18	113.19	113.03	113.079	21674.0
2013-03-07	AIA	ETF	47.25	47.3765	47.18	47.35	8837.0
2013-03-07	AIQ	ETF	7.0	7.0399	7.0	7.02	3072.0
2013-03-07	AIVI	ETF	42.48	42.66	42.48	42.64	33900.0
2013-03-07	AMJ	ETF	43.1	43.38	42.79	43.3	1083226.0
2013-03-07	AMLP	ETF	85.45	85.55	84.8	85.5	497460.0
2013-03-07	ANGL	ETF	26.83	26.83	26.8	26.8	1600.0
2013-03-07	AOA	ETF	39.61	39.61	39.35	39.41	37400.0
2013-03-07	AOK	ETF	30.97	31.0799	30.97	31.07	25510.0
2013-03-07	AOM	ETF	32.72	32.72	32.57	32.62	52533.0
2013-03-07	AOR	ETF	35.55	35.55	35.36	35.42	69801.0
2013-03-07	ARB	ETF	46.9	47.02	46.88	47.02	916671.0
2013-03-07	ARGT	ETF	17.42	17.5	17.42	17.44	1000.0
2013-03-07	ASEA	ETF	17.45	17.56	17.45	17.51	31600.0
2013-03-07	AWAY	ETF	30.62	31.0	30.4301	30.67	817726.0
2013-03-07	BAB	ETF	30.29	30.3199	30.21	30.2301	168844.0
2013-03-07	BAL	ETF	55.92	56.2	55.68	55.7475	48793.0
2013-03-07	BALT	ETF	3.85	3.92	3.75	3.83	46833.0
2013-03-07	BBH	ETF	62.13	62.13	61.65	62.05	26100.0
2013-03-07	BCM	ETF	42.9	42.9	42.838	42.838	844.0
2013-03-07	BIB	ETF	18.4825	18.4825	18.12	18.3275	59040.0
2013-03-07	BICK	ETF	25.38	25.439	25.3225	25.439	7936.0
2013-03-07	BIL	ETF	91.6	91.62	91.6	91.62	58250.0
2013-03-07	BIS	ETF	2070.396	2072.712	2059.2	2059.2	8.75
2013-03-07	BIV	ETF	87.53	87.56	87.35	87.42	410200.0
2013-03-07	BIZD	ETF	20.58	20.62	20.54	20.62	800.0
2013-03-07	BJK	ETF	38.47	38.56	38.34	38.56	1700.0
2013-03-07	BKF	ETF	40.36	40.6	40.35	40.57	77775.0
2013-03-07	BKLN	ETF	25.03	25.06	25.02	25.06	2457000.0
2013-03-07	BLV	ETF	91.29	91.41	90.9	90.97	42900.0
2013-03-07	BMVP	ETF	18.07	18.093	18.05	18.0767	10932.0
2013-03-07	BND	ETF	83.36	83.38	83.26	83.29	764800.0
2013-03-07	BNO	ETF	41.545	41.855	41.53	41.725	62400.0

> showing 50 of 970 rows — these rows as CSV

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