PREVIEW / etf_daily / 2016-03-02

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-02.parquet
  size:    50 KB
  rows:    1,259

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-03-02	SPY	ETF	197.74	199.06	197.25	199.0	102415000.0
2016-03-02	QQQ	ETF	105.63	105.85	105.01	105.83	29209756.0
2016-03-02	IWM	ETF	104.79	106.09	104.59	106.02	24937100.0
2016-03-02	DIA	ETF	168.02	168.93	167.55	168.89	3106200.0
2016-03-02	GLD	ETF	118.34	118.97	118.07	118.68	8903000.0
2016-03-02	TLT	ETF	128.32	128.97	128.21	128.96	7047700.0
2016-03-02	AADR	ETF	37.15	37.15	36.85	36.92	11200.0
2016-03-02	AAXJ	ETF	50.96	51.54	50.93	51.5	736100.0
2016-03-02	ACTX	ETF	4.72	4.72	4.72	4.72	84.0
2016-03-02	ACWF	ETF	21.9401	22.06	21.8801	22.06	6469.0
2016-03-02	ACWI	ETF	53.47	53.85	53.32	53.82	1394900.0
2016-03-02	ACWV	ETF	70.5	70.7	70.12	70.7	275200.0
2016-03-02	ACWX	ETF	37.49	37.85	37.44	37.85	1435453.0
2016-03-02	ADRE	ETF	28.39	28.54	28.32	28.5399	5216.0
2016-03-02	AFK	ETF	17.01	17.75	17.01	17.7199	12017.0
2016-03-02	AFTY	ETF	12.11	12.11	12.03	12.09	8300.0
2016-03-02	AGG	ETF	109.45	109.48	109.32	109.42	2624500.0
2016-03-02	AGGY	ETF	49.56	49.72	49.56	49.696	8600.0
2016-03-02	AGQ	ETF	30.85	31.43	30.72	31.18	127600.0
2016-03-02	AGZ	ETF	114.234	114.3699	113.9501	114.34	53324.0
2016-03-02	AGZD	ETF	23.805	23.81	23.62	23.625	33000.0
2016-03-02	AIA	ETF	40.26	40.59	40.22	40.59	26855.0
2016-03-02	AIQ	ETF	7.44	7.94	7.44	7.89	18127.0
2016-03-02	AIRR	ETF	16.149	16.241	16.149	16.2	3800.0
2016-03-02	AIVI	ETF	36.61	36.93	36.58	36.92	28200.0
2016-03-02	ALTY	ETF	13.469	13.5	13.41	13.5	1200.0
2016-03-02	AMJ	ETF	25.03	25.93	24.7	25.87	2640661.0
2016-03-02	AMLP	ETF	49.95	52.5	49.8	52.45	2250320.0
2016-03-02	AMZA	ETF	82.6	88.05	82.5	88.05	3520.0
2016-03-02	ANGL	ETF	24.58	24.7	24.36	24.7	50500.0
2016-03-02	AOA	ETF	43.47	43.75	43.43	43.75	43200.0
2016-03-02	AOK	ETF	31.43	31.5304	31.4275	31.53	40208.0
2016-03-02	AOM	ETF	33.83	33.92	33.77	33.91	71750.0
2016-03-02	AOR	ETF	38.13	38.25	38.0001	38.24	48558.0
2016-03-02	ARGT	ETF	18.61	18.84	18.52	18.79	82600.0
2016-03-02	ARKG	ETF	17.28	17.28	17.28	17.28	100.0
2016-03-02	ARKK	ETF	17.73	17.73	17.73	17.73	100.0
2016-03-02	ARKQ	ETF	17.2	17.372	17.2	17.33	1100.0
2016-03-02	ARKW	ETF	19.669	19.669	19.669	19.669	200.0
2016-03-02	ASEA	ETF	12.63	12.74	12.62	12.7	11600.0
2016-03-02	ASET	ETF	24.2103	24.2103	24.2103	24.2103	200.0
2016-03-02	ASHR	ETF	22.94	23.14	22.89	23.09	1598500.0
2016-03-02	ASHS	ETF	31.46	31.74	31.38	31.74	40200.0
2016-03-02	ATMP	ETF	16.87	17.42	16.68	17.34	142100.0
2016-03-02	BAB	ETF	29.95	29.95	29.8101	29.86	197885.0
2016-03-02	BAL	ETF	36.38	37.03	36.38	36.58	4578.0
2016-03-02	BBC	ETF	18.31	19.25	18.31	19.25	11000.0
2016-03-02	BBH	ETF	104.42	105.76	103.82	104.88	70300.0
2016-03-02	BBP	ETF	24.02	24.442	24.02	24.319	2000.0
2016-03-02	BCM	ETF	23.57	23.83	23.57	23.77	3125.0

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

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