PREVIEW / etf_daily / 2013-08-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-12.parquet
  size:    41 KB
  rows:    1,009

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-08-12	SPY	ETF	168.46	169.31	168.38	169.11	68593300.0
2013-08-12	QQQ	ETF	76.2	76.8099	76.19	76.67	20515862.0
2013-08-12	IWM	ETF	103.33	104.63	103.33	104.59	18960800.0
2013-08-12	DIA	ETF	153.45	154.3	153.35	154.03	3697300.0
2013-08-12	GLD	ETF	129.57	129.71	128.88	129.13	7414300.0
2013-08-12	TLT	ETF	107.61	107.63	106.47	106.53	7562800.0
2013-08-12	AADR	ETF	34.09	34.1	34.09	34.1	600.0
2013-08-12	AAXJ	ETF	56.08	56.4	55.92	56.33	353900.0
2013-08-12	ACTV	ETF	9.64	10.05	9.03	9.9	677779.0
2013-08-12	ACWI	ETF	52.79	52.98	52.68	52.94	1201400.0
2013-08-12	ACWV	ETF	61.99	62.11	61.85	61.96	25800.0
2013-08-12	ACWX	ETF	43.27	43.49	43.27	43.43	473652.0
2013-08-12	ADRE	ETF	36.11	36.33	35.93	35.94	14177.0
2013-08-12	AFK	ETF	29.9	29.97	29.73	29.84	43266.0
2013-08-12	AGEM	ETF	21.66	21.73	21.58	21.58	2694.0
2013-08-12	AGG	ETF	107.27	107.27	107.0	107.08	713400.0
2013-08-12	AGQ	ETF	79.08	80.56	78.84	79.84	580175.0
2013-08-12	AGZ	ETF	111.28	111.28	111.131	111.21	8511.0
2013-08-12	AIA	ETF	43.95	44.22	43.95	44.22	29808.0
2013-08-12	AIQ	ETF	23.62	25.06	23.62	24.99	278925.0
2013-08-12	AIVI	ETF	43.12	43.35	43.12	43.29	22500.0
2013-08-12	AMJ	ETF	47.04	47.37	46.49	46.55	355747.0
2013-08-12	AMLP	ETF	89.7	89.7	87.35	87.4	506100.0
2013-08-12	ANGL	ETF	26.35	26.45	26.35	26.4	2000.0
2013-08-12	AOA	ETF	41.47	41.64	41.47	41.58	19600.0
2013-08-12	AOK	ETF	31.2	31.2465	31.2	31.2005	10476.0
2013-08-12	AOM	ETF	33.04	33.1584	33.04	33.09	15141.0
2013-08-12	AOR	ETF	36.48	36.6437	36.48	36.56	44960.0
2013-08-12	ARB	ETF	46.15	46.27	46.13	46.26	81076.0
2013-08-12	ARGT	ETF	18.42	18.64	18.39	18.64	1400.0
2013-08-12	ASEA	ETF	17.06	17.07	17.0	17.02	11500.0
2013-08-12	ATMP	ETF	26.58	26.61	26.33	26.33	10100.0
2013-08-12	AVIV	ETF	24.23	24.9	24.17	24.76	53432.0
2013-08-12	AWAY	ETF	30.35	30.76	30.09	30.58	751874.0
2013-08-12	BAB	ETF	27.73	27.8142	27.71	27.78	286073.0
2013-08-12	BAL	ETF	56.35	57.91	56.34	57.91	25633.0
2013-08-12	BALT	ETF	3.85	3.95	3.7	3.87	82291.0
2013-08-12	BBH	ETF	77.9	77.9	77.14	77.49	118700.0
2013-08-12	BFOR	ETF	6.63	6.6725	6.615	6.6725	213600.0
2013-08-12	BIB	ETF	28.1225	28.192	27.7786	28.0625	168356.0
2013-08-12	BICK	ETF	22.12	22.1905	22.11	22.11	1848.0
2013-08-12	BIL	ETF	91.6	91.6	91.58	91.6	118550.0
2013-08-12	BIS	ETF	1214.76	1225.2	1210.04	1216.76	61.0
2013-08-12	BIV	ETF	83.63	83.65	83.42	83.45	185300.0
2013-08-12	BIZD	ETF	20.26	20.31	20.14	20.21	9600.0
2013-08-12	BJK	ETF	42.9	42.94	42.8	42.9	3100.0
2013-08-12	BKF	ETF	35.38	35.67	35.33	35.44	69011.0
2013-08-12	BKLN	ETF	24.9	24.9	24.89	24.9	2129300.0
2013-08-12	BLV	ETF	83.97	84.02	83.53	83.53	25400.0
2013-08-12	BMVP	ETF	20.01	20.1	20.01	20.0967	3545.0

> showing 50 of 1,009 rows — these rows as CSV

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