PREVIEW / etf_daily / 2016-04-18

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-18.parquet
  size:    50 KB
  rows:    1,260

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-04-18	SPY	ETF	207.78	209.28	207.0	209.24	82531000.0
2016-04-18	QQQ	ETF	110.33	111.265	110.25	111.23	17126086.0
2016-04-18	IWM	ETF	111.98	113.39	111.87	113.3	19428300.0
2016-04-18	DIA	ETF	178.13	179.83	178.1	179.78	2573700.0
2016-04-18	GLD	ETF	118.53	118.56	117.63	117.74	5809800.0
2016-04-18	TLT	ETF	131.33	131.44	130.66	131.31	4486600.0
2016-04-18	AADR	ETF	38.52	39.05	38.37	39.05	5200.0
2016-04-18	AAXJ	ETF	54.98	55.57	54.98	55.46	401300.0
2016-04-18	ACTX	ETF	4.425	5.31	4.13	4.13	1882.0
2016-04-18	ACWI	ETF	56.76	57.32	56.69	57.31	1177600.0
2016-04-18	ACWV	ETF	74.13	74.69	74.13	74.63	130800.0
2016-04-18	ACWX	ETF	40.18	40.59	40.09	40.56	418891.0
2016-04-18	ADRE	ETF	31.66	31.8535	31.45	31.76	9770.0
2016-04-18	AFK	ETF	19.54	19.72	19.5	19.61	48038.0
2016-04-18	AFTY	ETF	12.95	13.04	12.94	12.96	25700.0
2016-04-18	AGG	ETF	110.91	110.95	110.79	110.94	2146600.0
2016-04-18	AGGY	ETF	50.81	50.82	50.783	50.82	4100.0
2016-04-18	AGQ	ETF	36.52	36.66	36.12	36.19	152100.0
2016-04-18	AGZ	ETF	114.65	114.76	114.6401	114.76	10383.0
2016-04-18	AGZD	ETF	23.78	23.94	23.78	23.875	12200.0
2016-04-18	AIA	ETF	43.79	44.14	43.76	44.1	9467.0
2016-04-18	AIQ	ETF	6.95	7.02	6.92	7.0	10809.0
2016-04-18	AIRR	ETF	17.949	17.949	17.949	17.949	200.0
2016-04-18	AIVI	ETF	38.84	39.28	38.84	39.2	10700.0
2016-04-18	ALTY	ETF	14.5	14.56	14.5	14.559	500.0
2016-04-18	AMJ	ETF	26.38	28.05	26.32	27.94	1404877.0
2016-04-18	AMLP	ETF	53.95	57.35	53.5	57.05	2527620.0
2016-04-18	AMZA	ETF	89.0	94.0	87.7	93.4	5250.0
2016-04-18	ANGL	ETF	26.37	26.48	26.3	26.46	64500.0
2016-04-18	AOA	ETF	45.57	45.98	45.57	45.98	42800.0
2016-04-18	AOK	ETF	32.36	32.55	32.36	32.54	486534.0
2016-04-18	AOM	ETF	34.93	35.04	34.8501	35.04	140083.0
2016-04-18	AOR	ETF	39.65	39.85	39.645	39.85	69787.0
2016-04-18	ARGT	ETF	20.23	20.45	20.07	20.37	52000.0
2016-04-18	ARKG	ETF	18.55	18.86	18.55	18.86	1200.0
2016-04-18	ARKK	ETF	19.835	19.838	19.816	19.816	5000.0
2016-04-18	ARKQ	ETF	19.35	19.48	19.34	19.43	19400.0
2016-04-18	ARKW	ETF	21.161	21.161	21.161	21.161	300.0
2016-04-18	ASEA	ETF	13.52	13.64	13.48	13.64	7200.0
2016-04-18	ASHR	ETF	24.61	24.87	24.54	24.8	1362900.0
2016-04-18	ASHS	ETF	35.56	35.77	35.43	35.61	56800.0
2016-04-18	ASHX	ETF	21.89	21.9018	21.89	21.8901	1100.0
2016-04-18	ATMP	ETF	18.32	19.1	18.16	18.99	298700.0
2016-04-18	BAB	ETF	30.14	30.36	30.12	30.28	139820.0
2016-04-18	BAL	ETF	40.9173	41.1799	40.8101	41.15	10467.0
2016-04-18	BBC	ETF	21.13	21.41	21.13	21.21	10466.0
2016-04-18	BBH	ETF	110.51	112.82	110.4	112.18	77600.0
2016-04-18	BBP	ETF	26.92	27.19	26.92	27.02	2700.0
2016-04-18	BCM	ETF	24.97	24.97	24.97	24.97	253.0
2016-04-18	BFOR	ETF	7.615	7.6975	7.615	7.6825	46400.0

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

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