PREVIEW / etf_daily / 2016-07-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-14.parquet
  size:    52 KB
  rows:    1,288

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
2016-07-14	SPY	ETF	216.4	216.67	215.66	216.12	91230900.0
2016-07-14	QQQ	ETF	111.96	112.19	111.7	111.98	20870986.0
2016-07-14	IWM	ETF	120.3	120.36	119.3	119.37	19345400.0
2016-07-14	DIA	ETF	185.06	185.27	184.57	184.96	3354700.0
2016-07-14	GLD	ETF	126.31	127.37	126.03	127.33	12132400.0
2016-07-14	TLT	ETF	139.28	139.84	139.09	139.59	10817000.0
2016-07-14	AADR	ETF	39.91	39.91	39.89	39.89	500.0
2016-07-14	AAXJ	ETF	56.68	56.95	56.58	56.8	557100.0
2016-07-14	ACTX	ETF	3.835	3.835	3.835	3.835	1.0
2016-07-14	ACWI	ETF	57.9	58.02	57.81	57.83	5097200.0
2016-07-14	ACWV	ETF	77.87	77.89	77.61	77.77	103300.0
2016-07-14	ACWX	ETF	40.16	40.26	40.09	40.17	521375.0
2016-07-14	ADRE	ETF	32.55	32.6899	32.4801	32.58	5974.0
2016-07-14	AFK	ETF	20.65	21.12	20.0201	20.75	6217.0
2016-07-14	AFTY	ETF	13.1	13.13	13.07	13.081	7000.0
2016-07-14	AGG	ETF	112.51	112.7	112.5	112.67	3345200.0
2016-07-14	AGGY	ETF	52.04	52.15	52.04	52.15	6900.0
2016-07-14	AGQ	ETF	54.25	55.22	53.97	54.94	320300.0
2016-07-14	AGZ	ETF	115.28	115.79	114.98	115.48	35568.0
2016-07-14	AGZD	ETF	23.92	24.04	23.865	23.875	3600.0
2016-07-14	AIA	ETF	46.34	46.45	46.3201	46.38	21617.0
2016-07-14	AIQ	ETF	6.1	6.16	6.08	6.1	7634.0
2016-07-14	AIRR	ETF	19.38	19.49	19.36	19.36	3900.0
2016-07-14	AIVI	ETF	38.96	38.97	38.76	38.89	29100.0
2016-07-14	ALTY	ETF	15.32	15.32	15.32	15.32	100.0
2016-07-14	AMJ	ETF	32.23	32.41	31.99	32.24	1342907.0
2016-07-14	AMLP	ETF	64.75	64.75	64.1	64.5	1568540.0
2016-07-14	AMZA	ETF	113.0	115.0	111.8	112.9	7140.0
2016-07-14	ANGL	ETF	28.19	28.22	28.11	28.17	177100.0
2016-07-14	AOA	ETF	46.62	46.75	46.51	46.65	29200.0
2016-07-14	AOK	ETF	33.16	33.24	33.1	33.17	39211.0
2016-07-14	AOM	ETF	35.68	35.69	35.603	35.67	57001.0
2016-07-14	AOR	ETF	40.49	40.5699	40.45	40.5	80734.0
2016-07-14	ARGT	ETF	23.08	23.1	22.99	23.08	35100.0
2016-07-14	ARKG	ETF	17.71	17.74	17.71	17.74	500.0
2016-07-14	ARKK	ETF	20.285	20.285	20.285	20.285	100.0
2016-07-14	ARKQ	ETF	20.33	20.33	20.3	20.3	2200.0
2016-07-14	ARKW	ETF	23.29	23.53	23.29	23.53	900.0
2016-07-14	ASEA	ETF	13.98	14.09	13.98	14.09	4100.0
2016-07-14	ASHR	ETF	24.75	24.76	24.69	24.72	855600.0
2016-07-14	ASHS	ETF	35.55	35.63	35.5	35.61	8700.0
2016-07-14	ATMP	ETF	22.67	22.86	22.61	22.84	21900.0
2016-07-14	BAB	ETF	31.61	31.62	31.5583	31.61	563110.0
2016-07-14	BAL	ETF	48.93	49.7745	48.92	49.38	11495.0
2016-07-14	BBC	ETF	19.01	19.01	18.431	18.52	10129.0
2016-07-14	BBH	ETF	107.99	107.99	106.95	107.45	53300.0
2016-07-14	BBP	ETF	27.89	28.116	27.87	28.04	9500.0
2016-07-14	BCM	ETF	27.06	27.14	26.9801	27.025	19940.0
2016-07-14	BFIT	ETF	15.78	15.78	15.78	15.78	100.0
2016-07-14	BFOR	ETF	7.9275	7.96	7.9275	7.9375	60000.0

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

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