PREVIEW / etf_daily / 2016-08-24

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-24.parquet
  size:    51 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-08-24	SPY	ETF	218.8	218.91	217.36	217.85	71728900.0
2016-08-24	QQQ	ETF	117.49	117.64	116.41	116.8	17728656.0
2016-08-24	IWM	ETF	123.94	124.25	122.77	123.07	21533400.0
2016-08-24	DIA	ETF	185.06	185.2	184.29	184.66	1882900.0
2016-08-24	GLD	ETF	126.92	126.97	126.3	126.34	13539700.0
2016-08-24	TLT	ETF	140.1	140.19	139.39	139.7	6027800.0
2016-08-24	AADR	ETF	40.98	40.98	40.76	40.76	2400.0
2016-08-24	AAXJ	ETF	58.89	59.11	58.83	59.02	687100.0
2016-08-24	ACTX	ETF	3.54	3.54	2.891	2.891	1527.0
2016-08-24	ACWF	ETF	24.07	24.07	24.07	24.07	140.0
2016-08-24	ACWI	ETF	59.21	59.27	58.91	59.0	1656000.0
2016-08-24	ACWV	ETF	77.22	77.22	76.73	76.82	401800.0
2016-08-24	ACWX	ETF	41.43	41.44	41.25	41.3	308044.0
2016-08-24	ADRE	ETF	34.072	34.072	33.99	33.99	559.0
2016-08-24	AFK	ETF	20.72	20.9552	20.37	20.38	25124.0
2016-08-24	AFTY	ETF	13.62	13.62	13.567	13.567	2200.0
2016-08-24	AGG	ETF	112.79	112.8	112.63	112.64	2312800.0
2016-08-24	AGGY	ETF	52.2	52.23	52.097	52.17	10300.0
2016-08-24	AGQ	ETF	46.3	46.31	45.37	45.49	288600.0
2016-08-24	AGZ	ETF	115.7	115.906	115.5501	115.61	36057.0
2016-08-24	AGZD	ETF	24.005	24.005	24.005	24.005	200.0
2016-08-24	AIA	ETF	48.43	48.46	48.26	48.31	32288.0
2016-08-24	AIQ	ETF	6.17	6.35	6.17	6.25	5072.0
2016-08-24	AIRR	ETF	19.835	19.88	19.835	19.847	500.0
2016-08-24	AIVI	ETF	39.31	39.46	39.16	39.17	38700.0
2016-08-24	ALTY	ETF	15.721	15.75	15.721	15.75	3600.0
2016-08-24	AMJ	ETF	31.16	31.29	30.86	30.95	2259607.0
2016-08-24	AMLP	ETF	63.1	63.3	62.6	62.75	1177300.0
2016-08-24	AMZA	ETF	115.7	115.8	114.2	114.8	11050.0
2016-08-24	ANGL	ETF	28.79	28.79	28.72	28.74	83000.0
2016-08-24	AOA	ETF	47.57	47.6	47.35	47.35	17900.0
2016-08-24	AOK	ETF	33.49	33.5399	33.3501	33.4	28636.0
2016-08-24	AOM	ETF	36.14	36.2	36.01	36.03	70530.0
2016-08-24	AOR	ETF	41.1	41.1899	41.005	41.06	196332.0
2016-08-24	ARGT	ETF	22.82	23.02	22.77	22.81	20300.0
2016-08-24	ARKG	ETF	19.23	19.23	18.25	18.28	2100.0
2016-08-24	ARKK	ETF	21.37	21.37	21.24	21.24	600.0
2016-08-24	ARKQ	ETF	21.88	21.88	21.61	21.61	3300.0
2016-08-24	ARKW	ETF	24.83	24.83	24.47	24.47	4000.0
2016-08-24	ASEA	ETF	14.18	14.22	14.18	14.22	2700.0
2016-08-24	ASET	ETF	26.99	26.99	26.99	26.99	560.0
2016-08-24	ASHR	ETF	25.29	25.31	25.2	25.24	695900.0
2016-08-24	ASHS	ETF	35.44	35.44	35.3	35.4	22000.0
2016-08-24	ASHX	ETF	23.03	23.03	23.0	23.0	355.0
2016-08-24	ATMP	ETF	22.73	22.75	22.57	22.57	17900.0
2016-08-24	BAB	ETF	31.74	31.74	31.56	31.71	186840.0
2016-08-24	BAL	ETF	45.09	45.1	44.73	44.9705	6558.0
2016-08-24	BBC	ETF	21.17	21.602	20.0892	20.09	15639.0
2016-08-24	BBH	ETF	118.26	119.75	115.41	115.58	73100.0
2016-08-24	BBP	ETF	31.67	32.0	30.29	30.54	14900.0

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

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