PREVIEW / etf_daily / 2013-03-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-15.parquet
  size:    40 KB
  rows:    973

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-15	SPY	ETF	155.85	156.04	155.31	155.83	138601100.0
2013-03-15	QQQ	ETF	68.75	68.79	68.34	68.51	30743672.0
2013-03-15	IWM	ETF	94.65	94.96	94.39	94.75	35361700.0
2013-03-15	DIA	ETF	144.82	144.89	144.39	144.82	10835400.0
2013-03-15	GLD	ETF	154.12	154.72	153.97	154.0	5701300.0
2013-03-15	TLT	ETF	115.33	115.88	115.3	115.76	9673400.0
2013-03-15	AAXJ	ETF	59.0	59.03	58.75	58.9	154000.0
2013-03-15	ACTV	ETF	4.7	4.72	4.47	4.63	617921.0
2013-03-15	ACWI	ETF	51.05	51.11	50.88	51.01	425800.0
2013-03-15	ACWV	ETF	60.68	60.71	60.5	60.62	354100.0
2013-03-15	ACWX	ETF	43.35	43.48	43.29	43.39	149475.0
2013-03-15	ADRE	ETF	39.2	39.2	38.909	38.95	18641.0
2013-03-15	AFK	ETF	30.61	30.67	30.438	30.492	16461.0
2013-03-15	AGEM	ETF	22.81	22.81	22.682	22.682	541.0
2013-03-15	AGG	ETF	110.07	110.25	110.07	110.21	661500.0
2013-03-15	AGQ	ETF	156.48	158.52	155.12	155.36	207750.0
2013-03-15	AGZ	ETF	113.03	113.123	112.921	113.0999	8799.0
2013-03-15	AIA	ETF	46.15	46.22	45.974	46.02	21299.0
2013-03-15	AIQ	ETF	6.9	7.17	6.9	7.006	47265.0
2013-03-15	AIVI	ETF	43.0	43.08	42.83	42.96	36000.0
2013-03-15	ALTL	ETF	29.04	29.04	29.04	29.04	300.0
2013-03-15	AMJ	ETF	43.46	43.4788	43.22	43.28	1819738.0
2013-03-15	AMLP	ETF	85.7	85.75	85.4	85.75	666300.0
2013-03-15	AOA	ETF	39.85	39.85	39.69	39.77	38400.0
2013-03-15	AOK	ETF	31.13	31.17	31.13	31.154	12421.0
2013-03-15	AOM	ETF	32.77	32.79	32.73	32.78	23132.0
2013-03-15	AOR	ETF	35.67	35.67	35.57	35.62	37414.0
2013-03-15	ARB	ETF	46.94	47.01	46.87	46.98	289238.0
2013-03-15	ARGT	ETF	17.9	17.96	17.84	17.88	4000.0
2013-03-15	ASEA	ETF	17.2	17.29	17.16	17.27	8100.0
2013-03-15	ATMP	ETF	24.89	24.89	24.85	24.85	1100.0
2013-03-15	AWAY	ETF	30.4	30.58	30.145	30.33	933089.0
2013-03-15	BAB	ETF	30.03	30.09	29.9806	30.09	247964.0
2013-03-15	BAL	ETF	60.36	60.53	59.7001	59.87	30819.0
2013-03-15	BALT	ETF	3.904	3.94	3.78	3.9	174293.0
2013-03-15	BBH	ETF	63.36	63.36	62.56	62.68	22100.0
2013-03-15	BCM	ETF	43.78	43.78	43.14	43.164	1759.0
2013-03-15	BIB	ETF	18.8625	18.8625	18.53	18.5657	49764.0
2013-03-15	BICK	ETF	24.64	24.64	24.5301	24.5301	2322.0
2013-03-15	BIL	ETF	91.6	91.62	91.6	91.62	176800.0
2013-03-15	BIS	ETF	2001.6	2016.0	2000.4	2016.0	57.5
2013-03-15	BIV	ETF	87.1	87.36	87.1	87.33	180000.0
2013-03-15	BIZD	ETF	21.17	21.17	20.8	20.86	10200.0
2013-03-15	BJK	ETF	38.65	38.83	38.65	38.75	2600.0
2013-03-15	BKF	ETF	39.74	39.81	39.624	39.77	115719.0
2013-03-15	BKLN	ETF	25.06	25.07	25.04	25.06	4630900.0
2013-03-15	BLV	ETF	90.44	90.63	90.38	90.51	59900.0
2013-03-15	BMVP	ETF	18.34	18.37	18.32	18.33	3594.0
2013-03-15	BND	ETF	83.11	83.25	83.11	83.21	894000.0
2013-03-15	BNO	ETF	41.68	41.75	41.53	41.64	68000.0

> showing 50 of 973 rows — these rows as CSV

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