PREVIEW / etf_daily / 2016-03-03

all etf daily files

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

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-03	SPY	ETF	198.79	199.8	198.11	199.78	95172200.0
2016-03-03	QQQ	ETF	105.71	105.75	104.87	105.63	25474625.0
2016-03-03	IWM	ETF	106.05	107.15	105.92	107.13	28216300.0
2016-03-03	DIA	ETF	168.73	169.39	168.12	169.35	2968200.0
2016-03-03	GLD	ETF	118.86	121.3	118.81	120.73	18724100.0
2016-03-03	TLT	ETF	129.07	129.94	128.77	129.43	6394800.0
2016-03-03	AADR	ETF	36.85	36.85	36.85	36.85	300.0
2016-03-03	AAXJ	ETF	51.55	51.92	51.51	51.85	478000.0
2016-03-03	ACTX	ETF	4.72	4.72	3.54	4.13	692.0
2016-03-03	ACWI	ETF	53.87	54.23	53.75	54.22	1300600.0
2016-03-03	ACWV	ETF	70.62	70.69	70.32	70.66	444600.0
2016-03-03	ACWX	ETF	37.89	38.26	37.89	38.24	859718.0
2016-03-03	ADRE	ETF	28.829	28.958	28.829	28.93	1130.0
2016-03-03	AFK	ETF	17.75	17.9985	17.68	17.9663	6665.0
2016-03-03	AFTY	ETF	12.18	12.22	12.12	12.16	14600.0
2016-03-03	AGG	ETF	109.47	109.61	109.37	109.55	3632800.0
2016-03-03	AGGY	ETF	49.73	49.78	49.73	49.765	8100.0
2016-03-03	AGQ	ETF	31.24	32.67	31.24	32.31	348800.0
2016-03-03	AGZ	ETF	114.08	114.3199	114.08	114.14	11871.0
2016-03-03	AGZD	ETF	23.685	23.685	23.58	23.655	1800.0
2016-03-03	AIA	ETF	40.69	40.97	40.67	40.93	18980.0
2016-03-03	AIQ	ETF	7.9	8.11	7.896	7.97	22621.0
2016-03-03	AIRR	ETF	16.24	16.45	16.24	16.45	3300.0
2016-03-03	AIVI	ETF	37.02	37.35	37.0	37.35	29200.0
2016-03-03	AMJ	ETF	25.87	26.7975	25.745	26.56	4589065.0
2016-03-03	AMLP	ETF	52.0	54.5	52.0	53.8	3364620.0
2016-03-03	AMZA	ETF	89.3	92.1	87.2	91.5	5810.0
2016-03-03	ANGL	ETF	24.75	24.92	24.52	24.84	35300.0
2016-03-03	AOA	ETF	43.7	44.0	43.7	43.98	41200.0
2016-03-03	AOK	ETF	31.53	31.6899	31.51	31.63	90173.0
2016-03-03	AOM	ETF	33.98	34.07	33.8909	34.07	42090.0
2016-03-03	AOR	ETF	38.29	38.4558	38.2	38.45	157252.0
2016-03-03	ARGT	ETF	18.89	18.99	18.81	18.9	262000.0
2016-03-03	ARKG	ETF	17.48	17.48	17.375	17.375	600.0
2016-03-03	ARKK	ETF	17.7	18.145	17.7	18.145	2300.0
2016-03-03	ARKQ	ETF	17.55	17.766	17.55	17.766	700.0
2016-03-03	ARKW	ETF	19.54	19.643	19.54	19.64	1300.0
2016-03-03	ASEA	ETF	12.77	12.98	12.7	12.9	14400.0
2016-03-03	ASET	ETF	24.46	24.46	24.46	24.46	204.0
2016-03-03	ASHR	ETF	23.14	23.3	23.02	23.19	1236700.0
2016-03-03	ASHS	ETF	31.8	31.94	31.63	31.78	38000.0
2016-03-03	ASHX	ETF	20.89	20.89	20.89	20.89	100.0
2016-03-03	ATMP	ETF	17.37	18.03	17.37	17.83	57900.0
2016-03-03	BAB	ETF	29.89	30.03	29.89	29.98	294639.0
2016-03-03	BAL	ETF	36.46	36.82	36.46	36.719	1215.0
2016-03-03	BBC	ETF	19.54	19.54	18.975	19.0644	4031.0
2016-03-03	BBH	ETF	105.11	105.35	103.32	103.75	61600.0
2016-03-03	BBP	ETF	24.43	24.559	24.24	24.43	1500.0
2016-03-03	BCM	ETF	23.72	23.98	23.72	23.98	1734.0
2016-03-03	BFOR	ETF	7.2475	7.325	7.2475	7.325	53200.0

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

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