PREVIEW / etf_daily / 2013-01-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-14.parquet
  size:    39 KB
  rows:    966

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-01-14	SPY	ETF	146.89	147.07	146.43	146.97	89567200.0
2013-01-14	QQQ	ETF	66.9	67.15	66.67	66.96	36777292.0
2013-01-14	IWM	ETF	87.16	87.52	87.05	87.39	24351900.0
2013-01-14	DIA	ETF	134.66	135.0	134.4	134.89	4298000.0
2013-01-14	GLD	ETF	161.88	161.97	161.13	161.54	7289000.0
2013-01-14	TLT	ETF	120.04	120.28	119.37	119.52	3064600.0
2013-01-14	AADR	ETF	32.0	32.32	32.0	32.32	1000.0
2013-01-14	AAXJ	ETF	61.07	61.07	60.66	60.95	279000.0
2013-01-14	ACTV	ETF	5.75	6.3	5.67	6.16	1178700.0
2013-01-14	ACWI	ETF	49.31	49.32	49.12	49.28	474000.0
2013-01-14	ACWV	ETF	57.0	57.1	56.86	56.89	372900.0
2013-01-14	ACWX	ETF	42.81	42.81	42.62	42.79	265849.0
2013-01-14	ADRE	ETF	41.27	41.46	41.18	41.32	48498.0
2013-01-14	AFK	ETF	31.34	31.41	31.19	31.25	20121.0
2013-01-14	AGEM	ETF	23.7291	23.75	23.7291	23.75	936.0
2013-01-14	AGG	ETF	110.94	111.01	110.87	110.95	870200.0
2013-01-14	AGQ	ETF	184.0	184.84	180.16	183.68	333000.0
2013-01-14	AGZ	ETF	113.43	113.577	113.27	113.27	11032.0
2013-01-14	AIA	ETF	48.34	48.34	48.08	48.181	42599.0
2013-01-14	AIQ	ETF	6.69	6.73	6.6	6.6	14892.0
2013-01-14	AIVI	ETF	42.73	42.88	42.66	42.84	22900.0
2013-01-14	ALTL	ETF	26.94	26.94	26.93	26.93	1074.0
2013-01-14	AMJ	ETF	41.4	41.56	41.28	41.32	891647.0
2013-01-14	AMLP	ETF	83.7	83.85	83.5	83.65	540140.0
2013-01-14	ANGL	ETF	27.5	27.5	27.19	27.19	7300.0
2013-01-14	AOA	ETF	38.08	38.13	38.0	38.09	34600.0
2013-01-14	AOK	ETF	30.78	30.82	30.77	30.78	73760.0
2013-01-14	AOM	ETF	32.06	32.0983	32.03	32.03	55357.0
2013-01-14	AOR	ETF	34.52	34.52	34.459	34.5194	28173.0
2013-01-14	ARB	ETF	46.82	46.85	46.77	46.8	290876.0
2013-01-14	ARGT	ETF	18.26	18.36	18.06	18.2	2000.0
2013-01-14	ASEA	ETF	16.96	16.96	16.79	16.88	58200.0
2013-01-14	AWAY	ETF	22.18	22.35	21.35	22.11	608445.0
2013-01-14	BAB	ETF	30.22	30.23	30.08	30.11	101152.0
2013-01-14	BAL	ETF	49.53	49.55	49.04	49.28	13970.0
2013-01-14	BALT	ETF	3.36	3.36	3.21	3.29	53640.0
2013-01-14	BBH	ETF	56.95	56.95	56.61	56.84	117200.0
2013-01-14	BCM	ETF	44.12	44.23	44.104	44.23	2392.0
2013-01-14	BIB	ETF	16.075	16.37	16.075	16.265	29780.0
2013-01-14	BICK	ETF	25.84	25.8601	25.84	25.8601	776.0
2013-01-14	BIL	ETF	91.62	91.62	91.6	91.6	87250.0
2013-01-14	BIS	ETF	2427.6	2427.6	2294.0	2342.0	83.0
2013-01-14	BIV	ETF	88.14	88.15	87.94	88.03	189600.0
2013-01-14	BJK	ETF	37.78	37.84	37.65	37.69	160400.0
2013-01-14	BKF	ETF	41.78	41.83	41.59	41.7	146288.0
2013-01-14	BKLN	ETF	25.21	25.22	25.2	25.22	786600.0
2013-01-14	BLV	ETF	93.25	93.55	93.0	93.17	249500.0
2013-01-14	BMVP	ETF	16.94	16.968	16.8333	16.95	16050.0
2013-01-14	BND	ETF	83.86	83.93	83.83	83.83	893900.0
2013-01-14	BNO	ETF	41.08	41.395	40.815	41.32	76600.0

> showing 50 of 966 rows — these rows as CSV

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