PREVIEW / etf_daily / 2014-11-04

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-04.parquet
  size:    46 KB
  rows:    1,138

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-11-04	SPY	ETF	201.23	201.6	200.06	201.07	93343000.0
2014-11-04	QQQ	ETF	101.36	101.6244	100.67	101.36	22773298.0
2014-11-04	IWM	ETF	115.9	116.5	115.28	115.82	37347600.0
2014-11-04	DIA	ETF	173.08	173.65	172.46	173.46	6466000.0
2014-11-04	GLD	ETF	112.12	112.71	112.08	112.22	6430100.0
2014-11-04	TLT	ETF	119.42	119.91	119.08	119.33	3664800.0
2014-11-04	AAXJ	ETF	62.5	62.55	62.17	62.53	369200.0
2014-11-04	ACWI	ETF	59.07	59.19	58.77	59.08	1337600.0
2014-11-04	ACWV	ETF	68.74	68.98	68.66	68.97	149900.0
2014-11-04	ACWX	ETF	44.83	44.83	44.5399	44.78	168076.0
2014-11-04	ADRE	ETF	39.181	39.3799	39.076	39.31	8216.0
2014-11-04	AFK	ETF	29.58	29.64	29.2	29.3	15201.0
2014-11-04	AGG	ETF	109.7	109.86	109.67	109.69	2346300.0
2014-11-04	AGQ	ETF	40.29	40.74	40.0	40.44	180700.0
2014-11-04	AGZ	ETF	112.72	112.945	112.63	112.63	5660.0
2014-11-04	AGZD	ETF	24.85	24.86	24.775	24.805	16200.0
2014-11-04	AIA	ETF	47.55	47.65	47.39	47.6424	15128.0
2014-11-04	AIQ	ETF	24.07	25.31	24.07	24.83	12373.0
2014-11-04	AIRR	ETF	19.09	19.09	18.876	18.98	62500.0
2014-11-04	AIVI	ETF	45.42	45.53	45.28	45.46	16400.0
2014-11-04	AMJ	ETF	50.4	50.6	49.3201	49.58	1598929.0
2014-11-04	AMLP	ETF	93.25	93.75	91.45	91.7	725880.0
2014-11-04	AMZA	ETF	238.7	238.7	236.3	238.3	900.0
2014-11-04	ANGL	ETF	27.62	27.8	27.48	27.72	20600.0
2014-11-04	AOA	ETF	46.16	46.27	46.03	46.24	32900.0
2014-11-04	AOK	ETF	32.6	32.65	32.59	32.65	28223.0
2014-11-04	AOM	ETF	35.24	35.24	35.126	35.17	30575.0
2014-11-04	AOR	ETF	40.02	40.02	39.86	39.98	55096.0
2014-11-04	ARGT	ETF	21.04	21.06	20.76	20.84	16800.0
2014-11-04	ARKG	ETF	19.94	20.05	19.94	20.05	1900.0
2014-11-04	ARKK	ETF	20.2	20.27	20.2	20.26	7900.0
2014-11-04	ARKQ	ETF	19.98	19.98	19.84	19.862	1100.0
2014-11-04	ARKW	ETF	20.29	20.4	20.29	20.4	800.0
2014-11-04	ASEA	ETF	16.63	16.71	16.63	16.67	40400.0
2014-11-04	ASHR	ETF	26.6	26.61	26.45	26.55	1067100.0
2014-11-04	ASHS	ETF	34.28	34.28	34.13	34.15	7200.0
2014-11-04	ATMP	ETF	31.49	31.49	30.67	30.84	20300.0
2014-11-04	AVIV	ETF	33.67	34.08	33.44	33.7	1107180.0
2014-11-04	AWAY	ETF	34.94	34.94	33.74	33.75	2294319.0
2014-11-04	BAB	ETF	29.87	29.93	29.78	29.78	107475.0
2014-11-04	BAL	ETF	42.71	42.825	41.9799	42.17	11991.0
2014-11-04	BALT	ETF	3.88	4.03	3.68	3.95	1256506.0
2014-11-04	BAR	ETF	2.6968	2.72	2.684	2.684	23700.0
2014-11-04	BBH	ETF	115.7	116.11	114.58	115.11	139900.0
2014-11-04	BCHP	ETF	18.26	18.26	18.22	18.2427	8087.0
2014-11-04	BFOR	ETF	7.8325	7.8375	7.765	7.8025	290800.0
2014-11-04	BIB	ETF	59.74	60.415	58.605	59.305	540792.0
2014-11-04	BICK	ETF	24.92	24.92	24.92	24.92	241.0
2014-11-04	BIL	ETF	91.48	91.5	91.48	91.5	322350.0
2014-11-04	BIS	ETF	411.2	413.6	401.204	408.4	13862.0

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

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