PREVIEW / etf_daily / 2014-11-07

all etf daily files

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

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-07	SPY	ETF	203.17	203.6	202.61	203.34	89540000.0
2014-11-07	QQQ	ETF	101.87	101.91	101.07	101.6	20931734.0
2014-11-07	IWM	ETF	116.39	116.71	115.7	116.71	28657700.0
2014-11-07	DIA	ETF	175.24	175.6	174.77	175.58	4018100.0
2014-11-07	GLD	ETF	110.78	113.15	110.73	112.97	10916500.0
2014-11-07	TLT	ETF	118.72	119.75	118.68	119.75	8550500.0
2014-11-07	AADR	ETF	37.39	37.39	37.3	37.35	3100.0
2014-11-07	AAXJ	ETF	61.87	62.1	61.76	62.07	1004400.0
2014-11-07	ACWI	ETF	59.26	59.4	59.09	59.4	744300.0
2014-11-07	ACWV	ETF	68.91	69.01	68.77	69.01	66100.0
2014-11-07	ACWX	ETF	44.39	44.6499	44.38	44.64	318304.0
2014-11-07	ADRE	ETF	38.56	38.8299	38.36	38.72	4893.0
2014-11-07	AFK	ETF	28.69	29.1419	28.69	29.14	5267.0
2014-11-07	AGG	ETF	109.61	109.92	109.6	109.91	1661400.0
2014-11-07	AGQ	ETF	38.06	39.16	37.95	38.97	322300.0
2014-11-07	AGZ	ETF	112.8	113.1	112.66	112.92	11386.0
2014-11-07	AGZD	ETF	24.82	24.84	24.755	24.84	8600.0
2014-11-07	AIA	ETF	47.28	47.417	47.22	47.35	16133.0
2014-11-07	AIQ	ETF	24.18	24.18	21.82	22.7	33669.0
2014-11-07	AIRR	ETF	19.21	19.22	19.08	19.17	10000.0
2014-11-07	AIVI	ETF	45.3	45.54	45.25	45.43	16500.0
2014-11-07	AMJ	ETF	50.11	51.13	50.08	51.05	853969.0
2014-11-07	AMLP	ETF	91.5	92.5	90.8	92.2	605340.0
2014-11-07	AMZA	ETF	244.0	277.7	240.8	243.4	1980.0
2014-11-07	ANGL	ETF	27.79	27.8	27.75	27.8	1400.0
2014-11-07	AOA	ETF	46.35	46.41	46.22	46.39	45600.0
2014-11-07	AOK	ETF	32.68	32.7099	32.65	32.69	82050.0
2014-11-07	AOM	ETF	35.24	35.28	35.16	35.28	28916.0
2014-11-07	AOR	ETF	40.06	40.12	39.9765	40.12	32396.0
2014-11-07	ARGT	ETF	20.7	21.02	20.62	20.91	3300.0
2014-11-07	ARKG	ETF	20.0	20.0	19.57	19.65	1700.0
2014-11-07	ARKK	ETF	20.15	20.15	20.08	20.12	1500.0
2014-11-07	ARKQ	ETF	19.88	19.88	19.732	19.732	900.0
2014-11-07	ARKW	ETF	20.3	20.3	20.17	20.17	500.0
2014-11-07	ASEA	ETF	16.47	16.64	16.47	16.64	7300.0
2014-11-07	ASHR	ETF	26.38	26.4	26.32	26.38	189100.0
2014-11-07	ASHS	ETF	33.84	33.99	33.84	33.98	1700.0
2014-11-07	ATMP	ETF	31.2	31.78	31.2	31.75	115800.0
2014-11-07	AVIV	ETF	33.17	33.51	33.09	33.17	570844.0
2014-11-07	AWAY	ETF	29.68	29.75	28.915	29.21	1579610.0
2014-11-07	BAB	ETF	29.76	29.98	29.76	29.97	108477.0
2014-11-07	BAL	ETF	42.21	43.19	41.952	42.77	6380.0
2014-11-07	BALT	ETF	3.44	3.47	3.23	3.28	1869218.0
2014-11-07	BAR	ETF	2.598	2.73	2.594	2.73	53360.0
2014-11-07	BBH	ETF	115.42	115.42	113.44	114.43	76200.0
2014-11-07	BCHP	ETF	18.39	18.39	18.39	18.39	410.0
2014-11-07	BCM	ETF	35.4992	35.56	35.4992	35.56	985.0
2014-11-07	BFOR	ETF	7.8825	7.8925	7.865	7.8825	65200.0
2014-11-07	BIB	ETF	59.215	59.375	56.625	58.06	578556.0
2014-11-07	BICK	ETF	24.8	24.8	24.7901	24.7901	800.0

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

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