PREVIEW / etf_daily / 2014-09-26

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-26.parquet
  size:    45 KB
  rows:    1,124

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
2014-09-26	SPY	ETF	196.7	198.39	196.42	197.9	103547000.0
2014-09-26	QQQ	ETF	98.05	98.96	97.89	98.78	56109106.0
2014-09-26	IWM	ETF	110.55	111.22	110.2	111.12	26473300.0
2014-09-26	DIA	ETF	169.79	171.13	169.5	170.7	6062200.0
2014-09-26	GLD	ETF	117.02	117.1	116.58	117.06	4185200.0
2014-09-26	TLT	ETF	116.02	116.29	115.62	116.0	7799600.0
2014-09-26	AADR	ETF	37.59	37.6	37.5	37.6	3300.0
2014-09-26	AAXJ	ETF	62.5	62.71	62.39	62.57	271500.0
2014-09-26	ACWI	ETF	59.07	59.54	59.04	59.39	550600.0
2014-09-26	ACWV	ETF	66.64	67.09	66.63	66.93	13700.0
2014-09-26	ACWX	ETF	45.85	46.13	45.8387	46.03	158583.0
2014-09-26	ADRE	ETF	40.02	40.6032	40.02	40.46	192394.0
2014-09-26	AFK	ETF	31.42	31.5111	31.2301	31.33	19827.0
2014-09-26	AGG	ETF	109.06	109.09	108.88	109.06	1729500.0
2014-09-26	AGQ	ETF	48.83	49.31	48.5	49.31	139200.0
2014-09-26	AGZ	ETF	112.53	112.53	112.05	112.22	34419.0
2014-09-26	AGZD	ETF	24.89	24.915	24.86	24.865	8600.0
2014-09-26	AIA	ETF	47.6	47.818	47.53	47.79	35870.0
2014-09-26	AIQ	ETF	24.7	24.85	23.75	23.99	39012.0
2014-09-26	AIRR	ETF	18.68	18.68	18.58	18.67	15100.0
2014-09-26	AIVI	ETF	47.09	47.3	47.02	47.19	17700.0
2014-09-26	ALTL	ETF	35.34	35.4	35.34	35.4	698.0
2014-09-26	AMJ	ETF	51.96	52.69	51.585	52.59	1026002.0
2014-09-26	AMLP	ETF	94.45	95.2	93.7	95.05	548660.0
2014-09-26	ANGL	ETF	27.75	27.77	27.64	27.65	1700.0
2014-09-26	AOA	ETF	45.7	45.96	45.67	45.93	29300.0
2014-09-26	AOK	ETF	32.4	32.55	32.4	32.54	34693.0
2014-09-26	AOM	ETF	34.95	35.08	34.94	35.05	50519.0
2014-09-26	AOR	ETF	39.5491	39.7	39.5	39.67	17526.0
2014-09-26	ARGT	ETF	21.19	21.48	21.18	21.44	21500.0
2014-09-26	ASEA	ETF	16.93	16.93	16.86	16.86	2500.0
2014-09-26	ASHR	ETF	25.61	25.78	25.54	25.61	582200.0
2014-09-26	ASHS	ETF	33.28	34.9	33.28	34.9	26200.0
2014-09-26	ATMP	ETF	31.77	32.14	31.49	32.12	82100.0
2014-09-26	AVIV	ETF	26.79	27.01	26.63	26.84	157511.0
2014-09-26	AWAY	ETF	33.18	33.9	32.96	33.66	988717.0
2014-09-26	BAB	ETF	29.59	29.6899	29.4	29.58	230860.0
2014-09-26	BAL	ETF	41.5	41.5	41.0	41.35	4778.0
2014-09-26	BALT	ETF	4.22	4.36	4.2	4.23	564745.0
2014-09-26	BAR	ETF	3.1	3.1	3.076	3.089	15670.0
2014-09-26	BBH	ETF	106.84	107.25	105.8	107.07	56500.0
2014-09-26	BCM	ETF	37.0285	37.0592	37.0215	37.0592	523.0
2014-09-26	BFOR	ETF	7.5225	7.6475	7.515	7.6375	42400.0
2014-09-26	BIB	ETF	52.5	53.1799	51.9	53.09	398090.0
2014-09-26	BICK	ETF	25.53	25.67	25.44	25.67	1110.0
2014-09-26	BIL	ETF	91.5	91.52	91.5	91.52	54750.0
2014-09-26	BIS	ETF	481.2	484.0	470.8	471.6	7810.5
2014-09-26	BIV	ETF	84.02	84.13	83.93	84.12	487800.0
2014-09-26	BIZD	ETF	19.84	19.84	19.74	19.83	30100.0
2014-09-26	BJK	ETF	43.74	44.2	43.74	44.15	16000.0

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

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