PREVIEW / etf_daily / 2016-03-17

all etf daily files

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

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-17	SPY	ETF	203.24	205.23	202.77	204.63	134278500.0
2016-03-17	QQQ	ETF	107.26	107.77	106.87	107.52	29623740.0
2016-03-17	IWM	ETF	106.99	109.1	106.33	108.63	41724500.0
2016-03-17	DIA	ETF	173.46	175.41	173.08	174.94	4070500.0
2016-03-17	GLD	ETF	121.16	121.18	120.03	120.13	9914300.0
2016-03-17	TLT	ETF	128.51	129.34	128.49	128.79	7805500.0
2016-03-17	AADR	ETF	37.6	37.6	37.6	37.6	500.0
2016-03-17	AAXJ	ETF	53.45	54.08	53.24	54.04	1123500.0
2016-03-17	ACTX	ETF	5.9001	7.6701	5.015	7.0801	2605.0
2016-03-17	ACWI	ETF	55.42	56.02	55.31	55.89	2308700.0
2016-03-17	ACWV	ETF	72.4	72.91	72.25	72.83	224900.0
2016-03-17	ACWX	ETF	39.29	39.725	39.18	39.67	561455.0
2016-03-17	ADRE	ETF	30.16	30.53	30.16	30.48	4822.0
2016-03-17	AFK	ETF	19.33	19.75	19.23	19.66	19717.0
2016-03-17	AFTY	ETF	12.79	12.89	12.785	12.85	9700.0
2016-03-17	AGG	ETF	109.95	110.13	109.9	110.08	4116500.0
2016-03-17	AGGY	ETF	50.21	50.3	50.21	50.265	28400.0
2016-03-17	AGQ	ETF	34.95	35.64	34.4	35.05	572700.0
2016-03-17	AGZ	ETF	114.06	114.32	114.06	114.19	25107.0
2016-03-17	AGZD	ETF	23.93	23.93	23.93	23.93	1000.0
2016-03-17	AIA	ETF	42.41	42.92	42.39	42.86	19569.0
2016-03-17	AIQ	ETF	6.93	7.045	6.56	6.91	16557.0
2016-03-17	AIRR	ETF	17.06	17.36	17.06	17.36	1800.0
2016-03-17	AIVI	ETF	38.3	38.7	38.21	38.63	14200.0
2016-03-17	ALTY	ETF	14.2	14.2	14.095	14.095	500.0
2016-03-17	AMJ	ETF	27.31	27.91	27.05	27.61	4914547.0
2016-03-17	AMLP	ETF	55.1	56.5	54.8	55.9	4106720.0
2016-03-17	AMZA	ETF	92.6	94.5	91.3	93.5	8240.0
2016-03-17	ANGL	ETF	25.76	25.89	25.61	25.83	478700.0
2016-03-17	AOA	ETF	44.79	45.15	44.75	45.11	50400.0
2016-03-17	AOK	ETF	31.93	32.12	31.93	32.07	52317.0
2016-03-17	AOM	ETF	34.45	34.61	34.37	34.61	74692.0
2016-03-17	AOR	ETF	38.96	39.27	38.922	39.22	130689.0
2016-03-17	ARGT	ETF	19.14	19.29	18.97	19.18	27400.0
2016-03-17	ARKG	ETF	16.14	16.14	16.14	16.14	2500.0
2016-03-17	ARKK	ETF	18.1	18.1	18.1	18.1	100.0
2016-03-17	ARKQ	ETF	18.23	18.25	18.23	18.25	2800.0
2016-03-17	ARKW	ETF	20.009	20.009	20.009	20.009	100.0
2016-03-17	ASEA	ETF	13.33	13.41	13.33	13.41	900.0
2016-03-17	ASHR	ETF	23.88	24.22	23.84	24.16	2419700.0
2016-03-17	ASHS	ETF	32.03	32.51	32.03	32.39	123000.0
2016-03-17	ASHX	ETF	21.26	21.35	21.26	21.33	722.0
2016-03-17	ATMP	ETF	18.27	18.74	18.23	18.5	65300.0
2016-03-17	BAB	ETF	29.85	29.9	29.73	29.865	216200.0
2016-03-17	BAL	ETF	38.24	38.45	38.12	38.15	7709.0
2016-03-17	BBC	ETF	16.99	17.46	16.71	17.38	6193.0
2016-03-17	BBH	ETF	99.07	99.6	96.73	98.48	242700.0
2016-03-17	BBP	ETF	22.32	23.0	22.32	23.0	5500.0
2016-03-17	BCM	ETF	25.04	25.14	25.04	25.0846	3433.0
2016-03-17	BFOR	ETF	7.3475	7.445	7.3325	7.44	174400.0

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

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