PREVIEW / etf_daily / 2015-04-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-14.parquet
  size:    47 KB
  rows:    1,170

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
2015-04-14	SPY	ETF	208.85	209.71	208.1	209.49	75099900.0
2015-04-14	QQQ	ETF	107.37	107.68	106.56	107.17	23755747.0
2015-04-14	IWM	ETF	125.74	126.08	124.78	125.67	22600800.0
2015-04-14	DIA	ETF	179.58	180.54	178.8	180.18	4811400.0
2015-04-14	GLD	ETF	114.69	115.07	114.39	114.44	3651500.0
2015-04-14	TLT	ETF	131.31	131.86	130.48	130.72	6075500.0
2015-04-14	AADR	ETF	40.3	40.31	40.3	40.31	800.0
2015-04-14	AAXJ	ETF	68.23	68.44	67.99	68.28	1363600.0
2015-04-14	ACWI	ETF	61.57	61.79	61.48	61.76	2956400.0
2015-04-14	ACWV	ETF	73.08	73.23	72.88	73.15	117300.0
2015-04-14	ACWX	ETF	46.51	46.61	46.43	46.58	343321.0
2015-04-14	ADRE	ETF	36.86	37.0149	36.56	36.91	3859.0
2015-04-14	AFK	ETF	26.24	26.3894	26.18	26.29	12884.0
2015-04-14	AFTY	ETF	21.31	21.41	21.23	21.31	375100.0
2015-04-14	AGG	ETF	111.7	111.79	111.49	111.49	1157400.0
2015-04-14	AGQ	ETF	39.6	40.21	39.36	39.4	122600.0
2015-04-14	AGZ	ETF	114.11	114.52	114.11	114.16	12055.0
2015-04-14	AGZD	ETF	24.45	24.57	24.45	24.555	7600.0
2015-04-14	AIA	ETF	53.37	53.59	53.1401	53.514	23792.0
2015-04-14	AIQ	ETF	24.3	24.4	23.18	23.78	10757.0
2015-04-14	AIRR	ETF	19.118	19.118	18.96	19.09	14300.0
2015-04-14	AIVI	ETF	45.18	45.28	45.02	45.24	29700.0
2015-04-14	ALTL	ETF	37.73	37.73	37.66	37.66	688.0
2015-04-14	AMJ	ETF	43.76	44.21	43.55	44.04	1274834.0
2015-04-14	AMLP	ETF	83.8	84.6	83.7	84.3	551780.0
2015-04-14	AMZA	ETF	214.5	218.0	214.5	217.4	590.0
2015-04-14	ANGL	ETF	27.52	27.53	27.4	27.52	5800.0
2015-04-14	AOA	ETF	48.19	48.39	48.19	48.35	38400.0
2015-04-14	AOK	ETF	33.23	33.3093	33.2	33.2	45944.0
2015-04-14	AOM	ETF	35.91	36.06	35.91	35.92	58438.0
2015-04-14	AOR	ETF	41.36	41.4686	41.32	41.4	34070.0
2015-04-14	ARGT	ETF	22.07	22.07	21.93	21.97	5600.0
2015-04-14	ARKG	ETF	23.36	23.438	23.36	23.42	4000.0
2015-04-14	ARKK	ETF	21.42	21.42	21.39	21.39	800.0
2015-04-14	ARKQ	ETF	20.46	20.46	20.46	20.46	200.0
2015-04-14	ARKW	ETF	22.92	22.92	22.33	22.33	3400.0
2015-04-14	ASEA	ETF	15.94	16.04	15.94	16.03	8000.0
2015-04-14	ASHR	ETF	45.33	45.38	45.1	45.35	1294800.0
2015-04-14	ASHS	ETF	53.62	54.08	53.58	53.95	63200.0
2015-04-14	ATMP	ETF	29.83	30.01	29.75	29.94	18400.0
2015-04-14	AWAY	ETF	32.21	32.49	31.87	32.18	1391664.0
2015-04-14	BAB	ETF	30.5	30.66	30.36	30.56	98963.0
2015-04-14	BAL	ETF	44.39	44.39	44.0001	44.1032	4018.0
2015-04-14	BALT	ETF	1.4	1.44	1.32	1.36	1563815.0
2015-04-14	BAR	ETF	2.741	2.741	2.7185	2.72	8190.0
2015-04-14	BBC	ETF	34.85	34.85	33.9303	34.41	24678.0
2015-04-14	BBH	ETF	133.64	134.0	132.0	132.91	82000.0
2015-04-14	BBP	ETF	33.32	33.32	32.89	32.99	32400.0
2015-04-14	BCHP	ETF	19.818	19.818	19.818	19.818	192.0
2015-04-14	BCM	ETF	31.0372	31.0372	31.01	31.01	3803.0

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

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