PREVIEW / etf_daily / 2016-05-19

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-19.parquet
  size:    51 KB
  rows:    1,281

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-05-19	SPY	ETF	204.06	204.54	202.78	204.2	115430500.0
2016-05-19	QQQ	ETF	105.45	105.705	104.54	105.31	27334610.0
2016-05-19	IWM	ETF	109.04	109.77	107.99	108.96	36995600.0
2016-05-19	DIA	ETF	174.95	175.2	173.67	174.68	5090900.0
2016-05-19	GLD	ETF	119.0	119.98	118.92	119.87	14339700.0
2016-05-19	TLT	ETF	129.68	130.33	129.65	130.05	6209400.0
2016-05-19	AADR	ETF	37.56	37.68	37.0	37.31	6900.0
2016-05-19	AAXJ	ETF	50.53	51.04	50.53	50.87	850100.0
2016-05-19	ACTX	ETF	5.31	5.31	4.602	4.602	1303.0
2016-05-19	ACWF	ETF	22.47	22.48	22.43	22.48	850.0
2016-05-19	ACWI	ETF	55.5	55.57	55.16	55.51	1652200.0
2016-05-19	ACWV	ETF	72.36	72.73	72.28	72.7	115000.0
2016-05-19	ACWX	ETF	39.0	39.05	38.8	38.97	767945.0
2016-05-19	ADRE	ETF	29.53	29.54	29.2701	29.43	5041.0
2016-05-19	AFK	ETF	19.88	20.21	19.6	20.21	59661.0
2016-05-19	AFTY	ETF	12.19	12.22	12.19	12.21	2700.0
2016-05-19	AGG	ETF	110.47	110.56	110.4	110.47	3461900.0
2016-05-19	AGGY	ETF	50.741	50.741	50.644	50.644	2600.0
2016-05-19	AGNG	ETF	15.0	15.0	15.0	15.0	100.0
2016-05-19	AGQ	ETF	36.7	37.3	36.38	37.09	574600.0
2016-05-19	AGZ	ETF	114.584	114.67	114.5	114.58	36956.0
2016-05-19	AGZD	ETF	23.97	23.97	23.925	23.94	4000.0
2016-05-19	AIA	ETF	40.44	40.46	40.24	40.37	30876.0
2016-05-19	AIQ	ETF	7.43	7.64	7.3	7.37	14679.0
2016-05-19	AIRR	ETF	17.17	17.289	17.158	17.26	2900.0
2016-05-19	AIVI	ETF	37.89	37.89	37.63	37.8	23800.0
2016-05-19	ALTY	ETF	14.492	14.492	14.492	14.492	200.0
2016-05-19	AMJ	ETF	29.81	30.79	29.65	30.61	2146757.0
2016-05-19	AMLP	ETF	59.95	61.55	59.25	61.25	2062300.0
2016-05-19	AMZA	ETF	105.0	109.4	104.0	107.9	26690.0
2016-05-19	ANGL	ETF	26.74	26.81	26.67	26.75	80000.0
2016-05-19	AOA	ETF	44.84	44.86	44.64	44.82	26900.0
2016-05-19	AOK	ETF	32.08	32.2	32.06	32.18	27580.0
2016-05-19	AOM	ETF	34.64	34.64	34.4301	34.5	60298.0
2016-05-19	AOR	ETF	39.12	39.13	38.92	39.11	298416.0
2016-05-19	ARGT	ETF	20.18	20.26	19.77	20.18	48400.0
2016-05-19	ARKG	ETF	16.558	16.56	16.558	16.56	400.0
2016-05-19	ARKK	ETF	18.0	18.0	17.93	17.969	700.0
2016-05-19	ARKQ	ETF	18.088	18.088	18.088	18.088	100.0
2016-05-19	ARKW	ETF	20.498	20.498	20.498	20.498	300.0
2016-05-19	ASEA	ETF	12.87	12.87	12.87	12.87	100.0
2016-05-19	ASHR	ETF	22.72	22.83	22.68	22.72	1556800.0
2016-05-19	ASHS	ETF	31.15	31.22	31.11	31.21	6600.0
2016-05-19	ASHX	ETF	20.49	20.49	20.49	20.49	250.0
2016-05-19	ATMP	ETF	20.7	21.15	20.57	21.15	29100.0
2016-05-19	BAB	ETF	30.42	30.46	30.34	30.42	211152.0
2016-05-19	BAL	ETF	40.7712	40.7712	40.09	40.431	1180.0
2016-05-19	BBC	ETF	18.6825	18.6825	17.96	18.32	4774.0
2016-05-19	BBH	ETF	104.21	104.83	102.63	103.28	74200.0
2016-05-19	BBP	ETF	25.5	25.5	25.04	25.42	5000.0

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

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