PREVIEW / etf_daily / 2016-04-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-20.parquet
  size:    51 KB
  rows:    1,276

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-20	SPY	ETF	209.95	210.92	209.39	210.1	81100300.0
2016-04-20	QQQ	ETF	110.54	111.15	110.17	110.64	18078307.0
2016-04-20	IWM	ETF	113.39	114.21	112.97	113.56	21422500.0
2016-04-20	DIA	ETF	180.0	181.42	180.0	180.75	2628900.0
2016-04-20	GLD	ETF	119.67	120.08	118.72	118.97	10233200.0
2016-04-20	TLT	ETF	131.16	131.65	129.27	129.46	10920700.0
2016-04-20	AADR	ETF	39.3	39.53	39.3	39.53	300.0
2016-04-20	AAXJ	ETF	55.42	55.82	55.27	55.55	396300.0
2016-04-20	ACTX	ETF	4.72	4.779	4.13	4.13	1886.0
2016-04-20	ACWF	ETF	23.61	23.71	23.6099	23.677	11229.0
2016-04-20	ACWI	ETF	57.76	58.06	57.63	57.8	1370700.0
2016-04-20	ACWV	ETF	74.94	74.99	74.6	74.61	175200.0
2016-04-20	ACWX	ETF	41.14	41.4	41.07	41.2	418543.0
2016-04-20	ADRE	ETF	31.88	32.2263	31.8201	32.12	6089.0
2016-04-20	AFK	ETF	20.22	20.45	19.95	20.36	81406.0
2016-04-20	AFTY	ETF	12.85	12.875	12.79	12.79	31800.0
2016-04-20	AGG	ETF	111.02	111.03	110.6	110.66	2376000.0
2016-04-20	AGGY	ETF	50.88	50.88	50.763	50.778	3400.0
2016-04-20	AGQ	ETF	40.06	40.62	39.55	39.76	515500.0
2016-04-20	AGZ	ETF	114.61	114.744	114.4	114.4	13402.0
2016-04-20	AGZD	ETF	23.98	24.065	23.81	24.065	5600.0
2016-04-20	AIA	ETF	44.02	44.28	43.96	44.1	11467.0
2016-04-20	AIQ	ETF	7.064	7.391	6.93	6.98	18072.0
2016-04-20	AIRR	ETF	18.06	18.118	18.06	18.118	2600.0
2016-04-20	AIVI	ETF	39.88	40.14	39.82	39.89	12000.0
2016-04-20	ALTY	ETF	14.89	14.89	14.618	14.66	2600.0
2016-04-20	AMJ	ETF	28.54	29.77	28.54	29.52	2459266.0
2016-04-20	AMLP	ETF	59.1	61.0	58.8	60.45	2862520.0
2016-04-20	AMZA	ETF	97.5	102.4	97.5	101.5	6850.0
2016-04-20	ANGL	ETF	26.8	26.91	26.68	26.88	188100.0
2016-04-20	AOA	ETF	46.41	46.47	46.19	46.28	28400.0
2016-04-20	AOK	ETF	32.7	32.7	32.58	32.61	48595.0
2016-04-20	AOM	ETF	35.25	35.25	35.1101	35.16	98198.0
2016-04-20	AOR	ETF	40.19	40.19	40.0057	40.09	95518.0
2016-04-20	ARGT	ETF	21.09	21.32	21.05	21.16	86200.0
2016-04-20	ARKG	ETF	18.195	18.33	18.15	18.33	10100.0
2016-04-20	ARKK	ETF	19.27	19.565	19.27	19.565	700.0
2016-04-20	ARKQ	ETF	19.25	19.25	19.25	19.25	300.0
2016-04-20	ARKW	ETF	21.042	21.11	21.042	21.11	400.0
2016-04-20	ASEA	ETF	13.83	13.83	13.83	13.83	500.0
2016-04-20	ASET	ETF	26.2501	26.2501	26.2501	26.2501	605.0
2016-04-20	ASHR	ETF	24.25	24.33	24.02	24.19	2318700.0
2016-04-20	ASHS	ETF	33.88	33.97	33.66	33.79	56000.0
2016-04-20	ATMP	ETF	19.85	20.34	19.85	20.19	45900.0
2016-04-20	BAB	ETF	30.23	30.26	30.0645	30.09	145825.0
2016-04-20	BAL	ETF	41.77	42.93	41.75	42.42	12514.0
2016-04-20	BBC	ETF	21.04	21.074	20.5299	20.6985	9248.0
2016-04-20	BBH	ETF	110.58	111.2	110.11	110.59	33800.0
2016-04-20	BBP	ETF	26.923	26.923	26.538	26.739	2000.0
2016-04-20	BCM	ETF	25.738	25.738	25.738	25.738	122.0

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

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