PREVIEW / etf_daily / 2016-05-02

all etf daily files

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

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-02	SPY	ETF	206.92	208.18	206.41	207.97	62188000.0
2016-05-02	QQQ	ETF	105.97	106.87	105.5525	106.72	24813813.0
2016-05-02	IWM	ETF	112.83	113.51	112.18	113.48	21881000.0
2016-05-02	DIA	ETF	178.08	178.91	177.51	178.7	2463100.0
2016-05-02	GLD	ETF	123.78	123.96	123.05	123.24	12137500.0
2016-05-02	TLT	ETF	128.66	128.9	127.8	127.82	11035200.0
2016-05-02	AADR	ETF	38.67	38.87	38.67	38.82	1500.0
2016-05-02	AAXJ	ETF	54.04	54.16	53.77	54.07	563100.0
2016-05-02	ACTX	ETF	4.72	4.72	4.13	4.13	863.0
2016-05-02	ACWI	ETF	57.04	57.19	56.84	57.16	1692100.0
2016-05-02	ACWV	ETF	73.98	74.34	73.83	74.25	149200.0
2016-05-02	ACWX	ETF	40.72	40.78	40.57	40.74	1243972.0
2016-05-02	ADRE	ETF	31.36	31.36	31.0	31.12	6133.0
2016-05-02	AFK	ETF	21.04	21.24	21.0024	21.1	3259.0
2016-05-02	AGG	ETF	110.74	110.74	110.52	110.61	3553900.0
2016-05-02	AGGY	ETF	50.8	50.84	50.79	50.83	9700.0
2016-05-02	AGQ	ETF	43.48	43.48	41.87	41.94	353700.0
2016-05-02	AGZ	ETF	114.45	114.64	114.41	114.51	53002.0
2016-05-02	AGZD	ETF	23.855	23.855	23.855	23.855	400.0
2016-05-02	AIA	ETF	42.9	43.02	42.8	43.02	4310.0
2016-05-02	AIQ	ETF	7.28	7.52	7.0	7.06	25423.0
2016-05-02	AIVI	ETF	39.66	39.81	39.56	39.81	39900.0
2016-05-02	ALTY	ETF	14.55	14.55	14.55	14.55	200.0
2016-05-02	AMJ	ETF	30.04	30.3499	29.27	29.68	2026069.0
2016-05-02	AMLP	ETF	61.5	61.55	59.7	60.6	1728540.0
2016-05-02	AMZA	ETF	104.5	104.5	100.8	102.1	10010.0
2016-05-02	ANGL	ETF	27.59	27.59	27.06	27.12	88100.0
2016-05-02	AOA	ETF	45.8	45.89	45.65	45.84	37700.0
2016-05-02	AOK	ETF	32.59	32.59	32.39	32.52	31274.0
2016-05-02	AOM	ETF	35.05	35.05	34.8999	35.0	61340.0
2016-05-02	AOR	ETF	39.67	39.8099	39.6001	39.79	92190.0
2016-05-02	ARGT	ETF	20.67	20.72	20.55	20.63	35900.0
2016-05-02	ARKG	ETF	17.68	17.68	17.68	17.68	300.0
2016-05-02	ARKK	ETF	18.98	19.0	18.98	19.0	300.0
2016-05-02	ARKQ	ETF	18.852	18.954	18.852	18.954	400.0
2016-05-02	ARKW	ETF	20.952	20.952	20.952	20.952	300.0
2016-05-02	ASEA	ETF	13.26	13.28	13.26	13.28	4500.0
2016-05-02	ASHR	ETF	23.92	23.99	23.87	23.95	658900.0
2016-05-02	ASHS	ETF	33.49	33.51	33.39	33.47	53100.0
2016-05-02	ASHX	ETF	21.31	21.31	21.25	21.28	1545.0
2016-05-02	ATMP	ETF	20.46	20.46	20.16	20.34	42200.0
2016-05-02	BAB	ETF	30.15	30.17	29.93	30.06	308235.0
2016-05-02	BAL	ETF	42.47	42.81	42.47	42.79	13734.0
2016-05-02	BBC	ETF	19.88	19.93	19.4481	19.93	5853.0
2016-05-02	BBH	ETF	106.72	107.36	105.31	107.29	40500.0
2016-05-02	BBP	ETF	25.86	25.96	25.56	25.96	3100.0
2016-05-02	BCM	ETF	26.4499	26.45	26.4	26.4	850.0
2016-05-02	BDCZ	ETF	20.43	20.58	20.1	20.25	70200.0
2016-05-02	BFOR	ETF	7.6025	7.645	7.5825	7.645	68400.0
2016-05-02	BIB	ETF	43.04	43.8805	41.8	43.79	597428.0

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

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