PREVIEW / etf_daily / 2013-07-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-25.parquet
  size:    41 KB
  rows:    1,012

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-07-25	SPY	ETF	168.22	169.08	167.94	168.93	111088600.0
2013-07-25	QQQ	ETF	74.89	75.06	74.46	74.97	23167338.0
2013-07-25	IWM	ETF	103.47	104.65	103.33	104.54	46093900.0
2013-07-25	DIA	ETF	154.54	155.25	154.2	155.12	5483500.0
2013-07-25	GLD	ETF	127.7	128.87	127.64	128.67	4702400.0
2013-07-25	TLT	ETF	106.97	107.6	106.81	107.48	6443400.0
2013-07-25	AADR	ETF	33.8	33.8	33.75	33.75	1400.0
2013-07-25	AAXJ	ETF	56.69	56.99	56.5	56.99	288600.0
2013-07-25	ACTV	ETF	8.68	8.8	8.57	8.74	727835.0
2013-07-25	ACWI	ETF	52.48	52.79	52.33	52.75	1203000.0
2013-07-25	ACWV	ETF	61.52	62.07	61.52	62.07	22600.0
2013-07-25	ACWX	ETF	42.91	43.25	42.83	43.24	657812.0
2013-07-25	ADRE	ETF	35.69	35.87	35.59	35.86	37768.0
2013-07-25	AFK	ETF	28.85	29.18	28.72	29.1599	37665.0
2013-07-25	AGG	ETF	107.02	107.3	106.95	107.29	917100.0
2013-07-25	AGQ	ETF	71.2	72.24	71.2	71.84	194600.0
2013-07-25	AGZ	ETF	110.8	111.05	110.7801	111.02	14258.0
2013-07-25	AIA	ETF	44.18	44.5	44.13	44.5	5965.0
2013-07-25	AIQ	ETF	18.78	19.035	18.77	18.98	46440.0
2013-07-25	AIVI	ETF	42.45	42.95	42.45	42.95	15000.0
2013-07-25	ALTL	ETF	29.7873	29.7873	29.7873	29.7873	150.0
2013-07-25	AMJ	ETF	47.15	47.44	47.0	47.13	386521.0
2013-07-25	AMLP	ETF	89.7	90.0	89.55	89.55	423600.0
2013-07-25	ANGL	ETF	27.0	27.6	26.83	26.83	3800.0
2013-07-25	AOA	ETF	41.3	41.49	41.22	41.49	12700.0
2013-07-25	AOK	ETF	31.1	31.21	31.1	31.1836	24600.0
2013-07-25	AOM	ETF	32.97	33.08	32.91	33.08	19958.0
2013-07-25	AOR	ETF	36.38	36.52	36.36	36.52	42928.0
2013-07-25	ARB	ETF	46.43	46.43	45.026	46.04	930962.0
2013-07-25	ARGT	ETF	17.48	17.48	17.48	17.48	1000.0
2013-07-25	ASEA	ETF	17.22	17.26	17.15	17.26	7200.0
2013-07-25	ATMP	ETF	26.64	26.74	26.64	26.69	10000.0
2013-07-25	AVIV	ETF	25.58	26.15	25.3745	25.87	81167.0
2013-07-25	AWAY	ETF	31.74	33.74	31.5	33.42	2869458.0
2013-07-25	BAB	ETF	27.76	27.76	27.64	27.74	231985.0
2013-07-25	BAL	ETF	54.6699	55.25	54.6699	55.09	4874.0
2013-07-25	BALT	ETF	3.87	3.95	3.78	3.93	103887.0
2013-07-25	BBH	ETF	77.94	78.56	76.82	78.56	63900.0
2013-07-25	BFOR	ETF	6.55	6.575	6.5275	6.575	58000.0
2013-07-25	BIB	ETF	28.225	28.7425	27.2625	28.7425	124568.0
2013-07-25	BICK	ETF	22.01	22.11	21.97	22.11	1703.0
2013-07-25	BIL	ETF	91.6	91.62	91.58	91.58	149550.0
2013-07-25	BIS	ETF	1216.8	1254.0	1194.0	1194.0	397.0
2013-07-25	BIV	ETF	83.45	83.71	83.4	83.67	286900.0
2013-07-25	BIZD	ETF	20.44	20.51	20.41	20.51	2000.0
2013-07-25	BJK	ETF	42.08	42.08	41.63	42.07	16300.0
2013-07-25	BKF	ETF	35.25	35.58	35.24	35.57	39497.0
2013-07-25	BKLN	ETF	24.94	24.97	24.93	24.97	3179300.0
2013-07-25	BLV	ETF	84.06	84.41	83.99	84.35	40100.0
2013-07-25	BMVP	ETF	19.6785	19.8033	19.6743	19.8033	2550.0

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

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